odbc error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
odbc error
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
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
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
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)
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)
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
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
INSERT/UPDATE INVALID; INDEX 1 RESTRICTS COLUMNS WITH SAME VALUES. DB2INST1.PERSON_ID_INFO
Last edited by chulett on Fri Jan 09, 2009 10:07 am, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
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!!!!!
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!!!!!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm