Focal Point
[CASE-OPENED] InfoAssist - "empty list of fields"

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8387045995

March 01, 2011, 03:20 PM
Mike in DeLand
[CASE-OPENED] InfoAssist - "empty list of fields"
I have some InfoAssist reports on a dashboard that were developed by a power user. When I right-click and select "run" it works. When I select "edit source" it opens just fine. When I right-click and select "open" to open it in infoassist, I get a blank page with a dialog box that says "Empty List of Fields" and that's all. Click ok and the whole thing closes.

This is happening on several reports, but not all. They used to open just fine. I've already got a ticked opened with IBI, but no solution so far. Has anybody seen this before?
Thanks.

This message has been edited. Last edited by: Kerry,


Webfocus 8
Windows, Linux
March 04, 2011, 01:37 PM
Kerry
Hi all,

FYI, Mike already has a case opened, which is being researched on.

Mike, once you have an update/solution from the case, can you please post it here as well? Thank you in advance for sharing with all.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
March 04, 2011, 01:58 PM
Mike in DeLand
Here's what happened.

This report uses 3 tables. We use DBA security, and we use the central DBA file method, where each MFD points to one DBA file containing all the rules. Well, I took the DBA security rules from the central file, and entered them into each of the 3 MFDs. Then the problem went away. So, one at a time, I put the rules back into the central file until the problem came back. One of the 3 tables will not work when the rules are in the central file. The other 2 work either way. The kicker is, the problem file has exactly the same rules as one of the files that works both ways. Go figure.


Webfocus 8
Windows, Linux
March 07, 2011, 09:12 AM
Brian Suter
IA gets the field list by doing a TABLE FILE SYSCOLUMN against the server. This should work with DBAFILE (and as you saw, it worked in 2 of 3 cases). Please open a case. Would like to see what is unique about your masters and dba.


Brian Suter
VP WebFOCUS Product Development