Page 1 of 1

when I import the metadata for this column datastage is conv

Posted: Thu Dec 06, 2007 1:52 am
by uppalapati2003
when I import the metadata for this column datastage is converting as LONGVARCHAR, when I run this job , I am getting following error.

Traceback: [6] APT_FatalPath::msgAssertion(0xfca3b7c7, 0xffbec7a8, 0xfca3b7cf, 0x6b2, 0x0, 0xcd4a8), at 0xff0db308
> [7] APT_OraUtils::querySchema(0x0, 0xfca5dde8, 0xffbec738, 0xffbec888, 0xffbec894, 0xfca55f60), at 0xfc9a4488
> [8] APT_OraReadOperator::describeOperator(0xae498, 0x0, 0x12d278, 0xffbecde0, 0xfca5d7e8, 0xfc9861a8), at 0xfc97ee4c
> [9] APT_OperatorRep::wrapDescribeOperator(0x1692d0, 0x0, 0x1, 0x709228, 0xffbed02c, 0xb4), at 0xfe70b3c4
> [10] APT_OperatorRep::check1a(0x1692d0, 0x1800, 0xfed6e3e0, 0xff12de18, 0xfee1425c, 0xfee4eecc), at 0xfe70b92c
> [11] APT_StepRep::sequenceAndCheck1Operators(0x133960, 0x0, 0x0, 0xfed7994e, 0xfee1425c, 0x0), at 0xfe788580
> [12] APT_StepRep::check(0x133960, 0x68cb98, 0x0, 0x0, 0xfee1425c, 0x13396c), at 0xfe7878c8
> [13] APT_Step::check(0x13f170, 0xffbed7f0, 0xffbed734, 0xff135138, 0x0, 0xfee1425c), at 0xfe77b9d4
> [14] APT_OSL::createAndCheckStep(0x132010, 0xffbeeb88, 0xff1aee24, 0xffbed7b8, 0xffbed7f0, 0x3c794), at 0xff220d90
> [15] APT_ORCHESTRATE_main(0x1, 0x2b8fa, 0xffbeecc0, 0x4, 0xffbeee28, 0xffbeee44), at 0x1fcdc

Posted: Thu Dec 06, 2007 3:27 am
by ray.wurlod
What do you believe the data type should be? Were any other errors logged?

how to retrive the data from CLOB Column through datastage

Posted: Thu Dec 06, 2007 3:46 am
by uppalapati2003
i have column as datatype CLOB when i was selected the column through the datastage i am getting the problem , when i import the metadata its importing the longvarchar and when i ran the job its giving the error.