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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.