SAP Knowledge Base Article - Preview

2276339 - Sybase IQ DB monitoring fails. Query on sp_iqdbspace fails with Error -207. Wrong number of values for INSERT

Symptom

IQ database monitoring fails.

In SM21 and the Workprocess Trace shows:

ERROR: -1 in function RefillBuffer (fetch) [line 23398]
(-207) [21S01] [Sybase][ODBC Driver][Sybase IQ]Wrong number of values for INSERT
sql statement is ==> select count(*) from sp_iqdbspace() where Online = 'T'
/* R3:CL_SQL_STATEMENT==
============CP:468 T:sp_iqdbspace() */

When executing the query involved in dbisql utility, it fails too :

(DBA)> select count(*) from sp_iqdbspace() where Online = 'T' ;

count()

-----------

There was an error reading the results of the SQL statement. The displayed results may be incorrect or incomplete.

Wrong number of values for INSERT

SQLCODE=-207, ODBC 3 State="21S01"


Read more...

Environment

SAP IQ16 SP08.

May occur in any IQ 16 version.

Product

SAP IQ 16.0 ; SAP Solution Manager 7.1

Keywords

sp_iqdbspace ; alter database upgrade ; -207 ; Wrong number of values for INSERT ; SYSHISTORY ; SYS.SYSHISTORY , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.