Welcome to our Knowledge Base

Enter your search terms below.

Categories
< All topics
Print

Database update fails – query timeout expired

Description of the problem

Last weekend we tried to update our steadyPRINT database on the Microsoft SQL server. In doing so, the error message “query timeout expired” appeared. After a new attempt, the update could be successfully performed without any mistakes.

Explanation:

For the update of the database, the application CreateSteadyDB sends some instructions for creating and adapting new or existing tables to the SQL server. If the required instructions cannot be performed within 30 seconds (default value), the error message mentioned above is displayed


Solution

Solution for steadyPRINT version smaller than 5.1.2:

Perform the update directly on the SQL Server and repeat the process if necessary. The speed of execution can vary according to its load.

Solution for steadyPRINT version 5.1.2 and higher:

Increase the maximum query timeout in the extended connection settings within the CreateSteadyDB. A value of 120 seconds would be reasonable and can be increased if required.

Dependencies:

CreateSteadyDB in der Version 5.1.2

ID: 21675 | Zur deutschen Version

Was this article helpful?
0 out Of 5 Stars
5 stars 0%
4 stars 0%
3 stars 0%
2 stars 0%
1 stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Back Database cache in the steadyPRINT reporting
Next Database-Update not possible with special SQL user
btnimage