This SAS Note is part of a series of SAS Notes about diagnosing and resolving issues with SAS Micro Analytic Service (MAS) on SAS Viya 3.5 and SAS Viya. For additional information, see the related SAS Notes below:

• SAS Note 70229, “General questions about diagnosing and resolving issues with SAS^® Micro Analytic Service (MAS) on SAS^® Viya^® 3.5 and SAS^® Viya^®”
• SAS Note 70241, “Using logging to diagnose and resolve issues with SAS^® Micro Analytic Service (MAS) on SAS^® Viya^® 3.5 and SAS^® Viya^®”
• SAS Note 70242, “Performance considerations for diagnosing and resolving issues with SAS^® Micro Analytic Service on SAS^® Viya^® 3.5 and SAS^® Viya^®”

SAS Micro Analytic Service and Databases Documentation

The topics in the following sections of the Programming and Administration Guide can be helpful to understand the relationship between MAS and the connected database:

• SAS Viya 3.5 Database Access with DS2
• SAS Viya Database Access with DS2

Database Driver Tracing

Interactions between MAS and its connected database are complex. A database driver trace from the time of the issue can provide additional details that might resolve a database-related problem.

To enable the database driver tracing, add the following to the MAS connection string within SAS^® Environment Manager: 

DRIVER_TRACE=ALL;DRIVER_TRACEFILE=/tmp/driver.trace.file.log

When Using an Azure Database

When using an Azure SQL Database (or Azure SQL Managed Instance), check the MAS connection string within SAS Environment Manager for the following option: KeepConnectionActive=1. If this option is absent, add it, and then reevaluate the situation.

When Using an Oracle Database (and an Oracle driver)

When using an Oracle database (with the Oracle driver rather than the ODBC driver), there are situations where the Oracle database might not use indices as expected—thereby degrading performance. In these situations, consider adding the following parameter to the MAS connection string within SAS Environment Manager: FORCE_NCHAR_PARAMETERS=NO

Operating System and Release Information