Snowflake Data Cloud Connector

Back Next

Troubleshooting a mapping that continues to run post-SQL statements

The mapping fails without an error message in the session log and continues to run post-SQL statements specified for the target.: This issue occurs when all the following scenarios are true:
The source or target properties in the mapping configured with pre-SQL or post-SQL statements.
A transformation in the mapping pipeline fails.

To troubleshoot this issue, configure the -DSNOWFLAKE_SKIP_TARGET_POSTSQL_ON_ERROR JVM option property value to true in the Secure Agent properties.

However, you can't troubleshoot this issue in mappings in advanced mode.

To configure the -DSNOWFLAKE_SKIP_TARGET_POSTSQL_ON_ERROR JVM option property in the Secure Agent properties, perform the following steps:
Log in to Informatica Intelligent Cloud Services.
Select
Administrator
Runtime Environments
.
On the
Runtime Environments
page, select the Secure Agent machine that runs the mapping.
Click
Edit
.
In the
System Configuration Details
section, select
Data Integration Server
as the service and
DTM
as the type.
Edit the JVM option, and set the value to -DSNOWFLAKE_SKIP_TARGET_POSTSQL_ON_ERROR=true.
Click
Save
.