"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 OCTOBER 25, 2016

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:


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms