COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: sunosoft on 23 Sep 2015 06:40:24 AM

Title: Cognos not picking up data sources after restart
Post by: sunosoft on 23 Sep 2015 06:40:24 AM
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.
Title: Re: Cognos not picking up data sources after restart
Post by: sunosoft on 24 Sep 2015 09:36:54 PM
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