AutoConfig Failing With NegativeArraySizeException After Upgrading To 11gR2 Database

ERROR

Error stack while running autoconfig:

Updating Context file…COMPLETED

Attempting upload of Context file and templates to database…ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -29532: ORA-29532: Java call terminated by uncaught Java exception: java.lang.NegativeArraySizeException has been detected in FND_GSM_UTIL.upload_context_file.
oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -29532: ORA-29532: Java call terminated by uncaught Java exception: java.lang.NegativeArraySizeException has been detected in FND_GSM_UTIL.upload_context_file.
at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:281)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBInf(FileSysDBCtxMerge.java:735)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:224)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1663)
at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:709)
FAILED

SOLUTION

Step 1. Run below query from APPS User

SQL>select is_compiled from user_java_methods where name = ‘oracle/xml/parser/v2/SAXAttrList’ and method_name=’addAttr’ and arguments=7;

if it return YES then proceed further.

 

Step 2. Execute following SQL statement from APPS User.

SQL>call dbms_java.set_native_compiler_option(‘optimizerThrowConversion’, ‘false’);

Step 3. Execute the following SQLΒ statement from SYS User.

SQL>call dbms_java.set_native_compiler_option(‘optimizerThrowConversion’, ‘false’);

Step 4. Delete JIT-compiled code from the database by using following as SYS user.

SQL>truncate table java$mc$;
SQL>commit;

Step 5. Finally, restart database and Run Autoconfig again.

 

 

About Syed Saad

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

EBS_Latest_Configurations

(EJCPUC)EBS Java Critical Patch Update Checker OCT-2024

(EJCPUC)EBS Java Critical Patch Update Checker OCT-2024 Introduction A new utility, Oracle E-Business Suite Java …

Leave a Reply