web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Numeric value out of r...
Microsoft Dynamics AX (Archived)

Numeric value out of range in Project actual transactions report

(0) ShareShare
ReportReport
Posted on by saman0suke 2,894

Hi, I'm receiving an error while running The Project actual transactions base AX report with no filters. The error is:

Numeric value out of range

I'm trying to Fix it by looking at The ProjListTransDP class which populates The ProjListTransTmp table and I'm sure one of The real values is getting a really large number, but who do I solve this in AX? In SQL i guess this could be solved by using a Bigint field but what about AX? Any idea? Besides this is a base report. I would apareciste your help on this matter.

Thanks!

*This post is locked for comments

I have the same question (0)
  • Hajish Profile Picture
    Hajish 460 on at

    Check the temp table field property.

  • saman0suke Profile Picture
    saman0suke 2,894 on at

    Change The property on The field? Which property exactly? Thanks!

  • Martin Dráb Profile Picture
    Martin Dráb 237,795 Most Valuable Professional on at

    Can you please find the exact place throwing the error? It's difficult to fix it if you don't know where it is.

  • saman0suke Profile Picture
    saman0suke 2,894 on at

    It's happening on The insertTmpTable method of The ProjListTransDP class. I'm almost sure that it's one of The real fields maybe SalesAmount, CostAmount or Margin. I can try to apply the same solution to all of them but I'm not sure what should I change to solve this, and it only fails when I run The report with no filters which means that I have to wait like 15 mins until it fails.

    I tried to add a try catch in that method to check The buffer of The table when it fails to check The fields but it does not catch it. Any idea? Thanks!

  • Martin Dráb Profile Picture
    Martin Dráb 237,795 Most Valuable Professional on at

    Well, I think that attaching debugger and running the class for 15 minutes is worth doing. You can do some other work in the meantime. Do you think that your alternatives to identify the exact place would take less time?

    By the way, the X++ equivalent of SQL bigint is int64.

  • saman0suke Profile Picture
    saman0suke 2,894 on at

    Well I did place a breakpoint in The catch line, but it did not hit it, i enclosed The whole insert process in The try statement without luck. Is there a limit for a real EDT to hold Numeric values? I could change it to int64 but The decimales in The value would be lost right? Thank you.

  • Martin Dráb Profile Picture
    Martin Dráb 237,795 Most Valuable Professional on at

    Integers, including bigint, are whole numbers. If you're talking about real numbers, then forget about bigint. That's a different type.

    The range of reals in X++ is up to 10127 with a precision of 16 significant digits, which should be more than enough for any practical use. I would have to connect to an AX 2012 environment to check how they're stored in database.

    If your first attempt to debug the code failed, try again. If you just give up, how do you expect to resolve the problem?

    Try a few things. Check if your catch isn't inside a transaction - it won't work if it is. Try a breakpoint in Info.add(). Try to use CIL debugger with catching first chance exceptions. Note that you can also use conditional breakpoints there. Use trace messages if you're unable to debug the code. Or use your own creativity to come up with something else.

  • saman0suke Profile Picture
    saman0suke 2,894 on at

    I've been trying more than once believe me. I will try your suggestions and come back with results. If there's another one it's more than welcome.

    Regards.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans