CMS UPDATE

[Former Member]

Hello people,

We have XI on ISeries server. We are trying to create a track in

CMS. but we can not found any Software component to add. So, we do a

clink on "Update CMS" botton to synchronize any software components

that were created in my SLD (its in the same server) after CMS was last synchronized. when we do that, The system hung without visual error

any software component appears

What can i do?

[Former Member · Accepted solution]

check the logs:

C:\usr\sap\....\CMS\log

Additionally check that your user has all the required authorizations

regards,

jaime

[Former Member · Accepted solution]

Hello Jaime, thanks for tour help.

I ve checked the permission and, are OK. Also i see the CMS log and found same errors:

-

---

#1.5#00145E47F57D004B0000F4050000031D00043021C8905E3C#1178821563801#/Applications/CMS/PCS#sap.com/tc_SLCMS~PCS#com.sap.cms.pcs.conf.manager.CmsConfManager#XIRIG#666#SAP J2EE Engine JTA Transaction : [cffffff80ffffffd066006852]#SAPDESA1_XID_209768550#XIRIG#b2c0a730ff2311dba92f00145e47f57d#ID\#(SAPDESA1_XID_20)ID1244621550DB10959532899217746438End.3b0cee10ff1911dbb0c600145e47f57d##0#0#Error#1#com.sap.cms.pcs.conf.manager.CmsConfManager#Plain###com.sap.cms.util.exception.CMSUnexpectedException: Cannot assign NULL to host variable 2. setNull() can only be used in INSERT and UPDATE statements. The statement is "SELECT "CAPTION","DESCRIPTION","TRACKTYPE","ASSEMBLE4DELIVERY","TRACKSTATE","RESPONSIBLE","DOCURL" FROM "CMS_CTRACK" WHERE "VERSION" = ? AND "NAME" = ?".

-

---

#1.5#00145E47F57D004B0000F4080000031D00043021C8927C46#1178821563939#/Applications/CMS#sap.com/tc_wddispwda#com.sap.cms.ui.landconf.LandConfController#XIRIG#666##SAPDESA1_XID_209768550#XIRIG#b2c0a730ff2311dba92f00145e47f57d#ID\#(SAPDESA1_XID_20)ID1244621550DB10959532899217746438End.3b0cee10ff1911dbb0c600145e47f57d##0#0#Error#1#com.sap.cms.ui.landconf.LandConfController#Plain###CMSUnexpectedException com.sap.cms.util.exception.CMSUnexpectedException: Cannot assign NULL to host variable 2. setNull() can only be used in INSERT and UPDATE statements. The statement is "SELECT "CAPTION","DESCRIPTION","TRACKTYPE","ASSEMBLE4DELIVERY","TRACKSTATE","RESPONSIBLE","DOCURL" FROM "CMS_CTRACK" WHERE "VERSION" = ? AND "NAME" = ?".#

-

---

#1.5#00145E47F57D004B0000F40E0000031D00043022563A0D59#1178823940508#/Applications/CMS#sap.com/tc_wddispwda#com.sap.cms.ui.landconf.LandConfController#XIRIG#666####6a6f4260ff2911dbc23f00145e47f57d#ID\#(SAPDESA1_XID_20)ID1244621550DB10959532899217746438End.3b0cee10ff1911dbb0c600145e47f57d##0#0#Error#1#com.sap.cms.ui.landconf.LandConfController#Plain###CMSConfigurationException SLD (URL http://sapdesa1:52000/) server exception: HTTP response code: 503 Not Ready#

-

---

#1.5#00145E47F57D004F0000007100000419000430388B31837E#1178919318422#/Applications/CMS/PCS#sap.com/tc_SLCMS~PCS#com.sap.cms.pcs.conf.manager.CmsConfManager#XIRIG#38#SAP J2EE Engine JTA Transaction : [cffffff80ffffffd066002ffffffba]#SAPDESA1_XID_209768550#LSADMIN#fdbd79e0000211dcb3d700145e47f57d#ID\#(SAPDESA1_XID_20)ID0079734850DB20089242429703564717End.cc49b440fffe11dbb9e600145e47f57d##0#0#Error#1#com.sap.cms.pcs.conf.manager.CmsConfManager#Plain###Update CMS failed#

I think that the host name can be one an issue, for example?