When trying to save the user preferences the following end user error is displayed:
"The SQL operation failed. Check logs for details.
User Preferences have been saved."
Diving into the Planning logs identifies the actual error message:
java.sql.SQLSyntaxErrorException: ORA-00904: "ENABLE_MRU_SCREEN": invalid identifier
This error was found searching the knowledge base,
Unable to Save Form Preference in Planning After Upgrade [ID 889744.1]
According to Oracle:
This issue has been caused by migrating the application and a column must be added to HSP_USER_PREF table.
One would think that when you upgrade the application, the schema update it performs when logging in for the first time would add this column, nevertheless...
The following SQL was executed against the planning application database to add the appropriate column.
ALTER TABLE HSP_USER_PREFS ADD ENABLE_MRU_SCREEN INTEGER DEFAULT 1 NOT NULL
This error was found searching the knowledge base,
Unable to Save Form Preference in Planning After Upgrade [ID 889744.1]
According to Oracle:
This issue has been caused by migrating the application and a column must be added to HSP_USER_PREF table.
One would think that when you upgrade the application, the schema update it performs when logging in for the first time would add this column, nevertheless...
The following SQL was executed against the planning application database to add the appropriate column.
ALTER TABLE HSP_USER_PREFS ADD ENABLE_MRU_SCREEN INTEGER DEFAULT 1 NOT NULL
No comments:
Post a Comment