Troubleshooting a DSS Task
The solution to the following situations might help you troubleshoot JDBC Data Synchronization task.
- The Data Synchronization task fails.
When you run a Data 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.