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
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.
SAP Knowledge Base Article - Preview