General

Placeholder for KB's articles

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
java.io.IOException: The block list may not contain more than 50,000 blocks while running the TPT ingestion
Problem Description: Teradata TPT full load jobs fail with the below exception from the Azure end when Infoworks is running on Azure platform. [INFO...
Tue, 22 Oct, 2019 at 1:22 AM
org.apache.hadoop.fs.azure.AzureException: java.lang.IllegalArgumentException: StreamWriteSizeInBytes during sql server export
Problem Description: Export of data to SQL Server fails with the below Azure exception when Infoworks is running on Azure. ERROR] 2019-10-07 08:57:5...
Tue, 22 Oct, 2019 at 1:21 AM
String value 'NULL' in fixed with file will be converted to null data in hive
Problem Description: During the fixed-width file ingestion, if there as a string value 'NULL' in your data, it will be ingested as NULL data i...
Tue, 22 Oct, 2019 at 12:37 AM