Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Users Missing from Dashboard Reports

    Posted 06-15-2020 10:54
    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!

    Dev Reports Dashboard Users

    Prod Reports Dashboard Users


    ------------------------------
    Vanessa Kutasi | Application Analyst II
    IDEXX | New England WUG Leader
    ------------------------------


  • 2.  RE: Users Missing from Dashboard Reports

    Employee
    Posted 06-15-2020 19:16
    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

    Hope that helps a little.  For a better answer, I'd open a support ticket to see if you can get some help.  

    Best Regards,
    Sigrid


    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------



  • 3.  RE: Users Missing from Dashboard Reports

    Posted 06-16-2020 08:52

    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]

     




    Original Message


  • 4.  RE: Users Missing from Dashboard Reports

    Employee
    Posted 06-16-2020 09:24
    Hi Vanessa

    The tables will have usage data in them.  I pointed to them so that you could try to see if those users that you say are missing were in it or not.  That would be helpful in debugging this issue.

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 5.  RE: Users Missing from Dashboard Reports

    Posted 06-16-2020 11:50

    Hi Sigrid,

    I understand now, thank you! There are not any users showing up in production, whereas ALL users show up in development. Even if I enter a user name (such as my own), it says the user doesn't exist. It's odd that I can see it by user, but cannot search by user. The DB team doesn't see any issues, so have kicked it over to the SharePoint team. If they come up blank, I'll submit a ticket.

     

    Thank you,

     

    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]

     




    Original Message


  • 6.  RE: Users Missing from Dashboard Reports

    Employee
    Posted 06-16-2020 11:53
    Hi Vanessa - that is strange.  I wonder if there is an Active Directory change on production, perhaps it's not in sync?  Just another random thought.  I think you have a good plan.
    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 7.  RE: Users Missing from Dashboard Reports

    Posted 06-17-2020 08:53
    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
    610-781-1199 (Home Office/Cell) | jack.mcgarry@airgas.com 
    Find it with us, anytime, anywhere at Airgas.com




    Original Message


  • 8.  RE: Users Missing from Dashboard Reports

    Posted 08-24-2020 15:18
    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