Author Topic: Error "MSR-GEN-0009 Failed to get..." while using Dashboard/DataModule Samples  (Read 2222 times)

Offline IceTea

  • Community Leader
  • *****
  • Join Date: Mar 2009
  • Posts: 153
  • Forum Citizenship: +7/-0
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]
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






Online MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 9,299
  • Forum Citizenship: +563/-8
  • Cognos Software Muppet
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]
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.
Meep!

Online Kiran P

  • Full Member
  • ***
  • Join Date: Oct 2013
  • Posts: 45
  • Forum Citizenship: +0/-0
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

Online MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 9,299
  • Forum Citizenship: +563/-8
  • Cognos Software Muppet
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.
Meep!

Online Kiran P

  • Full Member
  • ***
  • Join Date: Oct 2013
  • Posts: 45
  • Forum Citizenship: +0/-0
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

 


           
Twittear