SAP Knowledge Base Article - Preview

3345825 - Error 1538 when creating a clustered index on a roundrobin partition table with more than 254 partitions - SAP ASE

Symptom

  • Table has more than 255 round robin partitions.

  • Receiving error 1538 when creating a clustered index on the table:
    Msg 1538, Level 17, State 1:
    Server 'SERVER', Line 1:
    max utility parallel degree 5 is less than the required 'max utility parallel degree' 517 to create clustered index on partition table. Change the parallel degree to required parallel degree and retry.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Msg 1538, 1538, Error 1538, round robin, roundrobin, partition, create unique clustered index, create clustered index, CR828127, CR#828127, CR 828127, 828127, "max utility parallel degree", parallel, serial, "number of worker processes" , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.