search cancel

Service Catalog Upgrade Fails at Configuring Components Step "Error importing Planning Sets" "IXPS0000"

book

Article ID: 242262

calendar_today

Updated On:

Products

CA Service Catalog

Issue/Introduction

Upgrade from Service Catalog 14.1 to 17.3 failed on the "Configuring Components step

Error message in view.log:

2022/05/11 09.13.42.713 TRACE [main] [DBSource] Query: select t.*, l.location_name, l.address_1, l.address_2, l.address_3, l.address_4, l.address_5, l.address_6, l.city, l.comments, l.country, l.county, l.fax_number as loc_fax_number, l.mail_address_1, l.mail_address_2, l.mail_address_3, l.mail_address_4, l.mail_address_5, l.mail_address_6, l.pri_phone_number, l.state, l.zip, ca_state_province.description as state_name, ca_country.name as country_name, 'true' as retrieved_location, cc.symbol as iccurrencysymbol, cc.name as iccurrencyname from usm_tenant t left outer join ca_location l on t.location_uuid = l.location_uuid left outer join ca_state_province on l.state = ca_state_province.id  left outer join ca_country on l.country = ca_country.id  left outer join ca_currency_type cc on cc.currency_type_code = t.currency_type_code where t.status = 1 and t.login_domain = ?
2022/05/11 09.13.42.713 TRACE [main] [DBSource] Query values: ["login_domain value here"]
2022/05/11 09.13.42.713 TRACE [main] [DBSource] Rows=0
2022/05/11 09.13.42.714 TRACE [main] [DBSource] Transaction committed
2022/05/11 09.13.42.714 ERROR [main] [ixUtil] Error importing Planning Sets
2022/05/11 09.13.42.715 ERROR [main] [ixUtil] IXPS0000
java.lang.NullPointerException
 at com.ca.usm.ix.ixReader.getDestTenantUUId(ixReader.java:909)
 at com.ca.usm.ix.ixReader.cacheLoginDomainTenantId(ixReader.java:901)
 at com.ca.usm.ix.ixReader.endElement(ixReader.java:251)
 at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
 at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
 at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
 at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
 at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
 at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
 at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
 at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
 at com.ca.usm.ix.ixReader.importFile(ixReader.java:425)
 at com.ca.usm.ix.billing.ixPlanSet.importFile(ixPlanSet.java:87)
 at com.ca.usm.ix.ix.performImportExport(ix.java:610)
 at com.ca.catalog.deploy.component.ContentDeployer.importContent(ContentDeployer.java:78)
 at com.ca.catalog.deploy.component.ContentDeployer.importPlanningContent(ContentDeployer.java:91)
 at com.ca.catalog.deploy.component.AccountingDeployer.deploy(AccountingDeployer.java:74)
 at com.ca.catalog.deploy.component.ComponentDeployer.deploy(ComponentDeployer.java:181)
 at com.ca.catalog.deploy.CmdDeploymentManager.deployModule(CmdDeploymentManager.java:98)
 at com.ca.catalog.deploy.Configurator.main(Configurator.java:177)

Environment

Release : 17.3

Component : Catalog - Install

Cause

The status value of this BU is 0 (inactive), this causes the query to return 0.

Resolution

Check this query from the trace view logs:

select t.*, l.location_name, l.address_1, l.address_2, l.address_3, l.address_4, l.address_5, l.address_6, l.city, l.comments, l.country, l.county, l.fax_number as loc_fax_number, l.mail_address_1, l.mail_address_2, l.mail_address_3, l.mail_address_4, l.mail_address_5, l.mail_address_6, l.pri_phone_number, l.state, l.zip, ca_state_province.description as state_name, ca_country.name as country_name, 'true' as retrieved_location, cc.symbol as iccurrencysymbol, cc.name as iccurrencyname from usm_tenant t left outer join ca_location l on t.location_uuid = l.location_uuid left outer join ca_state_province on l.state = ca_state_province.id  left outer join ca_country on l.country = ca_country.id  left outer join ca_currency_type cc on cc.currency_type_code = t.currency_type_code where t.status = 1 and t.login_domain = ?
2022/05/11 09.13.42.713 TRACE [main] [DBSource] Query values: ["login_domain value here"]

The installer expects this to return 1

2022/05/11 09.13.42.713 TRACE [main] [DBSource] Rows=0

This log indicates the result of the above query is 0.

We checked the customers usm_tenant_ext table and found this BU had status 0

We also verified that the query above returns 0 by running the query in another tool

Customer updated the status using this query:

update ca_tenant_ext set status = 1 where login_domain = "login_domain value here"

The login_domain value can be found in the trace view logs in the line that displays Query values.