Issue while executing a stored procedure

xch2005 · Post by **xch2005** » Thu Jun 20, 2013 8:30 pm

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.

chulett · Post by **chulett** » Thu Jun 20, 2013 9:30 pm

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

xch2005 · Post by **xch2005** » Mon Jun 24, 2013 2:33 pm

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

times29 · Post by **times29** » Mon Jun 24, 2013 2:52 pm

DS Admin

xch2005 · Post by **xch2005** » Tue Jun 25, 2013 8:22 pm

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

Thanks for the help.