OIM GTC Connector configuration fails in weblogic cluster
Hi,
I have installed OIM 9.1.0.2 on Weblogic 10.3.2 in cluster mode (2 managed server). I have tested using weblogic utility "utils.MulticastTest", cluster is working fine, both servers are able to communicate properly.
Now the problem is that, whenever we are trying to configure the reconcillation staging maping of GTC connector, we are getting the below exception in server log
<Apr 8, 2010 10:08:43 PM GMT-06:00> <Error> <Cluster> <BEA-000126> <All session objects should be serializable to replicate. Check the objects in your session. Failed to replicate non-serializable object.
java.rmi.MarshalException: failed to marshal update(Lweblogic.cluster.replication.ROID;ILjava.io.Serializable;Ljava.lang.Object;); nested exception is:
java.io.NotSerializableException: java.util.WeakHashMap
at weblogic.rjvm.BasicOutboundRequest.marshalArgs(BasicOutboundRequest.java:90)
at weblogic.rmi.internal.BasicRemoteRef.invoke(BasicRemoteRef.java:221)
at weblogic.cluster.replication.ReplicationManager_1032_WLStub.update(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
Truncated. see log file for complete stacktrace
Caused By: java.io.NotSerializableException: java.util.WeakHashMap
at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1156)
at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1509)
at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1474)
at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1392)
at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1150)
Truncated. see log file for complete stacktrace
>
<Apr 8, 2010 10:08:46 PM GMT-06:00> <Error> <HTTP> <BEA-101005> <[ServletContext@26932051[app:Xellerate module:/xlWebApp path:/xlWebApp spec-version:null]] getRealPath() called with unsafe path: "../css/Xellerate_en.css".
weblogic.utils.io.FilenameEncoder$UnsafeFilenameException: E:\Oracle\Middleware\user_projects\domains\oimserverdomain\servers\OIM_SERVER1\stage\Xellerate\WLXellerateFull.ear\css\Xellerate_en.css not under: E:\Oracle\Middleware\user_projects\domains\oimserverdomain\servers\OIM_SERVER1\stage\Xellerate\WLXellerateFull.ear\xlWebApp.war
at weblogic.utils.io.FilenameEncoder.getSafeFile0(FilenameEncoder.java:244)
at weblogic.utils.io.FilenameEncoder.getSafeFile(FilenameEncoder.java:165)
at weblogic.servlet.internal.WebAppServletContext.getRealPath(WebAppServletContext.java:751)
at jsp_servlet._gc.__connectorimagepopuptiles._jspService(__connectorimagepopuptiles.java:280)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
Truncated. see log file for complete stacktrace
>
<Apr 8, 2010 10:08:46 PM GMT-06:00> <Error> <HTTP> <BEA-101005> <[ServletContext@26932051[app:Xellerate module:/xlWebApp path:/xlWebApp spec-version:null]] getRealPath() called with unsafe path: "../css/Xellerate_en.css".
weblogic.utils.io.FilenameEncoder$UnsafeFilenameException: E:\Oracle\Middleware\user_projects\domains\oimserverdomain\servers\OIM_SERVER1\stage\Xellerate\WLXellerateFull.ear\css\Xellerate_en.css not under: E:\Oracle\Middleware\user_projects\domains\oimserverdomain\servers\OIM_SERVER1\stage\Xellerate\WLXellerateFull.ear\xlWebApp.war
at weblogic.utils.io.FilenameEncoder.getSafeFile0(FilenameEncoder.java:244)
at weblogic.utils.io.FilenameEncoder.getSafeFile(FilenameEncoder.java:165)
at weblogic.servlet.internal.WebAppServletContext.getRealPath(WebAppServletContext.java:751)
at jsp_servlet._gc.__connectorimagepopuptiles._jspService(__connectorimagepopuptiles.java:346)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
Truncated. see log file for complete stacktrace
The steps I am doing is as below
1) Clicked on create GTC connector
2) Specified the parameter values then click continue (the above exception is coming while clicking on continue button)
3) On connector configuration page, I am setting the rconcilliation mapping and clicking on close button.
4) Then clicked on save button, OIM is letting us save the connector configuartion and giving the error
"An error was encountered while saving the information for generic technology connector TRUSTED PEOPLESOFT RECON. Check the application logs for more details. "
In server log we are getting the below error
ERROR,08 Apr 2010 22:27:06,187,[XELLERATE.DATABASE],Class/Method: tcDataBase/writeStatement encounter some problems: ORA-01000: maximum open cursors exceeded
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1187)........
........
ERROR,08 Apr 2010 22:27:06,342,[XELLERATE.DDM.IMPORT],Could not execute database read. The database encountered a problem with the specified SQL query.
ERROR,08 Apr 2010 22:27:06,342,[XELLERATE.DDM.IMPORT],Exception during import
com.thortech.xl.ddm.exception.DDMException: Unable to save dataobject for RML
at com.thortech.xl.ddm.instance.TableInstance.finishDataObject(Unknown Source)
at com.thortech.xl.ddm.instance.visitor.ImportVisitor.dataDependencyVisitComplete(Unknown Source)
at com.thortech.xl.ddm.instance.TableInstance.traverse(Unknown Source)
at com.thortech.xl.ddm.instance.TableInstance.traverse(Unknown Source)
at com.thortech.xl.ddm.instance.TableInstance.traverse(Unknown Source)
at com.thortech.xl.ddm.instance.TableInstance.traverse(Unknown Source).....
.......
Please let me know if anybody has any idea?
Thanks,
Amitesh