DSXchange

Hi

I am extracting the data from oci stage while extracting i am not able see the view data, i am getting this error

main_program: Internal Error: (colDesc):orautils.C: 1653: getColDesc failed.
Traceback: msgAssertion__13APT_FatalPathFPCcRC11APT_UStringPCci() at 0xd50c9014
querySchema__12APT_OraUtilsFPCwP12APT_ErrorLogi() at 0xd65193d8
describeOperator__19APT_OraReadOperatorFv() at 0xd6556ab4
wrapDescribeOperator__15APT_OperatorRepFv() at 0xd488ad94
check1a__15APT_OperatorRepFv() at 0xd488b964
sequenceAndCheck1Operators__11APT_StepRepFR12APT_ErrorLog() at 0xd499a7d4
check__11APT_StepRepFv() at 0xd4999dd4
check__8APT_StepFv() at 0xd49b9ac8
createAndCheckStep__7APT_OSLFP20APT_OSL_SIL_StepSpecR12APT_ErrorLog() at 0xd3a2329c
.() at 0x10007a90



Thanks in Advance
Samba

samba,

if you cut-and-paste the SQL select statement from the Oracle stage to your favorite query tool do you get a better error message or does it run correctly?

query executing

Samba,

does your reply mean that it is executing correctly?

we are not clairvoyant Is there something special about the query? Do other tables show data correctly in PX? Is it user-SQL or generated? Are you using some odd datatypes? If you remove some columns does it work? Can you try to see if the error is reproduceable in a Server job with the same table?

Does the extract even run?
Do select on the target and see if it loaded or not.