Question
HP Enterprise Services
IN
HP Enterprise Services
Posted: Nov 15, 2022
Last activity: Aug 7, 2023
Last activity: 7 Aug 2023 10:33 EDT
Closed
Solved
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.
***Edited by Moderator Marije to add Capability tags***
Accepted Solution
Posted: 3 years ago
Updated: 3 years ago
Updated: 16 Nov 2022 15:49 EST
PEGA
Pegasystems Inc.
US
@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)