Does DS invoke Teradata Utilities during processing?

[Former Member]

Does Data Services XI 3.1 invoke Teradata Utilities during processing?

Edited by: Kim McCormick on Apr 14, 2009 9:10 PM

[Former Member]

Hi,

I'm using Bulk load to Teradata database with tpt option.

When I execute my job in Data services, I'm getting error as: "Cannot find the full path for file <tbuild.exe>, due to error <2>. "

Job console output:

6024 3872 DATAFLOW 11/4/2010 5:00:09 PM Data flow <pj_DataFlow> using IN MEMORY Cache.

6024 4896 BLKLOAD 11/4/2010 5:00:12 PM Starting Bulk Loader Utility <tbuild> in <Dataflow pj_DataFlow>. Data file is

6024 4896 BLKLOAD 11/4/2010 5:00:12 PM <
.\pipe\pjtarget_Datastore_OF_JIRA_PC2_7_0.dat>. Command line used is <tbuild.exe -f"C:/Program Files (x86)/Business

6024 4896 BLKLOAD 11/4/2010 5:00:12 PM Objects/BusinessObjects Data Services/log/bulkloader/pjtarget_Datastore_OF_JIRA_PC2_7.ctl" OF_JIRA_PC2 -z0>.

6024 3872 DATAFLOW 11/4/2010 5:00:22 PM Data flow <pj_DataFlow> is terminated due to error <50616>.

6024 3872 DATAFLOW 11/4/2010 5:00:22 PM Process to execute data flow <pj_DataFlow> is completed.

3596 3324 WORKFLOW 11/4/2010 5:00:27 PM Work flow <pj_WorkFlow4> is terminated due to an error <50616>.

3596 3324 JOB 11/4/2010 5:00:27 PM Job <pj_Job2> is terminated due to error <50616>.

Please let me know where I'm missing.

Thanks alot in advance.

Chintu

[Former Member]

is tbuild utility installed on the machine where job is getting executed (JobServer machine) ?

check if the tbuild utility PATH is there in PATH variable

[Former Member]

Thank you very much. its working

[Former Member]

Hi'

I'm having the same problem.

Where did you specify the user and password for teradata?

Thanks,

Amir

[Former Member]

if you are using teradata bulk load, while executing the job Data Services will inovke the respective utility to execute the bulk load

like, tpump, mload, etc...