My Oracle Support Banner

"ODI-10147: Repository type mismatches" Or "Invalid Object Name SNP_LOC_REP" Signaled By ODI When Connecting To The Repositories (Doc ID 563007.1)

Last updated on MARCH 26, 2018

Applies to:

Oracle Data Integrator - Version to [Release 3.2.03 to 11gR1]
Information in this document applies to any platform.


The below message:

oracle.odi.core.config.NotMasterRepositorySchemaException: ODI-10147: Repository type mismatches.    
PreparedStatementCallback; bad SQL grammar [select REP_SHORT_ID, REP_NAME, REP_TYPE, REP_TIMESTAMP, REP_VERSION, MIN_EXE_VERSION, IND_INSTALL_OK from SNP_LOC_REP]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


Invalid object name 'SNP_LOC_REP'

     is signaled when one of the following operations is executed:


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.