Author Topic: Data manager help needed  (Read 4894 times)

Offline jkabir

  • Full Member
  • ***
  • Join Date: Aug 2019
  • Posts: 12
  • Forum Citizenship: +0/-0
Data manager help needed
« 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.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,864
  • Forum Citizenship: +647/-10
  • Cognos Software Muppet
Re: Data manager help needed
« Reply #1 on: 01 Oct 2019 01:40:27 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.
Meep!

Offline jkabir

  • Full Member
  • ***
  • Join Date: Aug 2019
  • Posts: 12
  • Forum Citizenship: +0/-0
Re: Data manager help needed
« Reply #2 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

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,864
  • Forum Citizenship: +647/-10
  • Cognos Software Muppet
Re: Data manager help needed
« Reply #3 on: 02 Oct 2019 07:16:59 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.
Meep!

Offline jkabir

  • Full Member
  • ***
  • Join Date: Aug 2019
  • Posts: 12
  • Forum Citizenship: +0/-0
Re: Data manager help needed
« Reply #4 on: 02 Oct 2019 09:05:31 am »
Greatly appreciated! God bless you.

 


       
Twittear