Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.8K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Data Integration with Fusion

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
Is there a reason for it?
Answers
-
You could check the logs to see what is logged in the process log..just click on the show to view the logs
Abdul
-
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
-
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
-
It didn't complete before, and it takes much time as it was running for about 2 days and i used to kill it.
-
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.
-
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