Issue happen to see only in SP03PL04 version with respect to sort buffers.

[Former Member]

ERROR1 :Sort failure. The configure size for data cache () is not sufficient to handle the sort buffers (86) requested. Please reconfigure the data cache or sort buffers and try the command again.

ERROR2 : Sort failure. The configure size for data cache (default data cache) is not sufficient to handle the sort buffers (48) requested. Please reconfigure the data cache or sort buffers and try the command again.

ERROR3 : Sort failure. The configure size for data cache (default data cache) is not sufficient to handle the sort buffers (24) requested. Please reconfigure the data cache or sort buffers and try the command again.

[M-B]

Hello Mohammed,

Always attach a sybdiag output when you raise an issue related to ASE. If you are running Business Suite on ASE,

Execute the following on the command line

1. Log in as syb<sid> (On Windows system, make sure you open the cmd prompt in administrator mode)

2. execute this command on the command line sybdiag -S<DBSID> -Usapsa -T asecore, keyfile, aseadd, osdata

3. Attach the generated .zip file

If this is a standalone ASE, login as sybase user and replace sapsa by sa in the command.

Thanks

Mehrab