Issue with choosing Mload option on the load utility of TD

Hi All,

I m new to this forum and also new to this DI tool.
I have an issue with a simple job which is loading the data into teradata.
Job design :
Flat file -------> Query Transform -------> Teradata

Source info : Flat file with comma delimited with 2 fields only
Query Transform info : direct mapping
Target Teradata info : chosen Multiload as Bulkloader option and file option is data File and Bulk operation is Insert.

But when I choose the normal load(Bulk Loader option as None) , the data gets loaded into the teradata table.

By setting up all these for MLOAD ,i m not able to populate the data in the teradata table.I m getting the following errors.

|Data flow New_DataFlow4|Loader Query_TEST_TD
Teradata failed with the following error: <
UTY1006 CLI error: 303, CLI2: BADLOGON(303): Invalid logon string.

. Please run with script <D:/Program Files/Business Objects/BusinessObjects Data
Services/log/bulkloader/TD_DS_SGAM_DB_TEST_TD.ctl> on the command line to debug or notify Customer Support.
|Data flow New_DataFlow4|Loader Query_TEST_TD
Teradata failed with the following error: <
UTY1006 CLI error: 303, CLI2: BADLOGON(303): Invalid logon string.
. Please run with script <D:/Program Files/Business Objects/BusinessObjects Data
Services/log/bulkloader/TD_DS_scott_TEST_TD.ctl> on the command line to debug or notify Customer Support.

Thanks
Sam


sam_pat (BOB member since 2010-08-27)

Hi

I use Teradata and do Multiloads.

Have you setup the Bulk Loader Directory in Datastore?
Have you given the informations for Log Table, Work Table Error Table in the Bulk Loader Options?


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

Hi Ganesh,

Thanks for the reply.I did it for the Datastore and also set the value for TDPID and then i ran the job.It ran successfully for the first 2 run but after that when i ran the same job with MLOAD option it’s showing the following error.Can you please guide me how to do all these setup for the Teradata?

|Data flow New_DataFlow|Loader Query_CUSTOMER_TRG
Teradata failed with the following error: <
UTY0805 RDBMS failure, 5628: Column MloadSeq not found in
DBNM.CUSTOMER_TRG_LT.>.
Please check $CHANGE_DIR/bin/td_env.config and run with script
</BODI/dev/DS/dataservices/log/bulkloader/TD1_DBNM_CUSTOMER_TRG_7.ctl> on the command line to debug or notify Customer Support.
|Data flow New_DataFlow|Loader Query_CUSTOMER_TRG
Teradata failed with the following error: <
UTY0805 RDBMS failure, 5628: Column MloadSeq not found in
DBNM.CUSTOMER_TRG_LT.>.
Please check $LINK_DIR/bin/td_env.config and run with script
</BODI/dev/DS/dataservices/log/bulkloader/TD1_DBNM_CUSTOMER_TRG_7.ctl> on the command line to debug or notify Customer Support.

Thanks
Sam


sam_pat (BOB member since 2010-08-27)