Automate

 View Only

  • 1.  No tasks

    Posted 10-31-2019 12:01
    Hi all,
    we are using Foundation UG, Version 11.2. Currently we have a problem with the workflow and the tasks.
    In detail: 
    No taks are visible / could not be displayd. SharePoint error message: The number of items in this list exceeds the list view threshold, which is 10000 items. Tasks that cause excessive server load (such as those involving all list items) are currently prohibited.
    Similar situation at the "DataFiles" library. (see attached pictures)

    Has anyone had the same experiences?

    THX, regards

    ------------------------------
    Rüdiger Weiss | Business IT - Application Manager
    Roche Diagnostics GmbH - Penzberg | +49 174 3280715
    ------------------------------


  • 2.  RE: No tasks

    Posted 11-01-2019 07:44
    Typically, when a query to SharePoint exceeds it's threshold value, it will deny the request unless the request is made from an administrative account. The Winshuttle web part ties together process information to the corresponding SharePoint item to display the task information. If it's getting denied, it may be causing an exception.

    However, bottom line is that that any query over 5k is going to potentially severely impact your farm's performance. It's actually a SQL limitation and the 5k limit is the default to prevent table locking when making a query. If a table is locked, SQL will perform no further queries until the locking query finishes, creating a bottleneck. The best avenue would be to target your large lists and perform archiving to move out old completed items to a different archive list.

    ------------------------------
    Joshua Whitener | Technical Advisor
    Exxon Mobil Corporation | 8326258441
    ------------------------------

    Original Message


  • 3.  RE: No tasks

    Posted 12-02-2020 05:43
    Hi, Joshua,
    you had already answered my inquiry almost two years ago, see the posts above.
    Currently we have a problem with the display of task lists on the same platform. Standard users get an error message (see screenshot) or lists were not displayed. When I log on as administrator, I can access the list or entry. Our SharePoint team says that the administrator has a higher limit of 20,000 items and therefore does not get an error message.

    But the actual value is still well below 10,000 items. Nevertheless the error message appears. Is there possibly another tasklist, which is not displayed but is counted as one of them?
    Unfortunately the SharePoint team has not found a way to clean up or empty the task list. Do you have any idea how to solve the problem?
    Thanks a lot

    Best regards, Ruediger

    ------------------------------
    Rüdiger Weiss | Business Application Manager
    Roche Diagnostics GmbH - Penzberg | 08856606008
    ------------------------------

    Original Message


  • 4.  RE: No tasks

    Posted 12-02-2020 08:03
    I believe SharePoint task lists utilize the hidden SharePoint workflow history list and if that list exceeds the threshold, lists that rely on it will also fail. Normally, SharePoint has a timer job that performs auto-cleanup on those history lists removing items that are 60? days old. However, if you create enough tasks fast enough, it can exceed that threshold before 60 days.

    I saw a few times a long time ago and unfortunately, I don't remember the solution. It will revolve around cleaning up that history list manually, maybe through PowerShell.

    ------------------------------
    Joshua Whitener | Technical Advisor
    Exxon Mobil Corporation | 8326258441
    ------------------------------

    Original Message


  • 5.  RE: No tasks

    Posted 12-02-2020 08:21
    On any SharePoint page on that site with the issue, do the following:

    1. Press F12 to get the dev tools in the browser.
    2. In the console tab, paste in the below and hit enter.

    function getHistory() {
        var results;
        var connection = new XMLHttpRequest();
        connection.open("GET", _spPageContextInfo.webAbsoluteUrl + "/_api/lists/getbytitle('central workflow history')/items?&$top=24999");
        connection.setRequestHeader("accept", "application/json; odata=verbose");
        connection.send();
        connection.onload = function () {
            results = JSON.parse(connection.response);
            console.log(results);
        }
    }

    Then type getHistory(), after a bit you'll see a response in the console window, looks like {d: {}}. Expand this object and you'll see a count, I've bolded it. That's how many items are in your history list. You can confirm the count that way, since the the list is hidden.
    1. {d: {…}}

    Note, in the above function central workflow history is the default list Winshuttle uses for task history. If you've changed it, you will need to look at the workflow settings in the query or transaction script libraries to see where the history is actually being written.

    That's also one way to help prevent this in the future is by using different history lists for different workflows, like one history list for transaction workflows and one for query workflows and another for data file workflows.

    ------------------------------
    Joshua Whitener | Technical Advisor
    Exxon Mobil Corporation | 8326258441
    ------------------------------

    Original Message