Cognos Analytics

#CognosAnalyticswithWatson

Have you attempted to create a new report from the existing Package?

------------------------------
NORBERT Bracke
------------------------------

Original Message:
Sent: Wed August 28, 2019 04:03 PM
From: Sunny Padgett
Subject: Source Metadata Not Available when Editing Reports

A user recently reported that metadata was not available when editing a report in Cognos Connection (v11.0.13.1). The report is still correctly running, but there is no availability to add in new items from the original source data when editing. This message appears for all users including administrators. The images attached show the Metadata not available message and the data tab where the current report items are still available. We have a temp workaround where we can add a new query and use SQL to pull in data, but we'd like to know if anyone else has had this issue, how it was resolved, and causes if known. 

Additional info:
Windows server & Cognos services were restarted after issue reported with no change.
No known changes to the source tables/data.
No changes to server or Cognos configuration.
Have not attempted to re-publish FM packages in production.
Development server is not having same issues on identified reports/packages. However, a new package was published today and the admin who published can see source metadata as expected. The other admin gets the Metadata not available message when attempting to create a new report on the new package. Both admin user access is the same and model security is set to Full for these users. 

#CognosAnalyticswithWatson

Yes - great point that I left out. New reports from the package also provide the same Metadata not available message.

------------------------------
Sunny Padgett
------------------------------

Original Message:
Sent: Thu August 29, 2019 10:43 AM
From: NORBERT Bracke
Subject: Source Metadata Not Available when Editing Reports

Have you attempted to create a new report from the existing Package?

------------------------------
NORBERT Bracke

Original Message:
Sent: Wed August 28, 2019 04:03 PM
From: Sunny Padgett
Subject: Source Metadata Not Available when Editing Reports

A user recently reported that metadata was not available when editing a report in Cognos Connection (v11.0.13.1). The report is still correctly running, but there is no availability to add in new items from the original source data when editing. This message appears for all users including administrators. The images attached show the Metadata not available message and the data tab where the current report items are still available. We have a temp workaround where we can add a new query and use SQL to pull in data, but we'd like to know if anyone else has had this issue, how it was resolved, and causes if known. 

Additional info:
Windows server & Cognos services were restarted after issue reported with no change.
No known changes to the source tables/data.
No changes to server or Cognos configuration.
Have not attempted to re-publish FM packages in production.
Development server is not having same issues on identified reports/packages. However, a new package was published today and the admin who published can see source metadata as expected. The other admin gets the Metadata not available message when attempting to create a new report on the new package. Both admin user access is the same and model security is set to Full for these users. 

#CognosAnalyticswithWatson

Could you try taking a copy of the package and see if the copy works?

------------------------------
DENNY NAREZNY
------------------------------

Original Message:
Sent: Thu August 29, 2019 11:58 AM
From: Sunny Padgett
Subject: Source Metadata Not Available when Editing Reports

Yes - great point that I left out. New reports from the package also provide the same Metadata not available message.

------------------------------
Sunny Padgett

Original Message:
Sent: Thu August 29, 2019 10:43 AM
From: NORBERT Bracke
Subject: Source Metadata Not Available when Editing Reports

Have you attempted to create a new report from the existing Package?

------------------------------
NORBERT Bracke

Original Message:
Sent: Wed August 28, 2019 04:03 PM
From: Sunny Padgett
Subject: Source Metadata Not Available when Editing Reports

A user recently reported that metadata was not available when editing a report in Cognos Connection (v11.0.13.1). The report is still correctly running, but there is no availability to add in new items from the original source data when editing. This message appears for all users including administrators. The images attached show the Metadata not available message and the data tab where the current report items are still available. We have a temp workaround where we can add a new query and use SQL to pull in data, but we'd like to know if anyone else has had this issue, how it was resolved, and causes if known. 

Additional info:
Windows server & Cognos services were restarted after issue reported with no change.
No known changes to the source tables/data.
No changes to server or Cognos configuration.
Have not attempted to re-publish FM packages in production.
Development server is not having same issues on identified reports/packages. However, a new package was published today and the admin who published can see source metadata as expected. The other admin gets the Metadata not available message when attempting to create a new report on the new package. Both admin user access is the same and model security is set to Full for these users. 

#CognosAnalyticswithWatson

Hi,
   I have a message out there too regarding this problem.  I can duplicate exactly, as you stated, however, if I build a new package, with the same meta data with different name, it works fine. If I attempt to modify the package that is having problem, and republish it, still get same message.  This is only in reporting, everything else works fine, I can even enhance the package.  HELP!!​

------------------------------
Kurt Blevins
------------------------------

Original Message:
Sent: Wed August 28, 2019 04:03 PM
From: Sunny Padgett
Subject: Source Metadata Not Available when Editing Reports

A user recently reported that metadata was not available when editing a report in Cognos Connection (v11.0.13.1). The report is still correctly running, but there is no availability to add in new items from the original source data when editing. This message appears for all users including administrators. The images attached show the Metadata not available message and the data tab where the current report items are still available. We have a temp workaround where we can add a new query and use SQL to pull in data, but we'd like to know if anyone else has had this issue, how it was resolved, and causes if known. 

Additional info:
Windows server & Cognos services were restarted after issue reported with no change.
No known changes to the source tables/data.
No changes to server or Cognos configuration.
Have not attempted to re-publish FM packages in production.
Development server is not having same issues on identified reports/packages. However, a new package was published today and the admin who published can see source metadata as expected. The other admin gets the Metadata not available message when attempting to create a new report on the new package. Both admin user access is the same and model security is set to Full for these users. 

#CognosAnalyticswithWatson

Good morning Kurt, 

Some users are experiencing the same issue with New Reports.  We are on (11.0.13.1).  Others can duplicate the issue but I have no problems on my workstation.  Even different users using my workstation do not have the issue.  

The workaround I found for others is here: 

https://www-01.ibm.com/support/docview.wss?uid=swg1PI89033

------------------------------
Joseph Bankston
------------------------------

Original Message:
Sent: Fri August 30, 2019 03:32 AM
From: Kurt Blevins
Subject: Source Metadata Not Available when Editing Reports

Hi,
   I have a message out there too regarding this problem.  I can duplicate exactly, as you stated, however, if I build a new package, with the same meta data with different name, it works fine. If I attempt to modify the package that is having problem, and republish it, still get same message.  This is only in reporting, everything else works fine, I can even enhance the package.  HELP!!​

------------------------------
Kurt Blevins

Original Message:
Sent: Wed August 28, 2019 04:03 PM
From: Sunny Padgett
Subject: Source Metadata Not Available when Editing Reports

A user recently reported that metadata was not available when editing a report in Cognos Connection (v11.0.13.1). The report is still correctly running, but there is no availability to add in new items from the original source data when editing. This message appears for all users including administrators. The images attached show the Metadata not available message and the data tab where the current report items are still available. We have a temp workaround where we can add a new query and use SQL to pull in data, but we'd like to know if anyone else has had this issue, how it was resolved, and causes if known. 

Additional info:
Windows server & Cognos services were restarted after issue reported with no change.
No known changes to the source tables/data.
No changes to server or Cognos configuration.
Have not attempted to re-publish FM packages in production.
Development server is not having same issues on identified reports/packages. However, a new package was published today and the admin who published can see source metadata as expected. The other admin gets the Metadata not available message when attempting to create a new report on the new package. Both admin user access is the same and model security is set to Full for these users. 

#CognosAnalyticswithWatson

try Save to my content & see if you are able to link /re import package ?

report is upgraded ?

Thanks
Veera

------------------------------
Veera Kamma
------------------------------

Original Message:
Sent: Wed August 28, 2019 04:03 PM
From: Sunny Padgett
Subject: Source Metadata Not Available when Editing Reports

A user recently reported that metadata was not available when editing a report in Cognos Connection (v11.0.13.1). The report is still correctly running, but there is no availability to add in new items from the original source data when editing. This message appears for all users including administrators. The images attached show the Metadata not available message and the data tab where the current report items are still available. We have a temp workaround where we can add a new query and use SQL to pull in data, but we'd like to know if anyone else has had this issue, how it was resolved, and causes if known. 

Additional info:
Windows server & Cognos services were restarted after issue reported with no change.
No known changes to the source tables/data.
No changes to server or Cognos configuration.
Have not attempted to re-publish FM packages in production.
Development server is not having same issues on identified reports/packages. However, a new package was published today and the admin who published can see source metadata as expected. The other admin gets the Metadata not available message when attempting to create a new report on the new package. Both admin user access is the same and model security is set to Full for these users. 

#CognosAnalyticswithWatson