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
coldescfailed
Moderators: chulett, rschirm, roy
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?
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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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 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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>