General

Placeholder for KB's articles

Structured file ingestion is failing with java.lang.IllegalArgumentException: Delimiter cannot be more than one character
Problem Description: Structured file ingestion failing with java.lang.IllegalArgumentException: Delimiter cannot be more than one character error, sample s...
Mon, 10 May, 2021 at 9:59 AM
Export to SQL server is failing with java.sql.BatchUpdateException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.
Problem Description: Export to SQL server is failing with java.sql.BatchUpdateException: The conversion of a datetime2 data type to a datetime data type re...
Thu, 29 Apr, 2021 at 11:13 AM
Table Groups tab not getting displayed after importing the source export json using the configuration migration option
Problem Description:  When you export an RDBMS source configuration from an IWX v4.2 environment and import it into another IWX v4.2 environment, the im...
Wed, 21 Apr, 2021 at 4:34 PM
Export to Snowflake is failing with Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: Statement reached its statement or warehouse timeout of X second(s) and was canceled
Problem Description: Export to Snowflake fails with an error Failed during pipeline batch build : [TASK_EXECUTION_ERROR: 2524] When we look at the actu...
Wed, 21 Apr, 2021 at 1:20 AM
Ingestion is failing with "io.infoworks.saas.ingestion.commons.exception.IWException: io.infoworks.saas.ingestion.commons.exception.IWException: Error while writing data" Error for csv source in iwx 4.4.0.1
Problem Description: Ingestion is failing with "io.infoworks.saas.ingestion.commons.exception.IWException: io.infoworks.saas.ingestion.commons.exce...
Wed, 21 Apr, 2021 at 9:48 AM
Ingestion is failing with java.lang.NoClassDefFoundError: com/jcraft/jsch/SftpProgressMonitor
Problem Description: Ingestion is failing with below error for CSV source(source file location is sftp) when the target is gs bucket, 21/04/07 10:23:03...
Fri, 9 Apr, 2021 at 9:47 PM
Is it possible to change domain of existing pipeline in IWX?
Description: Is it possible to migrate a pipeline created in one domain to another in the same IWX instance? A pipeline once created under a domain cann...
Fri, 9 Apr, 2021 at 4:53 PM
Incremental ingestion job failing with column modified error for teradata tables when the jdbc driver was upgraded to newer version
Problem Description: Incremental ingestion job failing with column modified error during the pre-job step for the Teradata tables when the JDBC driver f...
Tue, 30 Mar, 2021 at 4:39 PM
Spark configurations on Infoworks 3.1.x and 3.3.x
In Infoworks 3.1.2, when user runs the pipeline build with spark as execution engine then a spark job is submitted to perform the transformations on the dat...
Sun, 21 Mar, 2021 at 1:05 PM
Incremental ingestion failing with error during table crawl due to path /target_hdfs_path/table_id/merged/orc does not exist
Problem Description: Incremental ingestion failing with /<target_hdfs_path>/<table_id>/merged/orc does not exists. Sample stack trace looks ...
Sun, 21 Mar, 2021 at 12:38 PM