SAP Knowledge Base Article - Preview

2082294 - rs_lastcommit fails with error: ERROR #1028, SQL0103N, and ERROR #5046 - SAP RS

Symptom

  • Insert into rs_lastcommit related to DB2 LUW (Linux Unix Windows)
  • DSI connection fails with the following lines in the Replication Server errorlog:

    T.. (22): Output command:  insert into rs_lastcommit values (0, 0x000000000000000000000000000000000000000000000000000000000000000000000000, 0x000000000000000000000000000000000000000000000000000000000000000000000000, '19000101 00:00:00:000', current timestamp)
    E.. ERROR #1028 DSI(103 <rds>.<rdb>) - /dsioqid.c(2022) Message from server: Message: -103, State 0, Severity 19 -- '[[Message Iteration=1|Data Source Name=<data_source_name>|SQL Function=INSERT|SQLState=42604|Native Error=-103|Message=[IBM][CLI Driver][DB2/LINUXX8664] SQL0103N  The numeric literal "0x00000000000000000000000000000000000000000000000000000000000000000000" is not valid.  SQLSTATE=42604]'.
    E.. ERROR #5046 DSI(103 <rds>.<rdb>) - /dsioqid.c(2036) When executing the rs_get_lastcommit function in database '<rds>.<rdb>', received data server errors. See logged data server errors for more information.

Read more...

Environment

SAP Replication Server (any version)

Product

SAP Replication Server all versions ; SAP Replication Server, heterogeneous edition all versions ; SAP Replication Server, option for IBM DB2 all versions ; SAP Replication Server, real-time loading edition all versions ; Sybase Replication Server software all versions ; Sybase Replication Server, heterogeneous edition all versions ; Sybase Replication Server, real-time loading edition all versions

Keywords

CR729274, 729274 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.