The solution to the following situations might help you troubleshoot JDBC Synchronization task.
The synchronization task fails.
When you run a synchronization task to write data to a JDBC target, the task fails with an SQLSyntaxErrorException error if the following conditions occur:
- The JDBC target has fields of the decimal data type with a precision over 31.
- The commit interval is greater than 1.
- You have specified the success file directory or error file directory.
To resolve the error, use fields of the decimal data type with a precision of 0-31 when the commit interval is greater than one and you have specified the success file directory or error file directory.