DSF initialization error ORA-00904: “PROCESSNAME”: invalid identifier – UPGRADE issue from 11.1.2.1.600 still exists even with 11.1.2.4

Issue:

If the Shared Services database schema is not upgraded completely, and you have a DSF initialization error ORA-00904: “PROCESSNAME”: invalid identifier in the Shared Services log file, this indicates that the Foundation Service upgrade scripts failed to execute, and the Shared Services schema was not upgraded to Release 11.1.2.4.

Cause: Foundation Service upgrade scripts failed to execute which results in Shared Services schema not upgrading to Release 11.1.2.3/11.1.2.4.

Resolution:

  1. Restore the Shared Services database to the Release 11.1.2.1.600 database backup taken before attempting to upgrade.
  2. Execute the following SQL scripts based on the database type configured from the SQL client connecting to the restored Shared Services database:

For an Oracle database: m DROP INDEX CSS_DELTA_TRANSACTION_IDX; m DROP SEQUENCE CSS_DELTA_TRANSACTION_ID_SEQ; m DROP TABLE CSS_GROUP_CACHE_DELTA CASCADE CONSTRAINTS; m CREATE TABLE CSS_GROUP_CACHE_DELTA (GROUP_IDENTITY VARCHAR2(200 BYTE) NOT NULL, ACTION_TYPE NUMBER(1, 0), VALUE1 VARCHAR2(256 BYTE), VALUE2 VARCHAR2(1000 BYTE), UPDATEDTIMESTAMP TIMESTAMP(9) WITH TIME ZONE DEFAULT (SYSTIMESTAMP) NOT NULL); l

For an MS-SQL Server database: m DROP INDEX CSS_DELTA_TRANSACTION_IDX ON CSS_GROUP_CACHE_DELTA; m DROP TABLE CSS_GROUP_CACHE_DELTA; m CREATE TABLE CSS_GROUP_CACHE_DELTA (GROUP_IDENTITY NVARCHAR(200) NOT NULL, ACTION_TYPE NUMERIC(1, 0), VALUE1 NVARCHAR(256), VALUE2 NVARCHAR(1000), UPDATEDTIMESTAMP DATETIME NOT NULL); l

For an IBM DB2 database: m DROP INDEX CSS_DELTA_TRANSACTION_IDX; m DROP TABLE CSS_GROUP_CACHE_DELTA; m CREATE TABLE CSS_GROUP_CACHE_DELTA (GROUP_IDENTITY VARCHAR(200) NOT NULL, ACTION_TYPE NUMERIC(1, 0), VALUE1 VARCHAR(256), VALUE2 VARCHAR(1000), UPDATEDTIMESTAMP TIMESTAMP NOT NULL );

  1. Commit the transaction.
  2. Reuse the database to upgrade Release 11.1.2.1.600 to Release 11.1.2.3/11.1.2.4.

Source

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s