Sharepoint List Threshold Limit Causing the sharepoint designer workflow to Suspend

One of the task lists which was used in designer workflow reached the threshold limit and because of which the workflows are suspending with the below error.

RequestorId: f307e5c6-0c50-b022-0000-000000000000. Details: An unhandled exception occurred during the execution of the workflow instance. Exception details: System.ApplicationException: HTTP 500 {“error”:{“code”:”-2147024860, Microsoft.SharePoint.SPQueryThrottledException”,”message”:{“lang”:”en-US”,”value”:”The attempted operation is prohibited because it exceeds the list view threshold.”}}}

There is a line in the workflow where it fetches the assignedTo field with taskname filter condition and the same exact line is throwing the above error.

Can someone please suggest to me how to overcome this error without increasing the threshold limit because the list can hold upto 30 million items as Microsoft document.

accessibility – Why do many prominent web apps use blue primary button with white text, when it fails the WCAG 2.1 contrast threshold

Accessibility modes are likely the reason. Twitter has a high-contrast mode for users who need it:

The accessibility setting of the web app now has a new “increase color
contrast” toggle button. The button once turned on, activates the high
contrast colors for UI elements. The high contrast mode makes it
easier for people with visual impairments to use the Twitter Web app.

Outlook’s desktop app adopts the operating system’s higher-contrast settings when activated.

Mac OS setting to increase contrast

Outlook – regular contrast mode

Outlook - regular contrast

Outlook – increase contrast mode

Outlook - high contrast mode

Unsure why Figma has a lower-contrast button – it doesn’t seem to be modal.

taproot – What is the point of miner signaling in a soft fork activation mechanism? What should the threshold be on miner signaling?

What is the point of miner signaling in a soft fork activation mechanism?

Miners are signaling readiness for a soft fork activation, they are not signaling to support (or vote for) a soft fork. It seems generally accepted at the time of writing (February 2021) that any opposition towards a soft fork should be raised and discussed before an activation mechanism is proposed. If arguments are raised that haven’t previously been considered or that opposition is material and sustained across the wider community, activation for that soft fork shouldn’t be considered.

Ideally you want as many miners enforcing the Taproot rules at the point it activates as possible. Otherwise an invalid Taproot spend could creep into a block and some miners wouldn’t reject it as they would be treating it as an anyone-can-spend. It would need a small, naturally occurring re-org to get that invalid Taproot spend out of the blockchain. This wouldn’t be a disaster but ideally you don’t want a greater frequency or greater magnitude of re-orgs than usually occur. Ideally you want all miners enforcing the Taproot rules from the point of activation.

As devrandom pointed out on IRC there is motivation for presumably unready miners who haven’t yet signaled to get ready urgently if the soft fork is activating soon. They don’t want to expend resources mining blocks (with an invalid Taproot spend in them) that will ultimately be rejected by a proportion of the network. But that doesn’t guarantee they will be ready and may lead to miners rushing to get ready for activation which again is not optimal.

There is also the consideration of miners deliberately or inadvertently producing blocks with invalid Taproot spends in them fooling SPV/non-upgraded clients that is discussed here.

What should the threshold be on miner signaling?

This is harder to answer as the threshold chosen appears to be a trade-off between ensuring as many miners are ready to activate the soft fork as possible and preventing a small minority of miners from unnecessarily delaying the soft fork for political or strategic reasons. With the SegWit soft fork in 2017, a BIP 148 user activated soft fork needed to be proposed because miners were assessed to be deliberately blocking activation to attempt to force through an additional block size increase.

In this developer survey conducted by AJ Towns the question “What do you consider a reasonable threshold for activation by hashpower supermajority?” it appears 90 percent or 95 percent would be the preferred threshold. The threshold for the SegWit activation was set initially at 95 percent.

c++ – Calling a function once a threshold is met

I’m currently writing an API for our codebase that allows us to use an Arduino Leonardo for our tests. This code is uploaded to the Arduino, and we read through the analog for work.

As stated in the docstring, this function calls a passed function once a threshold has been met. However, I need there to be a delay between function calls, as signals read from the analog can fluctuate and cause the callback function to be called more than expected. So, I devised a solution that requires the signals to depreciate 1/10 of the threshold value in order for callback to be executed again. The secondFactor is if the user wants to define their own limit of when they want the function to be called again. For example:

NeuroBoard board;
board.setTriggerOnEvenlope(700, Serial.println("Reached!");

This executes the statement once 700 is reached. Then once 630 is reached (700 - (700 x .10)), it set a boolean flag so that once 700 is reached again, it will be called. For another example:

NeuroBoard board;
board.setTriggerOnEnvelope(700, Serial.println("Reached!"), 500);

Same as above, however the boolean flag will only be set once the signals reach 500.

I hope I’ve explained everything so that it’s easily understandable. If anything is unclear, please leave a comment and I’ll address it! Below is the code:

NeuroBoard.hpp (code omitted for brevity)

class NeuroBoard {

    private:
        bool thresholdMet = false;

    public:
        /**
         * Calls the passed function when the envelope value is greater 
         * than the passed threshold.
         * 
         * @param threshold Threshold for envelope value.
         * @param callback Function to call when threshold is reached.
         * @param secondFactor Optional parameter for the second threshold the data must pass.
         * 
         * @return void.
        **/
        void setTriggerOnEnvelope(const unsigned int& threshold, void callback(), const unsigned int& secondFactor=0);
}

NeuroBoard.cpp (code omitted for brevity)

The ISR is basically a timer that runs on the Arduino. I’ve configured it so every second I get about ~50,000 readings from the analog per second. The envelopeValue is the highest reading recorded, then subtracted by one every time a reading isn’t equal to or greater than it.

int envelopeValue;

ISR (TIMER1_COMPA_vect) {
    int reading = analogRead(channel);
    envelopeValue = (reading >= envelopeValue) ? reading : envelopeValue - 1;
}

void NeuroBoard::setTriggerOnEnvelope(const unsigned int& threshold, void callback(), const unsigned int& secondFactor=0) {

    // TODO: Call callback when passed threshold is met by envelope value.

    const int THRESHOLD_SCALE_FACTOR = threshold / 10;
    int secondThreshold = secondFactor;

    if (secondFactor == 0) {
        secondThreshold = threshold - THRESHOLD_SCALE_FACTOR;
    }

    if (envelopeValue >= threshold) {
        if (!this->thresholdMet) {
            this->thresholdMet = true;
            callback();
        }
    } else {
        if (envelopeValue <= secondThreshold) {
            this->thresholdMet = false;
        }
    }

}

Note: Because this code is for an Arduino, I cannot use any standard library functions or imports. However, because this section of our code is pure c++, I don’t think it will be an issue. But please consider that if you decide to write an answer. Thanks!

office 365 – Sharepoint online list view threshold reached on execution of a caml query

I am having a hard time understanding how a caml query fetches data from a SPO list.
Currently, i have set up a client context on an CSOM console application and i am trying to upload a csv file onto a SPOList.
The requirements of the project is that i check wether the entry has already passed, in which case i simply delete and insert the new entry, based on a FilenetID hex code.
I get the error “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.” right at the moment that a CamlQuery is initialised, loaded on the client context and executed.
Setting up a Logging action showed me that the error above started displayig once the limit 5k list items was reached and at the moment i cannot insert any more new entries.
My CamlQuery is the below:

CamlQuery query = new CamlQuery
            {
                ViewXml = String.Format("@<View><Query><Where><Eq><FieldRef Name="FilenetID" />" +
            "<Value Type="Text">{0}</Value></Eq></Where></Query><RowLimit>10</RowLimit></View>", filenetID)
            };
var existingMappings = SpList.GetItems(query);
ClientContext.Load(existingMappings);
ClientContext.ExecuteQuery();
return existingMappings.FirstOrDefault();

The entries based on the FilenetID are unique, meaning that the CamlQuery above must return only one row.
I even tried to set the RowLimit attribute but still i get the same error.
My next step will be to index the column in question, but i would like to ask a question so that the community could please clarify upon the subject so that i could grasp a better understanding.
Have you guys faced any of the above problems?

SharePoint 5000 List View Threshold Limit Issue in CSOM

I have an issue with Sharepoint CSOM when I am trying to get subfolder with the following code

public void LoadFolders(Folder folder, SharePointFolder sharePointFolder)
{
  Context.Load(folder.Folders);
  Context.ExecuteQuery();

  foreach (var subFolder in folder.Folders)
  {
    var subRootFolder = new SharePointFolder(sharePointFolder, subFolder);
    sharePointFolder.SubFolders.Add(subRootFolder);
  }
}

I get the error below when trying to load subfolders of a folder that has an itemCount of more than 5000.

Microsoft.SharePoint.Client.ServerException
  HResult=0x80131500
  Message=The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.
  Source=Microsoft.SharePoint.Client.Runtime
  StackTrace:
   at Microsoft.SharePoint.Client.ClientRequest.ProcessResponseStream(Stream responseStream)
   at Microsoft.SharePoint.Client.ClientRequest.ProcessResponse()
   at Microsoft.SharePoint.Client.ClientRequest.ExecuteQueryToServer(ChunkStringBuilder sb)
   at Microsoft.SharePoint.Client.ClientContext.ExecuteQuery()
   at ..SharePointApi.SharepointSdkAccessMethod.LoadFolders(Folder folder, SharePointFolder sharePointFolder) in ....SharePointApiSharepointSdkAccessMethod.cs:line 435
   at ..SharePoint.ViewModels.SharePointFoldersViewModel.<>c__DisplayClass30_0.<GetFolderAsync>b__0() in ....ViewModelsSharePointFoldersViewModel.cs:line 183
   at System.Threading.Tasks.Task.InnerInvoke()
   at System.Threading.Tasks.Task.Execute()

Is there a way to resolve this issue or a CamlQuery that can give the same result as my function above?

2010 – List view threshold – Why is querying with key filters still possible without having an indexed field

I read a lot about the list view threshold topic, so I know, that it should not be increased, if you have large list. In short, as far as I read, it is recommended to create an index on a column and filter the view to this index.
We have currently the issue, that we are using multiple managed metadata fields and values to narrow down the list, but it is not possible to create an index on a managed metadata field, where multiple entries are allowed.
So our CAML query fails, if the list has more entries than specified in the list view threshold value (and because we are not querying a field with an index).

See these links for more info:

https://www.codeproject.com/Articles/1076854/Overcoming-the-List-View-Threshold-in-SharePoint-C

https://social.technet.microsoft.com/Forums/Lync/en-US/a4c28a29-a127-43da-8f33-23e77fbc7188/list-view-threshold-and-managed-metadata-fields-with-multiple-values?forum=sharepointgeneralprevious

But my question is now, why is it still possible to use the key filters in the library itself?
So there must be a way to query the list with managed metadata fields even when the threshold is exceeded and there is no index created.

enter image description here

Does anybody know, how the key filters work in the library?
Many thanks in advance!

linux – Multi user full disk encryption – larger than 8 user threshold. i.e. Not luks

I know Luks has a maximum of 8 I need something that does what LUKS does but allows multiple keys more than the maximum of 8.

All users will need to be able to access root.
It will be used regularly by multiple different users but not simultaneously.

I have looked at loads of different encryption tools but they do not seem to have any multi user system that does what I need, unless I’ve glossed over something.

magento2 – How to use the Out-of-Stock threshold option?

You can use a negative amount in order to have more salable items than you really have in stock.

Out-of-Stock threshold

Use a negative value for this threshold to set the maximum amount of products that can be backordered before the product is truly considered out of stock. This amount adds to the salable quantity. The value set at the product level overrides any value set at the global level.

The formula for the Salable Quantity is (Quantity – (Out-of-Stock Threshold)).

The following is an example:

Quantity: 25
Notify for Quantity Below: 10
Only X left Threshold: 5
Out of Stock Threshold: -50

The Salable Quantity for this product is 75 (25 – (-50)).

Magento 2 The Salable Quantity
Example Salable Quantity before backorders enabled

Magento 2 The Salable Quantity
Example Salable Quantity after backorders enabled

When customers purchase more than 25 products, new orders enter as backorders. As the product’s Salable Quantity reduces to 5 (70 items have been sold), the Product page will display a message Only 5 left on the storefront. When the Salable Quantity reaches 0, the product is displayed as Out of Stock in the storefront.

Reference: Magento 2 DevDocs – Out-of-Stock threshold

Can I defer levelling up after reaching the XP threshold?

As a rogue, I’ve gained enough XP to level up to level 3. However, I’m not yet ready to pick what archetype would fit best for me.

Despite having gained enough XP, can I wait until later to level up my character?

I’m looking for rules to back me up, especially if it explicitly states that I don’t need to level up immediately upon acquiring the XP threshold.