"DataSet has no unique row identifiers" Message when Trying to Modify Microsoft Access Datastore Data in ODI
(Doc ID 579022.1)
Last updated on OCTOBER 31, 2019
Applies to:Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.
This problem can occur on any platform.
The following message is displayed when editing the data of a Microsoft Access 2003 (or earlier version) technology Model Datastore (right click on the Datastore > Data) in Oracle Data Integrator (ODI):
Note: For QueryDataSets you need to disable MetadataUpdate.RowID in the MetaDataUpdate property in addition to setting the RowID property on a column.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document