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 for Me (Login required).

Search for additional results

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