Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Insert/update failed with ORA-00001 Unique Constraint
Go
New
Search
Notify
Tools
Reply
  
Insert/update failed with ORA-00001 Unique Constraint
 Login/Join
 
Member
posted
I tried to Insert/Update to Oracle table in DM but it returned Unique Constraint error even though I selected 'Update the existing record' for If the record exists attribute in target load options. Any suggestion welcomed.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 2 | Registered: September 22, 2011Reply With QuoteReport This Post
Member
posted Hide Post
Case closed.
Recreated synonym with unique key resolved the issue.

Thanks.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 2 | Registered: September 22, 2011Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Insert/update failed with ORA-00001 Unique Constraint

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.