narendar poosa
asked on
SSRS service terminating unexpectedly!!
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
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
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
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"