Forum Discussion

Jkaelin's avatar
Jkaelin
Resolver I
8 years ago
Solved

Error Message: Value Encoding Error - Data ID Range is too Large

Good afternoon,   *I searched for similiar posts but not much seems out there regarding this error, except that it could be something with underlying data.   *I run 8GB Ram, i7 processor, using p...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Jkaelin,

     

    I think this should related to query editor transform operations, have you enabled any advance transform operations in query editor?(combine, merge, append, refer other query, custom functions)
    BTW, I test to get data for excel table with hundreds of columns but can't reproduce your issue.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Jkaelin,

 

How many characters 'data id range' column stored? How many columns? Can you please provide more detail informations?

How to Get Your Question Answered Quickly

 

Regards,

Xiaoxin Sheng

Jkaelin's avatar
Jkaelin
Resolver I
8 years ago

Hi Anonymous,

 

I don't have a column labeled, "Data ID range".  I believe this is a microsoft error.  The table has 80 columns.  Sorry if I didn't initially provide enough information.  

 

I guess I'm asking if their is any source that explains errors so I know best where to troubleshoot?

 

Thank you,

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Jkaelin,

     

    I think this should related to query editor transform operations, have you enabled any advance transform operations in query editor?(combine, merge, append, refer other query, custom functions)
    BTW, I test to get data for excel table with hundreds of columns but can't reproduce your issue.

     

    Regards,

    Xiaoxin Sheng

    • Jkaelin's avatar
      Jkaelin
      Resolver I
      8 years ago

      Anonymous

       

      Thank you for your help.  After an extended period of testing, it appears some values have an extensive character length.  Although not resolved, I was able to pin-point the columns.  This thread helped me narrow down the troubleshooting.  Thank you.

      • AugustoRadames's avatar
        AugustoRadames
        Frequent Visitor
        6 years ago

        Hi Jkaelin ,

         

        I'm with the same problem as you were.

         

        Could you please tell me what did you do to find the value with an extensive character length?

         

        Thanks!