After upgrading datbase from version 10.2.0.4 to 11.2.0.1, i encountered Some issues. I encounter this issue while running autoconfig as post upgrade step.
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:
Run below query from apps user>
select is_compiled from user_java_methods where name = 'oracle/xml/parser/v2/SAXAttrList' and method_name='addAttr' and arguments=7;
It should return "YES", if it return YES then proceed further.
Execute following sql statement from RDBMS oracle home as apps user:
call dbms_java.set_native_compiler_option('optimizerThrowConversion', 'false');
Execute the following sql statement from RDBMS oracle home as sys user:
call dbms_java.set_native_compiler_option('optimizerThrowConversion', 'false');
Flush all JIT-compiled code from the database by using following statement as SYS:
truncate table java$mc$;
commit;
After this step restarted database and completed autoconfig without any issues.
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:
Run below query from apps user>
select is_compiled from user_java_methods where name = 'oracle/xml/parser/v2/SAXAttrList' and method_name='addAttr' and arguments=7;
It should return "YES", if it return YES then proceed further.
Execute following sql statement from RDBMS oracle home as apps user:
call dbms_java.set_native_compiler_option('optimizerThrowConversion', 'false');
Execute the following sql statement from RDBMS oracle home as sys user:
call dbms_java.set_native_compiler_option('optimizerThrowConversion', 'false');
Flush all JIT-compiled code from the database by using following statement as SYS:
truncate table java$mc$;
commit;
After this step restarted database and completed autoconfig without any issues.
Comments
Thanks,
Mamta
You're welcome :)
thanks,
X A H E E R
IS_
---
NO
If returns 'No' ...Any Action Plan pls ?...