Teradata connector BULK load issue

ureddy · Post by **ureddy** » Sat Apr 04, 2015 10:23 am

Hi All,

I have an issue with teradata bulk load. The job will load data from dataset to teradata database (teradata connector used).
When I run the job with BULk load the data is loading to WORK table but not to the main table.
The log showing 0 records inserted in main table and no abort except the information message Exit code: 4. The job completed successfully without any warnings.

I could able to load the table successfully with the Immediate method.

Can any one suggest me what is wrong with BULK load.

Job Flow: Dataset to teradata connector. Connectior properties are below .

Table action= Append
Write mode= Insert
ACCESS_METHOD = Bulk
LOAD_TYPE = Load
LOG_TABLE = CLNT_MSTR
ERROR_LIMIT = 1
MIN_SESSIONS = 2
MAX_SESSIONS = 6
TENACITY_HOURS = 1
SYNC_TIMEOUT = 999
SYNC_TABLE = LOG_D1
TENACITY_SLEEP = 3
ARRAY_SIZE = 200
CLIENT_CHARSET = UTF8
PARALLEL_SYNC = 1
NLS_MAP = UTF8
RECORD_COUNT = 2000

Bulk access: Start mode=Cleanup and cleanup mode=drop
Sync table action:Replace
Sync table cleanup: keep

Thanks in advance,
Ureddy

vinothkumar · Post by **vinothkumar** » Sun Apr 05, 2015 11:25 pm

Are you trying to load into empty target table ?

Because you have selected the operator as 'LOAD_TYPE=LOAD' which is equivalent to fast load and it will load only in empty tables.

ureddy · Post by **ureddy** » Mon Apr 06, 2015 3:00 am

hi Vinoth,

I will have always inserts so im using LOAD option and its working even though the data is already exists in table in Lower environment (DEV).
The issue is coming in UAT and as Im first time loading table so the target table is empty. I even tried with Load type as UPDATE but still zero records are loading. The tables have Primary Index only.

LOAD option will work even if the table is not empty.
viewtopic.php?p=438900

Thank you.

Ureddy

vinothkumar · Post by **vinothkumar** » Mon Apr 06, 2015 3:32 am

Did you check in your error tables ?

ureddy · Post by **ureddy** » Mon Apr 06, 2015 3:58 am

The job is getting completed successfully so the error and log tables are getting dropped. But the same code is working as expected in DEV. I checked all parameters related to Datastage and are same both in DEV and UAT. So i sent email to DBA for checking this issue and waiting for the reply from them.

Thanks,
Ureddy

ureddy · Post by **ureddy** » Mon Apr 06, 2015 8:26 am

Bulk with Update mode the data is loading into main table. But in datastage log its showing Total number of rows inserted is : 0 and Exit code 4.
But Bulk with Load mode data is not loading to main table and datastage log its showing Total number of rows inserted is : 0 and Exit code 4.

need to investigate on why Bulk with Load option is not working.

Thanks,
Ureddy