Skip to main content

Hello Everybody, we are trying to run a fairly simple Mig Job,  we are getting the following error message

 

Start time - 24-OCT-2025 09:26:59   HFI_ENG_PART_ACTIVE

Error in  select   - ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table 

End time - 24-OCT-2025 09:27:00   HFI_ENG_PART_ACTIVE 

 

Here is the Query we are running: 

 

SELECT OBJID, OBJVERSION, 'DO', ROWID FROM ENG_PART_REVISION_REFERENCE WHERE State='Preliminary' 

ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
Length of statement : 121 characters

 

Here below you will find a few screenshots of the Job itself, im fairly new at Mig Jobs and overall IFS, i have not been able to figure this out out.

 

any help would be appreciated.

 

 

 

​@QHFJESP Could we have a screenshot of the method list and rules please?

​@N.GEORGI  of course!!.. i dont know why i missed that… here you go.. thank you in advance!

 

 

 

is it normal that the ATTR_ Attribut is empty?

 

could you look if you can use ENG_PART_REVISION as a source in the database information tab please?

 

We do not use this module but i think the error is generating cause your view does not have a primary key

 

​@QHFJESP If the data exists only in the reference view, you can disable the ADDOBJID rule from the Rules tab and remove the OBJID line mapping from the Source Mapping tab.

The OBJID rowid is included only to allow you to restart the same occurrence of your data migration job in case of an error.

Hi,

The ORA-01445 means the query tried to select ROWID from a view based on a join, but the resulting rows could not be matched to an underlying physical row in a key-preserved base table.

Cause: The select statement attempted to select ROWIDs from a view derived from a join operation. Because the rows selected in the view did not always correspond to a single underlying physical record, no ROWIDs can be returned.

 

As N.GEORGI suggested, you need to disable ADDOBJID and remove the OBJID ID line if you want to use this view as a data source.

 

KR

Terms & ConditionsCookie settingsAccessibility statement