SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 54542: Applying Loqate patch to DataFlux® Data Management Server versions prior to 2.6 might impact job performance

DetailsAboutRate It

Users who are using DataFlux® Data Management Studio versions prior to 2.6 and who have upgraded to the latest Loqate engine might experience slower performance than with previous Loqate engines. (Note: You might know this product as SAS® Data Management Studio.)

The software patches are available for download on the "SAS Data Management / DataFlux Patch Downloads" web page.

The patch numbers are as follows:

  • 20777 - Data Management Studio
  • 20778 - Data Management Server

To work around this issue, improve performance by modifying the loqate.ini file:

  1. Open the loqate.ini file in their Loqate data folder. (There should be one in there already.)
  2. Add the following line to the bottom of the file: CombinedVerifyMethods=OFF

The option takes effect when the next Loqate job is started. The server does not need to be restarted.

This option should be used only when necessary, because setting CombinedVerifyMethod= to OFF can affect the quality of the output results.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
DatafluxDataFlux Data Management StudioMicrosoft® Windows® for x642.5
Microsoft Windows 8 Enterprise 32-bit2.5
Microsoft Windows 8 Enterprise x642.5
Microsoft Windows 8 Pro 32-bit2.5
Microsoft Windows 8 Pro x642.5
Microsoft Windows 8.1 Enterprise 32-bit2.5
Microsoft Windows 8.1 Enterprise x642.5
Microsoft Windows 8.1 Pro2.5
Microsoft Windows 8.1 Pro 32-bit2.5
Microsoft Windows Server 2003 Enterprise Edition2.5
Microsoft Windows Server 2003 for x642.5
Microsoft Windows Server 20082.5
Microsoft Windows Server 2008 R22.5
Microsoft Windows Server 2008 for x642.5
Microsoft Windows Server 2012 R2 Datacenter2.5
Microsoft Windows Server 2012 R2 Std2.5
Microsoft Windows Server 2012 Std2.5
Microsoft Windows XP Professional2.5
Windows 7 Enterprise x642.5
Windows 7 Home Premium x642.5
Windows 7 Professional x642.5
Windows 7 Ultimate x642.5
* 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.