Maximo Wire - The IBM Maximo Help & Discussion Forum
May 20, 2012, 10:33:56 am *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome to Maximo Wire, the IBM Maximo help forum. Feel free to register and ask any Maximo related questions you like.
 
  Home Help Search Login Register  
*
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Problem in defining location in MAXIMO  (Read 823 times)
0 Members and 2 Guests are viewing this topic.
sayan.aich
Newbie
*

Karma: 2
Posts: 16



View Profile Email
« on: October 30, 2010, 04:51:01 am »
After defining 1665 locations, no new location can be defined any more. Though the location id to be defined is absent in the location table and also in the asset, still an error message is being displayed on an attempt to define and save it , which says:

Database error number 1 has occurred when operating on LOCSTATUS LOCSTATUSID=1,084.
ORA-00001: unique constraint (MAXIMO.LOCSTATUS_NDX) violated

Please tell me why is this problem occurring and the solution?  Huh
Logged
mph
Newbie
*

Karma: 0
Posts: 7


View Profile
« Reply #1 on: November 18, 2010, 04:33:43 pm »
LOCSTATUS.NDX is an index on the LOCSTATUS table. This index forces the values in the LOCSTATUSID column in the LOCSTATUS table to be unique.

So Maximo tries to insert a row in the LOCSTATUS table with LOCSTATUSID 1084, but this value already exists in the table.

I cant tell why this has happened. Maybe you could check out the row in the table with LOCSTATUSID=1084 and see if its safe to delete the row.
Logged
Pages: [1]   Go Up
  Print  
Maximo Wire - The IBM Maximo Help & Discussion Forum > Everything Else > General Discussion > Topic: Problem in defining location in MAXIMO
 « previous next »
 
Jump to:  

Recent

TinyPortal v1.0 beta 4 © Bloc
Powered by MySQL Powered by PHP Powered by SMF 1.1.15 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!