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.