odbc error

suneelchallagali · Post by **suneelchallagali** » Fri Jan 09, 2009 2:19 am

Hi Guys,

I have created the job which was running fine earlier but now it is not working properly. JOb has following stages as mention in order below for loading source data into target database.

SEQ>TRANSFORMER>ODBC STAGE>REJ_SEQ.

I am getting an error stating that
insert into person(last_name,first_name) values(?,?).

so please can you help me out regarding this issue

thank you,
suni

Pierre · Post by **Pierre** » Fri Jan 09, 2009 5:17 am

Now, we know you get an error, but we don't know which error.
What is your error message ?
What is the difference between "earlier" and now ?

suneelchallagali · Post by **suneelchallagali** » Fri Jan 09, 2009 8:57 am

Hi pierre,

job was running fine earlier but now it is not working fine. error for abort the job mention below

TARGET_SSN,1: [IIS-CONN-ODBC-000016] Execute failed on statement INSERT INTO "DB2INST1".PERSON_ID_INFO (PERSON_ID, SSN, BIRTH_DATE, EFFECTIVE_DATE) VALUES (?, ?, ?, ?).

TARGET_SSN,1: [IIS-CONN-ODBC-000004] ODBC function "SQLExecute" reported: SQLSTATE = 23000: Native Error Code = -803: Msg = [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]INSERT/UPDATE INVALID; INDEX 1 RESTRICTS COLUMNS WITH SAME VALUES. DB2INST1.PERSON_ID_INFO (CC_OdbcDBStatement::rejectRows, file CC_OdbcDBStatement.cpp, line 1,549)

chulett · Post by **chulett** » Fri Jan 09, 2009 9:00 am

You are trying to insert duplicate data into your target table.

suneelchallagali · Post by **suneelchallagali** » Fri Jan 09, 2009 9:12 am

No i am not trying to insert any duplicate data into target i have check it actually there are no reocrds in target.

chulett · Post by **chulett** » Fri Jan 09, 2009 9:28 am

Then your duplicate ID values are in your source data or you are sending them multiple times:

INSERT/UPDATE INVALID; INDEX 1 RESTRICTS COLUMNS WITH SAME VALUES. DB2INST1.PERSON_ID_INFO

suneelchallagali · Post by **suneelchallagali** » Fri Jan 09, 2009 9:43 am

Thank you chulett error is due to multiple records coming from source. i had used the pivot stage in previous thats the reason i am getting an error.

Please can you do me another favour, actually i have posted the in form regarding the SIGSEGV error. if possible can you help me out.

Thank you once again!!!!!

ray.wurlod · Post by **ray.wurlod** » Fri Jan 09, 2009 3:34 pm

Moderator: please move to parallel forum

This job shows a reject link from an ODBC stage, something not possible in a server job.

suneelchallagali · Post by **suneelchallagali** » Fri Jan 09, 2009 4:38 pm

sorry ray for posting parallel job error in server forum...