FREQUENTLY ASK QUESTIONS

 The message will appear in the detail of the error message "Copy error data to clipboard". "Execution timed out", "Timed out before the completion of the operation" , "Server not responding" or "The timeout period elapsed"

There are a few things to consider while finding the optimal solution.

• You may be trying to view or evaluate too much data. This means, of course, that the SQL server will need a proportionate amount of time to execute. Try to restrict the limit of data displayed.
• The server has no performance, we recommend that the RAM size be 1:1 with the database size "*data*". This enables the SQL server to store a large part of the database to RAM and thus increase performance.
• The server has MSSQL Express installed, whic has a 1G RAM limit and will need to be upgraded to the full version of SQL. 
• It is possible to extend the timeout configuration in the PALSTAT application. This will tell the application to wait longer for the SQL server response. However, this is not an ideal solution as the extension of time could be so large that the application will wait longer for some operations, which will reduce user comfort and the application will appear stuck at such moments.

Settings can be made in the file ./CONFIG/config.xml

<?xml version="1.0" encoding="utf-8" ?>

<palstat>
	<globalconfig>

	        <BlobCommandTimeout>60</BlobCommandTimeout>
	        <DefaultCommandTimeout>60</DefaultCommandTimeout>	
	
	</globalconfig>
	
</palstat>