This discussion is archived
4 Replies Latest reply: Apr 13, 2012 8:55 AM by 774570 RSS

ODI Error: no Key is declared in your Target Datastore

809191 Newbie
Currently Being Moderated
Hi All

I am trying to update a field in a table (MSSQL database) from fields in the same table using the IKM MSSQL Incremental Update.

When I try to run the interface the following error occurs:

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Flow Control not possible if no Key is declared in your Target Datastore

I have selected the 'Key' option on the primary key field in the 'Target Column Properties' on the Mapping tab in Designer, but when i select the 'Update Key' in the Flow tab, there are no fields to select.
What is the difference between these two key configurations in Designer? Why isn't ODI recognizing the key specified on the target?

Thanks in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points