Failure during execution of operator logic

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sudhakar_viswa
Participant
Posts: 85
Joined: Fri Nov 18, 2005 5:35 am

Failure during execution of operator logic

Post by sudhakar_viswa »

Hi,

I am reading string value -300000000000.0000 from oracle9i and loading to oracle9i database. The target column datatype is number(38,10).

While loading this data i am getting following fatal error.

Failure during execution of operator logic.
APT_CombinedOperatorController,0: Internal Error: (byteValue < 100 && byteValue >= 0): decimal/decimal.f.C: 725
Traceback: [6] APT_FatalPath::pureAssertion(0xfed97376, 0xfed97398, 0x2d5, 0x49, 0xcd288, 0xc7f8), at 0xff0da700
[7] APT_Decimal::assignFromDFloat(0x9, 0xfffffffc, 0xb, 0xfee52f5c, 0x0, 0x40), at 0xfe88ba44
[8] APT_Decimal::operator=(0x113508, 0xc2517659, 0x2e000000, 0x0, 0x0, 0x70), at 0xfe88cefc
[9] APT_TransformOperatorImplV0S2_orctoorc_Transformer_2::processInputRecord(0x191010, 0x10f38c, 0x114c78, 0x191024, 0x0, 0x1), at 0xfccdbe2c
[10] APT_CombinedOperatorController::runLocally(0x18f348, 0xfee4afb4, 0x1928b0, 0xffffffff, 0x1, 0x0), at 0xfe6a3930
[11] APT_OperatorRep::run(0x18f388, 0x2, 0x18f348, 0x0, 0x18f348, 0xfee4b24c), at 0xfe70f624
[12] APT_SC::Operator::runLocally(0x196b90, 0x0, 0xfea42618, 0x1, 0x196bb0, 0x196bdc), at 0xfea42528
[13] APT_ProcessManager::executePlayer(0x14effc, 0x0, 0x17c00, 0x0, 0xffbfd028, 0xffbfd044), at 0xfea155f0
[14] executeStep(0xfee5e1a4, 0xfea0f054, 0xe1604, 0x4, 0x0, 0xfee5d3e8), at 0xfea12524
[15] APT_PMcontrolServiceTableClass::dispatch(0xb9e08, 0xbf768, 0xffbfd604, 0x437c30, 0x1d, 0xe8), at 0xfe9dbd1c

I am not understanding this one.

Thanks,
-- sudhakar
i need to know datastage
sanjay
Premium Member
Premium Member
Posts: 203
Joined: Fri Apr 23, 2004 2:22 am

Re: Failure during execution of operator logic

Post by sanjay »

Hi

If string value convert to decimal using function

Thanks
Sanjay
sudhakar_viswa wrote:Hi,

I am reading string value -300000000000.0000 from oracle9i and loading to oracle9i database. The target column datatype is number(38,10).

While loading this data i am getting following fatal error.

Failure during execution of operator logic.
APT_CombinedOperatorController,0: Internal Error: (byteValue < 100 && byteValue >= 0): decimal/decimal.f.C: 725
Traceback: [6] APT_FatalPath::pureAssertion(0xfed97376, 0xfed97398, 0x2d5, 0x49, 0xcd288, 0xc7f8), at 0xff0da700
[7] APT_Decimal::assignFromDFloat(0x9, 0xfffffffc, 0xb, 0xfee52f5c, 0x0, 0x40), at 0xfe88ba44
[8] APT_Decimal::operator=(0x113508, 0xc2517659, 0x2e000000, 0x0, 0x0, 0x70), at 0xfe88cefc
[9] APT_TransformOperatorImplV0S2_orctoorc_Transformer_2::processInputRecord(0x191010, 0x10f38c, 0x114c78, 0x191024, 0x0, 0x1), at 0xfccdbe2c
[10] APT_CombinedOperatorController::runLocally(0x18f348, 0xfee4afb4, 0x1928b0, 0xffffffff, 0x1, 0x0), at 0xfe6a3930
[11] APT_OperatorRep::run(0x18f388, 0x2, 0x18f348, 0x0, 0x18f348, 0xfee4b24c), at 0xfe70f624
[12] APT_SC::Operator::runLocally(0x196b90, 0x0, 0xfea42618, 0x1, 0x196bb0, 0x196bdc), at 0xfea42528
[13] APT_ProcessManager::executePlayer(0x14effc, 0x0, 0x17c00, 0x0, 0xffbfd028, 0xffbfd044), at 0xfea155f0
[14] executeStep(0xfee5e1a4, 0xfea0f054, 0xe1604, 0x4, 0x0, 0xfee5d3e8), at 0xfea12524
[15] APT_PMcontrolServiceTableClass::dispatch(0xb9e08, 0xbf768, 0xffbfd604, 0x437c30, 0x1d, 0xe8), at 0xfe9dbd1c

I am not understanding this one.

Thanks,
-- sudhakar
sudhakar_viswa
Participant
Posts: 85
Joined: Fri Nov 18, 2005 5:35 am

Post by sudhakar_viswa »

Hi Sanjay,

Thanks for your reply. Now, it is working by your idea.
I just want to know why it is giving for that number only(for those many digits), for other numbers it is working properly.


Thanks,
-- sudhakar
i need to know datastage
Post Reply