Documentation for Versions 2.x, 3.1.

Unity Catalog enabled Environments

On Unity Catalog enabled environments, if user sees this error User does not have permission SELECT on any file. SQLSTATE: 42501 which usually occurs when service principal is selected for profile running the job.
Then required permission is missing and admin has to provide access by running GRANT SELECT ON ANY FILE TO '<service-principal>'.

Last updated on

Was this page helpful?

On This Page

Unity Catalog enabled Environments

File ingestion Failure from SFTP Server

Infoworks Setup Failure in Kubernetes Cluster due to NGINX

Performing Ingress Controller Changes in values.yaml

Overview of Network Policy

6.2.1

PostgreSQL Upgrade Steps

6.1.2

Format for the timestamp for a Teradata Source

Jobs on Databricks Unity environment

Knowledge Base Legacy

Authentication using LDAP fails with an authentication error

Common infrastructure issues during Infoworks Installation on AKS

Compare configuration files before and after upgrade

Count mismatch due to hive fetching data from metastore

Crawl metadata failing with Response Row size exceeds 64K bytes and is incompatible with the Client software error in a

Custom docker image

Databricks Cluster Launch Fails Due to Cluster Policy Mismatch

Delegation token expiry

Enabling log rotation fails in Infoworks v5.0 v5.1

Error in accessing ADLS using Databricks CLI from Edge Node

Error while decrypting data in sample datasets page in IWX v5.0

Error while enabling log rotation

Export list of Infoworks users and accessible domains to CSV

Export to SQL server is failing with java.sql.BatchUpdateException The conversion of a datetime2 data type to a datetime

Export to Snowflake is failing with Caused by net.snowflake.client.jdbc.SnowflakeSQLException Statement reached its stat

FAQ When a pipeline job may go into blocked state

How to add custom tags to Infoworks Job clusters

How to add labels for Dataproc Ephemeral clusters launched by Ingestion jobs

How to create Generic JDBC Excel source in Infoworks DataFoundry 4.2

How to ingest from Hubspot using Datafoundry

How to monitor Infoworks Services

How to pass yarn queue to run a hive sql in a workflow bash script node

How to push Custom metrics from Infoworks Instance to AWS Cloud Watch

How to secure infoworks services with self signed SSL certificate in 5.0

How to update the default autoscaling policy for Dataproc Ephemeral clusters

How to use custom user defined functions in pipelines

How to use source extension feature in Infoworks v5.x

IBM DB2 ingestion job fails with CharConversionException

IWX UI shows the Ingestion job as failed but the data would be ingested

Incremental ingestion failing with error during table crawl due to path target_hdfs_path table_id merged orc does not ex

Incremental ingestion fails with cannot perform MERGE as multiple source rows matched and attempted to update the same t

Incremental ingestion is failing with unable to find the column of the target table error

Incremental ingestion job failing with column modified error for teradata tables when the jdbc driver was upgraded to ne

Infoworks Services Information & Log Locations

Infoworks users authentication using LDAP takes more than a minute

Infoworks – Bulk Connection Manager Source & Target Data Connections

Ingest job fails at merge stage with Table or view not found error

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

Ingestion is failing with java.lang.NoClassDefFoundError com jcraft jsch SftpProgressMonitor

Ingestion job TIMEDOUT after running for long time

Ingestion job failing with error org.apache.spark.sql.execution.OutOfMemorySparkException during the merge phase

Ingestion job fails with java.util.concurrent.ExecutionException java.io.FileNotFoundException in DataFoundry 4.2

Is it possible to change domain of existing pipeline in IWX

Jobs failing with Invalid JWT Signature

Jobs failing with error Amazon.S3.AmazonS3Exception Part number must be an integer between 1 and 10000, inclusive

Kafka ingestion fails with error Caused by java.lang.NoSuchMethodError com.univocity.parsers.csv.CsvFormat.setDelimiter

Length of parsed input (4097) exceeds the maximum number of characters defined in your parser settings (4096)

Monitor active job drivers for EMR cluster

Optimizing Ingestion Performance and Reducing Cluster Costs Using Split-By and Table Group Parallelism in Infoworks

Oracle source Ingestion fails with java.sql.SQLException ORA-28040 No matching authentication protocol

OutOfMemorySparkException while running Infoworks Jobs

Pipeline Job failing with Dates older than '1582-10-15' or Timestamp older than ‘1900-01-01 00 00 00.0'

Pipeline build fails with Too many open files error

Provisioning Dataproc Cluster's with custom machine image through Infoworks

Python script execution fails from bash node in workflow but succeeds from the Infoworks Edge node

Rabbit MQ fails to start

Renaming the columns and running the pipeline results in schema mismatch exceptions

Rest API requests return an error ‘Failed to retrieve username and password from auth token’

Sample Post Ingestion Hook Script

Scheduled workflow not getting triggered on time in IWX v4.2

Script for deleting jobs in Databricks workspace for 1000 job limit workspace

Source import fails with internal server error

Spark configurations on Infoworks 3.1.x and 3.3.x

Steps to Update Databricks Token on IWX Version 5.2.0

Steps to change the Ingestion job logs to debug mode

Steps to enable log rotation in IWX 5.x

Steps to take backup of MongoDb data and restore the data from the backup file

String value 'NULL' present in csv file will be converted to null data in hive

Structured file ingestion is failing with java.lang.IllegalArgumentException Delimiter cannot be more than one character

Sync to Target (Teradata failing)

Table Groups tab not getting displayed after importing the source export json using the configuration migration option

Test Connection Fails from Infoworks to Data Source

Test source connection outside Infoworks product

The pipeline build failing with Exception cannot resolve (column name) given input columns error

The pipeline build failing with java.lang.OutOfMemoryError GC overhead limit exceeded

Throttling exception in High-level application history section

Triggering Databricks Notebook from Infoworks Bash Node

Troubleshoot row count mismatches for replicated tables

Troubleshooting Insufficient Privileges for Snowflake Roles

V3 rest-api in errored state

What is the configuration to set the comparator to fetch CDC records

Workflows are going into pending state in Infoworks

Write to BQ jobs, Direct load and Indirect load options

csv_error_threshold in 3.x is changed to error_record_threshold in 5.0

java.lang.NoClassDefFoundError commons exception IWException wile doing Parquet source Metacrawl

psycopg2.OperationalError) FATAL sorry, too many clients already

sudo no tty present and no askpass program specified error while starting Nginx service

org.postgresql.util.PSQLException

6.1.1

Intermittent Failure of CDC SCD2 Pipeline Builds Due to Timestamp Casting Issue

Unity Catalog enabled Environments

Limitation: Additional Connection Parameters getting removed when connecting to Oracle Database via JDBC on Spark shared clusters