cancel
Showing results for 
Search instead for 
Did you mean: 

System Log Database error 54 at EXE

Former Member
0 Kudos

Hi Experts,

I am getting the following system log during the master data load.

Database error 54 at EXE

ORA-00054: resource busy and acquire with NOWAIT specified

This log is generated daily when the master data load is running.

But we are not facing any load failures due to this log in SM21.

Please help me to avoid this error.

Thanks & Regards,

Sunil

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member182470
Active Contributor
0 Kudos

Hi,

Check the table space settings in DB02 t-code.

In RSA1->Administration Tab->Current Settings->Batch Process

Regards,

Suman

Former Member
0 Kudos

what are the exact values you want me to look in?

Sunil

former_member182470
Active Contributor
0 Kudos

Hi,

Generally we will not be given access to change the Table space settings. You have to contact BASIS to know more about DB02.

Regards,

Suman

Former Member
0 Kudos

Hi Sanjay,

BASIS team had reported this issue to BW team

Let me know of any other options to dig the route cause.

Regards,

Sunil

ACE-SAP
Active Contributor
0 Kudos

Hello

To be able to solve this issue you need to know which SQL statement is causing that error.

DB02 could allow you to check in the Oracle system log, you can also try to check in the workprocess logfile (ST11) if you can get some information on the statement/tables involved in that error

Regards

Former Member
0 Kudos

Hi,

Check following thread,

[;

Regards,

Durgesh.

Former Member
0 Kudos

Hi Durgesh,

We are not getting any short dumps except the SM21 message.

As mentioned there are also no load failures occurring.

Please suggest

Sunil