Troubleshooting
Problem
Unable to return rotating assets using the Issues and Transfers application.
Symptom
Steps to reproduce:
1. Go to the Inventory module.
2. Go to the Issues and Transfers application.
3. Select a storeroom.
4. Select "Items for Return".
5. Choose a rotating asset.
6. Save.
Error message comes up: "BMXAA4211E - Database error number 2601 has occurred when operating on PLUSPWOPRICETOTALS : Site=BEDFORD Work Order=12345. Report the error to the owner of the deployment."
Excerpt from log file:
Cannot insert duplicate key row in object 'dbo.pluspwopricetotals' with unique index 'pluspwopricetotals_ndx2'. The duplicate key value is (BEDFORD, 12345).
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'dbo.pluspwopricetotals' with unique index 'pluspwopricetotals_ndx2'.
The duplicate key value is (BEDFORD, 12345).
Environment
Sql server environment.
Diagnosing The Problem
Upgraded from Maximo version 6.2
Resolving The Problem
Delete the indexes PLUSPWOPRICETOTALS_NDX1 AND PLUSPWOPRICETOTALS_NDX2 by running the script below:
drop index PLUSPWOPRICETOTALS.PLUSPWOPRICETOTALS_NDX1
go
drop index PLUSPWOPRICETOTALS.PLUSPWOPRICETOTALS_NDX2
go
Was this topic helpful?
Document Information
More support for:
IBM Maximo Asset Management
Software version:
6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6, 6.2.7, 6.2.8, 7.1, 7.1.1, 7.5
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows
Document number:
214371
Modified date:
17 June 2018
UID
swg21609490