SA-8083

Summary

Customer is getting errors while installing PRPC 7.1.7.  The error received is as follows in the UDF (User Defined Function) generation step:

Install UDF Jar:
[java] Feb 26, 2015 4:38:50 PM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] INFO: Loading user-defined functions into the database.
[java] Feb 26, 2015 4:38:50 PM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] INFO: Using a DB2 database.
[java] Feb 26, 2015 4:38:50 PM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] INFO: Jar is not already loaded.
[java] Feb 26, 2015 4:38:52 PM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] WARNING: Encountered a database problem when attempting to load jar onto DB2: DB2 SQL Error: SQLCODE=-311, SQLSTATE=22501, SQLERRMC=1, DRIVER=3.69.24
[java] com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-311, SQLSTATE=22501, SQLERRMC=1, DRIVER=3.69.24

Error Messages

[java] WARNING: Encountered a database problem when attempting to load jar onto DB2: DB2 SQL Error: SQLCODE=-311, SQLSTATE=22501, SQLERRMC=1, DRIVER=3.69.24
[java] com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-311, SQLSTATE=22501, SQLERRMC=1, DRIVER=3.69.24

Steps to Reproduce

Run PRPC_Setup.jar
Provide all necessary information to connect to the DB2 database running on AIX version 10.5 Fixpack 5.

Root Cause

The root cause of this problem is due to a defect in the DB2/AIX 10.5 Fixpack 5 loading of the prreadstream.jar. 

Resolution

This issue is resolved through the following local change:

1. Use DB2 command line interface, issue the command similar to this - make sure you replace the actual file path to the prreadstream.jar from the Pega media and replace "DATA" with your actual data schema name and "RULES" with your actual rules schema name:

db2 => call sqlj.install_jar('file:/home/prpc/114716_Pega717/archives/udf/prreadstream.jar', 'DATA.PRREADSTREAM')
db2 => call sqlj.install_jar('file:/home/prpc/114716_Pega717/archives/udf/prreadstream.jar', 'RULES.PRREADSTREAM')

2. Then execute the udfstatements under: scripts\schema\generated\udb\install\udfstatements (this is generated after running the installation). 

3. Check the validity of the UDF installation by issuing the query:

SELECT <RULES or DATA schema>.pr_read_from_stream('pzInsKey', pzInsKey, pzPVStream) as "StringValue",
          <RULES or DATA schema>.pr_read_int_from_stream('pzRuleSetVersionMajor', pzInsKey, pzPVStream) as "IntegerValue",
          <RULES or DATA schema>.pr_read_decimal_from_stream('pzRuleSetVersionMinor', pzInsKey, pzPVStream) as "DecimalValue"
       from <RULES or DATA schema>.pr4_rule