Support Article
ORA-29541 trying to use UDF in query
SA-43849
Summary
Logfiles show User Defined Functions (UDFs) errors ORA-29541 with Pega 7.2.
Error Messages
java.sql.SQLException: ORA-29541: class com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader could not be resolved
Steps to Reproduce
After copying the UDFs from working schema to new schema try to run report which uses them in query.
Root Cause
A defect or configuration issue in the operating environment.
Trying to copy the UDFs from one schema, to another usually results in the UDFs in an invalid state that cannot be easily corrected.
Resolution
Follow the steps in this guide for validating the UDF installation.
If issue still exists then follow steps to drop the existing UDFs and then use the generateudf script that comes with the media to reinstall them.
https://pdn.pega.com/understanding-and-troubleshooting-user-defined-functions/understanding-and-troubleshooting-user
Published September 21, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.