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

PowerPlay cube data source woes

Started by Michael75, 12 Jun 2015 01:37:53 PM

Previous topic - Next topic

Michael75

I'm completely stuck on a cube data source problem (C10.1.1). I have three package-based PowerPlay cubes which run off the same package, and which have many other similarites, such as the following options:
- Deployment strategy: Copy to available locations, then activate
- After building this cube: Automatically copy and activate

In my Prod environment, I use a .bat file with the -g switch for the nightly builds, and this has run reliably for over a year with no changes.

Cube creation is to a \Temp folder, deployment to an \Online folder. So each morning, in my \Temp folder I have three updated .mdc files, and in my \Online folder, I have three updated .ver files, to go with the existing .mdc stubs.

But my problem concerns my Dev environment, which has an identical folder structure, so I'm doing the cube creation and deployment interactively (right click -> Create selected PowerCube).

I've just carried out a round of very similar changes to all three cubes, and on two of the three, testing has gone smoothly. But on the third, when I try to open a studio, I get BMT-MD-6003 No connection to the data source '<my_problem_cube>' could be established.

One day later, I have compared (Dev vs Prod):
- data source connection properties
- PowerCube file name and effective name
- Deployment folder

and apart from the D / P in the top-level (environment) folder, all are strictly identical.

Then, I deleted the data source and the package, and did a Publish PowerCube as Data Source and Package, which went through with no error. Still no joy, and of course the data source connection test failed (PDS-PCT-0020 Unable to open the PowerCube).

Next, I again deleted the data source and the package, plus the relevant files and folder in the \Online folder (see above), and did another Publish PowerCube as Data Source and Package. The package and DS were recreated as in the previous attempt, as were the \Online files and folder, but still no joy.

At this point, I don't know what else to try. Does anybody have an idea?

TIA
Michael

Michael75

I'd like to bump this post by restating it in a simpler manner  :)

I do the following:
1. right click -> Create selected PowerCube
2. Publish PowerCube as Data Source and Package

Both go through successfully, but I then get BMT-MD-6003 No connection to the data source '<my_problem_cube>' could be established.

Anyone got any ideas what could cause this?

prikala

Try this: Go to the server running Dev environment using the same account that is used to run the Cognos service.
Check that the mdc really exists using exactly same path that is specified in the data source connection.
Also check that the server account has permissions to read all the files that are needed.

In other words, check the situation from the server's point of view.