SQLException at SDM deploy: closed connection

[Former Member]

Hi,

we are using JDI to develop and deploy a webdynpro application.

After having deployed on the production system we have developed a patch and tries to deploy it as well, but get an java.sql.SQLException (Closed Connection) from the SDM:

We also looked at oracle logs, application logs and stack traces, but did not find any further information.

SDM log:

[code]Info:Nov 15, 2005 8:59:37 AM Info: 8:59:37 2005-11-15 dbs-Info: $Id: //tc/DictionaryDatabase/630_VAL_REL/src/_dictionary_database_dbs/java/com/sap/dictionary/database/dbs/DbModificationManager.java#2 $

Info:Nov 15, 2005 8:59:37 AM Info: 8:59:37 2005-11-15 dbs-Info: <<<<<<<<<<<<<< Table Deployment >>>>>>>>>>>>>

Info:Nov 15, 2005 8:59:37 AM Info: 8:59:37 2005-11-15 dbs-Info:

Info:Nov 15, 2005 8:59:37 AM Info: 8:59:37 2005-11-15 dbs-Info: <<< Analyze table BC_DDDBRTH >>>

Info:Nov 15, 2005 8:59:37 AM Info:

Info:Nov 15, 2005 8:59:37 AM Info: E R R O R ******* (DbColumns)

Info:Nov 15, 2005 8:59:37 AM Info: 8:59:37 2005-11-15 dbs-Error: Table BC_DDDBRTH: Error during reading of columns from db

Info:Nov 15, 2005 8:59:37 AM Info:

Info:Nov 15, 2005 8:59:37 AM Info: E R R O R ******* (DbColumns)

Info:Nov 15, 2005 8:59:37 AM Info: 8:59:37 2005-11-15 dbs-Error: Caused by: Closed Connection Stack trace: java.sql.SQLException: Closed Connection

Info:Nov 15, 2005 8:59:37 AM Info: at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

Info:Nov 15, 2005 8:59:37 AM Info: at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

Info:Nov 15, 2005 8:59:37 AM Info: at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)

Info:Nov 15, 2005 8:59:37 AM Info: at oracle.jdbc.driver.OracleConnection.getMetaData(OracleConnection.java:1573)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sql.jdbc.basic.BasicConnection.getMetaData(BasicConnection.java:180)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sql.jdbc.direct.DirectConnection.getMetaData(DirectConnection.java:703)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sql.jdbc.common.CommonConnectionImpl.getDirectMetaData(CommonConnectionImpl.java:1315)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sql.services.OpenSQLServices.getNativeMetaData(OpenSQLServices.java:117)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sql.NativeSQLAccess.getNativeMetaData(NativeSQLAccess.java:84)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.dictionary.database.dbs.DbColumns.setContentViaDb(DbColumns.java:58)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.dictionary.database.dbs.DbTable.setColumnsViaDb(DbTable.java:195)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.dictionary.database.dbs.DbTable.setCommonContentViaDb(DbTable.java:183)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.dictionary.database.dbs.DbObjectModificationAnalyser.modify(DbObjectModificationAnalyser.java:72)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.dictionary.database.dbs.RuntimeObject.create(RuntimeObject.java:62)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.dictionary.database.dbs.RuntimeObjectTable.create(RuntimeObjectTable.java:179)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.dictionary.database.dbs.RuntimeObjectTable.createIfNecessary(RuntimeObjectTable.java:188)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.dictionary.database.dbs.DbModificationManager.distribute(DbModificationManager.java:73)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.serverext.servertype.dbsc.extern.JDDDeployer.executeAction0(JDDDeployer.java:130)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.serverext.servertype.dbsc.extern.JDDDeployer.executeActionInternal(JDDDeployer.java:73)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.serverext.servertype.dbsc.AbstractDeployer.executeAction(AbstractDeployer.java:156)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.serverext.servertype.dbsc.DBSCDeploymentActionProcessor.executeAction(DBSCDeploymentActionProcessor.java:154)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.app.proc.deployment.impl.PhysicalDeploymentActionExecutor.execute(PhysicalDeploymentActionExecutor.java:60)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.app.proc.deployment.impl.DeploymentActionImpl.execute(DeploymentActionImpl.java:186)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.app.proc.deployment.controllers.internal.impl.DeploymentExecutorImpl.execute(DeploymentExecutorImpl.java:46)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.app.proc.deployment.states.eventhandler.ExecuteDeploymentHandler.executeAction(ExecuteDeploymentHandler.java:83)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.app.proc.deployment.states.eventhandler.ExecuteDeploymentHandler.handleEvent(ExecuteDeploymentHandler.java:60)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.app.proc.deployment.states.StateBeforeNextDeployment.processEvent(StateBeforeNextDeployment.java:127)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.app.proc.deployment.states.InstContext.processEventServerSide(InstContext.java:73)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.app.proc.deployment.states.InstContext.processEvent(InstContext.java:59)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.app.sequential.deployment.impl.DeployerImpl.doPhysicalDeployment(DeployerImpl.java:127)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.app.sequential.deployment.impl.DeployerImpl.deploy(DeployerImpl.java:96)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.apiimpl.local.DeployProcessorImpl.deploy(DeployProcessorImpl.java:63)

Info:Nov 15, 2005 8:59:37 AM Info: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Info:Nov 15, 2005 8:59:37 AM Info: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

Info:Nov 15, 2005 8:59:37 AM Info: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

Info:Nov 15, 2005 8:59:37 AM Info: at java.lang.reflect.Method.invoke(Method.java:324)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.is.cs.remoteproxy.server.impl.RemoteProxyServerImpl.requestRemoteCall(RemoteProxyServerImpl.java:127)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.is.cs.remoteproxy.server.impl.RemoteProxyServerImpl.process(RemoteProxyServerImpl.java:38)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.apiimpl.remote.server.ApiClientRoleCmdProcessor.process(ApiClientRoleCmdProcessor.java:81)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.is.cs.session.server.SessionCmdProcessor.process(SessionCmdProcessor.java:67)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.is.cs.cmd.server.CmdServer.execCommand(CmdServer.java:76)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.client_server.launch.ServerLauncher$ConnectionHandlerImpl.handle(ServerLauncher.java:280)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.is.cs.ncserver.NetCommServer.serve(NetCommServer.java:43)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.sdm.is.cs.ncwrapper.impl.ServiceWrapper.serve(ServiceWrapper.java:39)

Info:Nov 15, 2005 8:59:37 AM Info: at com.sap.bc.cts.tp.net.Worker.run(Worker.java:50)

Info:Nov 15, 2005 8:59:37 AM Info: at java.lang.Thread.run(Thread.java:534)

Info:Nov 15, 2005 8:59:37 AM Info:

Info:Nov 15, 2005 8:59:37 AM Info:

Info:Nov 15, 2005 8:59:37 AM Info: E R R O R ******* (DbModificationManager)

Info:Nov 15, 2005 8:59:37 AM Info: 8:59:37 2005-11-15 dbs-Error:

Info:Nov 15, 2005 8:59:37 AM Error: Aborted: development component 'dormapp1/basis/dic'/'dorma.com'/'DJ1_Dev_C'/'11907':

Info:No further description found.

Info:Nov 15, 2005 8:59:39 AM Info: J2EE Engine is in same state (online/offline) as it has been before this deployment process.[/code]

Any idea is appreciated!

Regards,

Hans

[mohammad_al-mumen]

Having the same exact problem, too.

I hope someone have an answer.

[Former Member]

Hi,

I have the same problem.

Did you solve it?

Regrads,

Artem