|
|||
|
|||
After a user with the sysadmin role opens CommitCRM and has it open for 5-30 minutes, they are getting a CommitCRM Server error.
" An error occured while trying to connect to CommitSQL Database. Verify the 'Advantage Database Server' service is running on your server and then restart all Commit server side services on your server. Error 6420: The 'discover' process for the Advantage Database Server failed. Unable to conenct to the Advantage Database Server. :axServerConnect" Users without sysadmin roles seem to be able to open CommitCRM without any errors, even for hours in our testing. We currently have ADS.ini files in use with IP addresses, and have not have this issue before. We are running on CommitCRM 17. Any ideas on what might be causing this odd issue or what we might do to fix it? |
|
|||
|
|||
Thank you for posting this.
This error was logged by one of the server-side services that could not connect to the Advantage Database Server (the SQL backend). A message about this error is, indeed, displayed only to SysAdmin users. In case everything seems to be working well, e.g. the Email Connector the Web Interface and other server-side back end functionality, you can delete the textual file that holds this error message. The text file is stored under: <server>\RangerMSP\Server\QSysEDOutboxErr\ In addition we recommend to configure ALL RangerMSP services on your server as well as IIS (if used) with "Delayed Start" allowing the SQL engine to load first when restarting the server and only then the services will load and be able to connect. Hope this helps. |
|
|||
|
|||
I started getting the same error today after doing windows 10 update version 1803.
the error is" Error 6420: The "discovery" process for the advantage database server failed. unable to connect to the Advantage Database Server.axServerConnet. The odd thing is I have access to the share location is identified, and only my station is having an issue. |
|
|||
|
|||
We've received a few other reports about this. Please try to rename the following files (without deleting them):
\RangerMSP\Client\ADS.ini \RangerMSP\LastVer\ADS.ini To ADS.ini-Backup You may also try adding ADS.exe, which is the SQL backend executable, through the server firewall, maybe limited for local connections (but you can limit it in a later phase once things start to work again.). The RESTART your server. Hope this helps! |
|
|||
|
|||
I get the same Error 6420 after updating a client workstation to 1803.
We allowed ADS.exe through the firewall and restarted DB as well as the server machine with no change. Even disabling the firewall altogether on both machines with no change. Is there a sample ADS.ini file, or what parameters specifically would I need to define in order to bypass discovery? I have verified that I have access to the server\Commit\DB folder, but we just didn't happen to have an ADS.ini file in Client or LastVer folder which helped others. |
|
|||
|
|||
|
|
|||
|
|||
I just upgraded my workstation to 1803 and now I am getting this error. Obviously it is a Windows 10 1803 issue and not on the server side as others on my network are not having this problem that are on 1709.
Did any of these suggested solutions work? Any official word from Commit? |