Cannot find the full path for file <fastload.exe>

dataservices job design
1

When attempting a simple teradata fastload I get the following error :
Cannot find the full path for file <fastload.exe>, due to error <2>.

I have DS 4.0 installed on 64 bit machine. I have installed all Teradata utilities including fastload, tpump etc. Checked the PATH on the server and rebooted the server but no luck.

Any idea how to solve this error.

Thanks,
Ankur

ankur_s2000 (BOB member since 2006-06-08)

2

Interesting…Let me quickly check that here…btw…did you rebooted?

ganeshxp :us: (BOB member since 2008-07-17)

3

I have got this working now after reboot. Now, it is throwing error
4860 4444 DBS-120806 5/4/2012 12:55:51 PM Teradata failed with the following error: <0004 DEFINE

Since BODS is creating these fastload files so I have no idea why it is throwing the error

ankur_s2000 (BOB member since 2006-06-08)

4

What is the complete Error Message?

ganeshxp :us: (BOB member since 2008-07-17)

5

Here it is

4860 4444 DBS-120806 5/4/2012 12:55:51 PM |Data flow New_DataFlow|Loader Loader1 for table ‘Query_CSS_ACCOUNT’
4860 4444 DBS-120806 5/4/2012 12:55:51 PM Teradata failed with the following error: <0004 DEFINE
4860 4444 DBS-120806 5/4/2012 12:55:51 PM C0_ (VARCHAR(26))
4860 4444 DBS-120806 5/4/2012 12:55:51 PM ,C1_ (VARCHAR(3))
4860 4444 DBS-120806 5/4/2012 12:55:51 PM ,C2_ (VARCHAR(5))
4860 4444 DBS-120806 5/4/2012 12:55:51 PM ,C3_ (VARCHAR(8), NULLIF = ‘’ )
4860 4444 DBS-120806 5/4/2012 12:55:51 PM ,C4_ (VARCHAR(30))
4860 4444 DBS-120806 5/4/2012 12:55:51 PM ,C5_ (VARCHAR(15), NULLIF = ‘’ )
4860 4444 DBS-120806 5/4/2012 12:55:51 PM FILE=C:/Program Files (x86)/SAP BusinessObjects/Data Services/log/bulkloa
4860 4444 DBS-120806 5/4/2012 12:55:51 PM der/DWSDEVL_DWS_STAGE1_CSS_ACCOUNT_9_0.dat;

ankur_s2000 (BOB member since 2006-06-08)

6

Something to do with your table definition maybe? Are you able to do regular load on that table?

ganeshxp :us: (BOB member since 2008-07-17)

7

yes I was able to do direct load successfully and thought to use fastload option to improve performance.

ankur_s2000 (BOB member since 2006-06-08)

8

Okay…that is fine…What are the bulk load settings you use? Would you snap that and show it here?

ganeshxp :us: (BOB member since 2008-07-17)

9

Please find it attached

Thanks,
Ankur
BulkLoadsettings.jpg

ankur_s2000 (BOB member since 2006-06-08)