BDLS error after system copy in bw system

[Former Member]

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

bdls._error.txt.zip

[Former Member]

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

[former_member182657]

Thanks for the update.Kindly close the thread.

[Former Member]

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.

[Former Member]

Hi Tim,

No table entries found in table TBDBDLSADMIN.

Regards

Shafeeq

[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.

[Former Member]

Hi Muhammed,

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

Regards,

Serhat

[Former Member]

Hi Serhant,

Yes i have restarted , yesterday night i have Stopped DB2 ,SAP, Then Started DB2, SAP, still error persist.

Regards

Shafeeq

[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

[Former Member]

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

[former_member182657]

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,

[former_member182657]

Hi,

Could you share SAP_BASIS component SP level.

Thanks,

[Former Member]

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

[Sriram2009]

Hi

Is this same kernel & DBSL level in source & target systems?

BR

SS

[Former Member]

Hi shafeeq

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

Regards

Ram