Hi together,
just setting up Cognos Analytics 11 and installed the Samples. The sample dashboard (Product line dashboard) isn't working. If i investigate the one data module which is delivered with the samples i find this error:
Failed to retrieve M1_SampleFile_GOSales_xls data MSR-GEN-0009 Failed to get table data for module: "b88b83d49ebc97be1ff66b8f897339514ecb4a51_sessionTemp" using: "{projections=[{"identifier":"Quarter","sort":"ascending"}], moserFunctionType=getTableValues, resultCount=32000, offset=0, module=b88b83d49ebc97be1ff66b8f897339514ecb4a51_sessionTemp, querySubject=M1_SampleFile_GOSales_xls, outputType=columnar, autoSummary=true}"
CancelHide
The Cognos Samples Guide says nothing about the Dashboard/DataModule stuff.
Any idea what to do?
Regards
Ice
Quote from: IceTea on 05 Feb 2016 02:39:27 AM
Hi together,
just setting up Cognos Analytics 11 and installed the Samples. The sample dashboard (Product line dashboard) isn't working. If i investigate the one data module which is delivered with the samples i find this error:
Failed to retrieve M1_SampleFile_GOSales_xls data MSR-GEN-0009 Failed to get table data for module: "b88b83d49ebc97be1ff66b8f897339514ecb4a51_sessionTemp" using: "{projections=[{"identifier":"Quarter","sort":"ascending"}], moserFunctionType=getTableValues, resultCount=32000, offset=0, module=b88b83d49ebc97be1ff66b8f897339514ecb4a51_sessionTemp, querySubject=M1_SampleFile_GOSales_xls, outputType=columnar, autoSummary=true}"
CancelHide
The Cognos Samples Guide says nothing about the Dashboard/DataModule stuff.
Any idea what to do?
Regards
Ice
Looks to me like the module is looking for an uploaded file called "M1_SampleFile_GOSales.xls" which currently it can't find in the columnar data store. I haven't looked, but if you can locate this in the samples, you could upload it and see if it fixes the issue. Alternatively you could examine the structure from within the data module and try to re-create the XLS?
Cheers!
MF.
Hi,
I am getting this error every time I try to upload a file, not just samples. Did you find any solution for your problem yet? If yes, pls share.
Kiran
Quote from: kpassumarthi on 14 Jul 2016 05:18:48 AM
Hi,
I am getting this error every time I try to upload a file, not just samples. Did you find any solution for your problem yet? If yes, pls share.
Kiran
Not happening for me. What release of Cognos Analytics are you using?
MF.
Quote from: MFGF on 14 Jul 2016 09:36:46 AM
Not happening for me. What release of Cognos Analytics are you using?
MF.
Finally figured out that one of the dispatchers had query service disabled. Once enabled there is no error anymore.
FYI - we are reviewing/testing out cognos analytics 11.0.2
Thanks for responding anyway.
Kiran