Page 1 of 1
odbc error
Posted: Fri Jan 09, 2009 2:19 am
by suneelchallagali
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
Posted: Fri Jan 09, 2009 5:17 am
by Pierre
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 ?
Posted: Fri Jan 09, 2009 8:57 am
by suneelchallagali
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)
Posted: Fri Jan 09, 2009 9:00 am
by chulett
You are trying to insert duplicate data into your target table.
Posted: Fri Jan 09, 2009 9:12 am
by suneelchallagali
No i am not trying to insert any duplicate data into target i have check it actually there are no reocrds in target.
Posted: Fri Jan 09, 2009 9:28 am
by chulett
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
Posted: Fri Jan 09, 2009 9:43 am
by suneelchallagali
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!!!!!
Posted: Fri Jan 09, 2009 3:34 pm
by ray.wurlod
Moderator: please move to parallel forum
This job shows a reject link from an ODBC stage, something not possible in a server job.
Posted: Fri Jan 09, 2009 4:38 pm
by suneelchallagali
sorry ray for posting parallel job error in server forum...