TI Error: Cannot convert field number 9

I was working on a new TI process today and got this error – “Cannot convert field number 9, value “*textdata*” to a real number”.

Odd, I thought. Cryptic error – cannot convert field number 9! I initially thought it might concern field number 9 in my source data.  Nope.  No cigar!

What this is saying is that there is a field on the Variables tab has been defined as numeric when it should have been string.

To resolve the error “Cannot convert field number 9, value “*textdata*” to a real number”, go define the offending field (not field number 9!) as String on the Variables tab in your Turbo Integrator process and viola!

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.
This entry was posted in Errors, TI Errors. Bookmark the permalink.