Error in update activity

Avatar

Avatar

francisc4181303

Avatar

francisc4181303

francisc4181303

11-07-2017

Hi,  I'm using a enrichment activity to add data then doing a deduplication the data then trying to update data activity.  In the Update activity I’m getting the following error and i can't figure it out any help would be greatly appreciated

Oracle error: 'ORA-01779: cannot modify a column which maps to a non key-preserved table'

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

florentlb

Total Posts

1.1K

Likes

234

Correct Answer

239

Avatar

florentlb

Total Posts

1.1K

Likes

234

Correct Answer

239
florentlb

12-07-2017

Hi,

From my understanding key-preserved tables are specific to Oracle database. Is the table you are trying to update in this case? Do you have a way to change this at the database level?

Campaign won't be able to update data on such tables.

Let me know,

Florent.

Answers (0)