Error [SOURCE_CAPTURE] "The command has timed out"

[tanhanyan]

Hi,

Need advise. 

Source DB from Sybase end point. Target DB is Oracle end point. Total 18 tables to replicate directly. There are 2 tables having CLOB column type. 1 table having 6 CLOB column and another table having 1 CLOB column. Both tables have primary key

We had tried to configure Sybase source end point with 2 parameter:

1) cdcTimeout = 6000

2) executeTimeout = 600

We still hit the same error:

[SOURCE_CAPTURE  ]E:  RetCode: SQL_ERROR  SqlState: HYT00 NativeError: 30149 Message: [SAP][ASE ODBC Driver]The command has timed out. [1022502]  (ar_odbc_stmt.c:4693)

[SOURCE_CAPTURE  ]E:  Failed to position logtransfer [1020401]  (sybase_endpoint_capture.c:3352)

[SOURCE_CAPTURE  ]E:  Error executing source loop [1020401]  (streamcomponent.c:1942)

[john_wang]

Hello @tanhanyan ,

Thanks for reaching out to Qlik Community!

It's hard to tell the root case from the above error messages this time. We need additional information to understand the issue further, would you please open a support ticket and attach below information to the salesforce case:

1. The 2 tables creation DDL

2. Please enable SOURCE_CAPTURE  to Verbose, re-create the error and attach the Diag Packages

3. Please examine the Sybase server log to see if any helpful information there

Good luck,

John.

[SushilKumar]

Hello @tanhanyan 

The command has timed out. [1022502] this error mainly occurs when QR submits a Query to the Source endpoint to fetch info. If Qr does not get the output from the Source endpoint . 

in such case its need to check why Source DB or endpoint does not provide result to Qr.

there may be some contention on Db or Db is highly occupied. 

Regards

Sushil Kumar