If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

MSR_GEN_0057 Failed to get module metadata

Started by rrvars, 13 Mar 2018 12:06:14 PM

Previous topic - Next topic

rrvars

Hi all,

After upgrading to 11.0.9 from 11.0.6 my data modules started to retrieve errors.
Basically when I try to open the data module, or a dashboard created using the data module as a source, the following error appears: "MSR_GEN_0057 Failed to get module metadata: "i94DD303B753F43779444C02F09917760" ".
This data module joins two data sets that were successfully refreshed.

Honestly, I don't have any clue about this error. I have several data modules with this error (not all). And if I create one from scratch everything is fine. It seems that somehow cognos lost the data modules definition.

Creating from scratch these data modules is not a solution for me, so if anyone could help me, would be great!!

Thanks in advance

(^.^)

MFGF

Quote from: rrvars on 13 Mar 2018 12:06:14 PM
Hi all,

After upgrading to 11.0.9 from 11.0.6 my data modules started to retrieve errors.
Basically when I try to open the data module, or a dashboard created using the data module as a source, the following error appears: "MSR_GEN_0057 Failed to get module metadata: "i94DD303B753F43779444C02F09917760" ".
This data module joins two data sets that were successfully refreshed.

Honestly, I don't have any clue about this error. I have several data modules with this error (not all). And if I create one from scratch everything is fine. It seems that somehow cognos lost the data modules definition.

Creating from scratch these data modules is not a solution for me, so if anyone could help me, would be great!!

Thanks in advance

Hi,

Did you do the upgrade in-place from 11.0.6 to 11.0.9 (ie did you install over the top) or was it a new install alongside? Do you have a deployment archive containing the data modules from 11.0.6? If so, it might be worth trying to re-import them?

I'd also log this with IBM if I were you.

Cheers!

MF.
Meep!

rrvars

#2
Quote from: MFGF on 14 Mar 2018 10:20:05 AM
Hi,

Did you do the upgrade in-place from 11.0.6 to 11.0.9 (ie did you install over the top) or was it a new install alongside? Do you have a deployment archive containing the data modules from 11.0.6? If so, it might be worth trying to re-import them?

I'd also log this with IBM if I were you.

Cheers!

MF.
Hi.

I've performed an over the top installation.
Yes, I already imported the data modules. I even created a new and blank content store database and imported the exported files from 11.0.6, but without luck.
Also, I tried to import the files to another environment but the issues still remains.

Yes, I've also opened a case in IBM. 

So this issue isn't regular? I was under the impression that somehow I was missing some kind of metadata refresh (besides the datasets).

Anyway, do you know how can I find the definition/specification of the data modules? For example I can extract the report specification in XML, for data modules is it possible to do the same? I'm trying to understand if I can recover anything from my data modules and perform a workaround.

Thanks in advance.
(^.^)

MFGF

Quote from: rrvars on 14 Mar 2018 10:53:47 AM
Hi.

I've performed an over the top installation.
Yes, I already imported the data modules. I even created a new and blank content store database and imported the exported files from 11.0.6, but without luck.
Also, I tried to import the files to another environment but the issues still remains.

Yes, I've also opened a case in IBM. 

So this issue isn't regular? I was under the impression that somehow I was missing some kind of metadata refresh (besides the datasets).

Anyway, do you know how can I find the definition/specification of the data modules? For example I can extract the report specification in XML, for data modules is it possible to do the same? I'm trying to understand if I can recover anything from my data modules and perform a workaround.

Thanks in advance.

Hi,

No, sadly you can't grab the spec of a data module in the same way as you can with a report. Reports use the SOAP interface, whereas Dashboards, Data Modules etc use the new REST interface. It's different technology under the covers.

Cheers!

MF.
Meep!

rrvars

Quote from: MFGF on 14 Mar 2018 12:26:33 PM
Hi,

No, sadly you can't grab the spec of a data module in the same way as you can with a report. Reports use the SOAP interface, whereas Dashboards, Data Modules etc use the new REST interface. It's different technology under the covers.

Cheers!

MF.

Hi.

Well, and without the easiest way to grab the specification? :P

I'm asking this kind of questions because these data modules were created by a person who's not available anymore. To create them from scratch I'd need a reference.

I was able to open the export content from cognos and I saw some kind of XML specs from a file named "package1.xml". With this file I saw the data sources (names/schemas/datasets) of each data module. This was the kind of information that I was able to retrieve. But the relationships, the calculations, the custom groups, I couldn't find.


Thanks in advance
(^.^)

bus_pass_man

My working hypothesis is that you've imported a deployment which does not have the include uploaded data setting on and / or you choose to Assign new IDs during import in the store IDs section. 

Problem 1. The module data source problem.

You've tried to open up a module. The module produced an error referring to some bloody long ID, which is essentially useless. Is that a correct understanding?

You say you are in R9. It should be possible to open a module even if the data sources are not available, so I think you are able to open the module.

You're over-complicating things and pursuing a chimera.  When you open a module, you are editing it.  You have everything which is in the module--the relationships, calculations etc. so your quest

Even if you had access to the specification of the module you'd have nothing more than what you already have.   

Even if you had the specification you couldn't do much with it and if you somehow managed to figure out a way to do something with it you'd probably be violating your license by reverse engineering etc.  and would have the IBM legal hellhounds on your tail.

Problem 2. The data source problem.

There are several possible reasons why you can't access the data sets.

They might be located in the former modeler's my contents.

They might not have permissions for you to read them.

They might not actually be there.

When you say you imported the modules, I'm assuming you are saying you were working with a deployment.  What type of deployment was it?  If you were working with a partial deployment, can you confirm if the include uploaded data setting was on when you imported the deployment.   Did you check on the folders in the public folder, directory and library content page?  Can you confirm what setting you choose for the Store IDs section.  Was it the default, generate new IDs or do not assign new IDs?

Try, in a fresh CM db, using the do not assign new IDs option.


In extremis upgrade to R10. 

It has exposed the folder path or the data source name and schema for the data sources used in the module.   

Press the add sources button in the sources pane.  It will display a list of the sources in the module and the folder path to them or the data source name and schema.

It also has a feature to relink the data source. 

rrvars

#6
Quote from: bus_pass_man on 21 Mar 2018 12:18:26 PM
My working hypothesis is that you've imported a deployment which does not have the include uploaded data setting on and / or you choose to Assign new IDs during import in the store IDs section. 

Problem 1. The module data source problem.

You've tried to open up a module. The module produced an error referring to some bloody long ID, which is essentially useless. Is that a correct understanding?

You say you are in R9. It should be possible to open a module even if the data sources are not available, so I think you are able to open the module.

You're over-complicating things and pursuing a chimera.  When you open a module, you are editing it.  You have everything which is in the module--the relationships, calculations etc. so your quest

Even if you had access to the specification of the module you'd have nothing more than what you already have.   

Even if you had the specification you couldn't do much with it and if you somehow managed to figure out a way to do something with it you'd probably be violating your license by reverse engineering etc.  and would have the IBM legal hellhounds on your tail.

Problem 2. The data source problem.

There are several possible reasons why you can't access the data sets.

They might be located in the former modeler's my contents.

They might not have permissions for you to read them.

They might not actually be there.

When you say you imported the modules, I'm assuming you are saying you were working with a deployment.  What type of deployment was it?  If you were working with a partial deployment, can you confirm if the include uploaded data setting was on when you imported the deployment.   Did you check on the folders in the public folder, directory and library content page?  Can you confirm what setting you choose for the Store IDs section.  Was it the default, generate new IDs or do not assign new IDs?

Try, in a fresh CM db, using the do not assign new IDs option.


In extremis upgrade to R10. 

It has exposed the folder path or the data source name and schema for the data sources used in the module.   

Press the add sources button in the sources pane.  It will display a list of the sources in the module and the folder path to them or the data source name and schema.

It also has a feature to relink the data source.


Hi, thank you for your response.

The problem here is that I'm not able to open the data modules. I cannot open or edit them. I'm not over-complicating things, when I try to open one, cognos retrieves immediately an error. Basically my dashboards are linked to a few corrupted data modules. This only happened after the migration, everything was fine before.
My data sets are working fine, even when I create a data module from scratch.
Also, this is not a security/permissions issue, I'm the full admin in both cognos and SQL.
The data sets/ data modules / dashboards are located in team content. And data sets are in a daily basis refreshed.

From my perception, cognos lost the data modules definition after the migration.
I must say that I performed an on top installation. After seeing this issue, I imported the deployment file and nothing changed. Then I tried with a new CM database and nothing changed once again.


I think is not acceptable to create everything from scratch after any future migration, hence my questions over here. I want to understand what, how and why this happened, and how can I solve it.
If the data modules are an unstable capability from cognos analytics then I need to create the model in a more stable way. 


Thanks in advance,
RR
(^.^)