SAP Knowledge Base Article - Preview

3002691 - Got error 1910 when create proxy table is executed for SAP IQ - SAP ASE

Symptom

When create a proxy table on ASE for IQ table which has more than 250 columns, you will get error 1910.

1> create proxy_table testtab1 at "iqdemo.iqdemo.testuser.testtab1"
2> go
Msg 1910, Level 16, State 1:
Server 'ASE', Line 1:
Cannot create more than 250 indexes on one table.
Msg 1910, Level 16, State 1:
Server 'ASE', Line 1:
Cannot create more than 250 indexes on one table.
1>


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • SAP IQ

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP IQ all versions

Keywords

proxy table, create proxy_table, create existing table, FP index, IQ , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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 ONE Support launchpad (Login required).

Search for additional results

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