topic Re: RetCod: SQL ERROR SqlState: 42601 NativeError 3167 in Qlik Replicate

RetCod: SQL ERROR SqlState: 42601 NativeError 3167

nithin_seeni — Fri, 02 Aug 2024 12:37:36 GMT

Receiving an error "RetCod: SQL ERROR SqlState: 42601 NativeError 3167 " during execution of the job and not able to connect to the target.

Any help would be appreciated.

Re: RetCod: SQL ERROR SqlState: 42601 NativeError 3167

kng — Fri, 02 Aug 2024 12:44:55 GMT

Hello Team,

Thanks for reaching Qlik community!!

Please can you provide us with the full error line info!!

Regards,

shivananda

Re: RetCod: SQL ERROR SqlState: 42601 NativeError 3167

john_wang — Fri, 02 Aug 2024 13:05:52 GMT

Hello @nithin_seeni ,

Would you please share the target DB types and DB version information?

Thanks,

John.

Re: RetCod: SQL ERROR SqlState: 42601 NativeError 3167

SushilKumar — Sat, 03 Aug 2024 03:12:30 GMT

Hello @nithin_seeni

Hello Team,

Thanks for reaching out to Qlik via Qlik Community Support page. Such issue require through analysis of Settings, hence request you to reach out to technical Support via a case and provide Diagnostics package .

Please refer to Replicate https://community.qlik.com/t5/Knowledge/How-to-collect-Diagnostics-Package-from-Qlik-Replicate/ta-p/1815056

Regards,

Sushil Kumar

Re: RetCod: SQL ERROR SqlState: 42601 NativeError 3167

Tasha8688 — Sat, 03 Aug 2024 05:14:48 GMT

The SQL error you're encountering is related to syntax issues in your SQL query or statement. The SqlState: 42601 indicates a syntax error, and the NativeError 3167 provides additional details specific to the SQL database you’re using. This error commonly occurs when there is a problem with the SQL syntax, such as a missing keyword, incorrect placement of commas, or an improperly formatted query.

Re: RetCod: SQL ERROR SqlState: 42601 NativeError 3167

sureshkumar — Sun, 04 Aug 2024 10:31:56 GMT

Hello @nithin_seeni

The SQL error code 42601 indicates a syntax error. SQLSTATE error codes are standardized, and 42601 is used to denote syntax issues across various SQL databases.

Regards,

Suresh