Ingestion is failing with io.infoworks.saas.ingestion.commons.exception.IWException io.infoworks.saas.ingestion.commons

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.exception.IWException: Error while writing data" Error for csv source(source file location is sftp) when the target is gs bucket in iwx 4.4.0.1. Sample stacktrace looks like below,

Root cause:

This is a limitation in Infoworks which is fixed in future releases.

Solution:

This issue has been fixed in future releases and there is a patch available for IWX v4.4.0.1. Instructions are listed below.

• Take the backup of core.jar and commons.jar present in /opt/infoworks/lib/ingestion/core/

• Replace the core.jar and commons.jar present in /opt/infoworks/lib/ingestion/core/ with the jars attached.

• Change the permission to 755 for these 2 jars.

chmod 755 core.jar

chmod 755 commons.jar

• Rerun the ingestion job.

Applicable IWX versions:

IWX 4.4.0.1