SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 67071: SAS/ACCESS® Interface to PostgreSQL might trigger an "unrecognized configuration parameter 'yb_server_version'" message in the PostgreSQL Server log

DetailsHotfixAboutRate It

When you use SAS/ACCESS Interface to PostgreSQL, an error might be triggered in the PostgreSQL Server log. An example is shown here:

   2020-10-09 05:58:11.682 EDTERROR:  unrecognized configuration parameter "yb_server_version"
   2020-10-09 05:58:11.682 EDTSTATEMENT:  BEGIN;show yb_server_version

There is no impact on the code submitted, and no errors occur in SAS.

The types of SAS code that might trigger this message include the following:

  • POSTGRES LIBNAME statements
  • CONNECT TO POSTGRES statements
  • INSERT, UPDATE, or DELETE clauses in the SQL procedure

If the SAS system option SASTRACE='d' is enabled, you might also see these messages:

   POSTGRES: ENTER SQLExecDirect
                0x0000000004689710
                0x000000000fbe6850 [      -3] "show yb_server_version "
                                -3
   POSTGRES: EXIT SQLExecDirect with return code -1 (SQL_ERROR)
                0x0000000004689710
                0x000000000fbe6850 [      -3] "show yb_server_version "
                                -3

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemBase SASSolaris for x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Linux for x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Home Premium 32 bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Enterprise x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Enterprise 32 bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
HP-UX IPF9.4_M69.4_M89.4 TS1M69.4 TS1M8
64-bit Enabled Solaris9.4_M69.4_M89.4 TS1M69.4 TS1M8
64-bit Enabled AIX9.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Ultimate x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Ultimate 32 bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Professional x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Professional 32 bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Home Premium x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 20199.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 20169.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2012 Std9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2012 R2 Std9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2012 R2 Datacenter9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2012 Datacenter9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2008 for x649.4_M69.4 TS1M6
Microsoft Windows Server 2008 R29.4_M69.4 TS1M6
Microsoft Windows Server 20089.4_M69.4 TS1M6
Microsoft Windows 109.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8.1 Pro x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8.1 Pro 32-bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8.1 Enterprise x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8.1 Enterprise 32-bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8 Pro x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8 Pro 32-bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8 Enterprise x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8 Enterprise 32-bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft® Windows® for x649.4_M69.4_M89.4 TS1M69.4 TS1M8
z/OS 64-bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
z/OS9.4_M69.4_M89.4 TS1M69.4 TS1M8
* 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.