DSXchange

Hi,

The job is fairly simple and straight forward as,

oracle stage -> stored procedure stage

Here only 1 value (date) is returned from oracle stage and it is passwed to STP stage as input to the procedure, executes the stored procedure which is in Sybase. If the procedure is executed manually it works fine. The datastage in this job only executes the procedure and there are no return values.

Error:
Attempt to get target table info from MetaStage_Table_Locator_Info failed.
DSTAGE-STP-0061`:`select Computer, SoftwareProduct, DataStore from MetaStage_Loc_Info

Any idea on where to debug for this issue?
Thanks for your help in advance.

Thanks.

Try an exact search here for "MetaStage_Loc_Info" and see if anything that comes up helps.

Did search and found that I can try by setting the environment variable DS_NO_PROCESS_METADATA=1

Is this something I need to add to user-defined in the DS Admin project property?

Thanks

DS Admin

Thanks times29 and chulett, the warning did not come up after adding the env. variable.

Thanks for the help.