IBM Support

After having built a data module from two datasets, reports fail: 400 MSR-GEN-0077 or 500 MSR-GEN-0002 XQE-MD-0007

Troubleshooting


Problem

A data module had been built as follows...
1. import from .csv file
2. create a data module from the imported file
3. create two datasets from the data module
4. create a further data module consisting of the two datasets and join on a unique column

On attempting to build and execute a report, it fails with the following errors...

400
 MSR-GEN-0077 Data for dataset "name" does not exist. Try to reload dataset data.
 Details:
   400 - Bad Request
   URL:
   v1/metadata/modules/i9...5/metadata?item=on
{"msg";"MSR-GEN-0077 Data for dataset \"name" does not exist...
 
500
 MSR-GEN-0002 Error: "XQE-MD-0007 Unable to establish a metadata connection to data source i9...2HTTP/1.1 400 Bad Request."
 Details:
   500 - Internal Server Error
   URL:
   v1/metadata/base_modules/i9...5/metadata/functionList
{"msg";"MSR-GEN-0002 Error \"XQE-MD-0007 ...

It was also noted that inconsistent errors occurred on uploading the file and on selecting the datasets when defining the second data module.

Resolving The Problem

The .csv file was determined to be corrupted. Once the file had been recreated, there were no further problems.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"Reporting","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 September 2018

UID

ibm10730389