ADS SP15 Fails to deploy with SDM

[Former Member]

I am upgrading a NW04 sandbox from SP13 to SP15.

I succesfully applied the patch to J2EE, EP6, KMC and JDI but I keep on getting failures when trying to apply ADSSAPOFF15_0-20000262.SCA package with SDM.

The failure happens while deploying development component 'XMLFormService'/'com.adobe'/'Adobe with some weird DB / JDBC error as shown in the log file.

I suspect there might be some memory problem but can't figure out where to look at or what to fix.

Before going to open an OSS... is there anybody experiencing same or similar issue? Can anybody give advice where I shall look at ?

Thanks in advance & Regards

Jan 5, 2006 3:39:50 AM Info: SDA to be deployed: D:\usr\sap\J2E\JC00\SDM\root\origin\com.adobe\XMLFormService\Adobe Systems\700.20050924051937.238137\adobe-XMLForm.sda

Jan 5, 2006 3:39:50 AM Info: Software type of SDA: primary-service

Jan 5, 2006 3:39:51 AM Info: ***** Begin of SAP J2EE Engine Offline Deployment (Service component of SAP J2EE Engine) *****

Jan 5, 2006 3:39:51 AM Info: Shutting down all the cluster processes except SDM.

Jan 5, 2006 3:39:51 AM Info: Shutting down the instance JC_com-sap_J2E_00 running on host com-sap processes ...

Jan 5, 2006 3:39:51 AM Info: Stopping the instance JC_com-sap_J2E_00 processes. The instance is running on host com-sap

Jan 5, 2006 3:39:51 AM Info: Stopping the process dispatcher

Jan 5, 2006 3:39:51 AM Info: Stopping the process server0

Jan 5, 2006 3:40:36 AM Info: Cluster processes have been successfully shut down.

Jan 5, 2006 3:41:21 AM Info: ***** End of SAP J2EE Engine Offline Deployment (Service component of SAP J2EE Engine) *****

Jan 5, 2006 3:41:21 AM Error: Aborted: development component 'XMLFormService'/'com.adobe'/'Adobe Systems'/'700.20050924051937.238137':

Caught exception during deployment from SAP J2EE Engine's offline deploy API:

com.sap.engine.tools.offlinedeploy.rdb.ODeploymentException: ERROR: Can't deploy component with sda D:\usr\sap\J2E\JC00\SDM\root\origin\com.adobe\XMLFormService\Adobe Systems\700.20050924051937.238137\adobe-XMLForm.sda

com.sap.engine.frame.core.configuration.ConfigurationException: Error occurred during DB access: ,

at com.sap.engine.core.configuration.impl.persistence.rdbms.UpdateProcessor.flush(UpdateProcessor.java:294)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.commitConfigurationHandler(ConfigurationCache.java:1184)

at com.sap.engine.core.configuration.impl.ConfigurationHandlerImpl.commit(ConfigurationHandlerImpl.java:833)

at com.sap.engine.tools.offlinedeploy.rdb.OfflineComponentDeployImpl.deployComponent0(OfflineComponentDeployImpl.java:408)

at com.sap.engine.tools.offlinedeploy.rdb.OfflineComponentDeployImpl.deployComponent(OfflineComponentDeployImpl.java:264)

at com.sap.sdm.serverext.servertype.inqmy.extern.EngineOfflineDeployerImpl.performDeployment(EngineOfflineDeployerImpl.java:209)

at com.sap.sdm.serverext.servertype.inqmy.extern.EngineDeployerImpl.deploy(EngineDeployerImpl.java:96)

at com.sap.sdm.serverext.servertype.inqmy.EngineProcessor.executeAction(EngineProcessor.java:224)

at com.sap.sdm.app.proc.deployment.impl.PhysicalDeploymentActionExecutor.execute(PhysicalDeploymentActionExecutor.java:60)

at com.sap.sdm.app.proc.deployment.impl.DeploymentActionImpl.execute(DeploymentActionImpl.java:186)

at com.sap.sdm.app.proc.deployment.controllers.internal.impl.DeploymentExecutorImpl.execute(DeploymentExecutorImpl.java:46)

at com.sap.sdm.app.proc.deployment.states.eventhandler.ExecuteDeploymentHandler.executeAction(ExecuteDeploymentHandler.java:83)

at com.sap.sdm.app.proc.deployment.states.eventhandler.ExecuteDeploymentHandler.handleEvent(ExecuteDeploymentHandler.java:60)

at com.sap.sdm.app.proc.deployment.states.StateBeforeNextDeployment.processEvent(StateBeforeNextDeployment.java:127)

at com.sap.sdm.app.proc.deployment.states.InstContext.processEventServerSide(InstContext.java:73)

at com.sap.sdm.app.proc.deployment.states.InstContext.processEvent(InstContext.java:59)

at com.sap.sdm.app.view.controllers.DeployEventProcessor.processEvent(DeployEventProcessor.java:11)

at com.sap.sdm.client_server.deployserver.DeployCmdProcessor.processEvent(DeployCmdProcessor.java:268)

at com.sap.sdm.client_server.deployserver.DeployCmdProcessor.process(DeployCmdProcessor.java:112)

at com.sap.sdm.gui.server.GuiAdminRoleCmdProcessor.process(GuiAdminRoleCmdProcessor.java:72)

at com.sap.sdm.is.cs.session.server.SessionCmdProcessor.process(SessionCmdProcessor.java:67)

at com.sap.sdm.is.cs.cmd.server.CmdServer.execCommand(CmdServer.java:76)

at com.sap.sdm.client_server.launch.ServerLauncher$ConnectionHandlerImpl.handle(ServerLauncher.java:286)

at com.sap.sdm.is.cs.ncserver.NetCommServer.serve(NetCommServer.java:43)

at com.sap.sdm.is.cs.ncwrapper.impl.ServiceWrapper.serve(ServiceWrapper.java:39)

at com.sap.bc.cts.tp.net.Worker.run(Worker.java:50)

at java.lang.Thread.run(Thread.java:534)

Caused by: com.sap.nwmss.jdbc.base.BaseBatchUpdateException: [SAP_NWMss][SQLServer JDBC Driver]Communication error: The stream provided does not contain the number of bytes specified. For batches, please ensure that streams are reset before subsequent addBatch calls. This is a non-recoverable error and the connection has been terminated.

at com.sap.nwmss.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)

at com.sap.sql.jdbc.basic.BasicPreparedStatement.executeBatch(BasicPreparedStatement.java:263)

at com.sap.sql.jdbc.mss.MssInetPreparedStatement.executeBatch(MssInetPreparedStatement.java:188)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeBatch(DirectPreparedStatement.java:1102)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeBatch(DirectPreparedStatement.java:1066)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBAccessDefault.execUpdateFileBatch(DBAccessDefault.java:1215)

at com.sap.engine.core.configuration.impl.persistence.rdbms.UpdateProcessor.flush(UpdateProcessor.java:273)

... 26 more

(message ID: com.sap.sdm.serverext.servertype.inqmy.extern.EngineOfflineDeployerImpl.performAction(DeploymentActionTypes).ODEXC)

Jan 5, 2006 3:41:23 AM Info: Restoring the state of the instance (JC_com-sap_J2E_00) process dispatcher from Stopped to Running

Jan 5, 2006 3:41:23 AM Info: Restoring the state of the instance (JC_com-sap_J2E_00) process server0 from Stopped to Running

Jan 5, 2006 3:50:57 AM Info: J2EE Engine is in same state (online/offline) as it has been before this deployment process.

[Former Member]

Problem solved with SAP help - OSS note 795991.

The issue was related to offline deployment via DataDirect to DB.

I had to set the startup parameter -g512 for SQL Server (this will change the size of the preallocated memory area for SQl Server from the default 256M to 512M).

Thank You SAP!