Quite new to the Data Migration Tool in IFS I try doing my first Excel migration job using two LU’s. The purpose of the job is to update the SUPPLIER.SUPP_GRP column. As an additional information we will need the ASSOCIATION_NO from the SUPPLIER_INFO_GENEREAL LU but only SUPP_GRP needs to be updateable.
I have configured the job as follows:
In the method list tab I added the two LU’s:
In the rules tab I added a FETCHCONDITION that seems to work:
And finally I configured the source mapping tab as follows:
Running the job in Excel the Load Data procedure works as expected. One row for each supplier and all field showing the correct existing value. But then edit the SUPP_GRP value on a supplier and the run the Validate procedure I got an “Object does not exists” error in the Result Column.
Back to the migration job trying edit and save some information on the SUPPLIER_INFO_GENERAL row in the method list I got the following error:
To me it seems like the job don’t like using the SUPPLIER_INFO_GENERAL.SUPPLIER_ID column as a key even if this column is defined as one.
Does anyone has any idea how to solve this problem?
Best answer by NiyomalN
Quite new to the Data Migration Tool in IFS I try doing my first Excel migration job using two LU’s. The purpose of the job is to update the SUPPLIER.SUPP_GRP column. As an additional information we will need the ASSOCIATION_NO from the SUPPLIER_INFO_GENEREAL LU but only SUPP_GRP needs to be updateable.
I have configured the job as follows:
In the method list tab I added the two LU’s:
In the rules tab I added a FETCHCONDITION that seems to work:
And finally I configured the source mapping tab as follows:
Running the job in Excel the Load Data procedure works as expected. One row for each supplier and all field showing the correct existing value. But then edit the SUPP_GRP value on a supplier and the run the Validate procedure I got an “Object does not exists” error in the Result Column.
Back to the migration job trying edit and save some information on the SUPPLIER_INFO_GENERAL row in the method list I got the following error:
To me it seems like the job don’t like using the SUPPLIER_INFO_GENERAL.SUPPLIER_ID column as a key even if this column is defined as one.
Does anyone has any idea how to solve this problem?
@niklas_larsson , can you remove the below highlighted columns and see?
Quite new to the Data Migration Tool in IFS I try doing my first Excel migration job using two LU’s. The purpose of the job is to update the SUPPLIER.SUPP_GRP column. As an additional information we will need the ASSOCIATION_NO from the SUPPLIER_INFO_GENEREAL LU but only SUPP_GRP needs to be updateable.
I have configured the job as follows:
In the method list tab I added the two LU’s:
In the rules tab I added a FETCHCONDITION that seems to work:
And finally I configured the source mapping tab as follows:
Running the job in Excel the Load Data procedure works as expected. One row for each supplier and all field showing the correct existing value. But then edit the SUPP_GRP value on a supplier and the run the Validate procedure I got an “Object does not exists” error in the Result Column.
Back to the migration job trying edit and save some information on the SUPPLIER_INFO_GENERAL row in the method list I got the following error:
To me it seems like the job don’t like using the SUPPLIER_INFO_GENERAL.SUPPLIER_ID column as a key even if this column is defined as one.
Does anyone has any idea how to solve this problem?
@niklas_larsson , can you remove the below highlighted columns and see?
Thanks for quick reply. First your solution did not work. Same error on Validate/Execute in Excel: “Object does not exists”. But I think you might pointed me into the right direction because to avoid to get the error on saving the method list I had to enable the “New” value. But it still did not work i Excel so I also enabled the “On new Master” attribute and finally it worked in Excel :-)
To me this configuration seems a bit strange as I don’t add any new lines and only doing updates on SUPP_GRP. But anyway a working configuration for the method list seems to be:
