Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Oct 28, 2022 5:50:42 AM
Apr 21, 2021 7:47:27 AM
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
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
[Microsoft][SQL Server Native Client 10.0]An error has occurred during an attempt to access the log file, logging disabled
Suggestion
[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'source_current_position’
Suggestion
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
[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
[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
ERROR_GENERAL ORA-03135: connection lost contact Process ID: 4156 Session ID: 357 Serial number: 42497
Suggestion
[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
[DATA_STRUCTURE ]E: SQLite general error. Code <13>, Message <database or disk is full>. [1000505] (at_sqlite.c:484)
Suggestion
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.
SQL Database Engine Errors
Replicate Loggers
Qlik Replicate Troubleshooting
How to analyze a Qlik Replicate log
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?
Hello @yit-huang
Let me see if I can find a subject matter expert to review your request!
All the best,
Sonja
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
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"?
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
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.