Cognos not picking up data sources after restart

[sunosoft]

Hi All,

need one help, i have a cognos version 10.2.1 deployed in websphere.
Its Content manager and dispatcher is installed on the same server.

I needed to restart the service because of expiry of bind credentials to ldap. After restart of websphere, users were able to login.

However I encountered another issue like no data source is getting tested successfully.

Database is getting connected through sql developer...so no issue of like DB password expiry etc.

Anyone observed such issue ? Or any guidance will be helpful please.

[sunosoft]

Hi All,

I managed to resolve it. It was issue related to reset of environment variables after websphere restart.

Below is very helpful. Whenever your data source connection to oracle fails,you can follow the check list given in this link.

http://www-01.ibm.com/support/docview.wss?uid=swg21341734