Symptom
The synchronization of the consolidate DB2 database was working fine in the development environment. After setting up everything in the test environment, each synchronization fails. The messages in the MobiLink server log file looks like the following:
:
I. 2011-11-16 20:09:15. COMMIT
I. 2011-11-16 20:09:15. Closing connection for error/log hooks.
E. 2011-11-16 20:09:15. Server error: Message: ODBC: [IBM][CLI Driver][DB2/NT] SQL0198N The statement string of the PREPARE or EXECUTE IMMEDIATE statement is blank or empty. SQLSTATE=42617
(ODBC State = 42617, Native error code = -198). Table Name: <table name>
I. 2011-11-16 20:09:15. Opening connection to remote database to call error/log hook.
I. 2011-11-16 20:09:15. insert into #hook_dict values( 'MobiLink user','<user ID>' );
I. 2011-11-16 20:09:15. insert into #hook_dict values( 'script version','<script version>' );
I. 2011-11-16 20:09:15. insert into #hook_dict values( 'error message','Server error: Message: ODBC: [IBM][CLI Driver][DB2/NT] SQL0198N The statement string of the PREPARE or EXECUTE IMMEDIATE statement is blank or empty. SQLSTATE=42617
(ODBC State = 42617, Native error code = -198). Table Name: <table name>' );
I. 2011-11-16 20:09:15. insert into #hook_dict values( 'error id','15036' );
I. 2011-11-16 20:09:15. insert into #hook_dict values( 'error hook user state','0' );
I. 2011-11-16 20:09:15. insert into #hook_dict values( 'publication_0','Master' );
:
Read more...
Environment
SAP Sybase SQL Anywhere
Product
Keywords
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.