Database Error 54 Db
Contents |
Intelligence Old Forum (Read Only Archive) Where is this place located?All Places Business Intelligence Old Forum (Read Only Archive) 4 Replies Latest reply: Jul 26, 2011 10:56 AM by Anindya Bose Tweet Database error 54 at EXE Jens Heinichen
Database Error 54 At Exe
Mar 26, 2010 10:21 AM Currently Being Moderated Hello together,we've got the following 54 db equivalent error message on our BW 3.5 system:
Time Ty. Nr Cl. User Tcod MNo Text
02:14:01 DIA 001 302 ALEREMOTE BY2 Database
53 Db
error 54 at EXE
Details Recording at local and central time........................ 26.03.2010 02:14:01
Task................ 13968 / Dialog work process No. 01
User................ ALEREMOTE
Client.............. 302
Terminal............
Session............. 1
Transaction code....
Program ora-00054 resource busy and acquire with nowait specified name........ SAPMSSY1
Problem class....... K SAP Web AS Problem
Development class... SBAC
Module name......... dbds
Line................ 699
Table name.......... 54
Field name.......... EXE
Documentation for system log message BY 2 :
After the attempt to call a database operation, the database system has
returned the error code specified in the message, which indicates that
the operation concerned could not be executed ora-06512 successfully.
Technical details
File................ 274289
Position............ 0000488700
Entry type.......... h ( Database Error (Non-SQL) )
Message ID.......... BY 2
Variable parts...... 54 EXE dbds 699
Have someone a tip or advise what the reason could be?
Thx and a nice Friday :)
BR,
JensEdited by: Jens Heinichen on Mar 26, 2010 10:18 AM 3362Views Re: Database error 54 at EXE M Tibollo Mar 26, 2010 10:28 AM (in response to Jens Heinichen) Currently Being Moderated it seems that the process you launched didn't find a free resource...did you try to launch again?M. Alert Moderator Like (0) Re: Database error 54 at EXE Jens Heinichen Mar 26, 2010 11:22 AM (in response to Jens Heinichen) Currently Being Moderated No not at the moment, but it is a good idea we will check this option now. Someone tells me thatit is also possble to reschedule connectes processes like process chains if a chain is ivloved. We will ty it.thxJens Alert Moderator Like (0) Re: Database error 54 at EXE sunil kumar Jul 26, 2011 8:11 AM (in response to Jens Heinichen) Currently Being Moderated This is happening in our system as well during the master data load.Did you get rid
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi Clinton Jones bluesguyAZ59 Iqbalyk blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies Toolbox for IT Topics SAP Groups Ask a http://scn.sap.com/thread/1644688 New Question SAP BW The SAP BW group is a forum where peers share technical expertise, solve problems, and discuss issues related to SAP Business Warehouse. Home | Invite Peers | More SAP Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces http://sap.ittoolbox.com/groups/technical-functional/sap-bw/database-error-54-at-exe-694948 please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Database error 54 at EXE cp409sd asked Mar 26, 2005 | Replies (1) We continually get this error in the system log when loading master data(BW3=2E1): Database error 54 at EXE ORA-00054: resource busy and acquire with NOWAIT specified We have changed all master data to run in sequence, in hopes of preventing this problem, since it is a resource busy error, but that has not worked=2E The problem is not causing loads to fail, but we want to correct the problem=2E Has anyone else seen this issue? Thanks for the help=2E Join this group Popular White Paper On This Topic Big Data and the CMO: An Introduction to the Challenge and the Opportunity 1Reply Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... geetreddy replied May 2, 2007 Did any of you have answer on how to fix this error. We have the same issue and wondering if you find the way to avoid the error. Any reply g
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! http://www.dba-oracle.com/t_ora_00054_locks.htm Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
Locks and ORA-00054 error Oracle tips by Burleson Question: I'm trying to alter a table, and I get an ORA-00054, from what appears to be a locking database error problem: alter table mytab add newcol char * ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified How do I stop the ORA-00054 error? Answer: When I get an ORA-00054, it's usually impossible to do the DDL unless I spend hours inconveniencing end-users by nuking their sessions. For database error 54 related content, see here, details on the Oracle deadly embrace. Unfortunately, this is often unavoidable in a 24x7 database, especially when you are restructuring a table online with the dbms_redefinition utility. Fixing the ORA-00054 error You need to schedule the 'alter table' for when there is low activity and notify the end-users about the scheduled maintenance. Before 11g, you can mark the tablespace read-only for the duration of the alter table: alter tablespace tab_ts read only In 11g, you can mark the table as read-only to prevent updates during an alter table: alter table mytab read only You can verify that the table is read-only with this command: select table_name, read_onlyfrom dba_tables where owner = ?myowner? and table_name = 'MYTAB'; As an alternative to making the table read-only, you can create a temporary trigger to prevent updates: create or replace trigger tabl_read_only before insert or update or delete on mytab begin raise_applicat