Feedback
Did this article resolve your question/issue?

   

Article

Run custom sql command failed 2043 error while accessing MOVEit Automation.

« Go Back

Information

 
TitleRun custom sql command failed 2043 error while accessing MOVEit Automation.
URL NameRun-custom-sql-command-failed-2043-error-while-accessing-MOVEit-Automation
Article Number000158005
EnvironmentProduct: MOVEit Automation (Central)
Version: All Supported Versions
OS: All Supported Platforms
Question/Problem Description
MOVEit Automation throws "Run custom sql command failed, 2043" error while accessing MOVEit Automation Admin client.
Upgraded application and facing "Run custom sql command failed 2043 error" accessing task logs.
Steps to Reproduce1) Open the MOVEit Automation Admin Console on either locally or remotely.
2) Login with the user credentials if necessary (e.g. 12.1 requires the login credentials now).
3) After a moment, the error may present.
Clarifying Information
This error usually shows up when MOVEit automation has trouble accessing the database.
Error MessageThere are a variety of sub errors with starting line: RunCustomSQL command failed: 2043

In a popup window in the Console:
RunCustomSQL Command Failed: 2043 The connection cannot be used to perform this operation. it is either closed or invalid in this context.
In the Event Viewer logs we see:
Operation is not allowed when the object is closed.
Defect/Enhancement Number
Cause
The most likely reason would be the database connectivity. This may be because the session with the database grew stale and needs to be reset in some way (e.g. a reboot of the MOVEit VM). 

Often this error presents because the MOVEit VM has not been rebooted on a regular monthly schedule. 

Occassionally the Database server itself may need to be rebooted. 
Resolution

Please try the following steps to resolve:

1. Restart the MOVEit Automation service.
2. If running MySQL, Check for any MySQL crashed tables.
3. Testing/Resetting the database connection from the Database Tab of the Config utility:

1. Open Start Menu>All Programs, MOVEit Automation, then click MOVEit Automation Config.
2. Click on Database tab
3. Examine, Validate, and Edit the details and test.
4. Reboot the MOVEit Automation machine.
5. Run a Repair Install on the server to make sure the registry keys are set correctly: How do I make system restores or configuration changes take effect? Answer: Run a Repair install

If you run a Failover environment, please handle the environments appropriately: stop secondary, stop primary, reboot/start primary, reboot/start secondary. 
Workaround
Notes
Last Modified Date3/16/2021 9:16 PM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.