Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Invalid range value in AOT Query

(0) ShareShare
ReportReport
Posted on by 2,032

Hi ,

I have a weird issue using AOT query range. 

 

Below query lists the sales orders which are not cancelled. If you see the range value below, it is misspelled as ''Cancelled' instead of 'Canceled' .

pastedimage1676567246031v1.png

The query is fetching cancelled sales orders as well in dev and UAT environments , but not in Prod .

On debugging in Dev, it is assigning 255 for the above range value (as the value cancelled doesn`t exist in the system) and it proceeds to fetch the cancelled sales orders.

Why is the behavior different in prod ?

pastedimage1676567180776v3.png

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at
    RE: Invalid range value in AOT Query

    Hi Anitha,

    I'm not able to answer why something would be different in your production environment. Is the code base exactly the same? As this seem to be related to a customization, I can't verify this in a standard environment.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans