General

Placeholder for KB's articles

com.fasterxml.jackson.databind.JsonMappingException.(Ljava/io/Closeable;Ljava/lang/String;) while building spark pipeline
Problem Description: Spark pipeline build fails with the below error in the job log. [pool-1-thread-1]:[16:33:44,999] [DEBUG] [AwbUtil] (AwbUtil.jav...
Thu, 19 Dec, 2019 at 8:40 AM
How to re-ingest the already loaded segments?
PROBLEM DESCRIPTION This article explains how to re-ingest the already loaded/ingested segments during segmented ingestion RESOLUTION Add the be...
Wed, 23 Oct, 2019 at 2:41 AM
Metadata crawl for sql sever db fails with connection closed error
Problem Description: The metadata crawl job for sql server database fails with the below exception in the job log. [INFO] 2019-10-10 05:46:22,258 [m...
Wed, 23 Oct, 2019 at 2:38 AM
TPT Ingestion failing with /usr/lib/jvm/java-8-openjdk-amd64/src.zip cannot be found error
PROBLEM DESCRIPTION TPT Ingestion failing with /usr/lib/jvm/java-8-openjdk-amd64/src.zip cannot be found error WORKAROUND/ RESOLUTION The TPT in...
Wed, 23 Oct, 2019 at 2:35 AM
How to expand the classpath?
This article explains the usage of the  ExpandClasspath JAR, which helps in the listing all the jars present in the classpath. Usage: java -cp <c...
Wed, 23 Oct, 2019 at 2:22 AM
Error while deleting source: java.lang.NullPointerException in IWX v2.6.x
Problem Description: If you delete a source from Infoworks UI, it shows that the source is deleted but it will still be displayed under the Sources tab....
Tue, 22 Oct, 2019 at 2:44 AM
running task:java.lang.IllegalArgumentException: tez.runtime.io.sort.mb 6082 should be larger than 0 and should be less than the available task memory (MB):1010 while running the ingestion job
Problem Description: DFI Ingestion job fails with the below error in the job log. Running SQL: select `ziw_filename` ,count(*) from `FLML_AUTH_GTM_V...
Tue, 22 Oct, 2019 at 2:37 AM
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/hive/hcatalog/mapreduce/HCatOutputFormat while running a sqoop command inside a bash node
Problem Description: If you execute a custom sqoop command inside a bash node in a workflow, it fails with the below exception in Infoworks EDO2 v2.8.x ...
Wed, 11 Mar, 2020 at 5:41 AM
java.util.concurrent.ExecutionException: com.google.cloud.bigquery.BigQueryException: Request had insufficient authentication scopes while running an export job to BQ
Problem Description: Export Job to BigQuery fails with the below error in the job log. [ERROR] 2019-10-03 10:31:29,238 [main] infoworks.discovery.ex...
Tue, 22 Oct, 2019 at 2:21 AM
java.lang.NoSuchMethodError: com.google.api.client.json.jackson2.JacksonFactory.getDefaultInstance()Lcom/google/api/client/json/jackson2/JacksonFactory during the export to BigQuery
Problem Description: Export to BigQuery will fail with the below error in the job log. Caught exception: java.lang.NoSuchMethodError: com.google.api...
Tue, 22 Oct, 2019 at 2:05 AM