COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: jkabir on 01 Oct 2019 01:00:30 PM

Title: Data manager help needed
Post by: jkabir on 01 Oct 2019 01:00:30 PM

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.
Title: Re: Data manager help needed
Post by: MFGF on 01 Oct 2019 01:40:27 PM
Quote from: jkabir on 01 Oct 2019 01:00:30 PM
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.
Title: Re: Data manager help needed
Post by: jkabir on 02 Oct 2019 06:39:15 AM
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
Title: Re: Data manager help needed
Post by: MFGF on 02 Oct 2019 07:16:59 AM
Quote from: jkabir on 02 Oct 2019 06:39:15 AM
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.
Title: Re: Data manager help needed
Post by: jkabir on 02 Oct 2019 09:05:31 AM
Greatly appreciated! God bless you.