article Qlik Replicate: Example error codes sent by data sources in in Official Support Articles

Qlik Replicate: Example error codes sent by data sources in

Troy_Raney — Fri, 28 Oct 2022 09:50:42 GMT

For general troubleshooting advice, see: Qlik Replicate Troubleshooting
For more information about Qlik Replicate log files and how to read them, see: How to analyze a Qlik Replicate log

PK violation examples

TARGET_LOAD ]T: ORA-00001: unique constraint (CUST_TABLE.PK_CUST_ID) violated

[TARGET_APPLY ]E: RetCode: SQL_ERROR SqlState: 42X91 NativeError: -1 Message: [EXASOL][EXASolution driver]Exception when finishing statement with handle 14 : constraint violation - primary key (PK_PERSONENDATEN on table PERSON_CT) (Session: 1629089178267795534) [1022502] (ar_odbc_conn.c:797)

[TARGET_APPLY ]T: Constraint violation error codes are: - (provider_syntax_manager.c:1948)

Suggestions

Check DDL on source and target to ensure they match
Review apply_exceptions to see if transactions errored (a delete has failed then a new insert violated the PK constraint)
If you have Change Tables enabled, check the order of transactions for the record in question

Redo/transaction log not found examples

[Microsoft][SQL Server Native Client 10.0]An error has occurred during an attempt to access the log file, logging disabled

Suggestion

Ensure replication pre-requisites are in place

[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'source_current_position’

Suggestion

Ensure source and target DDL match (or are compatible)

SQL_ERROR SqlState: 08S01 NativeError: 10054 Message: [Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.

Suggestion

Talk with DBA team to trace why the connection was severed

[IBM][System i Access ODBC Driver]Communication link failure. comm rc=8500 - System policy does not allow use of this data source. Contact your system administrator. ODBC general error.

Suggestion

Ask your DBA / Admin to verify you have access

Network Related Examples

[SOURCE_CAPTURE ]E: Could not receive data from WAL stream: server closed the connection unexpectedly

TARGET_LOAD ]D: Connection failure error codes are: 00026,00904,10054,4060,18456,01222,55,64,121,1231,233,109 (provider_syntax_manager.c:1870)

Suggestion

Contact network team to verify network stability

Firewall

ERROR_GENERAL ORA-03135: connection lost contact Process ID: 4156 Session ID: 357 Serial number: 42497

Suggestion

Talk with your Network administrator to check the idle time of any firewall. This message was from the source Oracle connection severing due to 5 minutes of inactivity.

[TARGET_APPLY ]E: RetCode: SQL_ERROR SqlState: 08S01 NativeError: 10054 Message: [Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host. [1022502]

Suggestion

Ensure firewall is turned off or firewall rules allow communication for replicate.

Disk Space

[DATA_STRUCTURE ]E: SQLite general error. Code <13>, Message <database or disk is full>. [1000505] (at_sqlite.c:484)

Suggestion

Review all mount points and ensure that all have enough disk space to operate.

Environment

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Re: Find errors by searching log for "]E"

yit-huang — Thu, 27 Oct 2022 08:28:18 GMT

@Troy_Raney

I have a question on this item:

•[IBM][System i Access ODBC Driver]Communication link failure. comm rc=8500 - System policy does not allow use of this data source. Contact your system administrator. ODBC general error.

Suggestion: Ask your DBA / Admin to verify you have access

is it insufficient permission on DB2? Could you share some documents/references on checking DB2's permission setting and configuration?

Re: Find errors by searching log for "]E"

Sonja_Bauernfeind — Thu, 27 Oct 2022 10:36:50 GMT

Hello @yit-huang

Let me see if I can find a subject matter expert to review your request!

All the best,
Sonja

Re: Find errors by searching log for "]E"

KellyHobson — Thu, 27 Oct 2022 13:25:52 GMT

Hey @yit-huang ,

Thanks for reaching out with your question!

What kind/ flavor of DB2 do you have: LUW, z/OS, iSeries?

Yes, this looks like a permissions issue on the data source Replicate is trying to access.

From the user guide (example z/OS), here is the link to prerequisites.

More specifically, here are the required permissions you need to check with DBA if these are the settings.

Please let us know if you have any follow up questions.

Best,

Kelly

Re: Qlik Replicate: Example error codes sent by data sources in

yit-huang — Mon, 31 Oct 2022 03:19:41 GMT

Thank you @KellyHobson, we are creating “IBM DB2 for iSeries” endpoint connection.

From User signon to DB2/AS400 fails with error message. (ibm.com), the troubleshooting describes that "The user starting the Cognos service does not have appropriate access permissions to the ODBC Driver". Could you confirm the root cause is the permission setting on "DB2 for iSeries" rather than "the driver"?

Re: Qlik Replicate: Example error codes sent by data sources in

KellyHobson — Mon, 31 Oct 2022 13:34:50 GMT

Hey @yit-huang ,

It is difficult to determine without additional logging/ more info about your source connection.

I have opened a new support case with your contact information and will PM you the details.

Thanks!

Kelly

Re: Qlik Replicate: Example error codes sent by data sources in

yit-huang — Thu, 03 Nov 2022 07:07:54 GMT

hi @KellyHobson, I received the update for the case in emails, but I have no permission to reply in past day.

I commented in the case just now.

article Qlik Replicate: Example error codes sent by data sources in in Official Support Articles

Qlik Replicate: Example error codes sent by data sources in

PK violation examples

Redo/transaction log not found examples

Network Related Examples

Firewall

Disk Space

Environment

Related Content

Re: Find errors by searching log for "]E"

Re: Find errors by searching log for "]E"

Re: Find errors by searching log for "]E"

Re: Qlik Replicate: Example error codes sent by data sources in

Re: Qlik Replicate: Example error codes sent by data sources in

Re: Qlik Replicate: Example error codes sent by data sources in