My Oracle Support Banner

'Ebs Upload Local Forecast' Workflow Ending In Error - UploadLocalForecast Step name: UploadLocalForecast Error description Program internal error: null (Doc ID 788088.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to upload forecast from Demantra into the ASCP module, the 'EBS Upload Local Forecast' workflow is ending in error as below
"
Process ID: 2088 Schema ID: 634 Schema name: ''EBS Upload Local Forecast'' Step ID:
''UploadLocalForecast'' Step name: ''UploadLocalForecast'' Error description ''Program internal error: null''
"


The collaborator logs show the following:

23:15:48,133 [WFProcess_38] INFO appserver.integration: Run End Time: 02-23-2009 23:15:48
2009-02-23 23:15:48,133 [WFProcess_38] INFO appserver.integration: Run Duration Time
(hh.mm.ss.msec): 0.0.0.177
2009-02-23 23:15:48,134 [WFProcess_38] FATAL workflow.general: appserver.workflow.general
java.lang.NullPointerException
at
com.demantra.applicationServer.services.DBServicesCommon.exportToFile(DBServicesCommon.java:917)
at com.demantra.applicationServer.services.DBServices.exportToFile(DBServices.java:221)
at

com.demantra.applicationServer.metaDataObjects.transfer.profiles.QueryProfile.exportProfile(QueryPro
file.java:993)
at

com.demantra.applicationServer.metaDataObjects.transfer.profiles.IntegrationProfile.exportData(Integ
rationProfile.java:329)
at
com.demantra.applicationServer.metaDataObjects.transfer.Transfer.exportData(Transfer.java:199)
at com.demantra.workflow.step.TransferStep.doExecute(TransferStep.java:112)
at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:464)
at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:455)
at com.demantra.workflow.process.WFProcess.run(WFProcess.java:261)
at java.lang.Thread.run(Thread.java:595)
2009-02-23 23:35:02,251 [WFProcess_39] INFO appserver.integration:
#######################################################
2009-02-23 23:35:02,251 [WFProcess_39] INFO appserver.integration: Export Data.
2009-02-23 23:35:02,251 [WFProcess_39] INFO appserver.integration: Run Start Time: 02-23-2009
23:35:02
2009-02-23 23:35:02,251 [WFProcess_39] INFO appserver.integration: Interface Name: Local
Forecast
2009-02-23 23:35:02,251 [WFProcess_39] INFO appserver.integration: Profile Name: Local Forecast
2009-02-23 23:35:02,251 [WFProcess_39] INFO appserver.integration: Owner: dp
2009-02-23 23:35:02,251 [WFProcess_39] INFO appserver.integration: Profile From Date:
02-23-2009
2009-02-23 23:35:02,252 [WFProcess_39] INFO appserver.integration: Profile Until Date:
02-21-2011
2009-02-23 23:35:02,405 [WFProcess_39] INFO appserver.integration: View 'BIEO_Local_Fcst'
Created.
2009-02-23 23:35:02,405 [WFProcess_39] INFO appserver.integration: Export File: D:\Documents
and
Settings\vimal.nachiappan\Desktop\ExportForecast_1235412302405.TXT
2009-02-23 23:35:02,406 [WFProcess_39] ERROR appserver.integration:
java.lang.NullPointerException
at
com.demantra.applicationServer.services.DBServicesCommon.exportToFile(DBServicesCommon.java:917)
at com.demantra.applicationServer.services.DBServices.exportToFile(DBServices.java:221)
at

com.demantra.applicationServer.metaDataObjects.transfer.profiles.QueryProfile.exportProfile(QueryPro
file.java:993)
at

com.demantra.applicationServer.metaDataObjects.transfer.profiles.IntegrationProfile.exportData(Integ
rationProfile.java:329)
at
com.demantra.applicationServer.metaDataObjects.transfer.Transfer.exportData(Transfer.java:199)
at com.demantra.workflow.step.TransferStep.doExecute(TransferStep.java:112)
at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:464)
at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:455)
at com.demantra.workflow.process.WFProcess.run(WFProcess.java:261)
at java.lang.Thread.run(Thread.java:595)
2009-02-23 23:35:02,406 [WFProcess_39] INFO appserver.integration: Run End Time: 02-23-2009
23:35:02
2009-02-23 23:35:02,406 [WFProcess_39] INFO appserver.integration: Run Duration Time
(hh.mm.ss.msec): 0.0.0.155
2009-02-23 23:35:02,406 [WFProcess_39] FATAL workflow.general: appserver.workflow.general
java.lang.NullPointerException
at
com.demantra.applicationServer.services.DBServicesCommon.exportToFile(DBServicesCommon.java:917)
at com.demantra.applicationServer.services.DBServices.exportToFile(DBServices.java:221)
at

com.demantra.applicationServer.metaDataObjects.transfer.profiles.QueryProfile.exportProfile(QueryPro
file.java:993)
at

com.demantra.applicationServer.metaDataObjects.transfer.profiles.IntegrationProfile.exportData(Integ
rationProfile.java:329)
at
com.demantra.applicationServer.metaDataObjects.transfer.Transfer.exportData(Transfer.java:199)
at com.demantra.workflow.step.TransferStep.doExecute(TransferStep.java:112)
at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:464)
at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:455)
at com.demantra.workflow.process.WFProcess.run(WFProcess.java:261)
at java.lang.Thread.run(Thread.java:595)


When the user tries to run it from the command line it hangs:

aps EXPORT_DATA "integration interface name" "profile name" >abc.log



STEPS
The issue can be reproduced at will with the following steps:
1. Login the Workflow manager
2. Run the workflow EBS upload local forecast

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!


In this Document
Symptoms
Changes
Cause
Solution

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