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

 

Unable to find a datasource in content store - no matching datasource in admin

Started by Penny, 26 Sep 2014 04:39:58 PM

Previous topic - Next topic

Penny

We have Cognos 10.2 FP3 Installed on Windows Server 2012.  I am having problems with a package that seems to be looking for a datasource in the content store that is not there.

A team member had tried to create a datasource for a Cognos 7 cube and it didn't work properly.  The model that was used is not the same one I am having trouble with.

I deleted the datasource for the cube (test cube) in Cognos Administration, but still cannot publish the package nor run any reports.  If I open a report in RS I do not see any metadata. 
Instead RS gives the following error message 'the server returned an unrecognizable cognizable response'
I opened the model and checked all datasources and saw no reference to the test cube.
If I try to run the report I get 'QE-DEF-0288-          Unable to find the data source 'test cube' in the content store.'

I know there is something basic that I am missing here, and hope that someone could point me in the right direction.

MFGF

Quote from: Penny on 26 Sep 2014 04:39:58 PM
We have Cognos 10.2 FP3 Installed on Windows Server 2012.  I am having problems with a package that seems to be looking for a datasource in the content store that is not there.

A team member had tried to create a datasource for a Cognos 7 cube and it didn't work properly.  The model that was used is not the same one I am having trouble with.

I deleted the datasource for the cube (test cube) in Cognos Administration, but still cannot publish the package nor run any reports.  If I open a report in RS I do not see any metadata. 
Instead RS gives the following error message 'the server returned an unrecognizable cognizable response'
I opened the model and checked all datasources and saw no reference to the test cube.
If I try to run the report I get 'QE-DEF-0288-          Unable to find the data source 'test cube' in the content store.'

I know there is something basic that I am missing here, and hope that someone could point me in the right direction.

Hi Penny,

It appears your model (and therefore your package) is pointing to a data source labelled as "test cube". What data source are you expecting the model/package to connect to? The simple answer is to create a data source called "test cube" and point it to the relevant Powercube file for the cube your package requires.

Cheers!

MF.
Meep!

Penny

Hi MF..thank you for responding.

I have reviewed the model, and it has NO reference that I can see to 'test cube' datasource.   I have double checked Cognos administration and there is no reference to 'test cube' datasource.  Really stumped.

I am unable to republish a package from the model.  It fails with:

BmtActionsHelper.cpp(488): CCL AssertError: CCL_RETHROW:
BmtActionsHelper::DoAction
BmtEngineGateway.cpp(686): CCLAssertError: CCL_THROW:

Any other tips?

Thanks




bdbits

If your model is complicated it is possible there is still a reference to it within the model. To check for this, open the model.xml in a text editor and search for 'test cube'. If you find it, looking at the XML tags around it may help you find where it is in the model. You can edit the XML directly, but I do not recommend it and support will probably refuse to help you if they figure out you did.

Otherwise, this could be pretty difficult to sort out here. You should probably contact Cognos support.