Getting Error on Manage Database connection - Test Connection - "Value cannot be null. Parameter name: key"

[MSSOT_RIVA_HSBC1]

Hi All,

We are new to this community any help is appreciated.

After we did a database restart, Compose CDC workflow has stopped running and we are getting the error as below. It was running fine before the database reboot.

16 2023-09-20 16:48:54 [Engine ] [INFO ] Going to run task, Project "XXXX", Task Id 1235 Name "XXX_XXX"
16 2023-09-20 16:48:54 [Engine ] [ERROR] Execute Failed. Type:System.ArgumentNullException, Message: Value cannot be null.
Parameter name: key, Inner Type: , Inner Message:
16 2023-09-20 16:48:54 [Engine ] [ERROR] at System.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument)
at System.Collections.Generic.Dictionary`2.FindEntry(TKey key)
at OracleInternal.Common.SyncDictionary`2.ContainsKey(K k)
at OracleInternal.ConnectionPool.PoolManager`3.CreateServiceCtx(PR pr)
at OracleInternal.ConnectionPool.PoolManager`3.PutNewPR(PR pr, Boolean bForPoolPopulation)
at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd, CriteriaCtx criteriaCtx, String instanceName, List`1 switchFailedInstNames)
at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, CriteriaCtx criteriaCtx, String affinityInstanceName, Boolean bForceMatch)
at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, CriteriaCtx criteriaCtx, String affinityInstanceName, Boolean bForceMatch)
at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, CriteriaCtx criteriaCtx)
at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
at Attunity.Compose.BwAutomationManager.DatabaseConnection.Connect()
at Attunity.Compose.BwAutomationManager.DatabaseProviderManager.GetDatabaseConnection(DatabaseDto database, Boolean open_connection)
at Attunity.Compose.BwAutomationManager.TargetManager.GetLastRunNumber()
at Attunity.Compose.BwAutomationManager.ExecutorUtilsDWH.UpdateCurrentAndPrevRunNumbers()
at Attunity.Compose.BwAutomationManager.EtlCommandRemoteExecutor.a(ETLInfoDto )
at Attunity.Compose.BwAutomationManager.EtlCommandRemoteExecutor.D()
16 2023-09-20 16:48:54 [Engine ] [ERROR] ExecuteAsyncImp Failed with Message:`Value cannot be null.
Parameter name: key`
37 2023-09-20 16:48:55 [Engine ] [ERROR] Project: "XXXX" , Task: Task ID 1235 Name: "XXX_XXX" ETL_TASK_FINISHED_WITH_ERROR, Error: Value cannot be null.
Parameter name: key
5 2023-09-20 16:48:55 [Engine ] [WARN ] Failed to get task XXX_XXX status, error Value cannot be null.
Parameter name: key

[Adam_Herman · Accepted solution]

Hi @MSSOT_RIVA_HSBC1 

I've received your case through our portal and understand your concern. For a thorough investigation of this issue, we need to proceed within the case as it allows us to gather and share detailed information.

Please refer to the case you've raised, and I've already updated it to reflect your recent communication.

Best regards,

Adam

[MSSOT_RIVA_HSBC1]

One of the changes we made was to change the oracle setup from NO_ARCHIVE to ARCHIVE log, this resolved one part of the issue and TEST CONNECTION is now from COMPOSE UI is working.

Then we tried to again start the CDC and seeing new error message as below,

main 2023-09-20 19:37:26.490 [engine ] [TRACE ] [] creating connection
main 2023-09-20 19:37:26.490 [engine ] [TRACE ] [] Connection string: jdbc:oracle:oci8:@ABC_00001_XXXXXX.hc.cloud.hk.hsbc
main 2023-09-20 19:37:33.420 [engine ] [ERROR ] [] Failed to get connection: jdbc:oracle:oci8:@ABC_00001_XXXXXX.hc.cloud.hk.hsbc Error message: ORA-12154: TNS:could not resolve the connect identifier specified
main 2023-09-20 19:37:33.420 [engine ] [ERROR ] [] Connectionpool test failed: jdbc:oracle:oci8:@ABC_00001_XXXXXX.hc.cloud.hk.hsbc com.attunity.infrastructure.exceptions.AttInfrastructureException: SYS-E-SQLERR, Sql statement produced the following error: Failed to get connection: jdbc:oracle:oci8:@ABC_00001_XXXXXX.hc.cloud.hk.hsbc Error message: ORA-12154: TNS:could not resolve the connect identifier specified

The connection string generated by the COMPOSE is looking incorrect, we are not able to figure out why an incorrect string is being generated.