Thursday, March 20, 2014

EM12c: EMSYSTEMEXCEPTION ON UI WHILE CREATING JAVA EE APPLICATION IN SW LIBRARY

In EM 12.1.0.3, when trying to upload a J2ee Application Component to software library, it shows status as incomplete and oracle.sysman.emSDK.app.exception.EMSystemException can be seen on UI.

emoms.log shows following associated exception:
Caused by: java.sql.SQLException: ORA-20406: The following targets are invalid: em-oms.example.com
ORA-06512: at "SYSMAN.EM_JOB_OPS", line 290
ORA-06512: at "SYSMAN.GC_JOB", line 29
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)  
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

---
---

Cause: It turns out that if the OMS virtual host name is different from physical host name, that caused this issue.

Solution: This is a product bug, there is no fix AS OF NOW. But there is a workaround, not the best solution but to proceed further, it helps.

To workaround the issue, one can push another agent on oms host with same physical name. This will resolve the virtual host vs physical host conflict.
Now upload the J2ee Application Component to software library, it will be successful.

Once the J2ee App has been uploaded. One may stop the agent and bring it up only when its needed again. Else it can add some overhead to existing resources.