I started getting this error while opening the app
Application was working fine. All of a sudden this error came while opening the application.
" An Error Occurred While Processing This Page. Check The Log For Details. Please Close The Current Tab and Open Application Again."
I cannot see calc manger rules for this means in calc manager I am not able to see this app.
Also, in logs I see
java.lang.RuntimeException: Error loading objects from data source: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
I am not able to get why this is occurring.
Seems like it is not able to find the relational repository.
Can you trying connecting to your planning repository externally (toad or SQL developer) and check whether all the tables are present.
I've seen accounts getting locked and this error (similar) is logged
http://www.orahyplabs.com Please mark the responses as correct/helpful if applicable
Validating the data source is sometimes a good way to find out if there is an issue, though this wouldn't help if the tables have been removed, sometimes it can be privileges have been changed for the account used in the data source, if the account was locked you should in theory get the following Oracle code ORA-28000
This links talks about the table structure of EPM applications. Check whether all tables are present (this is for 126.96.36.199)
Also you can perform a comparison between your environments.
http://www.orahyplabs.com Please mark the responses as helpful/correct if applicable
No Table is there RDMS but data source exists. Other applications are working fine.
I can delete and recreate the application. Only thing I worry is that if something remains in repository than it might cause problem and did not let me create the app with same name.
If it is not important then you can try deleting and recreating the application, if you want to be sure after you delete the application then drop/recreate the Oracle schema.
If you have problems deleting the application and have to remove it manually the following post might be helpful Planning 188.8.131.52 - Manually Delete a Classic Application
In Shared Services under your application groups you should see the planning apps, exactly where they are located depends on which group you registered them against, anyway if you wanted to delete you would just right click the application and delete.