Qlik Replicate: SYS,GENERAL_EXCEPTION,Incorrect connection string for the thread 10

Alan_Wang — Wed, 28 Aug 2024 09:04:23 GMT

When ASM is used for an Oracle source endpoint, you should not be using a direct IP address to connect to the ASM.

Attempting to add multiple IP address connection strings into the ASM connection string field may lead to a connection failure with the following error:

SYS,GENERAL_EXCEPTION,Incorrect connection string for the thread 10

The TNS connection string of the ASM node cluster should be used for the ASM connection.

Correct Example:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=asmhostname)(PORT=1531))(CONNECT_DATA=(SERVICE_NAME=+ASM)))

Incorrect Example:

10.89.145.143:3100/+ASM,10.89.134.144:3100/+ASM

Resolution

The correct format of the ASM connection string should be used when using ASM with a cluster format.

Environment

Oracle source endpoint with ASM

article Qlik Replicate: SYS,GENERAL_EXCEPTION,Incorrect connection string for the thread 10 in Official Support Articles

Qlik Replicate: SYS,GENERAL_EXCEPTION,Incorrect connection string for the thread 10

Resolution

Environment