ABAP Server Resource Shortage

[Former Member]

Dear Friends,

We have installed SAP Netweaver 7.3 ABAP (BW) on Sybase 15.7 ASE database and Windows 2008 server.

Now when we are activating a infocube in t. code RSA1 then we are getting shortdum as belwo

"Short text
    SQL error 30012 while accessing table "NRIV".

What happened?
    Database error text: "[ASE Error SQL30012:08001]Client unable to
     connection[ASE Error SQL30012:08001]Client unable to establish a

What can you do?
    Please make a note of the actions and input which caused the erro
    -

    To resolve the problem, contact your
    SAP system administrator.

    Using transaction ST22 for ABAP dump analysis you can see and
    administrate termination messages and retain them for longer peri
    Please make a note of the actions and input which caused the erro
    -

    To resolve the problem, contact your
    SAP system administrator.

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 "NUMBER_GET_NEXT_SQL" "(FORM)", 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:

    Database error text: "[ASE Error SQL30012:08001]Client unable to establish a

     connection[ASE Error SQL30012:08001]Client unable to establish a connection"

Regards

Ganesh Datt Tiwari

[Former Member]

Lots of possible causes here.

The error is from the client not ASE so ...

- IS ASE up?

- Can it be be connected to?

- Any network/firewall issues?

- Is ASE Listening on the right ports?

[Former Member]

Hi Chris,

Thanks for your valuable reply.

We are able to login in SAP.

How can be foiund " Is ASE Listening on the right ports?"

Regards

Ganesh Datt Tiwari

[Former Member]

Can you log into ASE (i.e. via ISQL)?

If so then run 'select * from master..syslisteners' - this will tell you what network interfaces ASE is listening on.

[Former Member]

Hi Chris,

Please find the below output of teh command 'select * from master..syslisteners'

nlwnsck          ','XXXXXXX 4901                                                                                                                                                                                                                                                 ',0,

'nlwnsck                         ',XXXXXXXX 4901                                                                                                                                                                                                                                                 ',0,

'nlwnsck                         ','XXXXXXXXX 4901                                                                                                                                                                                                                                                 ',0,

'nlwnsck                         ','XXXXXXXX  4901

Note: XXXXXXXXX  is hostname

Regards

Ganesh

[Former Member]

So ASE is listening on port 4901 on host XXXXX

(See http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc38421_1500/html/ntconfig/X63416.htm )

Are you running the host on a seperate server to ASE?

[Former Member]

Hi Chris,

No. SAP application and Sybase are running on same server.

Regards

Ganesh

[Former Member]

Ok.  My SAP experience is limited. 

Try turning login auditing on in ASE - this report on all connection attempts (to the ASE errorlog).  This will show if the application is getting through to ASE?

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc38421_1500/html/ntconfig/X36456.htm

[JanStallkamp]

As long as the SAP system came up the basic DB connection seems to be fine (most of the time). Can you reproduce the issue? Are there more shortdumps in ST22?

I would recommend opening a message at BC-DB-SYB as I doubt this can be analyzed without system access. Please mention the versions/patch levels of ASE, DBSL, kernel and ODBC-driver in the message.

Regards,

Jan