LISA application issue - Registry throws ORA-00955: name is already used by an existing object

Products

• Service Virtualization

Issue/Introduction

Every time we restart Registry the following error is shown in the Registry.log  file:

java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

Environment

Release : 10.6.2 and newer

Cause

The below 2 properties were enabled in the logging.properties

log4j.logger.com.mchange.v2.c3p0=DEBUG
log4j.logger.com.mchange.v2.resourcepool=DEBUG

The error is because the table already exists in the database.

When we install the product, all the tables will be created in the database. Post installation when Registry starts it will again check for some of the tables and try to create it again. This error message is because of that.  

 

 

 

Resolution

When you restart the Registry Service,  we check to see for all the Tables,  and will try to create it again.    "ORA-00955: name is already used by an existing object"  message we saw in the logs is  just a DBUG Warning message.  This can be ignored. 

when this happens

1. we stopped all the Services,  Portal , VSE , REgistry  , ED and IAM 

2. Cleared all the logs in  CA/DevTest/lisatmp10.6 folder. 

3. Restarted the services - IAM, ED, Registry , Portal and VSE.  

 

See if all the  components are running and you are able to login to the Dashboards.