Common Problems & Things to Consider
Mapper Connector
use single quote ' instead double quotes "
Calculation, Math and Expressions
Calculate in mapper then put them in variable to be used later on
Consider fragmentation using () general function expression
Compare always use variables
SQL Syntax
Sql syntax prepare it in variables (not in mapper). Bug everything after dynamic field will be taken out
!!! Select from xxx where id = '<dyamic>' and 'bbb', everything after dynamic will be eaten
Into postgresql ensure not mix left and right sqlsyntax variables in a single mapper. Prepare gradually (fragment by fragement)
Failure Notifications
Email will be sent on workflow error concurrency 1, 3, and 7. Then it will auto disabled the scheduler on concurrent error number 7
Updated on: 10/02/2022
Thank you!