Resolving invalid Pega Java class while upgrading Pega application from 7.1 to 8.4

 Resolving invalid Pega Java class from Oracle , If you got below error from DB side while upgrading Pega application from 7.1 to 8.4  :-


SQL> select dbms_java.longname(object_name), status, object_type from all_objects where
      object_type = 'JAVA CLASS' and status='INVALID';  2

 

DBMS_JAVA.LONGNAME(OBJECT_NAME)
--------------------------------------------------------------------------------
STATUS  OBJECT_TYPE
------- -----------------------
com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2LUW
INVALID JAVA CLASS

 

com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2ZOS
INVALID JAVA CLASS

 

com/pega/pegarules/data/udf/directstreamreader/BasicEnvironmentAdapter
INVALID JAVA CLASS

 


DBMS_JAVA.LONGNAME(OBJECT_NAME)
--------------------------------------------------------------------------------
STATUS  OBJECT_TYPE
------- -----------------------
com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader
INVALID JAVA CLASS

 

com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderBase$Version6
INVALID JAVA CLASS

 

com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderBase$Version7
INVALID JAVA CLASS

 


DBMS_JAVA.LONGNAME(OBJECT_NAME)
--------------------------------------------------------------------------------
STATUS  OBJECT_TYPE
------- -----------------------
com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderBase
INVALID JAVA CLASS

 

com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2LUW
INVALID JAVA CLASS

 

com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderDB2ZOS
INVALID JAVA CLASS

 


DBMS_JAVA.LONGNAME(OBJECT_NAME)
--------------------------------------------------------------------------------
STATUS  OBJECT_TYPE
------- -----------------------
com/pega/pegarules/data/udf/directstreamreader/DirectStreamReaderPostgreSQL
INVALID JAVA CLASS

 

com/pega/pegarules/data/internal/clipboard/directstream/DirectStreamV7
INVALID JAVA CLASS

 

com/pega/pegarules/data/internal/clipboard/directstream/InflaterV7
INVALID JAVA CLASS

 


DBMS_JAVA.LONGNAME(OBJECT_NAME)
--------------------------------------------------------------------------------
STATUS  OBJECT_TYPE
------- -----------------------
com/pega/pegarules/data/internal/clipboard/directstream/DirectStream
INVALID JAVA CLASS

 

com/pega/pegarules/data/internal/clipboard/directstream/PropertyReferenceUtiliti
es
INVALID JAVA CLASS

 14 rows selected.

Then , check the Java_class comp_name from dba_registry and if it valid then login via username whose  DBMS_JAVA.LONGNAME(OBJECT_NAME) is invalid and fire the below command :-


ALTER JAVA CLASS "com/pega/pegarules/data/internal/clipboard/directstream/PropertyReferenceUtiliti" RESOLVER ((*PG7_P820_SITA_RULES)(* public)) RESOLVE;

Run the above command for all invalid DBMS_JAVA.LONGNAME(OBJECT_NAME).

Comments

Post a Comment

Popular posts from this blog

Installing DBMS_JAVA package in Oracle and calling UTL_DBWS web services through Oracle database

Installing DBMS_JAVA package in Oracle following  files need to be run:-  sql> select comp_name, version, status from dba_registry where comp_name like '%JAVA%'; @?/javavm/install/initjvm.sql; @?/xdk/admin/initxml.sql; @?/xdk/admin/xmlja.sql; @?/rdbms/admin/catjava.sql; @?/rdbms/admin/catexf.sql; and verify your java installation in Oracle Database  sql> select comp_name, version, status from dba_registry where comp_name like '%JAVA%'; sql> select dbms_java.longname(object_name), status, object_type from all_objects where       object_type = 'JAVA CLASS'; ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ calling  UTL_DBWS  web services through Oracle Database :-  set the follwing parameters in .bash_profile of oracle user  export JAVA_HOME=$ORACLE_HOME/jdk ORACLE_BASE=/opt/oracle/product; export ORACLE_BASE ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1; exp...
Read more

stick the job to the specific instance in Oracle RAC

First method ( and easy one too ) :- note:-  must perform this activity on each instance one by one. ......stop jobs which is assigning to the specific instance..... $ export ORACLE_SID=SID connect database using job owner .... $ sqlplus username/password list of jobs and its instance....  sql> select JOB,INSTANCE from user_jobs;        JOB   INSTANCE ---------- ----------       2510          0       2951          0       2992          0       3091          0       3111          0       1570          0       1567          0       1568          0       1569     ...
Read more

finding fragmentation at table level and tablespace level in Oracle and steps to remove them

Use this query :- select owner,table_name,blocks,num_rows,avg_row_len,round(((blocks*8/1024)),2)||'MB' "TOTAL_SIZE",     round((num_rows*avg_row_len/1024/1024),2)||'Mb' "ACTUAL_SIZE",     round(((blocks*8/1024)-(num_rows*avg_row_len/1024/1024)),2) ||'MB' "FRAGMENTED_SPACE"     from all_tables  WHERE Owner NOT IN (        'SYS', 'OUTLN', 'SYSTEM', 'CTXSYS', 'DBSNMP',        'LOGSTDBY_ADMINISTRATOR', 'ORDSYS',        'ORDPLUGINS', 'OEM_MONITOR', 'WKSYS', 'WKPROXY',        'WK_TEST', 'WKUSER', 'MDSYS', 'LBACSYS', 'DMSYS',        'WMSYS', 'OLAPDBA', 'OLAPSVR', 'OLAP_USER',        'OLAPSYS', 'EXFSYS', 'SYSMAN', 'MDDATA',        'SI_INFORMTN_SCHEMA', 'XDB', 'ODM'); Or This one :- It will collect the data which ...
Read more