Hi,

Need help!

While exporting TN Profile, Processing Rules, DocumentTypes etc. from TN 7.1.2, exception is thrown “[SoftwareAG][Oracle JDBC Driver]Object has been closed”.
Exception is thrown only, when we try to export, for other queries, like to find the partners, find the document type everything is working fine.
We deleted the Repository files thinking that may be because of currupt repository error is coming, but it didn’t work.
Please help.

Thanks
smudiraj

Below is the Error Trace


ErrorMessage: ErrorDialog
TRNCONS.000000.000003
ERROR






ImportExportDialog
getDataFromServer
Mon Apr 25 14:53:55 EDT 2011
[SoftwareAG][Oracle JDBC Driver]Object has been closed.



com.wm.ui2.UiException: wm.tn:exportData java.sql.SQLException [SoftwareAG][Oracle JDBC Driver]Object has been closed. null wm.tn:exportData java.sql.SQLException [SoftwareAG][Oracle JDBC Driver]Object has been closed. null null


com.wm.ui2.UiException: wm.tn:exportData java.sql.SQLException [SoftwareAG][Oracle JDBC Driver]Object has been closed. at com.wm.ui2.UiException.handle(UiException.java:215) at com.wm.ui2.UiException.handle(UiException.java:184) at com.wm.app.tn.ui.Server.invoke(Server.java:379) at com.wm.app.tn.ui.importexport.ImportExportDialog.getDataFromServer(ImportExportDialog.java:149) at com.wm.app.tn.ui.importexport.ImportExportDialog.setMode(ImportExportDialog.java:92) at com.wm.app.tn.ui.importexport.ImportExportDialog.(ImportExportDialog.java:78) at com.wm.app.tn.ui.importexport.ImportExportDialog.getInstance(ImportExportDialog.java:175) at com.wm.app.tn.ui.TNMainFrame$6$1.run(TNMainFrame.java:352) at com.wm.app.tn.ui.TNMainFrame.askToSave(TNMainFrame.java:1248) at com.wm.app.tn.ui.TNMainFrame$6.actionPerformed(TNMainFrame.java:344) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:302) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1092) at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:993) at java.awt.Component.processMouseEvent(Component.java:5517) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5282) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3984) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1791) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)


wm.tn:exportData java.sql.SQLException [SoftwareAG][Oracle JDBC Driver]Object has been closed. java.sql.SQLException: [SoftwareAG][Oracle JDBC Driver]Object has been closed. at com.wm.dd.jdbc.oraclebase.BaseExceptions.createSQLException(Unknown Source) at com.wm.dd.jdbc.oraclebase.BaseExceptions.createException(Unknown Source) at com.wm.dd.jdbc.oraclebase.BaseExceptions.getException(Unknown Source) at com.wm.dd.jdbc.oraclebase.BasePreparedStatement.setString(Unknown Source) at com.wm.app.tn.db.SQLWrappers.setString(SQLWrappers.java:75) at com.wm.app.tn.db.SQLWrappers.setString(SQLWrappers.java:66) at com.wm.app.tn.db.DLSOperations.queryRuleRole(DLSOperations.java:304) at com.wm.app.tn.db.Export.addDLS(Export.java:166) at wm.tn.adminimpl.exportData(adminimpl.java:1273) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:403) at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:631) at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:40) at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44) at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:253) at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51) at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:228) at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30) at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:636) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:536) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381) at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237) at com.wm.app.b2b.server.comm.DefaultServerRequestHandler.handleMessage(DefaultServerRequestHandler.java:119) at com.wm.app.b2b.server.HTTPMessageHandler.process(HTTPMessageHandler.java:152) at com.wm.app.b2b.server.HTTPDispatch.handleRequest(HTTPDispatch.java:185) at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:333) at com.wm.util.pool.PooledThread.run(PooledThread.java:118) at java.lang.Thread.run(Thread.java:595)

Make sure this folder has all the required .sql files:

IntegrationServer/packages/WmTN/config/

After that reload WmTN package and this should work:

HTH
RMG

Thanks RMG!
Well, reloading both WmJDBCAdapter and WmTN worked for couple of exports but again it failed and threw the same exception. It is happening in almost all our environments.

Thanks & Regards,
smudiraj

Did you also make sure WmTN/Config folder has all the required .sql files…

Hi RMG,

Thanks for your help!
We tried the options we discussed and some more, but still the issue persist.
We raised the SR to Software AG and waiting for them to come back.

Regards,
Shrinivas

OK…Please keep the forum posted:

Thanks,
RMG