AnsweredAssumed Answered

Failed to configure the component. Please configure MDB as prerequisite and try again

Question asked by santoshiw on Aug 9, 2016
Latest reply on Aug 11, 2016 by Jason_Wolfe


Hi Team ,

 

We have Servicedesk 14.1 in Dev environment and we are trying to install 12.9 ( due to some requirement ) Service catalog and catalog got installed but when i am deploying components from setup utility am getting below error.

 

"Failed to configure the component. Please configure MDB as prerequisite and try again"

 

MDB deployed successfully from setup utility below are log details for mdb

 

2016/08/08 09.34.50.421 INFO  [http-8080-6] [CmdLineUtility] Command executed Sucessfully

2016/08/08 09.34.50.421 INFO  [http-8080-6] [DatabaseDeployer] setupMdb is successful...

2016/08/08 09.34.50.421 INFO  [http-8080-6] [DatabaseDeployer] Starting configureMDB...

2016/08/08 09.34.50.421 INFO  [http-8080-6] [ConfigureSQLServer] Started configureMDBforSqlServer

2016/08/08 09.34.50.449 INFO  [http-8080-6] [ConfigureSQLServer] Successfully connected to SQL Server using Connect String: jdbc:sqlserver://ITSM-D-SQL-1:1433;database=mdb;instanceName=mssqlserver;SelectMethod=cursor

2016/08/08 09.34.51.720 INFO  [http-8080-6] [ConfigureSQLServer] User usmuser exists in syslogins table

2016/08/08 09.34.51.720 INFO  [http-8080-6] [ConfigureSQLServer] Calling sp_change_users_login for user: usmuser

2016/08/08 09.34.52.873 INFO  [http-8080-6] [ConfigureSQLServer] Successfully called sp_change_users_login for user: usmuser

2016/08/08 09.34.52.873 INFO  [http-8080-6] [ConfigureSQLServer] Executing Alter Login for user: usmuser

2016/08/08 09.34.54.890 INFO  [http-8080-6] [ConfigureSQLServer] Altered database user: usmuser successfully.

2016/08/08 09.34.54.890 INFO  [http-8080-6] [ConfigureSQLServer] Calling sp_defaultdb for user: usmuser mdb: mdb

2016/08/08 09.34.54.974 INFO  [http-8080-6] [ConfigureSQLServer] Called sp_defaultdb for user :usmuser successfully.

2016/08/08 09.34.54.974 INFO  [http-8080-6] [ConfigureSQLServer] Calling sp_addrolemember for user: usmuser

2016/08/08 09.35.14.688 INFO  [http-8080-6] [ConfigureSQLServer] Called sp_addrolemember for user :usmuser successfully.

2016/08/08 09.35.14.703 INFO  [http-8080-6] [ConfigureSQLServer] Calling sp_addrolemember for user: usmuser

2016/08/08 09.35.14.853 INFO  [http-8080-6] [ConfigureSQLServer] Called sp_addrolemember for user :usmuser successfully.

2016/08/08 09.35.14.858 INFO  [http-8080-6] [ConfigureSQLServer] Calling sp_addsrvrolemember for user: usmuser

2016/08/08 09.35.15.135 INFO  [http-8080-6] [ConfigureSQLServer] Called sp_addsrvrolemember for user :usmuser successfully.

2016/08/08 09.35.15.158 INFO  [http-8080-6] [ConfigureSQLServer] Executing Grant ALL to database user: usmuser

2016/08/08 09.35.15.273 INFO  [http-8080-6] [ConfigureSQLServer] Grant ALL to database user: usmuser done successfully.

2016/08/08 09.35.15.273 INFO  [http-8080-6] [ConfigureSQLServer] Executing Grant ALTER to database user: usmuser

2016/08/08 09.35.15.273 INFO  [http-8080-6] [ConfigureSQLServer] Grant ALTER to database user: usmuser done successfully.

2016/08/08 09.35.15.289 INFO  [http-8080-6] [ConfigureSQLServer] Executing Grant Execute on Object: CMN_ENABLE_DISABLE_SP to user: usmuser

2016/08/08 09.35.15.362 INFO  [http-8080-6] [ConfigureSQLServer] Executing Grant Execute on Object: CMN_ENABLE_DISABLE_SP to user: usmuser is successful

2016/08/08 09.35.15.363 INFO  [http-8080-6] [ConfigureSQLServer] Executing Grant Execute on Object: USM_TOGGLE_FK_TRIGGER_SP to user: usmuser

2016/08/08 09.35.15.405 INFO  [http-8080-6] [ConfigureSQLServer] Executing Grant Execute on Object: USM_TOGGLE_FK_TRIGGER_SP to user: usmuser is successful

2016/08/08 09.35.15.405 INFO  [http-8080-6] [ConfigureSQLServer] Executing Grant Execute on Object: USM_FN_PRODUCT_CODE to user: usmuser

2016/08/08 09.35.15.443 INFO  [http-8080-6] [ConfigureSQLServer] Executing Grant Execute on Object: USM_FN_PRODUCT_CODE to user: usmuser is successful

2016/08/08 09.35.15.444 INFO  [http-8080-6] [ConfigureSQLServer] Executing Grant Control on Object: USM_TENANT_EXT to user: usmuser

2016/08/08 09.35.15.452 INFO  [http-8080-6] [ConfigureSQLServer] Executing Grant Control on Object: USM_TENANT_EXT to user: usmuser is successful

2016/08/08 09.35.15.504 INFO  [http-8080-6] [ConfigureSQLServer] Successfully completed configureMDBforSqlServer

2016/08/08 09.35.15.504 INFO  [http-8080-6] [DatabaseDeployer] configureMDB is successful...

2016/08/08 09.35.15.504 INFO  [http-8080-6] [DatabaseDeployer] *********MDB deployment is successful****

 

 

and errors am seeing in log file are :

 

2016/08/09 01.45.27.790 INFO  [http-8080-4] [WebDeploymentManager] Deploy the module: component

2016/08/09 01.45.27.800 INFO  [http-8080-4] [DeployUtil] MDB deployed. Verifing the version

2016/08/09 01.45.27.831 ERROR [http-8080-4] [ComponentDeployer] MDB is not yet deployed.

2016/08/09 01.45.27.831 ERROR [http-8080-4] [WebDeploymentManager] Deploying the module 'component' failed

com.ca.catalog.deploy.exceptions.OperationFailedException

  at com.ca.catalog.deploy.component.ComponentDeployer.deploy(ComponentDeployer.java:156)

  at com.ca.catalog.deploy.WebDeploymentManager.deployModule(WebDeploymentManager.java:215)

  at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:606)

  at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:173)

  at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:89)

  at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:167)

  at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:94)

  at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

  at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:94)

  at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

  at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:122)

  at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:232)

  at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)

  at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154)

  at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:129)

  at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:219)

  at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:139)

  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

  at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:195)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

  at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)

  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)

  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)

  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

  at java.lang.Thread.run(Thread.java:744)

 

can you please suggest ?

 

Thank you,

 

Regards,

santoshi.P

Outcomes