data is not loading into the target database

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sureshchandra
Participant
Posts: 92
Joined: Mon May 07, 2007 4:26 am

data is not loading into the target database

Post by sureshchandra »

Hi all,
My source and target is Teradata.I'm trying to execute the job it is aborting.My fatal error is

onnector_22: [IIS-CONN-TERA-005004] RDBMS code 3803: Table 'X' already exists.
SQL statement: CREATE TABLE SEBI_EDW.X (X_Id INTEGER NOT NULL, Lifecycle_Cd VARCHAR(50)
NOT NULL, X_Type_Cd VARCHAR(50) NOT NULL, MEMBERCODE VARCHAR(100), LONGNAME VARCHAR(100),
FIRMTYPE VARCHAR(100), TRADENAME VARCHAR(100), ADDRESS VARCHAR(100), PINCODE VARCHAR(100),
STATE VARCHAR(100), TELEPHONE VARCHAR(100), FAX VARCHAR(100), NATUREOFOFFICE VARCHAR(100),
DIRECTORNAMES VARCHAR(100), SEBIREGISTRATIONNO VARCHAR(100), MEMBERSTATUS VARCHAR(100),
SEGMENTCODE VARCHAR(100), BATCH_NO VARCHAR(10), LOAD_TIME CHAR(23)) PRIMARY INDEX (X_Id)
(CC_TeraConnection::execute, file CC_TeraConnection.cpp, line 2,625)

please help

Regards
Suresh
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Table X already exists in the SEBI_EDW schema.

There's nothing more to say.

No database will permit CREATE TABLE if the table named already exists.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sureshchandra
Participant
Posts: 92
Joined: Mon May 07, 2007 4:26 am

Post by sureshchandra »

Hi Ray,
I tried,these are the fatal errors i'm getting.
Teradata_Connector_34: Properties /Usage/WriteMode, /Usage/Session/ArraySize: Incompatible property values

Teradata_Connector_34: Error occurred during initializeFromArgs().

Thanks
suresh
arnabdey
Participant
Posts: 50
Joined: Wed Jan 10, 2007 5:56 am

Post by arnabdey »

Check the target database stage. Go to Input -> Options. Check in the create table action -> You should have Do not create target table.
Arnab
Post Reply