Microsoft Azure Synapse SQL Connector > Troubleshooting > Troubleshooting a mapping or mapping task
  

Troubleshooting a mapping or mapping task

[FATAL] Exception: com.microsoft.sqlserver.jdbc.SQLServerException: 100001;Failed to generate query plan.
When you use an ORDER BY clause in a custom query or SQL override, the mapping fails with the following error:
[FATAL] Exception: com.microsoft.sqlserver.jdbc.SQLServerException: 100001;Failed to generate query plan.
To use the ORDER BY clause in a query, you must configure the following property in the JVM options of the Secure Agent:
-DAzureSynapseDisableStagingForSort=true
If you use custom query in a Lookup transformation, you must perform the following additional tasks:
Mapping failed with a Java heap space error
When you run a mapping that reads a large volume of data from or writes a large volume of data to Microsoft Azure Synapse SQL, the mapping fails with a Java heap space error.
Set the JVM options for type Tomcat JRE to increase the -Xms and -Xmx values in the system configuration details of the Secure Agent. You must then restart the Secure Agent.
[ERROR] com.informatica.cci.cloud.client.impl.CCIClientExceptionImpl: Invalid expression string for filter condition.
If you configure an uncached Lookup transformation to look up data from a Microsoft Azure Synapse SQL source and the source contains a column of DateTime or Timestamp data type, the mapping fails for certain values with the following error:
[ERROR] com.informatica.cci.cloud.client.impl.CCIClientExceptionImpl: Invalid expression string for filter condition.