SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 57583: A deadlock or poor performance occurs in SAS® Workflow Services when you use Microsoft SQL Server for your SAS® Shared Services database

DetailsAboutRate It

When you use Microsoft SQL Server for your SAS Shared Services database, you might see slow performance for services in the SAS® Web Infrastructure Platform. The problem might occur in SAS® solutions that use SAS Workflow Services to manage business processes, such as SAS® Enterprise GRC, SAS® Enterprise Case Management, and SAS® Model Risk Management.

By default, SQL Server sends text values to the server in Unicode format instead of the native data type defined in the database. The implicit data conversion performed by SQL Server might cause a performance problem. To work around the problem, add the following property to the SAS Shared Services JDBC DataSource:

sendStringParametersAsUnicode=false

After adding the property, you must restart SASServer1 for the change to take effect.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Web Infrastructure Platformz/OS9.3_M29.4_M39.3 TS1M29.4 TS1M3
Microsoft® Windows® for x649.3_M29.4_M39.3 TS1M29.4 TS1M3
64-bit Enabled AIX9.3_M29.4_M39.3 TS1M29.4 TS1M3
64-bit Enabled Solaris9.3_M29.4_M39.3 TS1M29.4 TS1M3
HP-UX IPF9.3_M29.4_M39.3 TS1M29.4 TS1M3
Linux for x649.3_M29.4_M39.3 TS1M29.4 TS1M3
Solaris for x649.3_M29.4_M39.3 TS1M29.4 TS1M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.