OmniPortlet Migration Issue (10g to 11g - 11.1.1.2)

After migrating from 10g to 11g the out of the box OmniPortlet Provider will use the database as its preference store by default. Therefore, if you did not use the database as a preference store in 10g you will be unable to add the OmniPortlet to a page in your upgraded environment. You will receive the ORA-00942: table or view does not exist. Either change the provider.xml file in the portalTools ear file to use a file-based preference store or run the following script as the PORTAL user in the database.


CREATE TABLE JPDK_PREFERENCE_STORE2 (
  PATH_TYPE       VARCHAR2 (60)  NOT NULL,
  REFERENCE_PATH  VARCHAR2 (250)  NOT NULL,
  SEARCH_PATH     VARCHAR2 (250)  NOT NULL,
  DATA_CLASS      VARCHAR2 (250),
  LONG_VALUE      LONG RAW,
  CONSTRAINT JPS2_PK
  PRIMARY KEY ( REFERENCE_PATH, PATH_TYPE ) ) ;

CREATE INDEX JPDK_PATH_TYPES2 ON
  JPDK_PREFERENCE_STORE2(PATH_TYPE)
;
CREATE INDEX JPDK_SEARCH_PREFS2 ON
  JPDK_PREFERENCE_STORE2(SEARCH_PATH)
;


Here is the error that you will receive when attempting to add the OmniPortlet to a page.

Internal error (WWC-00006)
Unexpected error - User-Defined Exception (WWC-35000)
An unexpected error has occurred in pages: User-Defined Exception (WWC-44847)
Unexpected error - User-Defined Exception (WWC-35000)
The provider URL specified may be wrong or the provider is not running. (WWC-43176)
The following error occurred during the call to Web provider: ORA-00942: table or view does not exist
(WWC-43147)