Pega 718 UDF Installation Manual
Hi,
Please share the complete steps to manually install UDF for pega 718 on DB2 and Oracle.I have the UDF script generated for both DB2 and Oracle and prreadstream.jar file available in distribution media.I went through the below article but which does not says how to install java classes on DB2 and oracle before excuting the DDL which anyway fails with out that.Looking for exact steps/ instruction for both DB2 and Oracle.Thanks
https://community.pega.com/support/support-articles/how-install-user-defined-functions-udfs
Accepted Solution
Virtusa IT Consulting
AE
- 1.Please Run this query:
SELECT dbms_java.longname(object_name) FROM all_objects WHERE status!='VALID' AND object_type LIKE 'JAVA%';
Check for the class ‘com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader’ listed here or not.
- 2. Please check the below functions exists or not:
Virtusa IT Consulting
AE
Hi Dinu,
Not sure about DB2, however you can follow attached document for UDF re-installation on Oracle.
Thanks,
Habeeb Baig
Cognizant Technology Solutions
US
is there any way this UDF can be generated on oracle using DB console itself like as DB2? On DB2 i just executed below and it worked.Attached doc is the only way to generate UDF on oracle?
call sqlj.install_jar('C:\718\114819_Pega718\archives\udf\prreadstream.jar','ARSDATA.PRREADSTREAM')
Pegasystems Inc.
US
pure db script for generating udf for Oracle is not available as far as I know. Instead, follow this link: https://community.pega.com/support/support-articles/report-definitions-return-corrupt-data-blob-column
Cognizant Technology Solutions
US
Kevin,
I tried this approach and was successful.That article is for single schema i think.How do i specify split schema? I added one more property dev.oracledate.rulesSchema=ruleschema and then ran it twice by changing dev.oracledate.rulesSchema=dataschema.Since i am using a different ID to generate the UDF.I noticed it generated the objects on the ID(Schema) that i used to generate the UDF.
Cognizant Technology Solutions
US
I didn't try the attached steps but i do see java objects are created and all are valid after the pega 718 installation on oracle 12c but the query from the attached document not returning any results.How can i confirm all UDF's are generated correctly on oracle?
Step 8: Execute the below SQL for testing:
SELECT PRPCDATA.pr_read_from_stream('pzInsKey', pzInsKey, pzPVStream) as "StringValue", PRPCDATA.pr_read_int_from_stream('pzRuleSetVersionMajor', pzInsKey, pzPVStream) as "IntegerValue", PRPCDATA.pr_read_decimal_from_stream('pzRuleSetVersionMinor', pzInsKey, pzPVStream) as "DecimalValue" from prpcrules.pr4_rule where pxInsID like 'CANNOT%';
Accepted Solution
Virtusa IT Consulting
AE
- 1.Please Run this query:
SELECT dbms_java.longname(object_name) FROM all_objects WHERE status!='VALID' AND object_type LIKE 'JAVA%';
Check for the class ‘com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader’ listed here or not.
- 2. Please check the below functions exists or not:
Cognizant Technology Solutions
US
I see following on both data and rules schema jav objects and most of them are valid except DB2LUW and DB2ZOS and i can see the functions as well.So i think i am all set with UDF generations. Thanks.
I see following on both data and rules schema jav objects and most of them are valid except DB2LUW and DB2ZOS and i can see the functions as well.So i think i am all set with UDF generations. Thanks.
- com/pega/pegarules/data/internal/clipboard/directstream/BadReferenceException
- com/pega/pegarules/data/internal/clipboard/directstream/BadStreamDataException
- com/pega/pegarules/data/internal/clipboard/directstream/ByteArrayUtil
- com/pega/pegarules/data/internal/clipboard/directstream/DirectStream
- com/pega/pegarules/data/internal/clipboard/directstream/DirectStreamEnvironmentAdapter
- com/pega/pegarules/data/internal/clipboard/directstream/DirectStreamV7
- com/pega/pegarules/data/internal/clipboard/directstream/InflaterV7
- com/pega/pegarules/data/internal/clipboard/directstream/PropertyReferenceUtilities
- com/pega/pegarules/data/internal/clipboard/directstream/ReferenceString
- com/pega/pegarules/data/udf/directstreamreader/BasicEnvironmentAdapter
- com/pega/pegarules/data/udf/directstreamreader/CachedDirectStream
- com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader
- com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderBase
- com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderBase$Version6
- com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderBase$Version7
- com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2LUW
- com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2ZOS
- com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderPostgreSQL
- com/pega/pegarules/data/udf/directstreamreader/FixedCacheMap
- com/pega/pegarules/data/udf/directstreamreader/UnsupportedFeatureException
Pegasystems Inc.
IN
Dinu,
Please check following PDN article for DB2 steps, though this SA is for PRPC 7.1.7, but should be safely applicable to PRPC 7.1.8
https://community.pega.com/support/support-articles/error-while-installing-pega-717-0