MSR_GEN_0071 Internal error getting catalogs and schemas Error

[gesys]

Thanks, bus_pass_man. I've got the sqljdbc_auth.dll file in the \drivers directory and have restarted the service already with no luck. I've also tried modifying the databaseDriverLocations.properties in \v5dataserver to point to the jdbc and jdbc_auth files. Neither of these has resolved the problem, but I think they're definitely along the right path!

You have to do the following step:

In the Microsoft SQL Server JDBC driver installation directory, locate and copy the 32-bit or the 64-bit version of sqljdbc_auth.dll to the cognos_analytics_server_install_location\bin (or bin64) directory.

see

http://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ig_rolap.doc/t_ig_rolap_sql_connect.html

it's different to 10.2.1!

hope this helps!

[brian_brooks]

GENIUS!!! You've done what no one in IBM support has been able to do...help me learn how to read technical documentation!  ;D

It does indeed work now. Thanks for walking me through the nuances of change with regards to the deployment of jdbc files!

[mastan]

Hi Team..,
Same problem is occurring to me also for Postgres. Can anyone help me on this?

[mastan]

Yes, its worked for me thanks a lot...!