How To Fix DB274 - Lower limit of interval is greater than upper limit


DB274 - Overview

  • Message type: E = Error

  • Message class: DB - Messages for logical databases and background processing

  • Message number: 274

  • Message text: Lower limit of interval is greater than upper limit

  • Show details Hide details
  • What causes this issue?

    You attempted to save a variable date calculation for the range
    (current date - x days, current date + y days) in a variant. However,
    the parameters x and y that you have entered return a range where the
    lower limit is greater than the upper limit. You have probably
    specified a too large a negative value for the parameter x.

    System Response

    Processing terminated.

    How to fix this error?

    Correct your input.

    Error message extract from SAP system. Copyright SAP SE.


Smart SAP Assistant

  • What is the cause and solution for SAP error message DB274 - Lower limit of interval is greater than upper limit ?
    The SAP error message DB274 "Lower limit of interval is greater than upper limit" typically occurs in the context of database operations, particularly when dealing with ranges or intervals in queries or data processing. This error indicates that there is a logical inconsistency in the specified range, where the starting point (lower limit) is greater than the endpoint (upper limit).
    
    Cause: Incorrect Query Parameters: The error often arises from a SQL query or a data selection operation where the parameters for a range are incorrectly defined. Data Input Errors: User input or programmatic input that defines a range may have been incorrectly set, leading to a situation where the lower limit exceeds the upper limit.
    Configuration Issues: In some cases, configuration settings in the database or application may lead to this inconsistency.
    Solution: Review SQL Queries: Check the SQL queries or data selection logic to ensure that the lower limit is indeed less than or equal

    Already have an account? Login here!




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


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
The AI Support Assistant is great. It provides comprehensive assistance even on the most difficult issues. I highly recommend this service.
Rate 1
John Jordan
SAP Consultant & Author