Database Error Number 2601
Contents |
WORKVIEW Database Error 2601; Workview; cannot insert duplicate key row; TPAEWORK Technote database error number 1 (FAQ) Question Is there a workaround for the error, "BMXAA4211E
Database Error Number 1 Has Occurred Maximo
- Database error number 2601 has occurred when operating on WORKVIEW"? Cause This error is database error number 29861 the result of incorrect sequencing or corruption of the sequence generator. When this happens, the interface will present an error similar to, "BMXAA4211E - Database error
Database Error Number 1045
number 2601 has occurred when operating on WORKVIEW Record=12-3456789 Class=WORKORDER Site=YOURSITE. Cannot insert duplicate key row in object 'dbo.workview' with unique index 'workview_ndx'. This errror may occur when inserting a new Work Order record. Answer Execute the following database updates to correct this issue. Please note that this will not work db 2601 exactly as described with Oracle databases, as sequence functionality is present. 1. Get the highest current value for WORKVIEWID plus 1: select max(WORKVIEWID)+1 from WORKVIEW 2. Update the sequence, using the number from the select query above: update maxsequence set maxreserved = ### where tbname='WORKVIEW' and name = 'WORKVIEWID' Example: if the maximum number is 5000, then the update statement is: update maxsequence set maxreserved = 5001 where tbname='WORKVIEW' and name = 'WORKVIEWID' 3. It is necessary to restart Maximo after updating the sequence, so please restart from the WebSphere console when users are out of the application. Document information More support for: Maximo Asset Management Work View Software version: Version Independent Operating system(s): Solaris, Windows Software edition: Enterprise Reference #: 1598339 Modified date: 2014-05-08 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
error 2601; duplicate key; unique index; sql server; maximo; base services; TPAEUI:TPAESS2005; TPAESS2008 Technote (troubleshooting) Problem(Abstract)
Bmxaa4211e Database Error Number
Cannot insert duplicate key row in object "X" with unique index
Bmxaa4211e - Database Error Number 2601 Has Occurred When Operating On Assetancestor.
'Y" error showing after Maximo 7.1.x patch update is done (On SQL Server only) Symptom After a database error number 1 has occurred when operating on Maximo 7.1.x patch update on SQL Server you could get a duplicate index error showing Cause Often this is caused as the sequence generator appears to be out of http://www-01.ibm.com/support/docview.wss?uid=swg21598339 sequence for the mentioned object's uid table. Environment SQL Server only Diagnosing the problem As an example ,when testing a new Maximo 7.1.x update and it appears it is no longer possible to move an asset from location to location. There are some error messages displayed, for example: BMXAA0066E - Asset "X" in site "Y" was not http://www-01.ibm.com/support/docview.wss?uid=swg21419788 moved successfully. BMXAA4211E - Database error number 2601 has occurred when operating on ASSET "X" [SQL1\SQL1] Cannot insert duplicate key row in object 'dbo.asset' with unique index 'asset_ndx1'. Resolving the problem It this example the sequence generator is out of sequence for the assetuid table. To fix this on SQL Server with Maximo 7.1.x: a) Get the highest current value for assetuid plus 1: select max(assetuid)+1 from asset b1) Update the sequence, use the number from the select for the ### value below: update maxsequence set maxreserved = ### where tbname='ASSET' and name = 'assetuid' b2) E.g. if the maximum number is 600, then the update statement is: update maxsequence set maxreserved = 601 where tbname='ASSET' and name = 'ASSETID' N.B!: It is necessary to restart Maximo after updating the sequence, so please restart from the Web Sphere console when it is convenient. c) Test:Create a new asset and or move an asset from a location to another location. Cross reference information Segment Product Component Platform Version Edition Sys
ROW IN OBJECT 'PLUSTCBLINES' WHEN CREATING COUNT BOOK Subscribe You can track all active APARs for this component. APAR status Closed as program error. Error description Similar to Issue 89175. Steps to reproduce the Issue in Maxdemo database: Maximo Application Server 6.2.3 Transportation 6.3.1 - http://www.ibm.com/support/docview.wss?uid=swg1IZ57333 Log into Maximo as wilson - Go to Inventory / Item Master (Tr) - Click on New Item button, accept the default values and enter this info: Item = ITEM100 Lot Type = NOLOT Order Unit = EACH Issue Unit = EACH Rotating = Yes - Save the record - Go to Purchasing / Purchase Orders (Tr) - Click on New PO button, accept the dafault values and enter this info: Company = BWC - Click on PO Lines tab, click on New Row database error button, accept the default values and enter this info: Item = ITEM100 Quantity = 10.00 Conversion Factor = 1.00 Unit Cost = 1.00 Storeroom = CENTRAL - Save and approve this PO - Go to Purchasing / Receiving (Tr) - Search by the PO record created above - Click on Select Ordered Items button - From Select Ordered Items box, select the PO Line 1 and click on OK - Click on PO Line 1 View Details button and enter this info: Quantity = 5.00 database error number To Bin = BIN01 - Click on Select Ordered Items button again - From Select Ordered Items box, select the PO Line 1 and click on OK again - From the second PO Line, click on View Details button and enter this info: To Bin = BIN02 - Save the record - Select Action / Receive Rotating Items - From Receive Rotating Items box, click on Autonumber button, click on OK - Go to Inventory / Invetory Couting (Tr) - Click on New Count Book button, accept the default values and enter this info: Storeroom = CENTRAL Selection Criterion = ITEM - Hit the Tab key - From Select Items frame, Selection Item field, type "ITEM100" - Click on Save Count Book The Issue is: at this point, Maximo shows the error: "Database error number 2601 has occurred when operating on PLUSTCBLINES Site=BEDFORD Count Book Number=1005 Bin=BIN01 Lot= Condition Code= Item=ITEM100 Asset=2080. [PI-EWXP-01]Cannot insert duplicate key row in object 'plustcblines' with unique index 'plustcblines_ndx2'." Local fix No workaround has been found. Problem summary **************************************************************** * USERS AFFECTED: All users with Transportation 6.3.1 * **************************************************************** * PROBLEM DESCRIPTION: Steps to reproduce the Issue in Maxdemo * * database: * * * * Maximo Application Server 6.2.3 * * * * Transportation 6.3.1 * * * * - Log into Maximo as wilson * * * * - Go to Inventory / Item Master (Tr) * * * * - Click on New Item button, accept the * * default values and enter