Teradata Parallel Transporter - RDBMS error 3862

Tools

Teradata Parallel Transporter - RDBMS error 3862

Hi Forum

I am using TPT utility(13.10) from within the Business Objects Data Services (v14). It creates the batch file and control file to run the utility commands.

I have tried to tlogview the log files created in -t -d options iftdbuild command. They do not give me any meaningful error information.

Error I am getting is as follows:

C:\>tbuild.exe -f"D:/Program Files (x86)/SAP BusinessObjects/Data Services/log/BulkLoader/ TGT_EDW_TRDT_DS_DVLP_EXP_DL_SAPPOC_SALES_LINE_DETAIL_3 .ctl" -z0 DVLP_E

XP_DL_SAPPOC_SALES_LINE_DETAIL

Teradata Parallel Transporter Version 13.10.00.04

Job log: C:\Program Files (x86)\Teradata\client\13.10\Teradata Parallel Transpor

ter/logs/DVLP_EXP_DL_SAPPOC_SALES_LINE_DETAIL-57.out

Job id is DVLP_EXP_DL_SAPPOC_SALES_LINE_DETAIL-57, running on NNORSOVMDE128

Found CheckPoint file: C:\Program Files (x86)\Teradata\client\13.10\Teradata Par

allel Transporter/checkpoint\ DVLP_EXP_DL_SAPPOC_SALES_LINE_DETAILLVCP

This is a restart job; it restarts at step MAIN_STEP.

Teradata Parallel Transporter DataConnector Version 13.10.00.04

file_opt Instance 2 restarting.

file_opt Instance 3 restarting.

Teradata Parallel Transporter Load Operator Version 13.10.00.03

file_opt Instance 1 restarting.

load_opt: private log specified: pl_SALES_LINE_DETAIL

file_opt: TPT19008 DataConnector Producer operator Instances: 3

file_opt: TPT19003 ECI operator ID: file_opt-11448

load_opt: connecting sessions

load_opt: preparing target table

load_opt: TPT10508: RDBMS error 3862: The tables in BEGIN LOADING statement must

be different.

load_opt: disconnecting sessions

file_opt: TPT19221 Total files processed: 0.

load_opt: Total processor time used = '1.70313 Second(s)'

load_opt: Start : Mon Dec 17 16:47:14 2012

load_opt: End : Mon Dec 17 16:47:33 2012

Job step MAIN_STEP terminated (status 8)

Job DVLP_EXP_DL_SAPPOC_SALES_LINE_DETAIL terminated (status 8)

I am stuck and can not debug it further than looking through the logs. Please help.

Many thanks

-- shalaka

2 REPLIES

Re: Teradata Parallel Transporter - RDBMS error 3862

Hi

If anyone is interested -

Found what mistake I was doing. The 2 Error Table names were populated to be the same. The Error Message could have been little more specific :(

thanks

--shalaka

Teradata Employee

Re: Teradata Parallel Transporter - RDBMS error 3862

You think that this message is not clear enough?

"The tables in BEGIN LOADING statement must

be different."

Seems pretty clear to me.

-- SteveF