Forum Stats

  • 3,758,404 Users
  • 2,251,383 Discussions
  • 7,870,182 Comments

Discussions

FDM failures - Need Help !!

1065274
1065274 Member Posts: 12
edited Dec 12, 2014 7:56AM in Financial Consolidation

Hi,

We are loading data into HFM from EBS via ERPI-FDM stack. We have noticed a peculiar problem yesterday as the load of data into HFM took very long and on inspection we found that EBS-to-ERPI load was normal, ERPI-to-FDM load was normal but FDM-to-HFM load encountered some intersection errors / exceptions . As the errors/exceptions are not very descriptive and specific we need experts to help us in identifying the causes for the errors/exceptions.Appreciate your valuable inputs in this regard. Thanks !!

XML Log:

<?xml version="1.0"?>

<validationReport name="Intersection Validation" time="12/9/2014 3:32:33 PM">

  <location name="Location">WAG-EBS</location>

  <globalDimensions name="Global Dimensions:">

  <scenario name="Scenario">MGTVIEW</scenario><period name="Period">Nov</period><year name="Year">2015</year><view name="View">YTD</view></globalDimensions>

  <cellStatusLegend name="Cell Status:">

  <status1>Invalid Member</status1><status2>Invalid Intersection</status2><status3>Cannot Write</status3><status4>Locked Intersection</status4></cellStatusLegend>

  <details name="Detail Dimensions:"><columnalias><column1>FM Entity</column1><column2>FM Account</column2><column3>ICP</column3><column4>LineBusiness</column4><column5>Department</column5><column6>ReportingType</column6><column7>CashFlow</column7><column8>Data Value</column8><column9>Amount</column9></columnalias></details><validmembers name="Valid Members"><columnalias><column1>ICP</column1><column2>LineBusiness</column2><column3>Department</column3><column4>ReportingType</column4><column5>CashFlow</column5></columnalias><icpmembers/><c1members/><c2members/><c3members/><c4members/></validmembers></validationReport>

FDM Error:

** Begin fdmFM11XG6A Runtime Error Log Entry [2014-12-09-16:00:32] **

-------------------------------------------------------------

Error:

Code............-2147023170

Description.....3.2.6 - 63172 - System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

   at HSVSESSIONLib.IHsvSession.get_Data()

   at fdmFM11XG6A.clsFMAdapter.fIntersectionCheckXML(Object& vaData, String strScenario, String strPeriod, String strYear, String strView, Object arrValue, String strFilePath, String strWebServer, Boolean bolSSL, String strAcctAlias, String strEntAlias, String strICPAlias, String strC1Alias, String strC2Alias, Object& arrCustoms, Int16 intPage, Int16 intPC, Boolean blnNoCheckICP)

Procedure.......clsHPDataAccess.fIntersectionCheckXML

Component.......D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents\Adapters\AdapterComponents\fdmFM11XG6A\fdmFM11XG6A.dll

Version.........1116

Identification:

User............admin

Computer Name...HYP-S8NL-1P

FINANCIAL MANAGEMENT Connection:

App Name........

Cluster Name....

Domain............

Connect Status.... Connection Open

** Begin FDM Runtime Error Log Entry [2014-12-09 16:00:35] **

-------------------------------------------------------------

ERROR:

Code............................................. -2146233088

Description...................................... 3.2.6 - 63172 - System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

   at HSVSESSIONLib.IHsvSession.get_Data()

   at fdmFM11XG6A.clsFMAdapter.fIntersectionCheckXML(Object& vaData, String strScenario, String strPeriod, String strYear, String strView, Object arrValue, String strFilePath, String strWebServer, Boolean bolSSL, String strAcctAlias, String strEntAlias, String strICPAlias, String strC1Alias, String strC2Alias, Object& arrCustoms, Int16 intPage, Int16 intPC, Boolean blnNoCheckICP)

At Line: 218

Procedure........................................ clsBlockProcessor.ActCheckIntersections

Component........................................ upsWBlockProcessorDM

Version.......................................... 1112

Thread........................................... 10004

IDENTIFICATION:

User............................................. admin

Computer Name.................................... HYP-S8NL-1P

App Name......................................... WAGFDM

Client App....................................... BatchEngine

CONNECTION:

Provider......................................... ORAOLEDB.ORACLE

Data Server......................................

Database Name.................................... PFDMDB1

Trusted Connect.................................. False

Connect Status.. Connection Open

GLOBALS:

Location......................................... WAG-EBS

Location ID...................................... 758

Location Seg..................................... 12

Category......................................... MGTVIEW

Category ID...................................... 16

Period........................................... 2015-03

Period ID........................................ 11/30/2014

POV Local........................................ False

Language......................................... 1033

User Level....................................... 1

All Partitions................................... True

Is Auditor....................................... False

** Begin FDM Runtime Error Log Entry [2014-12-09 16:00:37] **

-------------------------------------------------------------

ERROR:

Code............................................. -2146233088

Description...................................... 3.2.6 - 63172 - System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

   at HSVSESSIONLib.IHsvSession.get_Data()

   at fdmFM11XG6A.clsFMAdapter.fIntersectionCheckXML(Object& vaData, String strScenario, String strPeriod, String strYear, String strView, Object arrValue, String strFilePath, String strWebServer, Boolean bolSSL, String strAcctAlias, String strEntAlias, String strICPAlias, String strC1Alias, String strC2Alias, Object& arrCustoms, Int16 intPage, Int16 intPC, Boolean blnNoCheckICP)

At Line: 218

Procedure........................................ clsEventHandler.PobjAPI_BPCheckIntersections

Component........................................ upsWObjEventHandlerDM

Version.......................................... 1112

Thread........................................... 10004

IDENTIFICATION:

User............................................. admin

Computer Name.................................... HYP-S8NL-1P

App Name......................................... WAGFDM

Client App....................................... BatchEngine

CONNECTION:

Provider......................................... ORAOLEDB.ORACLE

Data Server......................................

Database Name.................................... PFDMDB1

Trusted Connect.................................. False

Connect Status.. Connection Open

GLOBALS:

Location......................................... WAG-EBS

Location ID...................................... 758

Location Seg..................................... 12

Category......................................... MGTVIEW

Category ID...................................... 16

Period........................................... 2015-03

Period ID........................................ 11/30/2014

POV Local........................................ False

Language......................................... 1033

User Level....................................... 1

All Partitions................................... True

Is Auditor....................................... False

** Begin FDM Runtime Error Log Entry [2014-12-09 16:00:37] **

-------------------------------------------------------------

ERROR:

Code............................................. 440

Description...................................... Automation error

Procedure........................................ clsValidationMgr.fValidate

Component........................................ upsWObjectsDM

Version.......................................... 1112

Thread........................................... 10004

IDENTIFICATION:

User............................................. admin

Computer Name.................................... HYP-S8NL-1P

App Name......................................... WAGFDM

Client App....................................... BatchEngine

CONNECTION:

Provider......................................... ORAOLEDB.ORACLE

Data Server......................................

Database Name.................................... PFDMDB1

Trusted Connect.................................. False

Connect Status.. Connection Open

GLOBALS:

Location......................................... WAG-EBS

Location ID...................................... 758

Location Seg..................................... 12

Category......................................... MGTVIEW

Category ID...................................... 16

Period........................................... 2015-03

Period ID........................................ 11/30/2014

POV Local........................................ False

Language......................................... 1033

User Level....................................... 1

All Partitions................................... True

Is Auditor....................................... False

** Begin FDM Runtime Error Log Entry [2014-12-09 16:00:37] **

-------------------------------------------------------------

ERROR:

Code............................................. 440

Description...................................... File [2_WAG-EBS_MGTVIEW_2015-03_RR.txt] Caused Error: (Automation error)

Procedure........................................ clsBatchLoader.mFileCollectionProcess

Component........................................ upsWBatchLoaderDM

Version.......................................... 1112

Thread........................................... 9456

IDENTIFICATION:

User............................................. admin

Computer Name.................................... HYP-S8NL-1P

App Name......................................... WAGFDM

Client App....................................... WebClient

CONNECTION:

Provider......................................... ORAOLEDB.ORACLE

Data Server......................................

Database Name.................................... PFDMDB1

Trusted Connect.................................. False

Connect Status.. Connection Open

GLOBALS:

Location......................................... WAG-EBS

Location ID...................................... 758

Location Seg..................................... 12

Category......................................... MGTVIEW

Category ID...................................... 16

Period........................................... 2015-03

Period ID........................................ 11/30/2014

POV Local........................................ False

Language......................................... 1033

User Level....................................... 1

All Partitions................................... True

Is Auditor....................................... False

Regards,
Sathish

Tagged:

Answers

  • 1065274
    1065274 Member Posts: 12

    Doesnt anyone have any clue at all ? SUrprising to know that we are the first one to have experienced this.


    Regards,
    Sathish

  • JTF85
    JTF85 Member Posts: 268

    It sounds as if the mapping is trying to load something to an invalid intersection in HFM, can you run through the validate fish in one of the offending periods manually in FDM?  This will display the validation report (Since you are getting this error intersection validation must be enabled).  Once you receive the validation report, it will highlight which intersections are the problems.

    Regards

    JTF

This discussion has been closed.