cancel
Showing results for 
Search instead for 
Did you mean: 

CMS UPDATE

Former Member
0 Kudos
66

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?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

check the logs:

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

Additionally check that your user has all the required authorizations

regards,

jaime

Former Member
0 Kudos

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/tcSLCMS~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/tcwddispwda#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/tcwddispwda#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/tcSLCMS~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?

Answers (3)

Answers (3)

Former Member
0 Kudos

ok,

and are you sure that the sld is up and running? the 503 is very suspicious.

Former Member
0 Kudos

That could be possible too.

Did you see the SLD logs? And does sldcheck give a correct output?

Former Member
0 Kudos

hello Jamine

The SLDCHECK is successfully, i dont understand what could be

Former Member
0 Kudos

Hi,

are you sure you are looking at the correct date? that looks like a deployment error- which is explained in note 718754. But Im not sure that it fits you.

Did you carry out the deployment of the java sp and abap sp correctly? Are they on the same level?

You need the following packets:

SAPINST<SP>.SAR

CTRL<DB><SP>.SAR

J2EERT<SP>.SAR

J2EERTOS<SP>.SAR

and install them in the same order!!

regards,

jaime

Former Member
0 Kudos

Hello Jaime, thanks for you help. My version is 640 SP18

and is the same level, abap and java.

I think in a posibility...an issue with SLD connection maybe?