SAP Knowledge Base Article - Preview

1945066 - Error " The statement string of the PREPARE or EXECUTE IMMEDIATE statement is blank or empty. " when trying to create MobiLink system objects in consolidate DB2 database - SQL Anywhere

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

SAP SQL Anywhere all versions ; SQL Anywhere all versions

Keywords

UltraLite, IBM DB2
, KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

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.