'Ebs Upload Local Forecast' Workflow Ending In Error (Doc ID 788088.1)

Last updated on OCTOBER 08, 2013

Applies to:

Oracle Demantra Demand Management - Version 7.2 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Oct-2013***


Symptoms

hen 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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms