Hi,
My job is like this
If the problem is with the decimal fields then
I have 2 fields which are coming in as (char) and field length 10
and I am converting it as Decimal in the transformer with the fallowing function and field legths as Decimal(18,4)
StringToDecimal(lnktest.field)
I have created this job couple of days back so far it's running good
but now when I run it it is throughing the fallowing error
APT_CombinedOperatorController(4),1: Fatal Error: APT_Decimal::asInteger: the decimal value is out of range for the integer result.
lkpname,1: sendWriteSignal() failed on node etldev ds = 20 conspart = 1 Broken pipe
lkpname,1: sendWriteSignal() failed on node etldev ds = 21 conspart = 1 Broken pipe
If anybody has any idea on this
My guess is it's data problem.
Thanks
APT_Decimal::asInteger: the decimal value is out of range
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Almost certainly, and it happened to occur on the second node in your configuration file.
Disable operator combination (set APT_DISABLE_COMBINATION) and re-run to determine in precisely which stage the error is being generated.
Disable operator combination (set APT_DISABLE_COMBINATION) and re-run to determine in precisely which stage the error is being generated.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Somewhere you are doing an AsInteger() function.
Not every 10-digit number can successfully be stored in an integer - the largest permissible int32 is 2147483647. It is the fact that you are being warned about.
Not every 10-digit number can successfully be stored in an integer - the largest permissible int32 is 2147483647. It is the fact that you are being warned about.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: