Problem Note 67712: You cannot connect to a database in SAS® Micro Analytic Service and an error occurs in the sas-microanalyticservice-core log file
 |  |  |  |  |
In SAS® Environment Manager, you can set up various properties in the sas.microanalyticservice.system:core component for the SAS Micro Analytic Score service. Two of the properties, dbconnretries and dbconnretryintervalseconds, are not honored when they are set. As a result, SAS Micro Analytic Service does not attempt to re-create a connection to the database by using the query that is provided in the connectioncheckstatement property in either of the following situations:
- the database connection was killed
- the database server's service was restarted
- the database server's machine was rebooted
In the sas-microanalyticservice-core log file (located in the /opt/sas/viya/config/var/log/microanalyticservice/default directory) you might see the following error for this issue.
To work around this issue, restart SAS Micro Analytic Service.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Micro Analytic Service | Microsoft® Windows® for x64 | 5.5 | 5.5 | Viya | Viya |
| Linux for x64 | 5.5 | 5.5 | Viya | Viya | ||
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2021-04-13 09:32:16 |
| Date Created: | 2021-04-02 15:13:09 |