DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, September 29, 2015

ERROR: InDbCtxFile.uploadCtx() : SQLException : ORA-20103: Null input is not allowed

Error:

When Running autoconfig on DB tier. Got the following error but autoconfig is successful. Due to this Apps tier autoconfig will not succeed. 

Attempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : SQLException : ORA-20103: Null input is not allowed
ORA-06512: at "APPS.XMLPARSER", line 33
ORA-06512: at "APPS.XMLPARSER", line 173
ORA-06512: at "APPS.FND_GSM_UTIL", line 1135
ORA-06512: at line 1
java.sql.SQLException: ORA-20103: Null input is not allowed
ORA-06512: at "APPS.XMLPARSER", line 33
ORA-06512: at "APPS.XMLPARSER", line 173
ORA-06512: at "APPS.FND_GSM_UTIL", line 1135
ORA-06512: at line 1

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1972)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
        at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:736)
        at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:274)
        at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328)
        at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:678)
        at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:222)
        at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1579)
        at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:661)


Action Plan/Solution:

1. Make sure stack size is set to 8192 kbytes (ulimit –s 8192)
2. Following SQL should return the rows.  

        SELECT owner ,DBMS_JAVA.LONGNAME(object_name) ,object_type ,status FROM           dba_objects WHERE DBMS_JAVA.LONGNAME(object_name) LIKE '%XMLParserCover%' ;

3. Rerun autoconfig and check. If you still see the Issue then Redo oracle home cloning.
4. Refer this Doc Id for cloning steps of various DB version. How to Clone an Existing RDBMS / Client Installation Using OUI (Doc ID 300062.1)




No comments: