FAW: SFTP extract ERROR.Error: Java.lang.NumberFormatException: For Input String: "VARCHAR2" or "NUMBER" (Doc ID 2965011.1)

Last updated on AUGUST 01, 2023

Applies to:

Fusion Analytics Warehouse - Version 23.R2.x and later
Information in this document applies to any platform.

Symptoms

While following blog: Configure Secure File Transfer Protocol Connector in Oracle Fusion Analytics

To load data via a csv SFTP file into FAW, received a data type error:

Failed. Exception occurred during metadata extract : Status: ERROR.Error: java.lang.NumberFormatException: For input string: "VARCHAR2"
at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.base/java.lang.Long.parseLong(Long.java:692)
at java.base/java.lang.Long.parseLong(Long.java:817)
at oracle.apps.bi.extractservice.extract.job.MetaExtractJob$MetaExtractJobTask.run(MetaExtractJob.java:686)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)

Error observed from FAW interface:

Changes

Configure Secure File Transfer Protocol Connector in Oracle Fusion Analytics

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

FAW: SFTP extract ERROR.Error: Java.lang.NumberFormatException: For Input String: "VARCHAR2" or "NUMBER" (Doc ID 2965011.1)

Applies to:

Symptoms

Changes

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!