DB Load fails during the upgrade process with the following message:
20200823/100359.291 - 1 U00003545 UCUDB: Opening database ...
20200823/100359.420 - 1 U00003611 DB OPEN executed. Return Code = '17002'
20200823/100359.421 - 1 U00003590 UCUDB - DB error: '08006', 'IO Error: NL Exception was generated TNS-04610: No literals left, reached end of NV pair', '17002', 'java.sql.SQLRecoverableException'
20200823/100359.422 - 1 U00032031 Error when connecting to Database
(DESCRIPTION = (ENABLE = BROKEN) (ADDRESS_LIST = (LOAD_BALANCE = OFF)(FAILOVER = ON) (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_01)(PORT = 1521)) (ADDRESS = (PRO
TOCOL = TCP)(HOST = SERVER_02)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = SERVICE_NAME) (FAILOVER_MODE = (TYPE = SESSION)(METHOD = BASIC)(RETRIES = 20)(DELAY = 30))))
Configuration.
Release : 12.3
Component : AUTOMATION ENGINE
The sqlDriverConnect= string included a line break:
(DESCRIPTION = (ENABLE = BROKEN) (ADDRESS_LIST = (LOAD_BALANCE = OFF)(FAILOVER = ON) (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_01)(PORT = 1521)) (ADDRESS = (PRO
TOCOL = TCP)(HOST = SERVER_02)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = SERVICE_NAME) (FAILOVER_MODE = (TYPE = SESSION)(METHOD = BASIC)(RETRIES = 20)(DELAY = 30))))
Once this was corrected to:
(DESCRIPTION = (ENABLE = BROKEN) (ADDRESS_LIST = (LOAD_BALANCE = OFF)(FAILOVER = ON) (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_01)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_02)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = SERVICE_NAME) (FAILOVER_MODE = (TYPE = SESSION)(METHOD = BASIC)(RETRIES = 20)(DELAY = 30))))
The DB Load was able to perform.