Unable to map external data and existing report

[ycrozet]

Hello,

I try to map an external data (Excel file with less than 100 lines) with an existing report (only 2 columns with the code article) but I have always the same SOAP error :

<SOAP-ENV:Fault xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><faultcode>Server</faultcode><faultstring>The server did something wrong</faultstring><detail><bus:exception xmlns:bus="http://developer.cognos.com/schemas/bibus/3/"><severity>error</severity><errorCode>CM-REQ-4342 Une erreur s'est produite avec le client.</errorCode><bus:message><messageString/><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>Remontée des informations de trace du gestionnaire :
[the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler
[the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler
[service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler
[load_balancer] com.cognos.pogo.handlers.logic.ChainHandler
[lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler
[mdaChainHandler] com.cognos.pogo.handlers.logic.ChainHandler
[asyncMetadataServiceHandler] com.cognos.pogo.async.impl.AsyncHandler
[metadataServiceHandler] com.cognos.metadataService.bibusHandler.MDSRVHandler</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>Remontée des informations de trace des exceptions :</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>CM-REQ-4342 Une erreur s'est produite avec le client.</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>java.lang.RuntimeException: CM-REQ-4342 Une erreur s'est produite avec le client.</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.metadataService.command.Command.getPackageFromCM(Command.java:226)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.metadataService.command.personalData.CommandProcessExtractReport.invokeRequest(CommandProcessExtractReport.java:75)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.metadataService.bibusHandler.MDSRVHandler.processRequest(MDSRVHandler.java:496)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.metadataService.bibusHandler.MDSRVHandler.invokeImpl(MDSRVHandler.java:461)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:203)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.async.impl.AsyncHandler.invokeImpl(AsyncHandler.java:125)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:203)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:53)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:203)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.impl.PogoEngineImpl.invokeHandler(PogoEngineImpl.java:158)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.p2plb.clerver.balancer.RequestForwarder.rawForwardToSelf(RequestForwarder.java:215)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.p2plb.clerver.balancer.RequestForwarder.forwardToSelf(RequestForwarder.java:188)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.p2plb.clerver.balancer.LoadBalanceRequest.processRequest(LoadBalanceRequest.java:92)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.p2plb.clerver.balancer.LoadBalanceRequest.processRequest(LoadBalanceRequest.java:47)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:267)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:203)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:53)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:203)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.impl.PogoEngineImpl.invokeHandler(PogoEngineImpl.java:158)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:115)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:203)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:53)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:203)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.handlers.performance.PerformanceIndicationHandler.invokeImpl(PerformanceIndicationHandler.java:118)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:203)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.impl.PogoEngineImpl.service(PogoEngineImpl.java:126)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.transport.PogoServlet.processRequest(PogoServlet.java:264)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.transport.PogoServlet.doPost(PogoServlet.java:727)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.pdk.performance.servlet.PerformanceIndicatorWrappedServlet.service(PerformanceIndicatorWrappedServlet.java:31)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.pogo.isolation.ServletWrapper.service(ServletWrapper.java:283)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1287)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:778)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1158)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:4867)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.handleRequest(DynamicVirtualHost.java:297)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:997)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.run(DynamicVirtualHost.java:262)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper.run(HttpDispatcherLink.java:955)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:341)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:470)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:404)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:284)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.ready(HttpInboundLink.java:255)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.tcpchannel.internal.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:174)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.tcpchannel.internal.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:83)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:504)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:574)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:929)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1018)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at java.lang.Thread.run(Thread.java:745)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>Caused by: CM-REQ-4342 Une erreur s'est produite avec le client.</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:609)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1782)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2973)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:117)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:648)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(SAXParserImpl.java:332)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:698)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at org.apache.axis.client.Call.invokeEngine(Call.java:2784)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at org.apache.axis.client.Call.invoke(Call.java:2767)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at org.apache.axis.client.Call.invoke(Call.java:2443)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at org.apache.axis.client.Call.invoke(Call.java:2366)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at org.apache.axis.client.Call.invoke(Call.java:1812)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.developer.schemas.bibus._3.ContentManagerServiceStub.query(ContentManagerServiceStub.java:8058)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   at com.cognos.metadataService.command.Command.getPackageFromCM(Command.java:208)</messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>   ... 54 more</messageString><nestingLevel>1</nestingLevel></bus:message></bus:exception></detail></SOAP-ENV:Fault>

Do you have any idea ?

NB: I do not have this issue if I choose a request subject.

Thanks in advance

[AnalyticsWithJay]

Does this issue happen if you select any report? Or a specific report?

This may occur if you're selecting another report which uses external data.

[GaryJ]

Would be keen to hear if you found a solution to this - I've just installed Fixpack 12 (32 bit and 64 bit) onto the server and have the same issue. External Data worked fine following the install and then this error surfaced again. All I'm doing is importing a very small file of a few lines for test purposes.

I run a training company and I've actually had this issue in every version after Fixpack 1 which worked fine.

I'm desperate to know what the cause is and the message offers no clues. Any help would be much appreciated..

Cheers
Gary

Error is as follows:

Unrecognised SOAP error

<SOAP-ENV:Fault xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><faultcode>Server</faultcode><faultstring>The server did something wrong</faultstring><detail><bus:exception xmlns:bus="http://developer.cognos.com/schemas/bibus/3/"><severity>error</severity><errorCode>CM-REQ-4159 Content Manager returned an error in the response header. The error "cmAuthenticateFailed CM-CAM-4005 Unable to authenticate. Check your security directory server connection and confirm the credentials entered at login." can be found in the response SOAP header.</errorCode><bus:message><messageString></messageString><nestingLevel>1</nestingLevel></bus:message><bus:message><messageString>Handler trace back:

[bdbits]

Has anyone tried contacting IBM support yet? I think this might be difficult to nail down on a forum like this one, even though we do have some pretty smart people here.

To me this sounds like a bug that should get reported and hopefully, fixed by IBM.

[GaryJ]

I haven't reported it to IBM but I agree it should be.

It's ok when you connect to a Query Subject (which is very limiting) but not when you connect to an existing report.

I've seen the same problem in the Cognos Analytics 11 too.

[MFGF]

Hi,

Are you absolutely sure the data type of the item in your external file being used for the join to your report is the same as the data type of the item in the report you are joining to?

MF.