SA-25544

Summary

User Defined Functions (UDFs) are not created after running generateudf.bat.  See ORA-29541 errors trying to use them.

Error Messages

There was a problem getting a list: code: 29541 SQLState: 99999 Message: ORA-29541: class <schema name>.com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader could not be resolved

Steps to Reproduce

 Run generateudf.bat.

Root Cause

A defect or configuration issue in the operating environment.  The UDFs were installed but they were in an invalid status.

Resolution

Make the following change to the operating environment: 

Force the recompilation of the UDFs.  
Replace V72RULES with the name of your rules schema and run the following commands.  
Repeat replacing with the name of your data schema.

ALTER JAVA CLASS "com/pega/pegarules/data/internal/clipboard/directstream/ByteArrayUtil"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/internal/clipboard/directstream/BadReferenceException"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/internal/clipboard/directstream/BadStreamDataException"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/internal/clipboard/directstream/DirectStream"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/internal/clipboard/directstream/DirectStreamEnvironmentAdapter"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/internal/clipboard/directstream/InflaterV7"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/internal/clipboard/directstream/PropertyReferenceUtilities"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/udf/directstreamreader/BasicEnvironmentAdapter"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/udf/directstreamreader/CachedDirectStream"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderBase"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/udf/directstreamreader/FixedCacheMap"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/udf/directstreamreader/UnsupportedFeatureException"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/internal/clipboard/directstream/DirectStreamV7"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderBase$Version7"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderBase"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;
ALTER JAVA CLASS "com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader"
   RESOLVER ((*V72RULES)(* public))
   RESOLVE;