How To Fix QG812 - The selection is limited to &1 inspection lots


QG812 - Overview

  • Message type: E = Error

  • Message class: QG - QM: Evaluation of inspection results

  • Message number: 812

  • Message text: The selection is limited to &1 inspection lots

  • Show details Hide details
  • What causes this issue?

    The selection of data was terminated after &v1& inspection lots, to
    limit the system runtime.
    The displayed data only includes the inspection lots that were selected
    up to this point; the list is therefore <ZH>incomplete</>.
    &REASON&
    The number of inspection lots to be selected from the database was
    limited to &v1& inspection lots.
    The system terminated the selection, because a greater number of
    inspection lots meet your selection criteria.
    Note that, based on the report processing, the list only contains a
    partial selection of inspection lots.

    How to fix this error?

    If the data you are searching for is included in the list, you can
    continue your processing activities normally.
    To make sure that the system finds all inspection lots that correspond
    to your selection criteria, you should limit your selection further
    (for example, by specifying a shorter time range, a plant, or an
    inspection lot origin).
    You can increase the number of inspection lots to be read, however,
    this can reduce the system performance considerably.
    You can use the function for <LS>user variants</> to define the
    selection criteria that is used repeatedly by a user.

    Procedure for System Administrators

    The system issues an error message and will not allow you to continue with this transaction until the error is resolved.


    Error message extract from SAP system. Copyright SAP SE.


QG812 - Details

  • The SAP error message QG812, which states "The selection is limited to &1 inspection lots," typically occurs in the context of Quality Management (QM) when you are trying to process or display inspection lots, but the system has restricted the selection to a certain number of lots.
    
    Cause: Selection Criteria: The selection criteria you have used may be too restrictive, leading to a limited number of inspection lots being available for processing. System Configuration: There may be system settings or configurations that limit the number of inspection lots that can be displayed or processed at one time. User Authorizations: The user may not have the necessary authorizations to view or process more than a certain number of inspection lots. Performance Optimization: SAP may limit the number of records returned to optimize performance, especially in large datasets.
    Solution: Review Selection Criteria: Check the selection criteria you are using to ensure they are not overly restrictive. Adjust the parameters

    Already have an account? Login here!




Instant HelpGet instant SAP help. Sign up for our Free Essentials Plan.


QG812 - Related SAP Errors

Click on this link to search all SAP messages.


Rating
ERPlingo simplifies finding the accurate answers to SAP message errors. I now use every week. A must have tool for anyone working with SAP! Highly recommended!
Rate 1
Kent Bettisworth
Executive SAP Consultant