Skip to main content
Question

Data migration


DMTCCAN
Sidekick (Customer)
Forum|alt.badge.img+5
  • Sidekick (Customer)
  • 10 replies

I am trying to migrate subcontract with DATA MIG Tools.

I got an error when loading the informations related to the Revision line .

 

When I look into the solution the expected values for this area are as follows.

 

 

Can somebody help !

 

Thank you Christophe.

 

2 replies

Jens
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 123 replies
  • March 14, 2025

Hi ​@DMTCCAN 

It would be fine if you could provide some screenshots of your migration job (source mapping, source name).

I assume you’re using the data migration tool (FndMig) and not DMM (Data Migration Manager)?

I suppose you mapped the field CALCULATION_METHOD_DB in the view SUB_CON_ITEM and not the field CALCULATION_METHOD. Always try to map a ..._DB-column if available and keep the non ….DB-column blank.

  1. Did you use a default value for the mapping which must have the value ‘FIXED’ (with apostroph)
  2. Or will it be mapped from a source table (IC...-table, Source_name) and here the value of the column in the source table is ‘FIXED’ (with apostroph) which is wrong and must have the value FIXED (without apostroph)

Kind regards,

Jens


DMTCCAN
Sidekick (Customer)
Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 10 replies
  • March 14, 2025

Hello,

I have indeed a default value set to ‘FIXED’ in the table, I have removed it as it is not the value we want to use.

That’s right I ama using FndMig Tool.

And now I have suceeded in  importing the data.

Thank you for your help.

 

Christophe

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings