If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

C10.1.1 Planning, PlanningStore Startup Problem

Started by Martin_HH, 19 Mar 2012 06:23:48 AM

Previous topic - Next topic

Martin_HH

Hello everyone!

i have a brand new system with a new installed Cognos environment:
Cognos Planning 10.1.1
MS SQL Server 2008 R2 (we also installed the MS SQL Server 2005 Backward Compatibility Components)

Now i have a strange behavior of the Contributor Administration: When i start the Contributor Administration and logon, there appears an error text which says:


An error has occurred while starting IBM Cognos Planning- Administrator.
Main form failed to initialize.
Error details:
Unable to execute the statement.Invalid object name 'C10_PLANNINGSTORE_TEST..P_SYSTEMOPTIONS'., Error number -2137217865 was raised by Microsoft SQL Server Native Client 10.0. Native RDBMS error 208
The SQL was:
SELECT optionvalue FROM
C10_PLANNINGSTORE_TEST..P_SYSTEMOPTIONS WHERE optionid='CRS_TIMEOUT'
Invalid object name
'C10_PLANNINGSTORE_TEST..P_SYSTEMOPTIONS'


The database name of the PlanningStore in Cognos Configuration is 'C10_PLANNINGSTORE_LIVE' and not '...._TEST' !!
Also the shown Planning Store name in Contributor Administration in the left pane at the top says the correct Database name.


How is this SQL in the error text generated?? How could it be, that this SQL takes the wrong database name??


I am glad for any advice! Thanks.