AnsweredAssumed Answered

Insert new lookup values using xog

Question asked by PragyaT on Feb 28, 2012
Latest reply on Feb 28, 2012 by PragyaT
Can we insert new lookup values using xog? I'm able to update existing lookup values using the write file, but if i try to insert new value, i get below error message:
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'CMN_LOOKUPS_PK'. Cannot insert duplicate key in object 'dbo.CMN_LOOKUPS'.
SQL error code: 3621
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
Executed:

Outcomes