Help on CubeSwap (Cognos 8.3)

[pribacus]

Hi All:

I'm having issue with cubeswap in 8.3.

Currently I have 2 production servers running in windows. The first one is where i have all the cubes, cognos configuration setting. The 2nd box, I have Cognos Framework Manager and PowerPlay Transformer (to build production cubes and then later copy them to the first box).

I am running cubeswap from the 2nd box, and trying to swap the cube location which is located on the 1st box. I keep getting the error message that it cannot find the cube.

Question is does cubeswap can be run in multiple server like this.

BTW, my script works like this:
1. Generate the cube (on the 2nd box). --> OK
2. Copy the cube from the 2nd box to 1st box --> OK
3. Run cubeswap to refresh the cube location on data source connection --> not OK

Thank You!

-Andy-

[josepherwin]

What is the cube path that you are using?

are you using C:\cube path or \\server name\cube path?

[pribacus]

Hi Joseph:

I am using 'e:\cube path'. It didn't work. It says that 'e:\cube path' does not exist when i run my cubeswap script.

If i use '\\server name\cube' path; my script works. However, the windows connection would be updated to '\\server name\cube' path. I would be getting an error message when i tried to run the cube. I need to set the location to e:\cube\path.

Do you have any idea how to solve this issue?

Thanks in advance!

-Andy-

[SomeClown]

If E:\ is a physical drive on that server, then it should work. 

If it is not, the only way I know of using a mapped drive is to leave a login session open for the account that is running a script when running in batch mode  (mapped drives only exist in the user space and are defined at the user level, two good reasons to avoid using them if possible).

If you are running interactively, then you need to define a persistent mapping for E: to point to your share location.

[josepherwin]

I'm a bit confused, when you say:

"windows connection would be updated to '\\server name\cube' path. I would be getting an error message when i tried to run the cube."

Which Windows connection? is it the Windows Location of the Cube Connection String in Data Source Connection?

If this was the case, you will need to start your Cognos service as a directory admin rather than local.

Try this method if you're on windows:
1. Go to the box where Cognos Service is running
2. Go to Control Panel -> Administrative Tools -> Services
3. Find your Cognos8 service in there
4. Check the properties
5. Switch to "Log On" tab
6. Select the "This Account" Radio Button
7. Type in a directory admin username and password

After this, you will need to Stop and Start the Cognos service through Cognos Configuration.

And I would think that this time you'll have no problem with \\servername path

[pribacus]

Hi Joseph:

I meant it's the windows location of the cube connection string in data source connection.

Thanks for the advice (Joseph and SomeClown). I will try to do it this weekend. Currently i cannot stop the service since our users are in 3 different regions (US, Europe, and Asia); gotta keep it running 24hrs a day. I can only do this testing on the weekend.

I really appreciate your help!!!

-Andy-

[josepherwin]

No prob...

If you're not sure, ask your technical team or network admin to grant your Cognos Admin username with Directory administrator privilege :)