We can't upgrade Service Catalog to v17.1 due to an integration we don't use

Document ID : KB000091873
Last Modified Date : 22/08/2018
Show Technical Document Details
Issue:
We tried to upgrade Service Catalog to 17.1 and we have an error when the installer tries to install the integration with USS (which we don't use).

The log error is the following:
2018/04/14 01.37.33.138 DEBUG [DeployThread: Integrating the Product(s)] [OSOPValidator] Unified Self-Service endpoint validation successful.
2018/04/14 01.37.33.139 INFO [DeployThread: Integrating the Product(s)] [ConfigureOSOPWithSDM] Configuring Unified Self-Service with CA Service Desk Manager
2018/04/14 01.37.33.139 INFO [DeployThread: Integrating the Product(s)] [ConfigureOSOPWithSDM] downloading the certificate File from DB
2018/04/14 01.37.33.141 ERROR [DeployThread: Integrating the Product(s)] [ConfigureOSOPWithSDM] Caught Exception
java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Long.parseLong(Unknown Source)
at java.lang.Long.parseLong(Unknown Source)
at com.ca.smsi.installui.integration.tasks.ConfigureOSOPWithSDM.downloadSDMCertFromDB(ConfigureOSOPWithSDM.java:314)
at com.ca.smsi.installui.integration.tasks.ConfigureOSOPWithSDM.configureOSOPWithSDMDetails(ConfigureOSOPWithSDM.java:142)
at com.ca.smsi.installui.integration.tasks.ConfigureOSOPWithSDM.run(ConfigureOSOPWithSDM.java:76)
at com.ca.smsi.installui.tasks.AutoIntegrateTask.run(AutoIntegrateTask.java:140)
at com.ca.smsi.wizard.task.Task.start(Task.java:239)
at com.ca.smsi.installcore.DeployThread.run(DeployThread.java:1117)
2018/04/14 01.37.33.143 ERROR [DeployThread: Integrating the Product(s)] [ConfigureOSOPWithSDM] Download of SDM Policy failed.
2018/04/14 01.37.33.143 ERROR [DeployThread: Integrating the Product(s)] [ConfigureOSOPWithSDM] Unable to update CA Service Desk Manager dataset in Unified Self-Service.
2018/04/14 01.37.33.169 ERROR [DeployThread: Integrating the Product(s)] [ConfigureOSOPWithSDM] Configuration of Unified Self-Service with CA Service Desk Manager failed.
2018/04/14 01.37.33.169 ERROR [DeployThread: Integrating the Product(s)] [AutoIntegrateTask] Error occured during intergration task : Configuration of Unified Self-Service with CA Service Desk Manager failed.
2018/04/14 01.37.33.170 ERROR [DeployThread: Integrating the Product(s)] [AutoIntegrateTask] will continue executing the next integration Task
2018/04/14 01.37.33.170 DEBUG [DeployThread: Integrating the Product(s)] [ConfigureOSOPWithSLCM] OSOP_SLCM_IS_INTEGRATED : true SLCM_HOSTNAME (CATALOG_HOSTNAME) osopHostname :(USS_HOSTNAME) isOSOPIntegSkipEnabled :(false)
2018/04/14 01.37.33.170 DEBUG [DeployThread: Integrating the Product(s)] [ConfigureOSOPWithSLCM] Execution of integration task (com.ca.smsi.installui.integration.tasks.ConfigureOSOPWithSLCM) is false
2018/04/14 01.37.33.171 DEBUG [DeployThread: Integrating the Product(s)] [AutoIntegrateTask] Executing auto-integration task : Class <com.ca.smsi.installui.integration.tasks.ConfigureOSOPWithSLCM> . Integration isAllowed : false
2018/04/14 01.37.33.171 INFO [DeployThread: Integrating the Product(s)] [AutoIntegrateTask] Task execution complete. failedTasks.size() = 1
2018/04/14 01.37.33.171 ERROR [DeployThread: Integrating the Product(s)] [AutoIntegrateTask] Installation was success but one or more integration tasks failed, please see log for more details
Environment:
Service Catalog 17.1
Cause:
Undetermined
Resolution:
1) in the MDB test database , insert the following entries al_cdb_configurationparameters table :
------------------------------

insert al_cdb_configurationparameters(componentkey,machinename,configkey,configvalue,productcode, last_update_date) values('itsm','common','osop.sdm.is.integrated','1',9,'1508335080807')
------------------------------

This entry basically tells SM installer : this environment already has "USS and SDM" set up, please do NOT attempt to do auto-integrations for them on this env .

2) then re-invoke SM 17.1 installer.