Import Transaction Using REST Api : Error in initializeMetadataForRestImport while processing InputFile java.lang.NullPointerException (Doc ID 2933492.1)

Last updated on MARCH 07, 2023

Applies to:

Symptoms

Import Transaction submitted using REST api error.  This has been working fine before.


ERROR from  SYSTASK_LOG generated in the Diagnostic file :
Some system error occurred with the content management server. Please contact administrator helpdesk.
Error in initializeMetadataForRestImport while processing InputFile for Batch: 300000080059854; with Input File : UCMFA03807081
Exception: java.lang.NullPointerException at File.java:<init>:279
FileImportCommonUtil.java:initializeMetadataForRestImport:6179
FileImportAMImpl.java:generateSQLLDRCtlDataFile:4015
Exception Message : null
Batch : 300000080059854:Error in SQLLDR Data/Ctl Generation with Exception :
java.lang.NullPointerException
Some system error occurred. Please contact administrator helpdesk.
Exception details - generateSQLLDRCtlDataFile: java.lang.NullPointerException
at File.java:<init>:279
FileImportCommonUtil.java:initializeMetadataForRestImport:6179
FileImportAMImpl.java:generateSQLLDRCtlDataFile:4015
300000080059854:Exception while Generating Control and Data Files :
java.lang.NullPointerException
Exception while deleting Queue Row/DB temp repository; Exception :
java.lang.NullPointerException at File.java:<init>:279
FileImportBatchScheduler.java:cleanUpBatchRelatedInfo:1236
FileImportBatchScheduler.java:execute:290
Exception during the Log/Ctl file generation of File Import Batch process,
logs will not get created, status : COMPLETE_WITH_ERRORS
Biz Exception in File Import Batch Process with Exception :
oracle.as.scheduler.ExecutionBizErrorException: ERROR at
FileImportEssUtil.java:checkSubRequestStatus:563
FileImportBatchScheduler.java:checkAndHandleSubRequestStatus:1162
FileImportBatchScheduler.java:invokeInterfaceTableLoading:669
Error in Batch CoOrdinator With Exception :
oracle.as.scheduler.ExecutionErrorException: Error:ERROR at
FileImportEssUtil.java:checkSubRequestStatus:571
FileImportJobCoOrdinator.java:execute:179
ExecutableWrapper.java:executeHelper:107


STEPS
1. Using REST api to upload the file to UCM server then call .../crmRestApi/resources/latest/importActivities REST to create the Import Activity
2. However, if create the Import Activity via the application UI, it works.
    Tools > Import Management > Create Import Activity
        [ Object ] = Incentive Transaction

Cause

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