Product:
Cognos Planning 10.1.1
Windows 2008 R2 Server
Oracle database
Problem:
When a user inside Cognos Planning Administration Console ( CAC ) click on the Monitoring Console tab he get a error message and when he click OK the CAC program exits (crash).
Error message:
Run time error 13 – type mismatch
Solution:
Truncate two tables inside the Cognos Planning Store.
p_pnrequestprogress
and p_pnrequest
Start SQL developer
Login to the database as COGPLAN (the schema that have access as the planning and planning store databases)
Enter;
truncate p_pnrequestprogress
truncate p_pnrequest
Commit
And test again from inside Cognos Planning Administrator to click on Monitoring Console.