help with this Orchestrate error

[mac4rfree85]

Hi Guys,

I imported the metadata using the Plugin and used that metadata in my Oracle enterprise stage. The Credentials are all fine.
When i tried to view data, i am getting the following error.

Code: Select all

##F IIS-DSEE-TUXX-00002 04:00:51(000) <main_program> Internal Error: (colDesc):orautils.C: 1859: getColDesc failed.

Internal Error: (colDesc):orautils.C: 1859: getColDesc failed.
>Traceback:   [6] APT_FatalPath::msgAssertion(0xfc656f53, 0xffbfb6e0, 0xfc656f5b, 0x743, 0x800, 0x2400), at 0xff0e6f08 
>  [7] APT_OraUtils::querySchema(0x0, 0x301288, 0x4, 0x1ce714, 0xffbfb670, 0x743), at 0xfc5b758c 
>  [8] APT_OraReadOperator::describeOperator(0x7b348, 0x0, 0xffbfbb3c, 0xffbfbb20, 0xffbfbba4, 0x4), at 0xfc5893e0 
>  [9] APT_OperatorRep::wrapDescribeOperator(0x1ce708, 0x7b34c, 0x1, 0xfee30abc, 0x0, 0xfedae5fc), at 0xfe7420cc 
>  [10] APT_OperatorRep::check1a(0x1ce708, 0xff1ba314, 0xfee30abc, 0xfee6f184, 0xfedae71f, 0x3000), at 0xfe74297c 
>  [11] APT_StepRep::sequenceAndCheck1Operators(0x1, 0x0, 0x1ce708, 0x5800c8, 0xffbfc120, 0xffbfc0fc), at 0xfe7bc93c 
>  [12] APT_StepRep::check(0x3ed988, 0x1, 0x1a400, 0x0, 0xfee6f124, 0x4800), at 0xfe7bbe1c 
>  [13] APT_Step::check(0x3ef568, 0xffbfc4e8, 0xffbfc4b0, 0xffbfc4b0, 0xffbfc42c, 0xfee30abc), at 0xfe7b11dc 
>  [14] APT_OSL::createAndCheckStep(0x349548, 0xffbfd59c, 0xc1d48, 0x1, 0xffbfc4cc, 0xffbfc4e8), at 0xff222908 
>  [15] APT_ORCHESTRATE_main(0xffbfcb2c, 0xffbfd068, 0xffbfd62c, 0xffbfd400, 0xffbfd5d8, 0xffbfd5f4), at 0x1f954 
>  [16] APT_PMconductorMain(0x0, 0xcc00, 0xff1b50c4, 0xfee30abc, 0xffbfdbe4, 0xffbfdc00), at 0xfea1edec 
>  [17] APT_SharedMain(0x10, 0xffbfdf04, 0x17378, 0x10, 0x1, 0x17000), at 0xfea52038 
>detaching from process 7460

But When i use the same query, which is being used in the Datastage, in the oracle, i am able to get the result set. (I got the query after i clicked Ok when it asked me there is more output to be displayed from the server command execution).

So can somebody help me out as what is going wrong in this particular job, whereas the other jobs which i developed in the similar fashion works well.

cheers!!!