ORA-29540: class com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader does not exist

we have updated from V7.3.1 to V8.7 (on premise) and seeing multiple error of “ORA-29540: class com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader does not exist”.

In Database, Java object com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader status is INVALID . I am assuming this is causing the error.

Could you please let me know how to make status to Valid.

attaching screenshot for reference.

@SivatejaI7587

I believe that this error indicates that UDFs are not configured in the database, and queries are using UDFs.

There are a couple of helpful articles on this topic where you can find instructions to configure the DB for UDF’s (keep in mind, is not advised to use UDF’s in production environment).

Understanding Pega Blob and UDF | Support Center

Troubleshooting user-defined functions | Support Center (pega.com)