Problem with view data on oracle stage

vinodn · Post by **vinodn** » Wed Mar 26, 2008 3:26 am

Hi,

I am using source as a Oracle stage to read the data from oracle database.
At the time of importing the meta data the data is appearing,but after loading the meta data into stage the data is not appeared.Follwing error is occured.

Error executing View Data command:
##F TFPM 000281 14:53:14(025) <main_program> Fatal Error: Caught unknown exception in main program: terminating.

Pls assist for this query.

Regards,
Vinodn

vinodn · Post by **vinodn** » Mon Mar 31, 2008 4:16 am

Hi,

Pls help me for this query.

ArndW · Post by **ArndW** » Mon Mar 31, 2008 4:19 am

This one seems to have fallend between the cracks. What sort of options are you using in the Oracle stage? Default or non-default SELECT? Does the exact same SELECT work from SqlPlus or your favorite query tool? Any other problems with other jobs/tables?