We are seeing invalid java class objects in a single database schema based 7.1.5 system with oracle, most of these classes are related to DirectStreamReader, CachedDirectStream, BadReferenceExcep etc. I have checked and found that the pr_read_from_stream, pr_read_int_from_stream and pr_read_decimal_from_stream functions are generated and are in valid state. SO can you please answer my below queries:
1. How to resolve this issue? will running generateudf.sh resolve this issue?
2. What are all areas affected if these objects are kept in invalid state for sometime?
Hello Celeste Dufresne and Arvind Malav! we tried regenerating the udf by running generateudf.sh but Java class objects are still in INVALID state. Can someone please help me resolve this issue. Below is the list of INVALID Objects.
Thank you Arvind Malav!! I followed the article to you suggested and resolved issue for all necessary JAVA CLASS object except one DirectStreamReader. I am getting below error(object does not exist) for this particular class.
SQL> ALTER JAVA CLASS "com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader"
2 RESOLVER ((*RMS_SIM_CI)(* public))
ALTER JAVA CLASS "com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader"
ERROR at line 1:
ORA-04043: object /32d1f03d_DirectStreamReader does not exist
Can you please let me know what can we do to resolve this one?
There is no red cross on udf function i.e. they all are in valid state. What do you mean by "whether UDF functions ends with semi column(;) or not?". As long as function definition goes they all are fine and ending with ; as shown below:
Just to update you all - The issue turn out to be some junk character with (com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader) class which I copied from PDN. After retyping this class name manually it got resolved and not it is in VALID status.