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.