Communications link failure Last packet sent to the server was 0 ms ago

Hi All,

I am using a stored procedure to run a report with a static parameter and another dynamic parameter.

eg:- TestProcedure("MONTHLY",?);

My report is working fine but sometime i am getting below error:-

Execute report failed (An exception occurred during processing. Please see the following message for details: Failed to prepare the query execution for the data set: TestProcedure Cannot get the result set metadata. org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object. SQL error #1:Communications link failure Last packet sent to the server was 0 ms ago. ; com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. (Element ID:220)).

Please help me to solve this problem.

Regards,
Swapna.

Find more posts tagged with

Comments

kclark

It sounds like something on the sql server. Have you checked the max connections and timeout settings?

appform

Hi,

Thanks for your response!!!
We are using mysql and please tell how to check timeout settings ?

Regards,
Swapna.