'DataSet has no unique row identifiers' Message when Trying to Modify Microsoft Access Datastore's Data in ODI
(Doc ID 423722.1)
Last updated on JUNE 16, 2022
Applies to:Oracle Data Integrator - Version 4.1.01.05 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 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