Database Error 1
Contents |
LOCHIERARCHY Subscribe You can track all active APARs for this component. APAR status Closed as program error.
Database Error Number 1
Error description Maximo Version and Patch level -> 6.2.2 + HF10 database error number 1 has occurred maximo Server Operating Systems -> Maximo Administration Workstation : Windows XP -> Application Server : Solaris 10 -
Bmxaa4211e - Database Error Number 1
64bit - SPARC -> Actuate Server : Windows Server 2003| Database platform -> Oracle10g(10.2.0.2) Web Appplication Server (WebSphere/WebLogic and Service Pack level) -> WAS 6.0.2.23 < Recreation steps > bmxaa4211e - database error number 2601 1. On Locations application, click "New Location" icon. 2. Enter the following values. Location : TEST04 Description : TEST04 Type : Operating 3. "Select Action" --> "Manage Systems" 4. On "Manage Systems" window, click "New Row" 5. Enter the following values. System : TEST01 Description : TEST01 Site : (anything) Primary System ? : Check 6. Click maximo bmxaa4211e database error number 1 "OK" 7. "Select Action" --> "Associate Systems with Location" 8. On "Associate Systems with Location" window, click "New Row" 9. Enter the following value. System : TEST01 10. Click "OK" 11. Click "Save Location" icon 12. "Select Action" --> "Duplicate Location" 13. Enter the following values. Location : TEST05 Description : TEST05 Type : Operating ==> Do not click "Save Location" icon here 14. "Select Action" --> "Associate Systems with Location" 15. On "Associate Systems with Location" window, click "New Row" 16. Enter the following value. System : TEST01 Parent : TEST04 17. Click "OK" ==> Then the error displays. On the customer's environment, using Oracle, "Database error number 1 has occurred when operatin on LOCHIERARCHY Site=XXXXX Location=TEST05 System=TEST01 Parent=TEST04. ORA-00001: unique constraint (MAXIMO.LOCHIERARCHY_NDX1) violated" . On our test environment, using DB2, "Database error number -803 has occurred when operatin on LOCHIERARCHY Site=XXXXX Location=TEST05 System=TEST01 Parent=TEST04. DB2 SQL error. SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 2; MAXIMO.LOCHIERARCHY Local fix NA Problem summary **************************************************************** * USERS AFFECTED: Maximo users * *
can track all active APARs for this component. APAR status Closed as program error. Error description replicated in 6.2.2, 6.2.6, 7.1.1.6 with hotfix 1. Create a new location with no system or parents (duploc1). type is operating 2. go to actions menu, duplicate
Database Error Number 1 Has Occurred When Operating On
location, enter duploc2 in the location field save 3. actions, associate system with location click New Row bmxaa4211e - database error number 1400 button enter SANITARY network system click OK in the parent section, click New Row enter MH100 in the parent field click New Row button
Maximo Bmxaa4211e - Database Error Number 1 Has Occurred
again enter MH200 in the parent field Save. 4. go to actions menu, Duplicate location enter duploc2 in the location field Save. Error occurs: BMXAA4211E - Database error number 1 has occurred when operating on LOCANCESTOR Site=BEDFORD Location=DUPLOC3 System=SANITARY Search Location http://www-01.ibm.com/support/docview.wss?uid=swg1IZ57378 Hierarchy=DUPLOC3. ORA-00001: unique constraint (MAXIMO.LOCANCESTOR_NDX1) violated Local fix do not use duplicate location function under the actions menu. create a new location instead Problem summary **************************************************************** * USERS AFFECTED: all * **************************************************************** * PROBLEM DESCRIPTION: replicated in 6.2.2, 6.2.6, 7.1.1.6 * * with hotfix * * * * 1. Create a new location with no system * * or parents (duploc). * * * * type is operating * * * * 2. go to actions menu, duplicate * * location, enter duploc2 http://www-01.ibm.com/support/docview.wss?uid=swg1IZ77571 in the * * * * location field * * * * save * * * * 3. actions, associate system with * * location * * * * click New Row button * * * * enter SANITARY network system * * * * click OK * * * * click New Row * * * * the dialog box is gone, we're in the * * location main page * * * * go to the section labelled: Parent of * * DUPLOC2 in the SANITARY System * * * * enter MH100 in the parent field * * * * click New Row button again * * * * enter MH200 in the parent field * * * * Save. * * * * 4. go to actions menu, Duplicate * * location * * * * enter duploc3 in the location field * * * * Save. * * * * Error occurs: BMXAA4211E - Database * * error number 1 has occurred when * * operating * * * * on LOCANCESTOR Site=BEDFORD * * Location=DUPLOC3 System=SANITARY * * * * Search Location Hierarchy=DUPLOC3. * * * * ORA-00001: unique constraint * * (MAXIMO.LOCANCESTOR_NDX1) violated * * * * LOCAL FIX: * * * * do not use duplicate location function * * under the actions menu. * * * * create a new location instead * * * **************************************************************** * RECOMMENDATION: * * * * * * * ******************************************************
on SQL ServerWhere is this place located?All Places SAP https://scn.sap.com/thread/3653437 on SQL Server 1 Reply Latest reply: Nov 18, 2014 4:06 PM by S Sriram Tweet Database error -1 at FET Hye-Rin An Nov 18, 2014 8:17 AM Currently Being Moderated I run the "T-code : DB02"I database error was selected "Performance -> Lock"When I select the "Lock", following such as dump occurs in "T-code:SM21".Database error -1 at FETFunction sequence errorDatabase error -1Our system information is as follows.Database system MSSQL.Release 11.00.2100.SAP_BASIS 700 Level 27 Operating system Windows database error number NTDBSL version 720.00 DBSL Patch Level 442 I would like to know how to resolve the cause of the dump.I look forward to answers.Thank you. 156Views Tagsnone (add) Topics: database Tags: sqlserver, windows, mssql, mssql2012, erp6.00 Re: Database error -1 at FET S Sriram Nov 18, 2014 4:06 PM (in response to Hye-Rin An) Currently Being Moderated Hi Hye1. You can use the transaction code ST04 for MS SQL Db2. Is possible download the latest version DBMSSLIB.dll from service market place and check the sameBRSS Alert Moderator Like (1) Tweet Actions Login to follow, like, comment, share and bookmark content. Login Register Follow SCNJive Software Version: 5.0.6.2 , revision: 201308121150.54f5b14.release_5_0_6_2