Assembly state is running in CMS

[Former Member]

Hi All,

In CMS transport.

After importing Software component from consolidation to assembly,In assembly tab some of the activities are in running state forever.

The detailed log for this is mentioned below.

u201Cassembly failed (Unex) Exc=com.sap.cms.pcs.ejb.exception.CMSUnexpectedEJBException: nested exception is: com.sap.sql.log.OpenSQLException: Cannot assign a blank-padded string to host variable 13.com.sap.cms.util.exception.CMSUnexpectedException: nested exception is: com.sap.sql.log.OpenSQLException: Cannot assign a blank-padded string to host variable 13.

at com.sap.cms.util.logging.CmsLogger.cmsalert(CmsLogger.java:469)

at com.sap.cms.util.logging.CmsLogger.errorWithStackTrace(CmsLogger.java:375)

at com.sap.cms.pcs.transport.proxy.CmsTransportProxyBean.startAssembly(CmsTransportProxyBean.java:836)

at com.sap.cms.pcs.transport.proxy.LocalCmsTransportProxyLocalObjectImpl0.startAssembly(LocalCmsTransportProxyLocalObjectImpl0.java:1838)

at com.sap.cms.ui.wl.Custom1.startComponetAssembly(Custom1.java:14080)

at com.sap.cms.ui.wl.Custom1.assembleQueue(Custom1.java:4685)

at com.sap.cms.ui.wl.wdp.InternalCustom1.assembleQueue(InternalCustom1.java:2303)

at com.sap.cms.ui.wl.Worklist.handleAssemblyOptionsEvent(Worklist.java:1487)

at com.sap.cms.ui.wl.wdp.InternalWorklist.wdInvokeEventHandler(InternalWorklist.java:2520)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingView.invokeEventHandler(DelegatingView.java:87)

at com.sap.tc.webdynpro.progmodel.controller.Component.fireEvent(Component.java:283)

at com.sap.cms.ui.wl.wdp.InternalWorklists.wdFireEventAssemblyOptionsEvent(InternalWorklists.java:388)

at com.sap.cms.ui.wl.Worklists.fireAssemblyOptionsEvent(Worklists.java:247)

at com.sap.cms.ui.wl.wdp.InternalWorklists.fireAssemblyOptionsEvent(InternalWorklists.java:328)

at com.sap.cms.ui.wl.AssemblyOptions.onActionStartAssembly(AssemblyOptions.java:276)

at com.sap.cms.ui.wl.wdp.InternalAssemblyOptions.wdInvokeEventHandler(InternalAssemblyOptions.java:339)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingView.invokeEventHandler(DelegatingView.java:87)

at com.sap.tc.webdynpro.progmodel.controller.Action.fire(Action.java:67)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.doHandleActionEvent(WindowPhaseModel.java:420)

at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequest(WindowPhaseModel.java:132)

at com.sap.tc.webdynpro.clientserver.window.WebDynproWindow.processRequest(WebDynproWindow.java:335)

at com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:143)

at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:299)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessingStandalone(ClientSession.java:752)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessing(ClientSession.java:705)

at com.sap.tc.webdynpro.clientserver.session.ClientSession.doProcessing(ClientSession.java:261)

at com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:154)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:62)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doPost(DispatcherServlet.java:53)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:387)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:365)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:944)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:266)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:160)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(AccessController.java:219)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

Caused by: com.sap.cms.pcs.ejb.exception.CMSUnexpectedEJBException: nested exception is: com.sap.sql.log.OpenSQLException: Cannot assign a blank-padded string to host variable 13.

at com.sap.cms.pcs.compversregistry.compvers.persistence.CmsComponentVersionDao.addCompvers(CmsComponentVersionDao.java:190)

at com.sap.cms.pcs.compversregistry.compvers.ComponentVersion.save(ComponentVersion.java:368)

at com.sap.cms.pcs.compversregistry.compvers.CompversManager.saveCompvers(CompversManager.java:447)

at com.sap.cms.pcs.assembly.manager.AssemblyManager.createAssemblyVersion(AssemblyManager.java:823)

at com.sap.cms.pcs.assembly.manager.AssemblyManager.assemble(AssemblyManager.java:1395)

at com.sap.cms.pcs.assembly.AssemblyQueueHandler.execAssembly(AssemblyQueueHandler.java:818)

at com.sap.cms.pcs.assembly.AssemblyQueueHandler.startAssembly(AssemblyQueueHandler.java:133)

at com.sap.cms.pcs.transport.proxy.CmsTransportProxyBean.startAssembly(CmsTransportProxyBean.java:829)

... 42 more

Caused by: javax.ejb.EJBException: nested exception is: com.sap.sql.log.OpenSQLException: Cannot assign a blank-padded string to host variable 13.

at com.sap.cms.pcs.ejb.SqlJHandler.handleSqlJInsertException(SqlJHandler.java:80)

at com.sap.cms.pcs.compversregistry.compvers.persistence.SqlJComponentversion.create(SqlJComponentversion.sqlj:68)

at com.sap.cms.pcs.compversregistry.compvers.persistence.CmsComponentVersionDao.addCompvers(CmsComponentVersionDao.java:163)

... 49 more

Any help in solving the problem will be highly apprecaited.

Reagrds,

Lavanya.G

[former_member192434]

Check out this forum link

Thanks