In SAS Real-Time Decision Manager, you might encounter the following error if you use a PostgreSQL database​​​​​​ as the storage location for your DS2 package. This error is displayed in the Decision Services design server or engine server log files for a successfully published package.

This error occurs under the following conditions:

1. You configure your PostgreSQL Federation Server data service using the PostgreSQL service type and a native PostgreSQL driver.


2. Your DS2 package is large (for example, 50,000 lines of code).



3. You believe you have published a DS2 package successfully (via a model process definition or a SAS process definition) based on logging lines in your Decision Services logs that are similar to the following lines:

   YYYY-MM-DD HH:MM:SS,SSS INFO sasdemo SASDSDesignRepository com.sas.rtdm.implementation.ds2.DS2Publisher - Attempting to publish DS2 code for SAS activity "MY_DS_PACKAGE".
   YYYY-MM-DD HH:MM:SS,SSS INFO  sasdemo SASDSDesignRepository com.sas.rtdm.implementation.ds2.DS2Publisher - Successfully published DS2 code for SAS activity "MY_DS_PACKAGE".
4. You do not see the package table in the SAS^® Federation Server Manager application, but you do see the package table in a different PostgreSQL client application.


5. The package table has exactly 10,000 rows.

To work around this issue, reconfigure your data service and add the CONOPTS=(MAXROWSETSIZE=20000) attribute.  Note that 20000 is an example value only. Choose a value that is large enough to handle your DS2 package code. To reconfigure, choose one of the following methods:

• Open the Federation Server Manager SQL window and choose the ADMIN connection. Submit the following data definition language (DDL) to add the CONOPTS= option option to the existing data service:

         ALTER SERVICE data-service-name {OPTIONS CONOPTS(DRIVER POSTGRES, ADD CONOPTS(MAXROWSETSIZE 20000))}

• Open the Federation Server Manager SQL window and choose the ADMIN connection.  Submit the following DDL to re-create the data service:

        CREATE DATA SERVICE "data-service-name" TYPE POSTGRES CATALOG "catalog-name" DOMAIN "authentication-domain" {OPTIONS
        conopts(DRIVER postgres, DB database-name, SERVER server-name, PORT port-number, SCHEMA schema, CONOPTS(MAXROWSETSIZE
        20000))}

Operating System and Release Information