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

Unable to retrieve data from data set...

Started by xcognos, 08 Oct 2018 05:48:49 PM

Previous topic - Next topic

xcognos

Hello,

I'm trying to create some dashboards using an already preexisting package that we use for some of our reports and I keep running into the same problem. Every time there are multiple filters and multiple measures measures on the same visualization, I keep getting the error "We can't retrieve the data from data set (Package Name)." I've found that this is an issue with our IIS request filters and I tried lengthening our maximum query length and maximum url length to no avail. Now when I bypass our IIS, the dashboard works perfectly and all the visualizations load with all the filters and measures.

I was wondering if anyone else had these problems and what was done to fix it.

TomCognos

Had the same issue. Wrote a detailed fix on here but was lost a few months back when the servers went down.

Roughly from what i can recall it was fixed by doing the following.

Under the Cognos virtual dir (cognosanalytics) click the BI folder
Click the configuration editor (bottom of the screen)

Section: system.web/httpRuntime      From: Default Web Site/cognosanalytics/bi Web.config

Change maxRequestLength to something like 16384
Change maxQueryString to something like 8192


You can trap the length of the request though F12 on your browser. Chrome is a little nicer than IE.

I changed the same settings in IIS but through a different way to no avail. Only this way fixed the issue.

sdf

Hi,

I had a similar issue, but the error I get from the dashboards is "PARENT is not defined".
Changing the maxurl/request length to 16000 and 8000 somehow solved the issue.
But form time to time, we still get this issue.

Seems like we still need to test this. Can you share the actual steps to capture this using F12 in browser?
Also, do you know of any side effects or security risks on increasing this values?


thanks!

sdf

TomCognos

For IE.

Open IE and got to the Cognos portal.
Press F12 to bring up the developer tools browser console. Ctrl P to unpin this into a separate window.
Goto the Network Tab.
What we want to do now is to record the browser actions and submits, via the play button.
Depending on your IE version this is already recording. Clear any entries. Press play to record.
Then in your other window open up your dashboard.
You will see a bunch of GET's and XMLHttpRequests.
These are HTML encoded but any free website decoder will give you a nicer readable version.
Look for the errors.

Now if you do this outside of your server you don't get all the info. If you can do this on your server you will get better error messages. Took me some time, but after hunting through I found that my query string was to long.

Would work fine for 2 filters. But three would trip the dashboard and I would get that some error.

After modifying the Request Filtering in IIS we saw no improvement. Though after modifying the settings through Configuration Editor. It worked. Also do a IIS restart after changing these settings.

Boatsman

Problem
Message "We can't retrieve the data from data set " appear in place of your chart or object in dashboard. For example, when you add more than 22 attributes in your dashboard filter, or when you add more than 11 columns in your dashboard list....

Cause
Microsoft IIS configuration gateway

Environment
Microsoft IIS

Diagnosing The Problem
No problem with the default Cognos Analytics gateway, just with IIS.

Resolving The Problem
Microsoft IIS imposes a limit on the size of the url address/http query string. This limit is controllable from IIS Internet Information Service Manager in windows ( under Administrative tools)

Here are some instructions on how to change/set these limits:

- Open Internet Information Service Manager on the Cognos IIS host. This is located from Control Panel under "Administrative tools" option.
- On the navigation tree to the left, Click on "Sites/Default Web Site\IBMCognos" and select the "bi" directory.
- Double click on "Request Filtering" and then click on "Edit Feature Settings"
- Modify "Maximum URL Length" and "Maximum Query String".
- Test with first one to at least 16000 and the second to at least 8000
- Restart IIS

intellimade

We also struggeled with this issue; after correcting the iis url length values as stated as above, sometimes the dashboard still failed at certain moments, and sometimes it did work again.
This was on a multi tier environment; it appeared to be that the webserver farm was not containing the correct servers, so requests where sometimes sent by IIS to servers where there wasn't a query service running.
After we fixed this, the error was finally gone permanently.

Magdalina08

Is there a solution for this when you don't use Microsoft IIS? We are on a Linux server and I am having the same issue.