Error "MSR-GEN-0009 Failed to get..." while using Dashboard/DataModule Samples

[IceTea]

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:

Code Select Expand

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

[MFGF]

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:

Code Select Expand

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.

[Kiran P]

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

[MFGF]

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.

[Kiran P]

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