SSRS service terminating unexpectedly!!

narendar poosa
narendar poosa used Ask the Experts™
on
Hi Experts,

we need your help in analyzing one of our reporting server issue. Actually,Few  of our SQL reports are connecting to MYSQL server via a MYSQL driver and fetch details from it. But whenever we are executing this report, SSRS is getting crashed and generating few logs in both Event viewer and Reporting services.I have enclosed them,so please check and advise on this

FYI...On Different server with the same configuration , when we are executing this report,it is executing successfully.

Regards,
Narendar Poosa.
Eventviewer_Error.PNG
ReportServerService__05_18_2017_13_2.log
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Vimal DMSenior Software Engineer

Commented:
@narendar poosa,

I think the problem from your sever is this "Maximum memory limit is 65536Mb". When the script fetches data from the server it needs so amount of memory allocation which is not satisfying in your server.

The fixes can be,
1. Increase the memory limit in php.ini
                    OR
2. Get the error status and re-execute the script using "pcntl_exec"

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial