Data manager help needed

[jkabir]

DM-DBM-3671 A bind error occurred on column 'EntityBudStdUnitCostAmt'; cannot convert the value SlBu to precision 23, scale 6.


this is the message I am getting everytime.
any help will be much appreciated.

[MFGF]

DM-DBM-3671 A bind error occurred on column 'EntityBudStdUnitCostAmt'; cannot convert the value SlBu to precision 23, scale 6.


this is the message I am getting everytime.
any help will be much appreciated.

Hi,

There's not much detail to go on here. I'm guessing this is in a Fact Build? What is the target? A relational table? What kinds of values are being loaded into the EntityBudStdUnitCostAmt element in the build? What is the data type of the target column you are trying to put this element into?

Cheers!

MF.

[jkabir]

Hi MF.
thank you for your time!
I'm guessing this is in a Fact Build?  yes FactBuild
What is the target? A relational table? Yes relational db table
What kinds of values are being loaded into the EntityBudStdUnitCostAmt element in the build? What is the data type of the target column you are trying to put this element into?---Numeric values

[MFGF]

Hi MF.
thank you for your time!
I'm guessing this is in a Fact Build?  yes FactBuild
What is the target? A relational table? Yes relational db table
What kinds of values are being loaded into the EntityBudStdUnitCostAmt element in the build? What is the data type of the target column you are trying to put this element into?---Numeric values

Are you sure the values in the element are numeric? Could a non-numeric value be in there, or a value that is too large for the target table column to accept?

Does this error occur immediately or does the build run for a while before you see the error?

I would try adding a calculated element to the build that writes the keys of the rows and the values in the element to the log file (using the logMsg function) so that you can see in the log exactly which row(s) and values are being processed. It might give you a better idea of what is happening?

Are you sure all your mappings are correct (data source -> data stream, data stream -> transformation elements, and transformation elements -> target table)?

MF.

[jkabir]

Greatly appreciated! God bless you.