Running Teradata MLOAD script through BODI

dataservices job design
1

Hello,

I am calling the Teradata Mload script through the job with exec function. Here is the command:

exec(‘cmd.exe’,’ Mload < E:\abc\Test_Mload.ml > E:\abc\Test_Mload_log.txt 2>&1’,8);

Now in the Mload script “Test_Mload.ml “, there is a set of command to load data from flat file to table in Teradata database. Inside the script I am reading the flat file ‘*.dat’ which is present on different server box apart from by BODI server box…

Now when I invoke the above command directly on BODI server box though command prompt with domain user as follows:

Mload < E:\abc\Test_Mload.ml > E:\abc\Test_Mload_log.txt 2>&1 (It woks fine)

But the same if I invoke through job it fails with error message “Access denied”.
I have checked that user has rights to access the data file present on the server but when I call from BODI job it fails.

Can somebody help me out?

Rick1981 (BOB member since 2010-06-05)

2

try giving the complete path of mload, also check under which user DI JobServer is running, if its SYSTEM then change it to run under a domain user who has access to mload and other files

one more thing, why are you calling mload from script I think DI provides options to bulk load using different Teradata bulk load utility, check the loader options for target table under bulk load tab

manoj_d (BOB member since 2009-01-02)

3

Thanks for your reply Manoj, I have changed the services to run on the domain user account rather than system account. It works fine for me.

Yes I am aware of bulk load using Teradata bulk load utility but due to perfornmance reason we went with the Mload & BTeq script

But still have few queries due to the user right as follows:

a) I have installed BODI XI3.0 with domain user with admin rights on server A (ETLBox).
b) I have created Local, Central and Profiler repositories on server B (Database server)
c) Now while configuring the job server with domain user, I was able to do so but the information was not getting saved in DSconfig file. Even though the domain users were having read and write rights on the BO folder.
d) Then I logged in with Administrator and did the Job server configuration and this time it has saved the information.

Now why I was not able to do the Job server configuration with the domain user?

Regards,
Rick

Rick1981 (BOB member since 2010-06-05)

4

Would you have an example of executing a BTEQ in BO? can you use the same exec() function? Screen shot would be appreciated

Cheers

jayhawkmba :us: (BOB member since 2012-08-29)