Duplicate Unique Primary Key Error In Teradata

baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for  Search instead for  Did you mean:  Teradata : Product Forums : Database : Error from Insert Select duplicate unique prime key error in teradata statement Options Subscribe to RSS Feed Mark Topic as New Mark Topic as

Duplicate Row Error In Teradata

Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page donal28 Enthusiast Options Mark as New Bookmark Subscribe duplicate row error in teradata update Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content ‎06-12-2012 01:58 PM ‎06-12-2012 01:58 PM Error from Insert Select statement Hi All I am getting an error when

Duplicate Unique Prime Key Error In Target Table

running the following Insert Select statment Statement INSERT INTO DDEWP42P.FMP_STRATEGIC_CM_BORROWER_AUTO (BORROWER_NAME) select DISTINCT TRIM (CM_CUST_NAME) FROM DDHWV03P.CM_CUSTOMER_STATIC_PERIODIC Error INSERT Failed. 2801:Duplicate unique prime key error in DDEWP42P.FMP_STRATEGIC_CM_BORROWER_AUTO. Neither the BORROWER_NAME or CM_CUST_NAME fields are prime keys and both are the same datatype varchar(255) Would I better using Update Select statement instead? Do I need to join the tables to do this Any help on this duplicate unique key error wow would be very much appreciated Regards Donal 0 Kudos Reply All Forum Topics Previous Topic Next Topic 8 REPLIES venkylingutla Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content ‎06-12-2012 11:42 PM ‎06-12-2012 11:42 PM Re: Error from Insert Select statement Hi, It means in the table FMP_STRATEGIC_CM_BORROWER_AUTO the colmn contains unique primary index please check. with the sql statement show table ; thanks, Venkat 0 Kudos Reply ulrich Junior Supporter Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content ‎06-13-2012 07:43 AM ‎06-13-2012 07:43 AM Re: Error from Insert Select statement you said thatBORROWER_NAME is not part of the PK, which you seem to have defined for the table. In this case your statement will use null for all DISTINCTTRIM (CM_CUST_NAME) And if you have more then one you would have a duplicate PK... So you would need to give the PK a unique not null value. 0 Kudos Reply donal28 Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content ‎06-13-2012 0

communityThis categoryThis boardKnowledge baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for  Search instead for  Did you mean:  Teradata : Product Forums : Database : Duplicate Unique Prime key error in Identity

Duplicate Unique Prime Key Error Informatica

colum... Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float

Duplicate Unique Prime Key Error World Of Warcraft

this Topic to the Top Bookmark Subscribe Printer Friendly Page annal_tamizhnam Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed unique primary index in teradata Get Direct Link Print Email to a Friend Report Inappropriate Content ‎06-10-2009 09:46 AM ‎06-10-2009 09:46 AM Duplicate Unique Prime key error in Identity column Table Hi,I'm getting duplicate Prime key error while loading into a Table http://community.teradata.com/t5/Database/Error-from-Insert-Select-statement/td-p/57936 with Identity column(which is defined as the UPI)Since the number is autogenerated i'm not sure why this happens(I have also defined with the clauses "Gen always as identity and No cycle"Currently if i simply rerun the job for the same data set it succeeds.1. This scenario is not consistent (We are facing this error only once in a while, but this error is not restricted to any one particular Table. We have seen this error http://community.teradata.com/t5/Database/Duplicate-Unique-Prime-key-error-in-Identity-column-Table/td-p/43678 in different Identity column tables)2. Earlier few months back we faced this issue when we restored Tables from Tape (That time tables were consistently failing and simply rerunning them was working) TD ticket was raised and they replied saying the archival might not have happened properly and we should be not be facing any issues going forward.Please let me know your comments on why this might be happening/what could be done toresolve this.Regards,Annal T 0 Kudos Reply All Forum Topics Previous Topic Next Topic 2 REPLIES mykovalenko Fan Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content ‎08-25-2010 02:25 AM ‎08-25-2010 02:25 AM Re: Duplicate Unique Prime key error in Identity column Table I'm facing exactly the same errors while trying to insert data using custom web application through JDBC. The column is defined "gen by default" though. We didn't restore any tables recently, so I don't think it has anything to do with it. 0 Kudos Reply goldminer Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content ‎09-01-2010 08:22 AM ‎09-01-2010 08:22 AM Re: Duplicate Unique Prime key error in Identity column Table You may want to check the max(identity col) value against the avail_value using th

Posted: Tue, 09 Dec 2008 @ 19:28:28 GMT <http://teradataforum.com/teradata/20081209_192828.htm Last>> Subj: Re: ML Error 2801: Duplicate unique prime key From: Pararha, Shubhangi The duplicate primary key error can be caused http://www.dsxchange.com/viewtopic.php?t=125503&view=previous&sid=1088f2abf9e22114416d917d935b227c because of the following: 1. The file or the table from where you are loading records into the target table have more than 1 record with the duplicate unique same UPI (unique primary index.). The duplicate primary key error is caused if you are trying to insert data into a table with a UPI which is already in the table. To find the erroneous record: Sel * from source_tbl where UPI in (sel UPI from target_tbl) You may have to delete this key error in record from the source table or use an update statement to update the record in the target table, with the source record. You cannot have both the record as you table has a unique primary index. If you are using loading from a file, use mload with insert and update statement and use the option: 'Do insert for missing update row' Regards, Shubhangi < Last>> Recent Threads Attachments Library Quick Reference Rules of Conduct FAQs Join the Forum Archives Sample Index 2016 2007 2015 2006 2014 2005 2013 2004 2012 2003 2011 2002 2010 2001 2009 2000 2008 1999 2008 Indexes Jan Jul Feb Aug Mar Sep Apr Oct May Nov Jun Dec Top Home Join Privacy Feedback Copyright 2016 - All Rights Reserved Last Modified: 31 Dec 2015

ECC View next topic View previous topic Add To Favorites This topic has been marked "Resolved." This topic is not resolved, but there is a WORKAROUND. Post new topic   Reply to topic    DSXchange Forum Index » IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX) Author Message mramak Group memberships:Premium Members, Heartland Usergroup Joined: 27 Mar 2007 Posts: 6 Points: 59 Posted: Fri Feb 20, 2009 1:51 pm Reply with quote    Back to top     DataStage Release: 7x Job Type: Parallel OS: Unix Hi, We are running DataStage EE version 7.5.2 on Sun Solaris for our ETL purposes and recently one of our business process requires us to extract data from a SAP ECC system. We are considering the SAP R/3 Pack. However, we don't know if SAP R/3 Pack would support integrating DataStage 7.5.2 with SAP ECC. Additionally, wondering if we could use the latest version of the SAP R/3 pack 6.0 with DataStage Version 7.5.2. I would definitely appreciate your comments and inputs. Thanks in advance. _________________DSX_MEMBER View user's profile  Send private message     chulett since January 2006 Group memberships:Premium Members, Inner Circle, Server to Parallel Transition Group Joined: 12 Nov 2002 Posts: 41398 Location: Denver, CO Points: 212207 Posted: Fri Feb 20, 2009 3:53 pm Reply with quote    Back to top     I would think that's really a question for IBM, but perhaps someone here knows as well. _________________-craig Can't keep my mind from the circling skies, tongue-tied and twisted just an earth-bound misfit, I View user's profile  Send private message     Rate this response: 0 1 2 3 4 5 Not yet rated mramak Group memberships:Premium Members, Heartland Usergroup Joined: 27 Mar 2007 Posts: 6 Points: 59 Posted: Wed Mar 04, 2009 11:15 am Reply with quote    Back to top     We Installed SAP Pack Version 5.2.1 and its working well with ECC. We started testing the ABAP Extract and BAP