Invalid Oracle 19c DB objects post UDF installation

Question

BlessonA

Member since 2018

Bank of America

Posted: Aug 23, 2021

Last activity: Aug 7, 2023

Posted: 23 Aug 2021 6:24 EDT
Last activity: 7 Aug 2023 10:34 EDT

Closed

We recently installed UDF’s on Pega new Dev server. Post that From Pega side there was no issue but we see the below DB Objects are in invalid state.

These Objects were not existing on Oracle 11G, but are in 19C.

alter JAVA CLASS PEGA_RULES."com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2ZOS" compile ;

alter JAVA CLASS PEGA_RULES."com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2LUW" compile ;

alter JAVA CLASS PEGA."com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2ZOS" compile ;

alter JAVA CLASS PEGA."com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2LUW" compile

To see attachments, please log in.

Posted: 3 years ago

Updated: 3 years ago

Posted: 23 Aug 2021 7:06 EDT
Updated: 23 Aug 2021 7:08 EDT

patwk replied to BlessonA

@BlessonA Please find the below link which can help you to valid the invalid JAVA classes:

com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2LUW com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2ZOS

The above Objects are not relevant to Oracle, one can see by the name, they are targeted at DB2, but can be ignored.

Thanks,

To see attachments, please log in.