Solman 7.1 with Sybase - runtime error when accessing SMSY

[Former Member]

Hello ,

I have implemented the central note 0001734341 latest version in solution manager 7.1 SR1 and database is Sybase ASE 15.7

I have done the SLD, LMDB configuration and I am able to see my ECC system in the managed system configuration tab. But when I try to access the ECC system in SMSY its giving me a run time error as below

Category               Installation Errors

Runtime Errors         DBIF_RSQL_SQL_ERROR

Except.                CX_SY_OPEN_SQL_DB

Date and Time          30.06.2013 09:44:41

Short text
    SQL error 10901 when accessing table "SMSY_SYST_COMP".

What happened?
    Error Text of the Database: "[ASE Error SQL10901]This query requires 24
     auxiliary scan descriptors, but currently there are only 16 auxiliary scan
     descriptors available. Either raise the value of the 'number of aux scan
     descriptors' configuration parameter or try your query later.#"

Error analysis

    An exception occurred that is explained in detail below.

    The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

     in

    procedure "SMSY_GET_SYSTEMS_TO_PRODVERS" "(FUNCTION)", nor was it propagated by

     a RAISING clause.

    Since the caller of the procedure could not have anticipated that the

    exception would occur, the current program is terminated.

    The reason for the exception is:

    Error Text of the Database: "[ASE Error SQL10901]This query requires 24

     auxiliary scan descriptors, but currently there are only 16 auxiliary scan

     descriptors available. Either raise the value of the 'number of aux scan

[Former Member · Accepted solution]

Anyone have any idea to resolve the issue, please help. I would appreciate it.

Thanks

Raj

[Former Member · Accepted solution]

Hi Rajagopal,

Please check the below note .. Hope it will fix your issue,

Note 1646155 - SYB: Configuring auxiliary scan descriptors

Thanks,

Jagadish.

[Former Member · Accepted solution]

Hi Jagadish,

Thanks for the information, It helped me to fix the issue.

Regards

Raj