Hi,
I have been using the report.saveas for some time without any issues. I have recently upgraded to Windows 2016 and MySQL 8.0.13. I am now having the following errors. Some reports work, but very slow (maybe 3 minutes) other now fail with the following message. Working locally works with no issues and very fast so I am thinking it is something in the latest version of Alpha, or my Server setup. Can anyone suggest where I can investigate?
regards Barry
ERROR BELOW ----
Amyuni Low Level Print:
Layout name: D:\A5Webroot\mesh\RPT_QUOTATION.a5rpt
Layout type: report
Could not create local cache for data from your Database. Your Database reported the following error:
Database API specific error
Your database has returned the following error code and description to Alpha Five.
Consult your database documentation for further information.
2013 - 'Lost connection to MySQL server during query while converting ResultSet to DBF table' at line: 557
Execution Stack:
0#1 evaluate_shared_private(
0#39 OOhttpdServerClientMIME(ptemp,"AppServerMain")
0#2 A5WCallResult = evaluate_a5w_to_response(page_contents,Response,quote(" " + eval_settings.global.Request.ScriptName),eval_settings,EVALUATE_A5W_TIMEOUT,RequestBundle.RequestInfo.Filename.Path)
0#183 x_out = a5_ajax_dialog2(tmpl)
0#268 a5w_report_saveAs(reportname,"pdf",filter,order,filename2,global_variables(),printOptions,args,options)
I have been using the report.saveas for some time without any issues. I have recently upgraded to Windows 2016 and MySQL 8.0.13. I am now having the following errors. Some reports work, but very slow (maybe 3 minutes) other now fail with the following message. Working locally works with no issues and very fast so I am thinking it is something in the latest version of Alpha, or my Server setup. Can anyone suggest where I can investigate?
regards Barry
ERROR BELOW ----
Amyuni Low Level Print:
Layout name: D:\A5Webroot\mesh\RPT_QUOTATION.a5rpt
Layout type: report
Could not create local cache for data from your Database. Your Database reported the following error:
Database API specific error
Your database has returned the following error code and description to Alpha Five.
Consult your database documentation for further information.
2013 - 'Lost connection to MySQL server during query while converting ResultSet to DBF table' at line: 557
Execution Stack:
0#1 evaluate_shared_private(
0#39 OOhttpdServerClientMIME(ptemp,"AppServerMain")
0#2 A5WCallResult = evaluate_a5w_to_response(page_contents,Response,quote(" " + eval_settings.global.Request.ScriptName),eval_settings,EVALUATE_A5W_TIMEOUT,RequestBundle.RequestInfo.Filename.Path)
0#183 x_out = a5_ajax_dialog2(tmpl)
0#268 a5w_report_saveAs(reportname,"pdf",filter,order,filename2,global_variables(),printOptions,args,options)
Comment