Forum Discussion

Tomcat3's avatar
Tomcat3
Helper I
3 years ago

Error message for ML model - unexplained NaN failure

I have no idea what this means. I am running a very simple Regression Model. This seems like an internal error rather than a design or data error. Any suggestions on how to dig deeper? I tried to check the report, but that fails too. No explanation.

 

Expression.Error: The number is out of range of a decimal value.. <ccon>NaN. </ccon>;The number is out of range of a decimal value.. The exception was raised by the IDbCommand interface. Table: IterationDetailsMa

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Tomcat3 ,

     

    As the error message states, you can find a solution by editing the query. Go into the table if you can identify it and remove all errors.

    Please check that the privacy settings for each data source in the dataflow are inconsistent, and try to switch all data source credentials to Organization.

    You can refer to the following documents that may be helpful to you:

    decimal and numeric (Transact-SQL) - SQL Server | Microsoft Learn

    mysql - Numeric value out of range for decimal data type? - Stack Overflow

    Out of Range Error When Updating A Decimal Value (microsoft.com)

     

    Best Regards,

    Neeko Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Tomcat3 ,

     

    Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.

     

    Best Regards,

    Neeko Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.