Ignition Report issue with key browser

Ignition
1

I have been building a 46 page report and now that i have mapped all of the data in it i went to check to see if everything was reporting as it should. i noticed that i was getting zeros for all my historical data and upon further inspection my start and end dates were improperly configured.

i corrected those start and end dates but now I'm getting 2 new issues I’m getting this error whenever I open the designer

image
image1074×408 23.7 KB

And this issue when I open the preview

image
image889×190 4.34 KB

now I'm not getting any data at all and i do not see my parameters or queries in my design mode

image
image1292×897 61.6 KB

i switched my start and end dates back to standard but still no luck

image
image797×560 47.4 KB

if anyone has any insight that would be helpful.

(also i one point i did add and then remove 2 parameters that are no longer pointing at anything and are not in the report anymore)

Thank you.

2

potentially solved after writing all this out, i may have to much information in a single report

1 Like
3

The designer (and vision clients) operate with a hard-coded 60-second timeout on gateway requests. If your report takes that long to run, it will break in the designer.

Note that this is typically caused by poor database design/indexing or terrible SQL query design. If historian queries, verify that you have indices on the data partitions.

2 Likes