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 ONE Support launchpad (Login required).

Search for additional results

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