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 for Me (Login required).

Search for additional results

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