CSM error during installation

Products

• Mainframe Software Manager (Chorus Software Manager)

Issue/Introduction

 I obtain these message during the step of installation, after the choice of the TARGET:

MSM0051E - CA CSM database error.
  Additional Diagnostic Data:
    Database Error
    A database error has occurred. Consult the CSM logs for further information.
      Error message: Incorrect result size: expected 1, actual 3

Exception Details
=================
org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 3
 at org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:74)
 at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:17
8)
 at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(SimpleJdbcTemplate.java:157)
 at com.ca.mf20.dao.impl.datacom.JdbcCsiZoneDao.getCsiZoneByCsiIDAndName(JdbcCsiZoneDao.java:61)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
 at java.lang.reflect.Method.invoke(Method.java:508)
 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
 at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:42)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
 at com.sun.proxy.$Proxy138.getCsiZoneByCsiIDAndName(Unknown Source)
 at com.ca.mf20.daoservice.impl.CSI_CsiZoneSrvcImpl.getCsiZone(CSI_CsiZoneSrvcImpl.java:75)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
 at java.lang.reflect.Method.invoke(Method.java:508)
 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
 at com.sun.proxy.$Proxy139.getCsiZone(Unknown Source)
 at com.ca.mf20.sis.csiman.db.dataprovider.CsiDataProvider.getCsiZone(CsiDataProvider.java:621)
 at com.ca.mf20.sis.csiman.DefaultManagedZone.getZonePrefix(DefaultManagedZone.java:40)
 at com.ca.mf20.sis.sddprofile.instances.impl.ExistingZone.getZonePrefix(ExistingZone.java:30)
 at com.ca.mf20.sis.sddprofile.instances.TargetZoneInstance.getZoneHighLevelQualifier(TargetZoneInstance.java:98)
 at com.ca.mf20.ui.msm.sim.server.api.baseinstall.stages.impl.ExistingZoneSetupStage.getName(ExistingZoneSetupStage.java:
512)
 at com.ca.mf20.ui.msm.sim.server.api.baseinstall.stages.impl.ExistingZoneSetupStage.getAllocationParameters(ExistingZone
SetupStage.java:747)
 at com.ca.mf20.ui.msm.sim.server.api.baseinstall.stages.impl.ExistingZoneSetupStage.getAllocationParameters(ExistingZone
SetupStage.java:46)
 at com.ca.mf20.ui.msm.sim.server.api.baseinstall.BaseInstallDriver.getAllocationParameters(BaseInstallDriver.java:907)
 at com.ca.mf20.ui.msm.sim.server.BaseInstallSrvcImpl.getCsiDefinitionParameters(BaseInstallSrvcImpl.java:176)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
 at java.lang.reflect.Method.invoke(Method.java:508)
 at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:265)
 at com.ca.mf20.ui.foundation.server.servlet.MSMRemoteServiceServlet.processCall(MSMRemoteServiceServlet.java:120)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:305)
 at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at com.ca.mf20.ui.foundation.server.SecurityFilter.doFilter(SecurityFilter.java:83)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at com.ca.mf20.ui.foundation.server.GWTCacheControlFilter.doFilter(GWTCacheControlFilter.java:47)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:442)
 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1083)
 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:640)
 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.lang.Thread.run(Thread.java:818)

 

Environment

Release : 6.0

Component : Chorus Software Manager

Resolution

Select all 5 FMID whatever combination you want and proceed . Select your existing CCS CSI that is in your working set and proceed to step 5 target zone (1/3) where it allows you create a new target instead of using the exiting target zone that has Legacy already installed. You should be able to complete this successfully.