Symptoms:
This KB article describes the error “We can’t retrieve the data from data set Flexera Data Models” when a user tries to access Cognos Analytics. The Cognos Analytics dashboards display the above message and do not load.
Solution:
The error message is displayed due to an incorrect configuration of data source connections details on Cognos. One needs to follow the steps below as the Analytics Administrator (with Business Reporting Portal Admin account) to check the configuration issue:
- Access the FNMS webui using the account that has the Business Reporting Portal Admin role.
-Navigate to Reports>Analytics to access Analytics UI.
- Click on the Manage icon 'click mark icon' around the bottom left side of the navigation bar.
-Then navigate to Administration Console>Configuration>Data Source Connections.
-Notice the three FNMP groups named below:
FNMP-Dashboard
FNMP-DW-DS
FNMP-DW-DS-DQM
-Click on each one of the above three groups and then click on the ‘More’ link under Actions on the right side of the page.
-Then navigate to Set Properties>Connection.
-Next to the ‘Connection String’ field, click on the pencil icon ‘Edit the connection string’.
- Check both the ‘Native’ and ‘JDBC’ tabs. Ensure connection information, such as Server name, database name and port number, are correct. Also ensure the port number is specified correctly in the ‘Port number’ field.
-Also for both Native and JDBC connections, one can do test connection by clicking ‘Test the connection’ link.
-The FNMP-Dashboard-Group connection string should point to the Compliance database and the rest of the other two should point to the DataWarehouse database.
Related Articles
Retrieve installed application data for a large set of devices 7Number of Views Business adapters fail to retrieve data from SOAP API with error: Unable to cast object of type 'System.Net.HttpWebRequest… 13Number of Views Migrating from Data Platform to IT Visibility with the Flexera Integration ServiceNow App 38Number of Views Non-Commercial Software Disclosures, License Texts, and Attributions for Flexera Data Platform 5.5 33Number of Views ServiceNow update set to fix freezing during large data set processing 12Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Revenera Assistant
Case id: 00001065
Activity: Status change: 2 hours ago