1695323 - Crystal Report schedule fails intermittently with error "Object failed to run due to an error while processing on the Job Server

Symptom

Crystal Report Schedule fails intermittently for few parameter values and throws error message "Object failed to run due to an error while processing on the Job Server".

Following error messages could be seen in the windows event viewer:

"The scheduler component failed the object identified by 52335883. The job associated with the object was unresponsive"

"The schedule result provided by the Job Server for the object identified by 52334760 is invalid"

"Subprocess (Job Server Child) could not be started. Reason: Couldn't get IJob interface or writing IAudit: Pipe exception. Reason: jobserverchild (procprogram, 2, Could not send request to child [13860] (timeout = [60000]ms, request time span = [2013])"




Environment

SAP BusinessObjects Enterprise XI 3.1

Reproducing the Issue

Login to Infoview or CMC with Enterprise user.
Schedule a crystal report having multiple subreports and dynamic prompts in it.

Cause

Unable to retrieve data for the provided prompt values due to incorrect database configuration.

Resolution

Open the affected report into Crystal Report designer.
Refresh the report with the same prompt values with which we are unable to schedule the report.
It wont bring any data after refresh completes.
Update the data source from designer and save it back into enterprise.