I am getting this error when i run a custom crystal report that is using BAQ to pull data? Any idea how to get rid of this error?
Error message:
BAQ execution returned errors:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Check your query…it’s probably messed up.
Try limiting your results to 10 and see if it can execute. BAQ Timeout limit is a setting, but I think it’s a query problem.
Does the BAQ complete without the timeout when it is executed in the BAQ designer?
Yes, it works in the BAQ designer, takes a little time but still works.
Result summary:
Query returned 504 row(s).
Query has no more records to return.
Query execution total time: 38420.2144 ms.
Is the reports xml data file created on the server?
Haven’t run into it in E10 yet, in E9 I’ve seen Crystal runtime errors on the client PC.
Large XML files that took a while to generate.
Do you have a dedicated printing appserver that your taskagent configuration points to?
BAQ designer executes a BAQ through the interactive appserver–the appserver that the client is connecting to-- and a BAQ report executes through the appserver that the taskagent configuration is pointing to so there could be a timeout set in the EAC for the printing appserver but not the interactive.
Bruce,
Yes, it’s the xml data file created over the server.
Nathan,
I am not sure if there is dedicated printing appserver. (i am not in IT, so don’t know what the setup is). I tried to look in system monitor to see if it shows something but it does not mention anything about server.
The xml files are written to a shared location on the server under each user. After the report error, i check my location and no xml file was written there other reports files are written to.