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

[Alan_Wang]

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

• Qlik Replicate 
• Oracle source endpoint with ASM