Title
ORABPEL-03003, ORA-00904, ORABPEL-30320, ORABPEL-30023, ORA-00904 after SOA Suite 10.1.3.4 or 10.1.3.5 upgrade

Date
2009-10-12

Summary
After upgrading to SOA Suite 10.1.3.4 or 10.1.3.5, the BPEL and ESB consoles may appear to hang during the login process.

If you see one or more of the following errors in the OPMN log (e.g., default_group~oc4j_soa~default_group~1.log),
then the Oracle Application Server 10g Release 3 post-install upgrade scripts were not run.

Error #1: 
<2009-10-12 20:34:45,203>    Detected datasource 'oracle'
09/10/12 20:34:45 ORABPEL-03003

Incorrect db schema version.
The database schema version "2.0.4" from the database does not match the version "10.1.3.4.0" expected by the server.
The database schema currently in place has probably been configured for a previous release; please re-install the database schema and try to start the server again.

09/10/12 20:34:45 	at com.collaxa.cube.engine.adaptors.util.BaseSchemaManager.getSchemaVersion(BaseSchemaManager.java:96)
09/10/12 20:34:45 	at com.collaxa.cube.engine.adaptors.util.DataSourceSchemaUtils$1.validateCompatibility(DataSourceSchemaUtils.java:72)

Error #2: 
09/10/12 20:34:48 java.sql.SQLException: ORA-00904: "KEY": invalid identifier

Error #3: 
<*::*> ORABPEL-30320
<*::*>
<*::*> Error while querying workflow task timer.
<*::*> Error while querying workflow task timer based on task metadata and application name.
<*::*> Check the underlying exception and correct the error. Contact oracle support if error is not fixable.
<*::*>

<*::*> 	at oracle.bpel.services.workflow.repos.driver.WFTaskTimer.getWFTaskTimers(WFTaskTimer.java:241)

Error #4: 
<*::*> ORABPEL-30023
<*::*>
<*::*> Internal workflow error.
<*::*> An internal workflow error occured.
<*::*> Check the underlying exception and correct the error if possible. Contact oracle support if error is not fixable.

Error #5: 
09/10/12 20:35:00 oracle.tip.esb.model.repository.exception.RepositoryException: Unable to retrieve Service in system with id 96DD76C0971311DABF1A87858E4395A7 of service type with id AEFB9A91D10411DA9F363341D0AE9ED7
Ensure that the repository is accessible

Error #6: 
09/10/12 20:35:00 Caused by: java.sql.SQLException: ORA-00904: "FQ_PATH": invalid identifier

Details
1. Set your environment variables.

2. Shutdown SOA Suite: 
opmnctl stopall

3. Navigate to the upgrade script directory for BPEL and ESB, and execute the upgrade scripts. 

cd %ORACLE_HOME%\bpel\system\database\scripts
sqlplus orabpel/orabpel @upgrade_10131_10135_oracle.sql

cd %ORACLE_HOME%\integration\esb\sql\other
sqlplus oraesb/oraesb @upgrade_10131_10135_oracle.sql

A few things worth noting:
  • You must run these upgrade scripts as ORABPEL and ORAESB and not SYSTEM.
  • Locate the appropriate SQL script (e.g., if you are upgrading from 10.1.3.1 to 10.1.3.5, then run upgrade_10131_10135_oracle.sql)

    • 4. Startup SOA Suite: 
    opmnctl startall

    Applicable Versions
    Oracle SOA Suite 10g 10.1.3
    Ahmed Aboulnaga
    .com .com