SAP Knowledge Base Article - Preview

2016177 - DSI shuts down on error: Message from server ... Invalid SQL syntax - SRS

Symptom

SAP Replication Server (SRS) DSI shuts down with the following error in the errorlog:

T. YYYY/MM/DD HH:MM:SS. (95): '{CALL <schema>.<stored_procedure_name>(@argument1)}'
E. YYYY/MM/DD HH:MM:SS. ERROR #1028 DSI EXEC(107(1) DCT_NYPRISM8.dta1) - dsiqmint.c(4272)
Message from server: Message: 30291, State 0, Severity 19 -- '[[Message Iteration=1|Data Source Name=DTA1|SQLState=37000|Native Error=-99999|Message=[IBM][CLI Driver] CLI0118E Invalid SQL syntax. SQLSTATE=37000]'.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)
SAP Replication Server (SRS)
SAP Enterprise Connect Data Access (ECDA)
RS  -> ECDA using IBM's ODBC driver to DB2 -> DB2 z/OS

Product

SAP Replication Server all versions ; SAP Replication Server, heterogeneous edition all versions ; SAP Replication Server, option for IBM DB2 all versions

Keywords

KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP-RSO , Rep Server Options (RSO) , Problem

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.