SAP Knowledge Base Article - Preview

2329094 - Query Failing after table dropped, recreated and populated with data, and a new column added. SAP IQ

Symptom

The following items were done to an existing table:

  1. Dropped and recreated the table adding a column. The column added was a char(1) and a constant value of 'Y' added to existing data.  The column is nullable.
  2. Recreated a view that used the table.
  3. Recreated a function - that is also used by that table.
  4. Rebooted the IQ


The query does not fail per se, it fails with the following error:

  • Sybase Server error 13492 (severity 19): SQL Anywhere Error -1000: Temporary space limit exceeded

  • Same Query ran quickly in IQ before the addition of the new column.


Read more...

Product

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

Keywords

KBA , BC-SYB-IQ , Sybase IQ , 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.