Migration Job Error

Hi ​@FPayab,

no this is not a bug. It’s probably related to the dynamic key of project activites (activite seq).

Pls share the source mapping (screenshot).

Thx

I have not mapped the Activity sequence. isnt the activity sequence generated automatically? 

Yes, the activity sequence is generated automatically. However, this can also lead to problems, as your migration job may never find the correct records to update.

It's not easy to explain, but here are the key questions:

1. Is the SELECT statement in your migration job valid (check Show Select Statement)?

2. Are you only trying to migrate new activities, or do you also want to update existing ones?

3. Do the existing data already contain inconsistencies?

The reason for this error is that, during the execution of the migration job, a record cannot be uniquely identified. This is typically an issue when updating existing data. The goal is therefore to restore uniqueness.

This can usually be achieved either by adjusting the key definition in the migration job (via the Method List Attributes) or by correcting inconsistencies in the existing data.

How can i “Show Select Statement” in IFS Cloud?

i want to insert and update activities

the data has no inconsistencies (except functional inconsistencies)

I tried getting the Max(sequence) and use it to migrate new record but the same error is displayed. 

This in no way is any functional error and it does not help users understand the real problem. Will keep trying to find a fix.

Hi ​@FPayab,

Let me share my experience with Project Activity data migration.

Migration Job having Procedure INSERT_OR_UPDATE should not be used for migrating new Activities since this method does not generate Activity Sequence automatically, and if you are providing Activity Sequence value (next available number manually) for migration, the system will migrate the data but will not increase the Activity Sequence counter in the backend.

You can use INSERT_BY_METHOD_NEW for migration job to migrate new Activities data. This method generates the Activity Sequence automatically and no need to pass manually. 

Though, you can use INSERT_OR_UPDATE method for updating the Activities data, but you need to provide Activity Sequence for each record. Plus, you need to activate Migration rule INSUPD for UPDATE only.

Please check if this helps.