Skip to Content
avatar image
Former Member

BDLS error after system copy in bw system

Hi Experts ,

May i please request you to please help me on the below issue which iam facing BDLS error after system copy in bw system

i have done system copy of  bw system

source ( BW, AIX, DB2)

target ( BW,AIX,DB2)

EVERYTHING worked fine till bdls

Category               Error in Database Interface

Runtime Errors         DBIF_RSQL_INVALID_REQUEST

Date and Time          19.03.2015 16:57:26

Short text

     Invalid request.

What happened?

     The current ABAP/4 program terminated due to

     an internal error in the database interface.

Error analysis

     An invalid request was made to the SAP database interface in a statement

      in which the table "TBDBDLSADMIN" was accessed.

Trigger Location of Runtime Error

     Program                                 SAPLBDLS

     Include                                 LBDLSU16

     Row                                     23

     Module type                             (FUNCTION)

     Module Name                             BDLS_TABLE_LOAD

Source Code Extract

Line  SourceCde

1 FUNCTION BDLS_TABLE_LOAD.

2 *"----------------------------------------------------------------------

3 *"*"Lokale Schnittstelle:

4 *"----------------------------------------------------------------------

5 * Administration-table

6   select count(*) from tbdbdlsadmin into counter.

7   add 1 to counter.

8   if counter gt c_max.

9 * löschen der ersten 800 Einträge

0     delete from tbdbdlsadmin where counter le c_save.

1 * den counter um 800 verringern für die bestehenden

2     select * from tbdbdlsadmin.

3       tbdbdlsadmin-counter = tbdbdlsadmin-counter - c_save.

4       insert tbdbdlsadmin.

5     endselect.

6     delete from tbdbdlsadmin where counter gt c_save.

7     counter = counter - c_save.

8   endif.

9   tbdbdlsadmin-counter = counter.

0   tbdbdlsadmin-datum = sy-datum.

1   tbdbdlsadmin-uhrzeit = sy-uzeit.

2   tbdbdlsadmin-name = sy-uname.

>   insert tbdbdlsadmin.

4 * read all excluded tables from automatic changing

5   select * from bdlsext where objcls = 'T'.

6     i_excl-tabname = bdlsext-objkey.

7     append i_excl.

8   endselect.

9   select * from bdlsexz where objcls = 'T'.

0     i_excl-tabname = bdlsexz-objkey.

1     append i_excl.

2   endselect.

3   sort i_excl by tabname.

4 * read all tables and structures with domain ls_domain

5   SELECT tabname fieldname keyflag FROM dd03l

6                          INTO CORRESPONDING FIELDS OF TABLE t_field_ls

7                         WHERE domname = ls_domain

8                           AND as4local = tab_activ.

9   IF sy-dbcnt > 0.

0 * read only active transparent tables

Could you please help me to resolve this error

Many Thanks in Advance..!!!

Regards

Shafeeq

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Mar 19, 2015 at 07:25 PM

    Hi shafeeq

    Refer the 3 sap notes 2014933,1714286 and 1844916 for issues during BDLS

    Regards

    Ram

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 20, 2015 at 07:17 AM

    hi ram,

    the below sap notes did not apply as its on highest level  NW7.3 EHP 1

    Is there any other options.

    Regards

    Shafeeq

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 20, 2015 at 07:55 AM

    Hi,

    Could you share SAP_BASIS component SP level.

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 20, 2015 at 07:58 AM

    An invalid request was made to the SAP database interface in a statement

          in which the table "TBDBDLSADMIN" was accessed.

    Could you check with SAP Notes  2014933 - BDLS: Function module BDLS_TABLE_LOAD

    1714286 - BDLS: Prevention of various terminations

    Hope this will help you.

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 20, 2015 at 09:33 AM

    hi,

    kernel level

    source : kernel 721 sp 401  , db_client DB6_81 ,   sap_basis   sp level  731 sp 14

    target  : kernel 721 sp 401   , db_client DB6_81 ,    sap_basis   sp level  731 sp 14

    above note did not worked .

    Regards

    Shafeeq

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 20, 2015 at 09:54 AM

    Hi Muhammed,

    Have you already tried to restart it? Does the error persist then?

    Regards,

    Serhat

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Muhammed,

      Maybe you would try BDLS exception table "BDLSEXZ" to exclude that table which cannot be accessed. I know it's not a proper solution but you can take this into account as a workaround maybe.

      Related notes :

      1844916 - BDLS: Client-independent and excluded tables

      1845435 - BDLS table exclude does not completely work

      1714286 - BDLS: Prevention of various terminations

      Good luck and regards,

      Serhat

  • avatar image
    Former Member
    Mar 20, 2015 at 01:09 PM

    What are the current entries in the table tbdbdlsadmin?

    The insert into that table is going wrong, it might be because it is trying to insert the same key as a previous run.

    It might just be the logic in the FM is failing so trying to insert the same counter ID.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Have you got a friendly developer there?

      If so I would put a break point on the start of the section of code below and see if they can see anything unusual that gets populated, I checked and the code is the same as here where we have run lots of BDLS runs.  If that does not throw anything up there must be something going on at the database level.

      tbdbdlsadmin-counter = counter.

      tbdbdlsadmin-datum = sy-datum.

      tbdbdlsadmin-uhrzeit = sy-uzeit.

      tbdbdlsadmin-name = sy-uname.

      insert tbdbdlsadmin.

  • avatar image
    Former Member
    Mar 21, 2015 at 03:03 AM

    Hi All,

    i have checked all but nothing worked.

    hence i have restored again and renamed tables properly  and started system

    This time it worked , the issue might be with the table renaming .

    i suggest you be careful while doing  table rename.

    Thanks guys for your support

    Regards

    Shafeeq

    Add comment
    10|10000 characters needed characters exceeded