SAP Knowledge Base Article - Preview

2822449 - Error 102 when executing sp_iqrebuildindexwide for a table with many columns and many indexes

Symptom

The execution of sp_iqrebuildindexwide for a table with many columns and many indexes reports the following error:

1> sp_iqrebuildindexwide Tbwide,dba,4
2> go
Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near 'XXX021_20NN" column "XXX021_20NN_X"
column "XXX022_2011" column "XXX022_20NN_X" column "XXX023_20NN" column "XXX023_20NN_X" column "XXX024_2'


Read more...

Environment

  • SAP IQ 16.0 SP11 PL23 

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

sp_iqrebuildindexwide error 102 Msg 102 -131 syntax error near column many indexes wide CR 819792 CR819792 , KBA , BC-SYB-IQ , Sybase IQ , 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.