AutoCAD Electrical SQL Server Timeout Variable

May 25, 2022 Heath White

Issue:

Since SQL became an option for managing catalog databases in AutoCAD Electrical, some users have experienced the following error:  https://knowledge.autodesk.com/support/autocad-electrical/troubleshooting/caas/sfdcarticles/sfdcarticles/SQL-Server-Timeout-Error-when-performing-catalog-database-lookup-in-AutoCAD-Electrical.html

Autodesk addressed that issue beginning with the release of AutoCAD Electrical 2022. Autodesk included a new system variable that allows users to control the SQL timeout when connecting to a SQL hosted catalog database.  The problem is that none of the currently available documentation indicates how to effectively use the variable to make the desired change.

The currently available documentation (as of the time this article was published) can be seen in the link below:

https://knowledge.autodesk.com/support/autocad-electrical/learn-explore/caas/CloudHelp/cloudhelp/2022/ENU/AutoCAD-Electrical-WhatsNew/files/GUID-1E9CACD7-D22C-4EA6-A32F-8C5A1BCBED8F-htm.html

As you can see in the image below, if you try to use the information provided in the AKN article, you will receive an “Unknown Command” response.

 

Causes:

This issue is caused by the fact that the system variable needs to be run from the command line as an API call and that requirement is not detailed in any official documentation currently available.

Solution:

The solution is to apply the system variable using the following format: (AESETSQLSERVERTIMEOUT XX) with “XX” representing the amount of time you’d like to set the timeout for.  A “T” will be displayed for a successful change, while “nil” will be show for an unsuccessful attempt.

The default setting is 30 seconds, but the valid range is between 15-500 seconds per Autodesk Technical Support.  To see what your timeout is set to, you can use the following command: (AEGETSQLSERVERTIMEOUT)

 

About the Author

Heath White

Sr. Technical Support Specialist, Manufacturing

Follow on Linkedin More Content by Heath White
Previous Article
Install Inventor Read-only Mode using Custom Install
Install Inventor Read-only Mode using Custom Install

You want to install Inventor Read-only Mode without Inventor for a user that needs an Inventor file viewer ...

Next Article
Silently install the Autodesk Desktop Connector
Silently install the Autodesk Desktop Connector

How to silently install the Autodesk Desktop Connector