Skip to main content

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:

 

 

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

Terms & ConditionsCookie settings