Skip to Main Content

EPM agent--Import Format Failing

User_F9M0XMay 19 2020 — edited May 19 2020

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

Comments