SAP Knowledge Base Article - Preview

3038124 - SAP IQ - "Table ~ cannot be found in the IQ store" error returns during running sp_iqtablesize

Symptom

(dba)> sp_iqtablesize ('owner_name.table_name');
Could not execute statement.
  Table 'table_name' cannot be found in the IQ store.
  --
  (dblib/db_iqutility.cxx 2818)
  SQLCODE=-1009141, ODBC 3 State="HY000"

However, you can run "select" query statement with the table.

(dba)> select * from owner_name.table_name
expression expression1
----------------------
         2 aa
         4 bb


Read more...

Environment

  • SAP IQ all versions

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , How To

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.