Troubleshooting

When you run a mapping to write data from a string column that contains date and time information, the mapping writes date and time information incorrectly to the Snowflake target.

To resolve this issue, set the JVM option to -DHonorInfaDateFormat=true for the Secure Agent.

To configure the JVM option in Administrator, perform the following steps:

1. 1Select Administrator > Runtime Environments.
2. 2On the Runtime Environments page, select the Secure Agent machine that runs the mapping.
3. 3Click Edit.
4. 4In the System Configuration Details section, select Data Integration Server as the Service and DTM as the Type.
5. 5Edit the JVMOption system property and set the value to -DHonorInfaDateFormat=true.
6. 6Click Save.