COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: danii64 on 28 Feb 2014 06:35:18 PM

Title: Data source connection test stalling in cognos admin
Post by: danii64 on 28 Feb 2014 06:35:18 PM

We're having some trouble with running reports in RS. When the report is executed, it stays in the executing status and never finish running. The packages are loading, but the 'validating with report serve' is also stalling.

I ran a data source connection test in the cognos admin and i get the same thing again, it seems like its running but it never finishes.

I was able to test cubes and other data source and was able to run the test successfully.

Any help is appreciated!

Thanks in advance
Title: Re: Data source connection test stalling in cognos admin
Post by: saumil287 on 01 Mar 2014 07:13:23 AM
Hi,

I have also encountered the same kind of problem.
I restarted the server and then it was working fine.
This thing might happen because your server is taking a lot of load eg: Many users accessing the same server at the same time, or You have scheduled many reps, or If you have change the server tunning parameters after that you experienced this issue, or please check your log files which is taking more memory.

If you have change the server parameters, please change the server properties if you are aware of each and every parameters which you are changing, Changing the parameters unknowingly can mess up your server performance.