After 2 months, we have resolution! It took a bit of SharePoint web app. manipulation, but it worked. All of my reports are now able to be done by specified usernames. Below is a snipit of their thought process which lead to the resolution. Maybe it will help others.
8. On looking into NewtonSoft documentation, We found out that the value of default maxJSONLength could be 102400.
9. We then looked for ways to override the default value.
10. Finally added
the below tag in the SharePoint Web Application's Web.Config:
<configuration>
<system.web.extensions>
<scripting>
<webServices>
<jsonSerialization maxJsonLength="50000000"/>
</webServices>
</scripting>
</system.web.extensions>
</configuration>
------------------------------
Vanessa Kutasi | Application Analyst II
IDEXX | New England WUG Leader
------------------------------
Original Message:
Sent: 06-17-2020 08:51
From: Jack McGarry
Subject: Users Missing from Dashboard Reports
We had an issue with these reports. The guidance we got was the usage data is not written to the Winshuttle database until the next time the user logs into Winshuttle. Even then, not all of the data seems to make it. We gave up on them being 100% reliable.
Note: I will be on vacation June 19 through June 28.
Thank you,
Jack McGarry | Sr. Business Systems Analyst – SAP Finance | Airgas, an Air Liquide company
Find it with us, anytime, anywhere at Airgas.com
Original Message:
Sent: 6/16/2020 8:52:00 AM
From: Vanessa Kutasi
Subject: RE: Users Missing from Dashboard Reports
Hi Sigrid,
I do have access to the license database in both development & production. I checked production and both the query and transaction tables are functioning, pulling in data as recently as this morning. I am going to check with my internal database team to make sure there isn't something going on on our end. After that, if needed, I will submit a ticket to support.
Thank you for your guidance as to where to start!
Vanessa Kutasi | Application Analyst II, Operations Systems | IDEXX
One IDEXX Drive | Westbrook, ME 04092
o/f. 207.556.5197 | m. 207.208.6887 | email: Vanessa-Kutasi@IDEXX.com
![B_G_R_Y[1]](https://higherlogicdownload.s3.amazonaws.com/PRECISELY/WinshuttleImages/3da5c38a138d440c9e5c637b541e1d0e_ca374f1ae071412d9017b6dd0c07342c.png)
Original Message:
Sent: 6/15/2020 7:16:00 PM
From: Sigrid Kok
Subject: RE: Users Missing from Dashboard Reports
Hi Vanessa
Am not really sure, as I don't know the underlying query that is running. Is it possible that user never had a license and/or didn't run anything on the site? Or that they data related to that user has been archived? That's my best guess. We've had people come and go from our demo site, and they're all listed in the dropdown you have in your picture.
I know where the underlying tables are, if you want to check those and run a SQL query. It's in the Licensing database, which you'd have to be granted permission to see, as that's not the default. Tables: TransactionLog and QueryLog
------------------------------
Sigrid Kok
PSE | Winshuttle NA
Original Message:
Sent: 06-15-2020 10:53
From: Vanessa Kutasi
Subject: Users Missing from Dashboard Reports
Hi Friends,
In Foundation 12.1, dashboard reports, production, when I choose Users, the users box is not populating. When I do this same thing in development, users populate for me to choose from. I have dug around in site settings, role permissions (I have ALL roles due to being an admin), support site, docs.winshuttle.com and I just cannot figure out what is different. My guess is that there is a setting on the SharePoint server that needs adjusting. I do not have access to the SharePoint servers in production so cannot validate, however I can reach out to that admin. I do have dev SharePoint admin permissions if there is anything I need to check there.
Any suggestions as to why there is a difference? Am I on the right path thinking that it is a SharePoint server setting?
As always, thank you!
------------------------------
Vanessa Kutasi | Application Analyst II
IDEXX | New England WUG Leader
------------------------------