Cognos Planning Web Contributor Grid is not opening

[gourraju.kumar@gmail.com]

Error Details:

Database errors: number: 0x80004005, source: OraOLEDB, description: ORA-00942: table or view does not exist, number: 0x80040e37, source: OraOLEDB, description: ORA-00942: table or view does not exist, details: SELECT userid,xmldata FROM xxxxxxx.clientsettings WHERE userid = 'CAMID("xxxxxxxx:u:c0922ad285f05a48bffe087437a3992f")', com error description: ORA-00942: table or view does not exist

[ericlfg]

Since you are running Oracle, I also assume you are running 10.1.1 FP2 and that you recently upgraded?

There is a defect with the FP2 build whereby existing Oracle contributor applications are not updated to include the new clientsettings table.

http://www-01.ibm.com/support/docview.wss?crawler=1&uid=swg1PM75871 (you need to have an IBM profile setup and attached to an IBM customer number to access this link properly)

At this point you can:
1. Uninstall FP2 and go down to FP1 (may require database restorations)
2. Contact IBM Support for resolution