Hi All,

Greetings...!!

This is regarding the issue with report caster scheduler error.
I am facing an issue in my production environment when the daily sales reports are running daily at 8:10 AM CST. I am getting the below error when I checked the status in report caster console. The same report is working fine when I run it from AppStudio and we don't have any issue in our code.

We are getting the issue when the scheduled job is crossing the time 1822 seconds(30 mins).The same job is working fine if the time is below the mentioned time (< 30 mins).

Error Detail:

ERROR FOUND IN A COMPOUND REPORT
Compound Report is TERMINATING.....
Connection to the Reporting Server EDASERVE closed at 2015-10-24 08:40:29.359-0500 (1,445,694,029,359)
Job ran on the Reporting Server EDASERVE for 1793.364 seconds
Task error: THE REPORT IS NO LONGER AVAILABLE
No report to distribute.

Could anyone help me how to increase the run time for schedule?.

Is there any time limit for report caster agent to process the jobs?


Any help would be appreciated :-).

This message has been edited. Last edited by: <Emily McAllister>,

Hi Sureshkuamr

I am following up with you regarding your time limit on Report Caster.


Please review the following link and see if this helps:
Caster log: Task error:Server disconnected, cause 32012... .

If the above does not help and it is a Production issue then please open a case on IBI InfoResponse at Case Management

Thank you for participating in the Focal Point Forum.

Kindest regards,
Tamra Colangelo
Focal Point Moderator
Information Builders Inc.

Hi Tamra,

I have checked the connection_limit parameter setting in reporting server console and it is set as "1800".

I hope we don't need to change this value to "-1". Already the connection limit is high.

Let me know your comments and what shall i do now?.

Thanks a lot for your help.

This message has been edited. Last edited by: Sureshkuamr Murugesan,

Hi,
The connection limit is set to 1800 (30 minutes) and that is when the job is being killed.

You could try setting this to 1 hour.

You can also create a separate service for report caster and then direct report caster jobs to it. This service could have a lower priority and the connection limit set higher.

https://techsupport.informatio...om/sps/50512025.html

Hi CLH,
I tried your suggestion and now the jobs are running fine without any issues.

Thanks for your help on this.