Error BMXAA7901E

Technote (troubleshooting)


This document applies only to the following language version(s):

English

Problem(Abstract)

When trying to login to Maximo BMXAA7901E - You cannot log in at this time. Contact the system administrator.

Symptom

Error in logs shows unique constraint on logintrackingid whenever user tries to log in.

java.sql.SQLException: ORA-00001: unique constraint (MAXIMO.LOGINTRACKING_NDX) violated

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)


Cause

This is caused by the oracle sequence logintrackinguseq having an incorrect last_number. This can happen when exporting sequences from one database and importing them to a new database incorrectly.


Resolving the problem

To fix, you can recreate the sequence with the correct number to increment from. This can be achieved with the following statements:


select max(logintrackingid) from logintracking;

drop sequence logintrackinguseq;

create sequence logintrackinguseq start with #### (number one higher
than selected above);

for example

create sequence logintrackinguseq start with 1000;


Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management IBM Maximo Asset Management Essentials
Systems and Asset Management Tivoli Asset Management for IT
Systems and Asset Management IBM SmartCloud Control Desk
Systems and Asset Management Tivoli Change and Configuration Management Database
Systems and Asset Management Tivoli Service Request Manager

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo Asset Management

Software version:

6.2, 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, Version Independent

Operating system(s):

Platform Independent

Software edition:

All Editions

Reference #:

1617333

Modified date:

2012-11-14

Translate my page

Machine Translation

Content navigation