AnsweredAssumed Answered

Getting error while running "Capacity vs. Demand by Resource" in Jasper

Question asked by mailtojustine on Feb 3, 2016
Latest reply on Feb 3, 2016 by Suman Pramanik

Hi,

 

We are using Clarity 14.2. When I tried to run the CSP report "Capacity vs. Demand by Resource" in Advanced reporting, I am getting an error.

 

The server has encountered an error. Please excuse the inconvenience.

 

Error Message

net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : CSK_RES_CapVsDemandByResource_Allocation_Subreport

Error Message

net.sf.jasperreports.engine.JRException: Error executing SQL statement for : CSK_RES_CapVsDemandByResource_Allocation_Subreport

Error Message

com.microsoft.sqlserver.jdbc.SQLServerException: Socket closed

 

 

The report is generating successfully when we reduce the size of report by filtering it for a few resources. The corresponding B.O report is running with same parameters. Is it happening due to memory issue?

 

Thanks,

Justine

Outcomes