Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: “TENANT_ID”: invalid identifier

This is one of the strafe issue we saw during start-up of our newly created managed server. We ran the RCU and configured our weblogic domain on it.
Environment – Solaris server

During the managed server startup we saw couple of error like

oracle.toplink.exceptions.DatabaseExceptionInternal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: “T1″.”TENANT_ID”: invalid identifier
Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: “TENANT_ID”: invalid identifier
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: “APPS_DOC_PROTOCOL_NAME”: invalid identifier
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: “CREATED_BY_UI”: invalid identifier
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: “APPS_DOCTYPE_NAME”: invalid identifier
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: “APPS_DOC_PROTOCOL_VERSION”: invalid identifier

It seems RCU did not created these files under SOA_INFRA schema. so we manually added these column based on its structure. After adding these column, managed server started with no issue.

 

While doing further digging in this issue, we found that the RCU version which we ran was not compatible with current version of weblogic we are running with. Quick fix for this issue is to check RCU compatibility with your installation. 

 

I ran following commands on DB under SOA_INFRA schema

desc MEDIATOR_DEFERRED_MESSAGE;
desc MEDIATOR_CASE_INSTANCE
desc B2B_LIFECYCLE;

ALTER TABLE B2B_LIFECYCLE ADD (APPS_DOCTYPE_NAME  VARCHAR2(256));
ALTER TABLE B2B_LIFECYCLE ADD (APPS_DOC_PROTOCOL_NAME  VARCHAR2(256));
ALTER TABLE B2B_LIFECYCLE ADD (APPS_DOC_PROTOCOL_VERSION  VARCHAR2(256));

ALTER TABLE MEDIATOR_CASE_INSTANCE ADD (TENANT_ID NUMBER(18, 0) DEFAULT -1 );

ALTER TABLE MEDIATOR_DEFERRED_MESSAGE ADD (TENANT_ID NUMBER(18, 0) DEFAULT -1 );

Advertisements
This entry was posted in Weblogic and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s