FAW: SFTP Meta Data Refresh Fails for SFTP_META_EXTRACT
(Doc ID 2964969.1)
Last updated on AUGUST 01, 2023
Applies to:
Fusion Analytics Warehouse - Version 23.R2.x and laterInformation in this document applies to any platform.
Symptoms
In FAW, while performing data augmentation using SFTP connector, the extract job is failing with an error:
Failed. Exception occurred during metadata extract : Extract was not successful.
Status Response : {"requestId":"xxx-8209-4de4-8f3e-3d6166c5cca6","jobId":"1600","extractType":"SFTP_META_EXTRACT","message":"java.lang.NullPointerException\n\tat oracle.apps.bi.extractservice.extract.impl.FileExtractorImpl.extractDataStoreColumnsByName(FileExtractorImpl.java:442)\n\tat oracle.apps.bi.extractservice.extract.impl.SFTPExtractorImpl.extractDataStoreColumnsByName(SFTPExtractorImpl.java:106)\n\tat oracle.apps.bi.extractservice.extract.impl.SFTPExtractorImpl.extractDataStoreColumns(SFTPExtractorImpl.java:138)\n\tat oracle.apps.bi.extractservice.extract.job.MetaExtractJob$MetaExtractJobTask.run(MetaExtractJob.java:629)\n\tat java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)\n\tat java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n\tat java.base/java.lang.Thread.run(Thread.java:834)\n","status":"ERROR","dataStoreJobDetails":[],"percentComplete":0}java.lang.RuntimeException: Extract was not successful.
Status Response : {"requestId":"xxx-8209-4de4-8f3e-3d6166c5cca6","jobId":"1600","extractType":"SFTP_META_EXTRACT","message":"java.lang.NullPointerException\n\tat oracle.apps.bi.extractservice.extract.impl.FileExtractorImpl.extractDataStoreColumnsByName(FileExtractorImpl.java:442)\n\tat oracle.apps.bi.extractservice.extract.impl.SFTPExtractorImpl.extractDataStoreColumnsByName(SFTPExtractorImpl.java:106)\n\tat oracle.apps.bi.extractservice.extract.impl.SFTPExtractorImpl.extractDataStoreColumns(SFTPExtractorImpl.java:138)\n\tat oracle.apps.bi.extractservice.extract.job.MetaExtractJob$MetaExtractJobTask.run(MetaExtractJob.java:629)\n\tat java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)\n\tat java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n\tat java.base/java.lang.Thread.run(Thread.java:834)\n","status":"ERROR","dataStoreJobDetails":[],"percentComplete":0}
at oracle.apps.bi.common.datasourceclient.client.BaseDataSourceClient.getStatusWithWaitForCompletion(BaseDataSourceClient.java:1433)
at oracle.apps.bi.common.datasourceclient.client.BaseDataSourceClient.getStatus(BaseDataSourceClient.java:1370)
at oracle.apps.bi.common.datasourceclient.client.BaseDataSourceClient.getStatus(BaseDataSourceClient.java:1321)
at oracle.apps.bi.common.datasourceclient.client.BaseDataSourceClient.getStatus(BaseDataSourceClient.java:1299)
at oracle.apps.bi.common.datasourceclient.client.BaseDataSourceClient.getStatus(BaseDataSourceClient.java:1273)
at oracle.apps.bi.data.config.service.v2.impl.MetaDataExtractService.extractMetadata(MetaDataExtractService.java:172)
Status Response : {"requestId":"xxx-8209-4de4-8f3e-3d6166c5cca6","jobId":"1600","extractType":"SFTP_META_EXTRACT","message":"java.lang.NullPointerException\n\tat oracle.apps.bi.extractservice.extract.impl.FileExtractorImpl.extractDataStoreColumnsByName(FileExtractorImpl.java:442)\n\tat oracle.apps.bi.extractservice.extract.impl.SFTPExtractorImpl.extractDataStoreColumnsByName(SFTPExtractorImpl.java:106)\n\tat oracle.apps.bi.extractservice.extract.impl.SFTPExtractorImpl.extractDataStoreColumns(SFTPExtractorImpl.java:138)\n\tat oracle.apps.bi.extractservice.extract.job.MetaExtractJob$MetaExtractJobTask.run(MetaExtractJob.java:629)\n\tat java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)\n\tat java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n\tat java.base/java.lang.Thread.run(Thread.java:834)\n","status":"ERROR","dataStoreJobDetails":[],"percentComplete":0}java.lang.RuntimeException: Extract was not successful.
Status Response : {"requestId":"xxx-8209-4de4-8f3e-3d6166c5cca6","jobId":"1600","extractType":"SFTP_META_EXTRACT","message":"java.lang.NullPointerException\n\tat oracle.apps.bi.extractservice.extract.impl.FileExtractorImpl.extractDataStoreColumnsByName(FileExtractorImpl.java:442)\n\tat oracle.apps.bi.extractservice.extract.impl.SFTPExtractorImpl.extractDataStoreColumnsByName(SFTPExtractorImpl.java:106)\n\tat oracle.apps.bi.extractservice.extract.impl.SFTPExtractorImpl.extractDataStoreColumns(SFTPExtractorImpl.java:138)\n\tat oracle.apps.bi.extractservice.extract.job.MetaExtractJob$MetaExtractJobTask.run(MetaExtractJob.java:629)\n\tat java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)\n\tat java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n\tat java.base/java.lang.Thread.run(Thread.java:834)\n","status":"ERROR","dataStoreJobDetails":[],"percentComplete":0}
at oracle.apps.bi.common.datasourceclient.client.BaseDataSourceClient.getStatusWithWaitForCompletion(BaseDataSourceClient.java:1433)
at oracle.apps.bi.common.datasourceclient.client.BaseDataSourceClient.getStatus(BaseDataSourceClient.java:1370)
at oracle.apps.bi.common.datasourceclient.client.BaseDataSourceClient.getStatus(BaseDataSourceClient.java:1321)
at oracle.apps.bi.common.datasourceclient.client.BaseDataSourceClient.getStatus(BaseDataSourceClient.java:1299)
at oracle.apps.bi.common.datasourceclient.client.BaseDataSourceClient.getStatus(BaseDataSourceClient.java:1273)
at oracle.apps.bi.data.config.service.v2.impl.MetaDataExtractService.extractMetadata(MetaDataExtractService.java:172)
Changes
Implementation of the following BLOG:
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
| Symptoms |
| Changes |
| Cause |
| Solution |