Forum Stats

  • 3,769,391 Users
  • 2,252,961 Discussions
  • 7,875,015 Comments

Discussions

Data Integration with Fusion

AbanoubZaki
AbanoubZaki Member Posts: 144 Red Ribbon
edited Jul 29, 2019 12:05PM in Financial Data Management

Dears,

I have created a connection with fusion and when i test connection it gives "Connection Successful" then configure, but when I initialize it took much time in running

as per the below screenshot

54e707f9-4246-4f70-acdc-647281322080.jpg

Is there a reason for it?

Answers

  • Abdul-Oracle
    Abdul-Oracle Member Posts: 89 Employee
    edited Jul 29, 2019 6:03AM

    You could check the logs to see what is logged in the process log..just click on the show to view the logs

    Abdul

  • AbanoubZaki
    AbanoubZaki Member Posts: 144 Red Ribbon
    edited Jul 29, 2019 6:14AM

    Please check the below:

    2019-07-29 08:55:28,927 INFO  [AIF]: FDMEE Process: 261, Log Level: 4

    2019-07-29 08:55:28,928 INFO  [AIF]: Location     : NA (Partitionkey:null)

    2019-07-29 08:55:28,928 INFO  [AIF]: Period Name  : NA (Period Key:null)

    2019-07-29 08:55:28,928 INFO  [AIF]: Category Name: NA (Category key:null)

    2019-07-29 08:55:28,928 INFO  [AIF]: Rule Name    : NA (Rule ID:null)

    2019-07-29 08:55:44,061 INFO  [AIF]: FDM Version: 11.1.2.4.230

    2019-07-29 08:55:44,062 INFO  [AIF]: Log File Encoding: UTF-8

    2019-07-29 08:55:45,107 INFO  [AIF]: initializeFsGLCloudSource - START

    2019-07-29 08:55:45,231 WARN  [AIF]: No details found in loads table for Loadid:261

    2019-07-29 08:55:45,232 WARN  [AIF]: Query:SELECT AIF_BALANCE_RULES.RULE_ID,

    AIF_BALANCE_RULES.RULE_NAME,

    AIF_BAL_RULE_LOADS.START_PERIODKEY,

    AIF_BAL_RULE_LOADS.END_PERIODKEY,

    AIF_BAL_RULE_LOADS.PLAN_TYPE,

    AIF_BAL_RULE_LOADS.FILE_NAME_STATIC,

    AIF_BAL_RULE_LOADS.FILE_PATH,

    AIF_BAL_RULE_LOADS.IMPORT_FROM_SOURCE_FLAG,

    AIF_BAL_RULE_LOADS.EXPORT_TO_TARGET_FLAG,

    AIF_BAL_RULE_LOADS.EXECUTION_MODE,

    AIF_BAL_RULE_LOADS.EXPORT_MODE,

    AIF_BAL_RULE_LOADS.CATKEY,

    TPOVCATEGORY.CATNAME

    FROM AIF_BAL_RULE_LOADS JOIN

    AIF_BALANCE_RULES ON

    AIF_BAL_RULE_LOADS.RULE_ID = AIF_BALANCE_RULES.RULE_ID

    JOIN TPOVCATEGORY ON

    TPOVCATEGORY.CATKEY = AIF_BAL_RULE_LOADS.CATKEY

    WHERE AIF_BAL_RULE_LOADS.LOADID = ?

    2019-07-29 08:55:45,232 WARN  [AIF]: Query bind:261

    2019-07-29 08:55:45,235 WARN  [AIF]: No details found in partition table for partitionkey:null

    2019-07-29 08:55:45,235 WARN  [AIF]: Query:SELECT

    TPOVPARTITION.PARTNAME,

    TPOVPARTITION.PARTIMPGROUP,

    TPOVPARTITION.PARTTARGETAPPLICATIONID,

    TPOVPARTITION.PARTSOURCESYSTEMID

    FROM TPOVPARTITION

    WHERE PARTITIONKEY = ?

    2019-07-29 08:55:45,235 WARN  [AIF]: Query bind:null

    2019-07-29 08:55:45,238 WARN  [AIF]: No details found in applications table for APPID:null

    2019-07-29 08:55:45,238 WARN  [AIF]: Query:SELECT AIF_TARGET_APPLICATIONS.APPLICATION_NAME,

    AIF_TARGET_APPLICATIONS.TARGET_APPLICATION_NAME,

    AIF_TARGET_APPLICATIONS.ESSBASE_DB_NAME,

    AIF_TARGET_APPLICATIONS.TARGET_APPLICATION_TYPE,

    AIF_TARGET_APPLICATIONS.APPLICATION_ID,

    AIF_TARGET_APPLICATIONS.DATA_LOAD_METHOD

    FROM AIF_TARGET_APPLICATIONS WHERE APPLICATION_ID = ?

    2019-07-29 08:55:45,238 WARN  [AIF]: Query bind:null

    2019-07-29 08:55:45,241 WARN  [AIF]: No details found in source table for sourceID:null

    2019-07-29 08:55:45,241 WARN  [AIF]: Query:SELECT  AIF_SOURCE_SYSTEMS.SOURCE_SYSTEM_TYPE,

    AIF_SOURCE_SYSTEMS.SOURCE_SYSTEM_NAME

    FROM AIF_SOURCE_SYSTEMS WHERE

    AIF_SOURCE_SYSTEMS.SOURCE_SYSTEM_ID = ?

    2019-07-29 08:55:45,241 WARN  [AIF]: Query bind:null

    2019-07-29 08:55:45,247 WARN  [AIF]: No details found in periods table for period Key:null

    2019-07-29 08:55:45,247 WARN  [AIF]: Query:SELECT TPOVPERIOD.PERIODDESC FROM TPOVPERIOD WHERE PERIODKEY = ?

    2019-07-29 08:55:45,247 WARN  [AIF]: Query bind:null

    2019-07-29 08:55:45,283 INFO  [AIF]: Executing the following script: /u01/test/PBCS_19.07.62/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py

    2019-07-29 08:55:45,297 INFO  [AIF]: FusionCloudAdapter.extractCubeInformation - START

    2019-07-29 08:55:45,298 INFO  [AIF]: FusionCloudAdapter.fusionCloudHelper - START

    2019.07.29.08.55.47.676 INFO  [AIF]: Starting FusionAdapter main program...

    2019.07.29.08.55.47.682 INFO  [AIF]: fusionIntegrationType: V2

    2019.07.29.08.55.47.685 INFO  [AIF]: fusionGlWebServiceWsdl: https://ehxm.fa.us6.oraclecloud.com/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL

    2019.07.29.08.55.47.685 INFO  [AIF]: fusionGlWebServiceUser: fin_impl

    2019.07.29.08.55.47.691 INFO  [AIF]: batchTimeoutInMinutes: 30

    2019.07.29.08.55.47.691 INFO  [AIF]: fusionProductType: null

    2019.07.29.08.55.52.253 INFO  [AIF]: FusionAdapter initialized fine.

    2019.07.29.08.55.52.253 INFO  [AIF]: fusionAdapter.processRuleType: null

    2019.07.29.08.56.16.467 INFO  [AIF]: Submitted request to extract cube information, Ess request: 15645840

    2019.07.29.08.56.17.072 INFO  [AIF]: Current polled request status is: WAIT

    2019.07.29.08.56.32.555 INFO  [AIF]: Current polled request status is: RUNNING

    2019.07.29.08.56.48.084 INFO  [AIF]: Current polled request status is: RUNNING

    2019.07.29.08.57.03.787 INFO  [AIF]: Current polled request status is: SUCCEEDED

    2019.07.29.08.57.03.788 INFO  [AIF]: Ess request has completed fine.

    2019.07.29.09.01.06.475 INFO  [AIF]: Could not download files, attempt: 1

    2019.07.29.09.05.24.828 INFO  [AIF]: Could not download files, attempt: 2

    2019.07.29.09.09.45.683 INFO  [AIF]: Could not download files, attempt: 3

    2019.07.29.09.14.04.092 INFO  [AIF]: Could not download files, attempt: 4

    2019.07.29.09.18.22.618 INFO  [AIF]: Could not download files, attempt: 5

    2019.07.29.09.22.43.750 INFO  [AIF]: Could not download files, attempt: 6

    2019.07.29.09.27.01.107 INFO  [AIF]: Could not download files, attempt: 7

  • WPaffhausen
    WPaffhausen Member Posts: 412
    edited Jul 29, 2019 7:29AM

    Hello AbanoubZaki,

    Please clarify what you mean by it took too much time?  Time is a measure of performance and patience of an individual.  Did the process complete?  The log you have provided is not 100% and the step you show on the screen is still "in progress".

    So my questions are:

    1.  Did it ever complete?  If so, please provide the logs.

    2.  How long did it take to complete?  What are your expectations?

    Thank you,

    Wayne

  • AbanoubZaki
    AbanoubZaki Member Posts: 144 Red Ribbon
    edited Jul 29, 2019 7:56AM

    It didn't complete before, and it takes much time as it was running for about 2 days and i used to kill it.

  • Rajesh CP-Oracle
    Rajesh CP-Oracle Posts: 102 Employee
    edited Jul 29, 2019 12:05PM

    Please check the Fusion UI job details for the ess request. If it does not helps then reset the current process and recreate the source system.

  • User_T58G2
    User_T58G2 Member Posts: 2 Red Ribbon

    I am facing same problem

    2021-10-14 11:46:59,566 INFO [AIF]: FDMEE Process: 106, Log Level: 4

    2021-10-14 11:46:59,566 INFO [AIF]: Location   : NA (Partitionkey:null)

    2021-10-14 11:46:59,566 INFO [AIF]: Period Name : NA (Period Key:null)

    2021-10-14 11:46:59,566 INFO [AIF]: Category Name: NA (Category key:null)

    2021-10-14 11:46:59,566 INFO [AIF]: Rule Name  : NA (Rule ID:null)

    2021-10-14 11:47:00,486 INFO [AIF]: Log File Encoding: UTF-8

    2021-10-14 11:47:00,848 INFO [AIF]: initializeFsGLCloudSource - START

    2021-10-14 11:47:00,876 WARN [AIF]: No details found in loads table for Loadid:106

    2021-10-14 11:47:00,876 WARN [AIF]: Query:SELECT AIF_BALANCE_RULES.RULE_ID,

     AIF_BALANCE_RULES.RULE_NAME,

     AIF_BAL_RULE_LOADS.START_PERIODKEY,

     AIF_BAL_RULE_LOADS.END_PERIODKEY,

     AIF_BAL_RULE_LOADS.PLAN_TYPE,

     AIF_BAL_RULE_LOADS.FILE_NAME_STATIC,

     AIF_BAL_RULE_LOADS.FILE_PATH,

     AIF_BAL_RULE_LOADS.IMPORT_FROM_SOURCE_FLAG,

     AIF_BAL_RULE_LOADS.EXPORT_TO_TARGET_FLAG,

     AIF_BAL_RULE_LOADS.EXECUTION_MODE,

     AIF_BAL_RULE_LOADS.EXPORT_MODE,

     AIF_BAL_RULE_LOADS.CATKEY,

     TPOVCATEGORY.CATNAME

     FROM AIF_BAL_RULE_LOADS JOIN

     AIF_BALANCE_RULES ON

     AIF_BAL_RULE_LOADS.RULE_ID = AIF_BALANCE_RULES.RULE_ID

     JOIN TPOVCATEGORY ON

     TPOVCATEGORY.CATKEY = AIF_BAL_RULE_LOADS.CATKEY

     WHERE AIF_BAL_RULE_LOADS.LOADID = ?

    2021-10-14 11:47:00,876 WARN [AIF]: Query bind:106

    2021-10-14 11:47:00,876 WARN [AIF]: No details found in partition table for partitionkey:null

    2021-10-14 11:47:00,876 WARN [AIF]: Query:SELECT

     TPOVPARTITION.PARTNAME,

     TPOVPARTITION.PARTIMPGROUP,

     TPOVPARTITION.PARTTARGETAPPLICATIONID,

     TPOVPARTITION.PARTSOURCESYSTEMID

     FROM TPOVPARTITION

     WHERE PARTITIONKEY = ?

    2021-10-14 11:47:00,876 WARN [AIF]: Query bind:null

    2021-10-14 11:47:00,877 WARN [AIF]: No details found in applications table for APPID:null

    2021-10-14 11:47:00,877 WARN [AIF]: Query:SELECT AIF_TARGET_APPLICATIONS.APPLICATION_NAME,


     AIF_TARGET_APPLICATIONS.TARGET_APPLICATION_NAME,


     AIF_TARGET_APPLICATIONS.ESSBASE_DB_NAME,


     AIF_TARGET_APPLICATIONS.TARGET_APPLICATION_TYPE,


     AIF_TARGET_APPLICATIONS.APPLICATION_ID,


     AIF_TARGET_APPLICATIONS.DATA_LOAD_METHOD


     FROM AIF_TARGET_APPLICATIONS WHERE APPLICATION_ID = ?

    2021-10-14 11:47:00,877 WARN [AIF]: Query bind:null

    2021-10-14 11:47:00,877 WARN [AIF]: No details found in source table for sourceID:null

    2021-10-14 11:47:00,877 WARN [AIF]: Query:SELECT AIF_SOURCE_SYSTEMS.SOURCE_SYSTEM_TYPE,

     AIF_SOURCE_SYSTEMS.SOURCE_SYSTEM_NAME

     FROM AIF_SOURCE_SYSTEMS WHERE

     AIF_SOURCE_SYSTEMS.SOURCE_SYSTEM_ID = ?

    2021-10-14 11:47:00,877 WARN [AIF]: Query bind:null

    2021-10-14 11:47:00,883 INFO [AIF]: Starting FusionAdapter main program, executionMethod: extractCubeInformation

    2021-10-14 11:47:00,883 INFO  [AIF]: fusionGlRestUrl: https://fa-esev-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.17.08/erpintegrations

    2021-10-14 11:47:00,883 INFO [AIF]: fusionGlWebServiceUser: Casey.brown

    2021-10-14 11:47:00,884 INFO [AIF]: batchTimeoutInMinutes: 30

    2021-10-14 11:47:00,884 INFO [AIF]: FusionAdapter initialized fine.

    2021-10-14 11:47:00,884 INFO [AIF]: processRuleType: null

    2021-10-14 11:47:53,029 INFO [AIF]: Submitted request to extract cube information, Ess request: 3893017

    2021-10-14 11:48:02,137 INFO [AIF]: Current polled request status is: RUNNING

    2021-10-14 11:48:17,730 INFO [AIF]: Current polled request status is: ERROR

    2021-10-14 11:48:17,730 INFO [AIF]: Merging Ess request log with the process log, Ess request: 3893017

    2021-10-14 11:48:37,731 INFO [AIF]: Executing downloadFileFromUcmWithRetry, pNumberRetry=20, pRetryIntervalInSeconds=15

    2021-10-14 11:48:37,731 INFO [AIF]: Calling downloadESSJobExecutionDetails operation to download files from Fusion...

    2021-10-14 11:48:40,134 INFO [AIF]: Downloading zipped documentContent as individual files...

    2021-10-14 11:48:40,136 INFO [AIF]: Downloading file: 3893017.log

    2021-10-14 11:48:40,136 INFO [AIF]: downloadedLogFileFullName: 3893017.log

    2021-10-14 11:48:40,136 INFO [AIF]: -------------------------------------------------------- BEGIN: Process Log From the Ess Job --------------------------------------------------------

    2021-10-14 11:48:40,136 INFO [AIF]: ####[2021-10-14T11:48:03.024+00:00] [INFO] execute:Start( RequestExecutionContext requestExecutionContext = 3893017, false, null, CE3821BDD6BAB6B9E0534B64F00A9AA7, 12, 1

    2021-10-14 11:48:40,136 INFO [AIF]: Request for ExtractCubeInformation running with request ID: 3893017

    2021-10-14 11:48:40,136 INFO [AIF]: getOutputFile:Start  

    2021-10-14 11:48:40,136 INFO [AIF]: getOutputFile: Attempting to get LogFile from ProcessHelper 

    2021-10-14 11:48:40,136 INFO [AIF]: getOutputFile:End 

    2021-10-14 11:48:40,136 INFO [AIF]: -------------------------------------------------------

    2021-10-14 11:48:40,136 INFO [AIF]: isHarnessTest():: harness flag enable ? false

    2021-10-14 11:48:40,136 INFO [AIF]: ExtractCubeInformation:Error::getOlapserver() : Exception occured :: null

    2021-10-14 11:48:40,136 INFO [AIF]: ExtractCubeInformation:Info::Started of Extracting GL Cube Information at ::::: 1634212082988

    2021-10-14 11:48:40,136 INFO [AIF]: ExtractCubeInformation:Error::Could not connect to Essbase server

    2021-10-14 11:48:40,136 INFO [AIF]: ExtractCubeInformation:Info::End of Extracting GL Cube Information at ::::: 1634212082988

    2021-10-14 11:48:40,136 INFO [AIF]: ExtractCubeInformation:Error::Could not connect to Essbase server

    2021-10-14 11:48:40,136 INFO [AIF]: Request for ExtractCubeInformation completed with request ID: 3893017

    2021-10-14 11:48:40,137 INFO [AIF]: 

    2021-10-14 11:48:40,137 INFO [AIF]: --------------------------------------------------------- END: Process Log From the Ess Job ---------------------------------------------------------

    2021-10-14 11:48:40,141 INFO [AIF]: Deleting temporary file: 3893017.log

    2021-10-14 11:48:40,142 ERROR [AIF]: Error in initializeFsGLCloudSource. 

    2021-10-14 11:48:40,144 FATAL [AIF]: Error in initializeFsGLCloudSource

    Traceback (most recent call last):

     File "<string>", line 83, in initializeFsGLCloudSource

     File "<string>", line 487, in executeFusionService

    Exception: java.lang.Exception: Ess request has completed with errors.


    2021-10-14 11:48:40,345 INFO [AIF]: FDMEE Process End, Process ID: 106