Skip to main content
Question

Error in Migration Job Procedure Type: "MIGRATE_SOURCE_DATA"

  • October 24, 2025
  • 7 replies
  • 53 views
Q
Do Gooder (Customer)
Forum|alt.badge.img+2

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.

 

 

 

7 replies

N
Sidekick (Customer)
Forum|alt.badge.img+6
  • N.GEORGI
  • Sidekick (Customer)
  • October 24, 2025

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

Q
Do Gooder (Customer)
Forum|alt.badge.img+2
  • QHFJESP
  • Author
  • Do Gooder (Customer)
  • October 24, 2025

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

 

 

 

Grzegorz Byrski
N
Sidekick (Customer)
Forum|alt.badge.img+6
  • N.GEORGI
  • Sidekick (Customer)
  • October 27, 2025

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

 

N
Sidekick (Customer)
Forum|alt.badge.img+6
  • N.GEORGI
  • Sidekick (Customer)
  • October 27, 2025

​@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.

FlorianTauber
Hero (Partner)
Forum|alt.badge.img+6
  • FlorianTauber
  • Hero (Partner)
  • October 28, 2025

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

Regards, Florian from FLEXiCODE
Z
Do Gooder (Customer)
Forum|alt.badge.img+6
  • ZFTKMARTELE
  • Do Gooder (Customer)
  • November 14, 2025

I have the same problem with a mig job. In 23R1 it was working fine and in the new version 25R1 not.
If I change the rowid to objid in the source column it it working again.
Could this be a bug?

FlorianTauber
Hero (Partner)
Forum|alt.badge.img+6
  • FlorianTauber
  • Hero (Partner)
  • November 18, 2025

I have the same problem with a mig job. In 23R1 it was working fine and in the new version 25R1 not.
If I change the rowid to objid in the source column it it working again.
Could this be a bug?

Hi ​@ZFTKMARTELE 

which source are you using in your mig job? A view or a table?

I’am not aware of any “common issues”.

KR

Regards, Florian from FLEXiCODE
Terms & ConditionsCookie settingsAccessibility statement