ERROR:YK-ERR-0001 Multiple server environment IBM Cognos and Microsoft SSAS

UPDATE: Finally this issue can be solved. Click here to read the solution.

You might be lucky enough and come across strange behavior in a multiple server Cognos environment, when trying to work towards Microsofts SSAS cubes as data sources.


It shows up by randomly failing to establish the connection from one of the application servers to 2005 Analysis Services client. So if you go into the connection details (in Cognos Administration) and try testing it by selecting all of your application servers, the resuld would look simmilar to this:

If you try the same action again, it will either fail on the same server or might fail the other one absolutely randomly.

The error code is YK-ERR-0001 and it is whining about not being able to establish connection to the server. But it actualy manages to do that sometimes (schizo? :) ).

Anyway, at this point in time there is no info at IBM Cognos regarding this matter. We solved it by routing the package to only one application server using Advanced Dispatcher routing properties (RTFM here). Assign one of your application servers to a unique group and route all traffic from your SSAS package to that new group.

Not the perfect solution as it eliminates the loadbalancing, but it works for now and eliminates the symptoms completely.

Got better ideas? Share in the comment section!

//MxD