Skip to main content
Solved

ODX error the numerical value is too large to fit into a 96 bit decimal


christian.koeken
Contributor
Forum|alt.badge.img

Dear Support,

I'm running into a weird error when I try to load customer data from the customer table of Navision. 

The error is: The numerical value is too large to fit into a 96 bit decimal.

I use a query table to only get the columns I need. In this query table I use a where clause in which I exclude some customernumbers. But now I found out that I also need these numbers in my customer dimension. But when I clear the WHERE clause, the error comes up again.

If I execute the same query in SQL Management studio it runs good and I don't see some strange values in one of the columns.

Do you have any idea?

Best answer by G-T

In limited situations i have seen it where the source and target regional settings (specifically the decimal separator) are not the same, sometimes 300.2345743225 can become 3002345743225. If the ‘where’ clause is used to exclude some customer numbers as per Thomas’s idea, this will help you to get just those numbers you were excluding at first. Then it should be possible to do a try_cast() to the expected target type to see which fails.

View original
Did this topic help you find an answer to your question?

3 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1070 replies
  • March 28, 2023

Hi Christian

Do you have the source data type and the BU data type available and are they the same?

Could you try to make a specific query that reverses the where clause to get the specific rows that gives issues. You can use management studio to do this.

It would be a specific field that contains this value that is somehow too large.


Forum|alt.badge.img
  • Starter
  • 1 reply
  • Answer
  • March 28, 2023

In limited situations i have seen it where the source and target regional settings (specifically the decimal separator) are not the same, sometimes 300.2345743225 can become 3002345743225. If the ‘where’ clause is used to exclude some customer numbers as per Thomas’s idea, this will help you to get just those numbers you were excluding at first. Then it should be possible to do a try_cast() to the expected target type to see which fails.


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @christian.koeken did the above answers manage to resolve the issue? If so please help us by marking a best answer. Or let us know if you have any follow up questions


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings