cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Random error Cannot convert data <.> into type <DECIMAL>. Context: Column <>

arndtir_ec
Newcomer
0 Likes
600

We are using SAP BODS on  an Oracle database. From time to time the same dataflow aborts with the error Cannot convert data <.> into type <DECIMAL>. Context: Column <>  . Without specification which data or column is affected.

All mappings on decimal fields  in this dataflow are from decimal to decimal or from decimal to integer. All decimals are of the form decimal(n,0) .  The underlying Oracle columns are number(38,0). The same dataflow is successful when executed  a bit later but on presumably the same data -no transformations are run on this data between abortion and new run.  The error message provides the name of  the transform which fails and references some Join48 which is probably  some execution step of the transform. But we are not able to exactly localize the causing issue.  Is there a way to find the  information, what object the Join48 is referring to?

Accepted Solutions (0)

Answers (0)