Skip to main content
Question

Error while trying to create a migration job.

  • July 16, 2025
  • 1 reply
  • 12 views

Greetings,
I need to perform a Migration Job to update some columns from the Fiscal Registry screen. Specifically, in the “Fiscal Note Items” rows, for the columns highlighted as the SQL Column:


ICMS_TAXATION_CODE; CREDIT_TYPE_CODE; IPI_TAXATION_BASE; COFINS_TAXATION_BASE; PIS_PERCENTAGE; COFINS_PERCENTAGE; PIS_VALUE; COFINS_VALUE; PIS_CST; COFINS_CST

 

 

The Migration Job was created following these templates:

 

 


However, when attempting to start the task, the following error appears:

 

 

1 reply

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1268 replies
  • July 17, 2025

@Israel Freire could you try with 2 steps approach:

  1. Mig Job - > create table from file → load your file in the IC%TAB table
  2. Mig Job - Migrate Source Data → load data in the abse table from the intermediary IC_%TAB table.

This way, in the 2nd mig job you hve the option to do RMB → Show Select Statement → and it will show you a validation of the SQL. If there’s any error, you could easily fix it there.


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