some dispatcher fails to connect to a cube sporadically

[UseCog]

Hi,

We have a power play transformer cube created in a server with admin rights. As I tried to create a Cognos connection to this cube it is giving error for some dispatchers sporadically. We have 3 dispatchers and Cognos uses the same user credentials as what the transformer uses for the cube creation. The issue is Cognos is not giving an error for the same dispatcher at every time, the testing of the connection succeeds sometime for one dispatcher and the other time the testing fails to the same dispatcher.

Any thoughts to solve this issue?

Thanks,
UC

[ducthcogtechie]

You have a central location fot the cube to be reachable for all dispatchers?
Why not copy them to local drive of the dispatcher, so performance is optimal, and redundancy is automated?

[UseCog]

Thanks for you reply.

I have copied these cubes to the c: of the server where CM is installed. Even, this is giving same error. Also shared the folder. Any idea how to check whether dispatcher have access to this location?

Any other thoughts

[smiley]

The dispatchers needs access to the cube, at the fastest way posible.
My suggestion would be something like d:\cubes\sample.mdc on every server that runs a dispatcher service.