Execution of some migrated reports from Sterling Control Center 5.2 or 5.3 fails on Sterling Control Center 5.4 with error message codes CGNS007E and RSV-CM-0005

Symptom

If you are running the report manually from Sterling Control Center Console, you will experience a pop-up with the following error message:

Error running the report on Cognos Business Intelligence Server

The connection with the Cognos Business Intelligence Server may be down.
The connection is retried automatically.
Check the engine log for more details

An error message similar to the message below will occur in Engine_*.log:

17 Sep 2014 08:52:04,968 40040349 [Thread-10766] ERROR SccContextChecker - CGNS007E Unable to execute the report: <REPORT NAME WITH MULTIPLE CONSECUTIVE BLANKS> on Cognos Business Intelligence Server.
Stack Trace:
com.sterlingcommerce.scc.common.ReportServiceException: CGNS007E Unable to execute the report: <REPORT NAME WITH MULTIPLE CONSECUTIVE BLANKS> on Cognos Business Intelligence Server.
at com.sterlingcommerce.scc.agent.services.cognos.CognosReportService.addExecuteReport(CognosReportService.java:271)
at com.sterlingcommerce.scc.agent.services.cognos.CognosReportService.executeCognosReport(CognosReportService.java:94)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:618)
at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:87)
at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:618)
at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:291)
at com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(StandardMBeanIntrospector.java:124)
at com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(StandardMBeanIntrospector.java:58)
at com.sun.jmx.mbeanserver.MBeanIntrospector.invokeM(MBeanIntrospector.java:249)
at com.sun.jmx.mbeanserver.PerInterface.invoke(PerInterface.java:150)
at com.sun.jmx.mbeanserver.MBeanSupport.invoke(MBeanSupport.java:264)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:831)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:813)
at com.sun.jdmk.MBeanServerForwarder.invoke(MBeanServerForwarder.java:281)
at com.sun.jdmk.MBeanServerChecker.invoke(MBeanServerChecker.java:337)
at com.sterlingcommerce.scc.agent.services.jmx.SccContextChecker.invoke(SccContextChecker.java:328)
at com.sun.jdmk.comm.GenericHttpRequestHandler.invoke(GenericHttpRequestHandler.java:559)
at com.sun.jdmk.comm.GenericHttpRequestHandler.doOperation(GenericHttpRequestHandler.java:285)
at com.sun.jdmk.comm.GenericHttpRequestHandler.processPostRequest(GenericHttpRequestHandler.java:235)
at com.sun.jdmk.comm.GenericHttpClientHandler.processRequest(GenericHttpClientHandler.java:193)
at com.sun.jdmk.comm.GenericHttpClientHandler.doRun(GenericHttpClientHandler.java:113)
at com.sun.jdmk.comm.ClientHandler.run(ClientHandler.java:135)
at java.lang.Thread.run(Thread.java:804)


An error message similar to the message below will occur in CognosReportService_*.log:

RSV-CM-0005 Content Manager did not return an object for the requested search path '/content/package[@name='IBMControlCenter']/report[@name='<REPORT NAME WITH MULTIPLE CONSECUTIVE BLANKS>']'.