Symptom
Below error occurred in your Sybase error log.
This query requires 527 auxiliary scan descriptors, but currently there are only 160 auxiliary scan descriptors available. Either raise the value of the ‘number of aux scan descriptors’ configuration parameter or try your query later.
Error: 10901, Severity: 17, State: 1
Solution
Taken from Sybase official documentation below, you may refer to this link for further explanation.
number of aux scan descriptors sets the number of auxiliary scan descriptors available in a pool shared by all users on a server.
Each user connection and each worker process has 48 scan descriptors exclusively allocated to it. Of these, 16 are reserved for user tables, 12 are reserved for worktables, and 20 are reserved for system tables (with 4 of these set aside for rollback conditions). A descriptor is needed for each table referenced, directly or indirectly, by a query.
Refer to SAP Note 1646155 – SYB: Configuring auxiliary scan descriptors,
Increase the ASE configuration parameter ‘number of aux scan descriptors’ to a suitable number. The minimum number of scan descriptors needed during the failed execution is part of the error message you can find in the trace file or in the runtime error text in transaction ST22. It is recommended to increase the value to a number higher than this minimum value.
To change the configuration parameter, use transaction DBACOCKPIT. Choose the action “Server Configuration” from the “Configuration” menu. The parameter ‘number of aux scan descriptors’ is part of the ‘SQL Server Administration’ group. Select the parameter and choose ‘Change’ to set a new value. The change is recorded in the DBA Cockpit audit log.
As the parameter is a dynamic parameter, the change takes effect immediately and no restart of the database server is required.
