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

Critical Patch Update January 2025

Critical Patch Update for January 2025 The Critical Patch Update (CPU) for January 2025 was …

Leave a Reply