Runtime Error: DBSQL_SQL_ERROR

[Former Member]

Hi Experts: I am getting a runtime error  while running an infopackage which loads data from ECC/R3 The details are given below.

Category                   Installation Errors

Runtime Errors         DBSQL_SQL_ERROR

Except.                     CX_SY_OPEN_SQL_DB

Short Text
    SQL error "SQL code: 64" occurred while accessing table "BIW_PS24".

What happened?
    Database error text: "SQL message: TCP Provider: The specified network name is
     no longer available.##"

What can you do?
    Note which actions and entries caused the error to occur.

    Consult your SAP administrator.

    Using transaction ST22 for ABAP dump analysis, you can view, manage,
    and retain termination messages for longer periods.

Error analysis
    An exception has occurred which is explained in more detail below. The
    exception is assigned to class 'CX_SY_OPEN_SQL_DB' and was not caught in
     procedure
    "PSBW_PRPS8_TO_PRPS24_PROJ24" "(FUNCTION)", nor was it propagated by a RAISING
     clause.
    Since the caller of the procedure could not have anticipated this
    exception, the current program was terminated.
    The reason for the exception is:
    Database error text: SQL message: TCP Provider: The specified network name is
     no longer available.##
    Return value of the database layer: "SQL dbsl rc: 99"

How to correct the error
    The exception must either be prevented, caught in procedure
     "PSBW_PRPS8_TO_PRPS24_PROJ24" "(FUNCTION)", or
    the possibility of it occurring must be declared in the RAISING clause
    in the procedure.
    To prevent the exception, note the following:

    Analyze the entries in the system log (transaction SM21).
    If the error occurs in a non-modfied SAP program, you might be able to
    find a solution in the SAP Notes system. If you have access to the SAP
    Notes system, check there first using the following keywords:

   "DBSQL_SQL_ERROR" CX_SY_OPEN_SQL_DB
   "SAPLPSBS" bzw. LPSBSU04
   "PSBW_PRPS8_TO_PRPS24_PROJ24"
   If you cannot solve the problem yourself, please send the following
   information to SAP:

   1. This description of the problem (short dump)
   To do this, choose  System -> List -> Save -> Local File (unconverted)
   on the screen you are in now.

   2. A suitable system log
   To do this, call the system log in transaction SM21. Restrict the time
   interval to ten minutes before the short dump and five minutes after
   it. In the display, choose System -> List -> Save -> Local File
   (unconverted).

   3. If these are programs of your own, or modified SAP programs: Source
   code of these programs
   To do this, choose  More Utilities -> Upload/Download -> Download in
   the Editor.

   4. Details regarding the conditions under which the error occurred or
   which actions and input caused the error.

Source code extract

3 *"*"Lokale Schnittstelle:

4 *"       IMPORTING

5 *"             VALUE(T_R_PSPNR) TYPE  PSBW_T_R_PSPNR

6 *"       EXPORTING

7 *"             VALUE(E_T_PS24) TYPE  PSBW_T_PS24

8 *"-------------------------------------------------------------

9

10   IF NOT T_R_PSPNR[] IS INITIAL.

11

12     SORT T_R_PSPNR.

13     DELETE ADJACENT DUPLICATES FROM T_R_PSPNR.

14

>>     SELECT *

16            FROM BIW_PS24

17            INTO CORRESPONDING FIELDS OF TABLE E_T_PS24

18            FOR ALL ENTRIES IN T_R_PSPNR

19            WHERE PSPNR = T_R_PSPNR-PSPNR.

20

21   ENDIF.

22

23   SORT E_T_PS24 BY PSPNR.

24

25 ENDFUNCTION.

Please help me to resolve this.

[Anand71]

Hi,

Check this blog :

http://scn.sap.com/community/data-warehousing/business-content-and-extractors/blog/2015/09/18/bw-inf...

Regards,

Anand Kumar

[colm_boyle]

Hi Das,

it seems there are a few corrections related to the performance of the FM ...PSBW_PRPS8_TO_PRPS24_PROJ24. Check if you can implement the notes 522006, 1737738 & 780250? They might improve the performance of the select on BIW_PS24.

Also, check if you can increase your memory parameters/allowance. And check and make sure you are not loading too much data in one request, please see the note 892513 for these recommendations.

What is the size of BIW_PS24?

Thanks,

Colm

[former_member278885]

Complete restart of the systems (R3, DB, server OS) should workaround the issue

Regards,

AP.

[petra_writz]

Hi,

did you solve this problem?

I've got the same error, but on different tables.

We use BW 7.4 on Windwos 2008 R2 and SQL Server 2012.

We implemented a new stack last week. We had SPS 9 and gone to SPS11. Since this implementation we have at different day times this error:

Short Text

    SQL error "SQL code: 64" occurred while accessing table "xxx".

What happened?

    Database error text: "SQL message: TCP Provider: The specified network name is

     no longer available.##"

It occurs on different tables.

Does somebody have an idea?

Thank you

Best regards

Petra Wöritz

[Former Member]

Hi Petra,

Did you resolve your issue? We have the same problem.

[petra_writz]

Hi Olzhas,

we had a Problem with the communication between our application Server and the db Server. Both are VMWare and at the host with the VM of DB Installation was too much traffic and not enough ressources.
We moved the VM to another host and solved this problem.

[sander_vanwilligen]

Hi,

Please provide more information. E.g. which DataSource are you using (a Business Content one or generic), which SAP source system (incl. release and SP level), which database?

Best regards,

Sander