Dear Gurus,
We have successfully calling the epm agent and able to generate the file but DLR is failing.
We are trying to check the file DMTEST_DATA_120.dat which is getting processed,please check below log.
Can anyone let us know what would be path in cloud to see this file like we have outbox/data in on premise fdmee?
Do we need to perform some set up on cloud-DM?
Extract file 120.dat is getting created successfully.
***************************************************LOGS:-
2020-05-19 11:55:05,892 INFO [AIF]: FDMEE Process: 120, Log Level: 4
2020-05-19 11:55:05,893 INFO [AIF]: Location : LO_DMTEST (Partitionkey:39)
2020-05-19 11:55:05,893 INFO [AIF]: Period Name : Jan-20 (Period Key:1/31/20 12:00 AM)
2020-05-19 11:55:05,893 INFO [AIF]: Category Name: Actual (Category key:4)
2020-05-19 11:55:05,893 INFO [AIF]: Rule Name : DLRDmtest (Rule ID:4)
2020-05-19 11:55:07,132 INFO [AIF]: Log File Encoding: UTF-8
2020-05-19 11:55:08,092 INFO [AIF]: -------START IMPORT STEP-------
2020-05-19 11:55:08,255 INFO [AIF]: Executing the following script: OnPremDBExtractData.py
2020-05-19 11:55:08,266 INFO [AIF]: ------------------------------------------------------------------------------------------------------------------
2020-05-19 11:55:08,266 INFO [AIF]: Fetching Start / End PeriodKey:
2020-05-19 11:55:08,266 INFO [AIF]: ------------------------------------------------------------------------------------------------------------------
2020-05-19 11:55:08,268 INFO [AIF]: ************************************************************************************
2020-05-19 11:55:08,268 INFO [AIF]: *On Prem DB Extract: Started *
2020-05-19 11:55:08,268 INFO [AIF]: ************************************************************************************
2020-05-19 11:55:08,324 INFO [AIF]: Original Extract Query:select DMAC,DMYear,DMPeriod,DMAppBud,DMSpend from dmtest
2020-05-19 11:55:08,325 INFO [AIF]: Entering method parseQuery with sql:select DMAC,DMYear,DMPeriod,DMAppBud,DMSpend from dmtest
2020-05-19 11:55:08,325 INFO [AIF]: UPDATED QUERY:select DMAC,DMYear,DMPeriod,DMAppBud,DMSpend from dmtest
2020-05-19 11:55:08,326 INFO [AIF]: Retrieved EPM Cluster name:DM_POC
2020-05-19 11:55:08,326 INFO [AIF]: Retrieved Cluster Mode:ASYNC
2020-05-19 11:55:08,327 INFO [AIF]: Calling agent extract ASYNC mode: BEGIN
2020-05-19 11:55:08,327 INFO [AIF]: Request Payload Length:369
2020-05-19 11:56:08,337 INFO [AIF]: Appending EPM agent log to process: BEGIN
2020-05-19 11:56:08,337 INFO [AIF]: Appending agent log to process log.
May-19 17:25:59:573 :: *************** Starting execution for sessionId:120 at: May-19 17:25:59:571***************
May-19 17:25:59:574 :: Process Extract Request with data:--------------Executor Request Data--------------
jobType:EXTRACT
sessionID:120
Data Source Name:DMTEST_DATA
credStore:CLOUD
query:select DMAC,DMYear,DMPeriod,DMAppBud,DMSpend from dmtest
outputType:FILE
delimiter:,
--------------Bind Variables--------------
--------------------------------------------
May-19 17:25:59:575 :: --------------- Executing Custom Event :BefExtract ---------------
May-19 17:25:59:612 :: Writing extract output to file: XXXXXXFDMEE\EPM_Agent\EPMAgent\appdata\data\120.dat
May-19 17:25:59:616 :: --------------- Completed execution for sessionId:120 ---------------
May-19 17:25:59:618 :: --------------- Executing Custom Event :AftExtract ---------------
May-19 17:25:59:620 :: --------------- Executing Custom Event :BefUpload ---------------
May-19 17:25:59:622 :: Commencing file upload to cloud for file:XXXXXXFDMEE\EPM_Agent\EPMAgent\appdata\data\120.dat
May-19 17:26:00:558 :: File Upload successfully complete
May-19 17:26:00:559 :: --------------- Executing Custom Event :AftUpload ---------------
May-19 17:26:01:589 :: Commencing file upload of log file:XXXXXXFDMEE\EPM_Agent\EPMAgent\appdata\logs\120.log
2020-05-19 11:56:08,340 INFO [AIF]: Appending EPM agent log to process:: END
2020-05-19 11:56:08,340 INFO [AIF]: Renaming and moving data file: BEGIN
2020-05-19 11:56:08,341 INFO [AIF]: Data file moved to data folder.
2020-05-19 11:56:08,341 INFO [AIF]: Renaming and moving data file: END
2020-05-19 11:56:08,343 INFO [AIF]: Balance rules updated successfully
2020-05-19 11:56:08,347 INFO [AIF]: ************************************************************************************
2020-05-19 11:56:08,348 INFO [AIF]: *On Prem DB Extract: Completed *
2020-05-19 11:56:08,348 INFO [AIF]: ************************************************************************************
2020-05-19 11:56:08,394 INFO [AIF]: File Name: DMTEST_DATA_120.dat
2020-05-19 11:56:08,493 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:IMPGROUPFILETYPE::120;39:4:4:[NONE]::MULTIPER
2020-05-19 11:56:08,493 INFO [AIF]: EPMFDM-140274:Message - Method - getUser
2020-05-19 11:56:08,494 INFO [AIF]: EPMFDM-140274:Message - Method - getUser
2020-05-19 11:56:08,494 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
2020-05-19 11:56:08,495 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start
2020-05-19 11:56:08,570 ERROR [AIF]: EPMFDM-140274:Message - null
2020-05-19 11:56:08,572 ERROR [AIF]: EPMFDM-140274:Message - null
2020-05-19 11:56:08,575 ERROR [AIF]: Unexpected error: <type 'java.lang.RuntimeException'>
java.lang.RuntimeException
2020-05-19 11:56:08,575 FATAL [AIF]: Error in FileData.importData
Traceback (most recent call last):
File "<string>", line 96, in importData
RuntimeException: java.lang.RuntimeException
2020-05-19 11:56:08,636 FATAL [AIF]: Error in File Import Data
2020-05-19 11:56:08,639 INFO [AIF]: FDMEE Process End, Process ID: 120