Need help with Change Capture stage

mac4rfree85 · Post by **mac4rfree85** » Mon Apr 11, 2011 6:36 am

Hi Guys,

I have 2 tables. Source table and a Cross refrence table. I am trying to find the records present in Source table but not in Cross refrence table.

I am using Change capture stage. I have given Primary column as key field and based on the change code, i am getting the required information. (Actually i am trying to learn the Change Capture stage)

When i am running the job, i am getting the following error.

Code: Select all

main_program: Internal Error: (colDesc):orautils.C: 1859: getColDesc failed.
Traceback:   [6] APT_FatalPath::msgAssertion(0xfc656f53, 0xffbfc130, 0xfc656f5b, 0x743, 0x800, 0x2400), at 0xff0e6f08 
  [7] APT_OraUtils::querySchema(0x0, 0x2a85c8, 0x4, 0x40b994, 0xffbfc0c0, 0x743), at 0xfc5b758c 
  [8] APT_OraReadOperator::describeOperator(0x38f2a8, 0x0, 0xffbfc58c, 0xffbfc570, 0xffbfc5f4, 0x4), at 0xfc5893e0 
  [9] APT_OperatorRep::wrapDescribeOperator(0x40b988, 0x38f2ac, 0x1, 0xfee30abc, 0x0, 0xfedae5fc), at 0xfe7420cc 
  [10] APT_OperatorRep::check1a(0x40b988, 0xff1ba314, 0xfee30abc, 0xfee6f184, 0xfedae71f, 0x3000), at 0xfe74297c 
  [11] APT_StepRep::sequenceAndCheck1Operators(0x1, 0x0, 0x40b988, 0x404df8, 0xffbfcb70, 0xffbfcb4c), at 0xfe7bc93c 
  [12] APT_StepRep::check(0x24c6c8, 0x1, 0x1a400, 0x0, 0xfee6f124, 0x4800), at 0xfe7bbe1c 
  [13] APT_Step::check(0x277340, 0xffbfcf38, 0xffbfcf00, 0xffbfcf00, 0xffbfce7c, 0xfee30abc), at 0xfe7b11dc 
  [14] APT_OSL::createAndCheckStep(0x225228, 0xffbfdfec, 0xd4, 0x9, 0xffbfcf1c, 0xffbfcf38), at 0xff222908 
  [15] APT_ORCHESTRATE_main(0xffbfd57c, 0xffbfdab8, 0xffbfe07c, 0xffbfde50, 0xffbfe028, 0xffbfe044), at 0x1f954 
  [16] APT_PMconductorMain(0x0, 0xcc00, 0xff1b50c4, 0xfee30abc, 0xffbfe634, 0xffbfe650), at 0xfea1edec 
  [17] APT_SharedMain(0x11, 0xffbfe958, 0x17378, 0x11, 0x1, 0x17000), at 0xfea52038 
detaching from process 29493

Can somebody help me wiith this error

Cheers!!!!

chulett · Post by **chulett** » Mon Apr 11, 2011 6:49 am

An exact search for "getColDesc failed" returned 19 other matches, perhaps some of them can help.

mac4rfree85 · Post by **mac4rfree85** » Mon Apr 11, 2011 7:16 am

Actually my job is working fine till the Change capture stage. I verified it by writing it to flat file.

Now after the change capture stage, i am using a lookup stage to pull the remaining records from the source table based on the key field and change field.

Now it is failing giving that error.

I tried the search, but my target is just a flat file instead of the oracle table as mentioned in the other threads..

chulett · Post by **chulett** » Mon Apr 11, 2011 7:22 am

But your lookup is against an Oracle table and that's where your problem lies according to the errors.

mac4rfree85 · Post by **mac4rfree85** » Mon Apr 11, 2011 7:43 am

chulett,, sorry to be pesturing...

But when the job which ran successfully till change capture also had the same table.. but it didn had any problem there...

I am just tryin to understand the problem here..