Clarity Service Management

Expand all | Collapse all

CA Service Catalog 17.1 upgrade failing

Jump to Best Answer
  • 1.  CA Service Catalog 17.1 upgrade failing

    Posted 09-10-2019 05:44 PM
    We are getting below error when we are trying to upgrade Service Catalog from 12.9 to 17.1. Can anyone please sugest.


    09-10,15:55:05 INFO -    IF EXISTS (select * from syscolumns where id=object_id('usm_offering') and name='offering_name')09-10,15:55:05 INFO -    IF EXISTS (select * from syscolumns where id=object_id('usm_offering') and name='offering_name')09-10,15:55:05 INFO -    BEGIN09-10,15:55:05 INFO -    ALTER TABLE [usm_offering] ALTER COLUMN [offering_name] nvarchar ( 128 )  COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL09-10,15:55:05 INFO -    END09-10,15:55:05 INFO -    IF EXISTS (select * from syscolumns where id=object_id('usm_offering') and name='description')09-10,15:55:05 INFO -    BEGIN09-10,15:55:05 INFO -    ALTER TABLE [usm_offering] ALTER COLUMN [description] nvarchar ( 512 )  COLLATE SQL_Latin1_General_CP1_CI_AS  NULL09-10,15:55:05 INFO -    END09-10,15:55:05 INFO -    IF NOT EXISTS (select * from syscolumns where id=object_id('usm_offering') and name='overview_text')09-10,15:55:05 INFO -    ALTER TABLE [usm_offering] ADD [overview_text] ntext  COLLATE SQL_Latin1_General_CP1_CI_AS  NULL09-10,15:55:05 INFO -    IF NOT EXISTS (select * from syscolumns where id=object_id('usm_offering') and name='mobile_enabled')09-10,15:55:05 INFO -    ALTER TABLE [usm_offering] ADD [mobile_enabled] int CONSTRAINT [DF_usm_offering_mobile_enabled] DEFAULT '0' NOT NULL09-10,15:55:05 INFO -    IF NOT EXISTS (select * from syscolumns where id=object_id('usm_offering') and name='rateplanheaderdisplay')09-10,15:55:05 INFO -    ALTER TABLE [usm_offering] ADD [rateplanheaderdisplay] int DEFAULT '0' NOT NULLUpdate sql failed:IF EXISTS (select * from syscolumns where id=object_id('usm_offering') and name='offering_name')BEGIN ALTER TABLE [usm_offering] ALTER COLUMN [offering_name] nvarchar ( 128 )  COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULLEND
    IF EXISTS (select * from syscolumns where id=object_id('usm_offering') and name='description')BEGIN ALTER TABLE [usm_offering] ALTER COLUMN [description] nvarchar ( 512 )  COLLATE SQL_Latin1_General_CP1_CI_AS  NULLEND
    IF NOT EXISTS (select * from syscolumns where id=object_id('usm_offering') and name='overview_text') ALTER TABLE [usm_offering] ADD [overview_text] ntext  COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
    IF NOT EXISTS (select * from syscolumns where id=object_id('usm_offering') and name='mobile_enabled') ALTER TABLE [usm_offering] ADD [mobile_enabled] int CONSTRAINT [DF_usm_offering_mobile_enabled] DEFAULT '0' NOT NULL
    IF NOT EXISTS (select * from syscolumns where id=object_id('usm_offering') and name='rateplanheaderdisplay') ALTER TABLE [usm_offering] ADD [rateplanheaderdisplay] int DEFAULT '0' NOT NULL09-10,15:55:05 DEBUG - The index 'usm_offering_idx_04' is dependent on column 'offering_name'.09-10,15:55:05 INFO - MDBTools_0308I - Installation of last object failed, requeuing it to the end of the list.09-10,15:55:05 INFO - MDBTools_0305E - Error processing table 'usm_offering.xml'; details follow:09-10,15:55:05 ERROR - com.microsoft.sqlserver.jdbc.SQLServerException: The index 'usm_offering_idx_04' is dependent on column 'offering_name'.com.microsoft.sqlserver.jdbc.SQLServerException: The index 'usm_offering_idx_04' is dependent on column 'offering_name'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:751) at com.ca.mdbtools.DriverApp.updateDB(DriverApp.java:2697) at com.ca.mdbtools.DriverApp.apply(DriverApp.java:2256) at com.ca.mdbtools.DriverApp.installSchemaDriver(DriverApp.java:1085) at com.ca.mdbtools.Utilities.run(Utilities.java:1678) at com.ca.mdbtools.Utilities.main(Utilities.java:1042)


  • 2.  RE: CA Service Catalog 17.1 upgrade failing

    Posted 09-11-2019 08:30 AM
    Please close the installer and drop the index 'usm_offering_idx_04' on the usm_offering table

    Then restart the installer and reattempt the upgrade


    ------------------------------
    Paul Coccimiglio
    Principal Support Engineer
    Broadcom Inc.
    ------------------------------



  • 3.  RE: CA Service Catalog 17.1 upgrade failing

    Posted 09-11-2019 06:06 PM

    I tried this, it still failed with below logs.

     

    Install.log

     

    2019/09/11 15.50.29.495 DEBUG [DeployThread: Configuring CA Service Catalog - MDB] [CommonProcessUtilities] java.util.ServiceConfigurationError: com.sun.tools.attach.spi.AttachProvider: Provider sun.tools.attach.WindowsAttachProvider could not be instantiated

    2019/09/11 15.52.45.706 DEBUG [DeployThread: Configuring CA Service Catalog - MDB] [CommonProcessUtilities] Deploy module 'mdb' failed with return code - -3

    2019/09/11 15.52.45.708 DEBUG [DeployThread: Configuring CA Service Catalog - MDB] [CommonProcessUtilities] Java HotSpot(TM) 64-Bit Server VM warning: ignoring option UseSplitVerifier; support was removed in 8.0

    2019/09/11 15.52.46.117 INFO  [DeployThread: Configuring CA Service Catalog - MDB] [ActiveProcessHolder] Exit Monitor. Process ID (PID): 11432

    2019/09/11 15.52.46.117 DEBUG [DeployThread: Configuring CA Service Catalog - MDB] [CommonProcessUtilities] Command terminated with exit code: -3

    2019/09/11 15.52.46.117 DEBUG [DeployThread: Configuring CA Service Catalog - MDB] [ConfigureSLCMMDB] SLCM MDB Configuration Exit Code: -3

    2019/09/11 15.52.46.118 INFO  [DeployThread: Configuring CA Service Catalog - MDB] [ConfigureSLCMMDB] SLCM MDB Configuration Exit Code: -3

    2019/09/11 15.52.46.118 DEBUG [DeployThread: Configuring CA Service Catalog - MDB] [ConfigureSLCMMDB] Configuring mdb failed. Firing Task Error.

    2019/09/11 15.52.46.118 DEBUG [DeployThread: Configuring CA Service Catalog - MDB] [ProgressPage] ProgressPage - Task Changed Configuring CA Service Catalog - MDB

    2019/09/11 15.52.46.118 DEBUG [DeployThread: Configuring CA Service Catalog - MDB] [ProgressPage] Task State Changed. TaskID: task.configuring_mdb,Configuring CA Service Catalog - MDB, Old State: running, New State:failed

    2019/09/11 15.52.46.118 INFO  [DeployThread: Configuring CA Service Catalog - MDB] [DeployThread] Saving task status to DB for task task.configuring_mdb

    2019/09/11 15.52.46.119 INFO  [DeployThread: Configuring CA Service Catalog - MDB] [DeployThread] Saving task 'task.configuring_mdb' status to DB ....

    2019/09/11 15.52.46.119 INFO  [DeployThread: Configuring CA Service Catalog - MDB] [DatabasePersister] Saving component install state to database.

    2019/09/11 15.52.46.119 DEBUG [DeployThread: Configuring CA Service Catalog - MDB] [DatabasePersister] Insert/Update Parameters: productCode (2); currVersion (17.1); status(failed); packageId(task.configuring_mdb)

    2019/09/11 15.52.46.167 DEBUG [DeployThread: Configuring CA Service Catalog - MDB] [DatabasePersister] Query Parameters: lower(machineName) - (ui2dcaap010x); lower(packageid) -  (task.configuring_mdb); productCode(2)

    2019/09/11 15.52.46.167 INFO  [DeployThread: Configuring CA Service Catalog - MDB] [DatabasePersister] al_cdb_componentinstallstate count 1

    2019/09/11 15.52.46.167 DEBUG [DeployThread: Configuring CA Service Catalog - MDB] [DatabasePersister]  Update to al_cdb_componentinstallstate successful

    2019/09/11 15.52.46.167 INFO  [DeployThread: Configuring CA Service Catalog - MDB] [DeployThread] Task 'task.configuring_mdb' status saved to DB ....

    2019/09/11 15.52.46.167 DEBUG [DeployThread: Configuring CA Service Catalog - MDB] [ProgressPage] ProgressPage - Task Error.

    2019/09/11 15.52.46.167 DEBUG [DeployThread: Configuring CA Service Catalog - MDB] [ProgressPage] Task Error. TaskID: task.configuring_mdb,Configuring CA Service Catalog - MDB

     

     

    View.log

     

    2019/09/11 15.51.49.735 INFO  [main] [CmdLineUtility] Command process started: D:/Program Files/CA/Service Catalog/temp/mdb1.5/windows/setupmdb.bat in directory D:\Program Files\CA\Service Catalog\temp\mdb1.5\windows

    2019/09/11 15.52.45.648 WARN  [main] [CmdLineUtility] Command terminated with exit code: 3

    2019/09/11 15.52.45.649 ERROR [main] [DatabaseDeployer] setupmdb failed with returncode=3

    2019/09/11 15.52.45.703 ERROR [main] [CmdDeploymentManager] Deployment of the module 'mdb' failed

    com.ca.catalog.deploy.exceptions.OperationFailedException

                    at com.ca.catalog.deploy.database.DatabaseDeployer.setupMdb(DatabaseDeployer.java:351)

                    at com.ca.catalog.deploy.database.DatabaseDeployer.deployMdb(DatabaseDeployer.java:307)

                    at com.ca.catalog.deploy.database.DatabaseDeployer.deploy(DatabaseDeployer.java:189)

                    at com.ca.catalog.deploy.CmdDeploymentManager.deployModule(CmdDeploymentManager.java:98)

                    at com.ca.catalog.deploy.Configurator.main(Configurator.java:177)

    2019/09/11 15.52.45.705 ERROR [main] [Configurator] Deployment of module:mdb failed

     

     

    Thanks and Regards,

     

    Rajasheker Chittanur 

    Service Catalog Development and Support
    Baker Hughes, a GE company

    Office: +1 713 879 4625| Mobile: +1 469 434 4384

    Rajasheker.Chittanur@bakerhughes.com

     






  • 4.  RE: CA Service Catalog 17.1 upgrade failing
    Best Answer

    Posted 09-11-2019 11:34 PM
    I was able to resolve this issue and successfully upgrade to 17.1. Now forms are not loading and even the request details are not loading..
    i am seeing below error in view.logs

    2019/09/11 22.18.35.110 ERROR [CatalogStatusUpdater] [OfferingStatusUpdateTask] OFFUPST0002019/09/11 22.18.35.110 ERROR [CatalogStatusUpdater] [OfferingStatusUpdateTask] OFFUPST000com.ca.usm.common.CommonException: Unavailable Date cannot be entered when Available Date is empty at com.ca.usm.billing.ServiceManager.Offerings.getCurrentStatus(Offerings.java:2397) at com.ca.usm.billing.ServiceManager.OfferingStatusUpdateTask.run(OfferingStatusUpdateTask.java:65) at java.util.TimerThread.mainLoop(Unknown Source) at java.util.TimerThread.run(Unknown Source)


  • 5.  RE: CA Service Catalog 17.1 upgrade failing

    Posted 09-11-2019 11:35 PM
    also below error,

    019/09/11 22.26.38.197 ERROR [http-nio-8080-exec-1] [CRequest] CREQ0015019/09/11 22.26.38.197 ERROR [http-nio-8080-exec-1] [CRequest] CREQ0015java.lang.NullPointerException at com.ca.usm.datasource.DBJDBC.getJDBCCatalog(DBJDBC.java:279) at com.ca.usm.datasource.DBJDBC.getPrimaryKeys(DBJDBC.java:335) at com.ca.usm.datasource.DBSource.getPrimaryKeys(DBSource.java:877) at com.ca.usm.datasource.DBSource.newObject(DBSource.java:1539) at com.ca.usm.datasource.CommonDB.newObject(CommonDB.java:294) at com.ca.usm.datasource.DBSource.doSelect(DBSource.java:1407) at com.ca.usm.datasource.DBSource.doSelect(DBSource.java:1378) at com.ca.usm.datasource.DBSource.doSelect(DBSource.java:1372) at com.ca.usm.datasource.DBSource.executeQuery(DBSource.java:1052) at com.ca.usm.datasource.DBSource.executeQuery(DBSource.java:1030) at com.ca.usm.datasource.DBSource.executeQuery(DBSource.java:1012) at com.ca.usm.billing.ServiceManager.RequestItemForm.getFDFormIdAttrValMap(RequestItemForm.java:755) at com.ca.usm.billing.ContentEngine.CRequest.cloneRequest(CRequest.java:1597) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.ca.usm.contentInterface.PluginMethod.invoke(DefaultContentEngine.java:172) at com.ca.usm.contentInterface.DefaultContentEngine.invokeMethod(DefaultContentEngine.java:98) at com.ca.usm.contentInterface.DefaultContentEngine.processRequest(DefaultContentEngine.java:57) at com.ca.usm.contentInterface.DefaultContentEngine.processRequest(DefaultContentEngine.java:17) at com.ca.usm.util.ViewManager.executeRequest(ViewManager.java:92) at com.ca.usm.util.ViewManager.doRequest(ViewManager.java:51) at com.ca.usm.util.ViewManager.processRequest(ViewManager.java:28) at com.ca.usm.producer.DocumentGenerator.processRequest(DocumentGenerator.java:563) at com.ca.usm.producer.DocumentGenerator.generateDocument(DocumentGenerator.java:270) at com.ca.usm.producer.DocumentGenerator.generateDocument(DocumentGenerator.java:241) at com.ca.usm.producer.DomProcessor.renderPage(DomProcessor.java:167) at com.ca.usm.producer.DomProcessor.service(DomProcessor.java:123) at com.ca.usm.producer.WPFServlet.service(WPFServlet.java:337) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.system.ThreadLocalFilter.doFilter(ThreadLocalFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:419) at org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:169) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.HttpHeaderNullifierFilter.doFilter(HttpHeaderNullifierFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.NtlmAuthenticationFilter.doFilter(NtlmAuthenticationFilter.java:239) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.SsoAuthFilter.doFilter(SsoAuthFilter.java:57) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.SecurityHandleFilter.doFilter(SecurityHandleFilter.java:201) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.ca.usm.httpfilter.ClickjackFilter.doFilter(ClickjackFilter.java:94) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:784) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1410) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)2019/09/11 22.26.39.287 INFO  [http-nio-8080-exec-1] [WPFServlet] END: Time taken for GET request, Node=icguinode.requestclone&sh=igA%2FN538gw%2B9Z6s0DNUW4icT%2Bes%3D&Args=127540&savedFrom=copy&Args=BHGE%20Data%20Center%20Access%20Request&iscopyPage=true is:19642019/09/11 22.26.39.287 INFO  [http-nio-8080-exec-1] [WPFServlet] NUmber of sqls=107


  • 6.  RE: CA Service Catalog 17.1 upgrade failing

     
    Posted 09-12-2019 01:10 AM
    Hello Rajeshekar,

    Good to hear that you progressed the previous issue. To help the Community in the future:

    • Please advise the steps that were done and the result.
    • Maintain one set of symptoms/questions and their resolution to one thread.
    This makes it easier for people later to find out what the resolution to a particular question or symptom set was.


    For this query, I searched existing issues and found this similar symptom set. 

    - - - - - - SIMILAR ISSUE FOR A DIFFERENT SITE

    Service catalog nodes down and they won't come back up

    2019/05/09 12.21.10.274 ERROR [CatalogStatusUpdater] [OfferingStatusUpdateTask] OFFUPST000 com.ca.usm.common.CommonException: Unavailable Date cannot be entered when Available Date is empty at com.ca.usm.billing.ServiceManager.Offerings.getCurrentStatus(Offerings.java:2334) at com.ca.usm.billing.ServiceManager.OfferingStatusUpdateTask.run(OfferingStatusUpdateTask.java:64) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) 2019/05/09 12.21.10.276 ERROR [CatalogStatusUpdater] [OfferingStatusUpdateTask] OFFUPST000 com.ca.usm.common.CommonException: Unavailable Date cannot be entered when Available Date is empty at com.ca.usm.billing.ServiceManager.Offerings.getCurrentStatus(Offerings.java:2334) at com.ca.usm.billing.ServiceManager.OfferingStatusUpdateTask.run(OfferingStatusUpdateTask.java:64) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505)


    Updated the viewService.conf file on 3775 to match the other Catalog nodes, however we were still having issue with getting the login screen to display.

    Catalogs java.exe process was still showing a high usage.

    Referencing the doc below:

    https://comm.support.ca.com/kb/high-usage-of-javaexe-process-at-service-catalog-server-when-integrated-to-service-desk-manager/kb000006608

    We then backed up the Jms-data folder "..\Service Catalog\logs\jms-data" to a separate folder outside "..\Service Catalog\logs", then delete all the files under "..\Service Catalog\logs\jms-data"

    And also cleared out some older log files.

    After starting Catalog back up we were then able to get to the login screen.
    - - - - - - END

    I don't know if some of those suggestions might be able to help you, as this document seems to be around resources. But maybe the extra steps on deleting files may help.

    The new link for the above document is here:
    https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=6608

    Thanks, Kyle_R.