This discussion is archived
3 Replies Latest reply: Jul 12, 2013 6:05 AM by 851387 RSS

HFM Consolidation getting aborted at 40%

711039 Newbie
Currently Being Moderated
Hi,

We have updated a new rules file and while trying to consolidate, we found that the consolidation gettting aborted at 40% for legal (the changes done here).

I checked the HFMErrorlogviewer and found the below errors:
--------------------------------------------------
File: CHsvDSCalculate.cpp Version: 9.2.0.0.1380 Line: 10335 Error: (269441)(0x41C81)(Consolidation started.)
File: CHsvScriptEngine.cpp Version: 9.2.0.0.1380 Line: 352 Error: (-2147209278)(0x80042FC2)(Error executing VBScript Microsoft VBScript runtime error, Line 142.)
File: CHsvDSCalculate.cpp Version: 9.2.0.0.1380 Line: 2049 Error: (-2147209278)(0x80042FC2)(Error executing VBScript .)
File: CHsvDSCalculate.cpp Version: 9.2.0.0.1380 Line: 4304 Error: (-2147209278)(0x80042FC2)(Error executing VBScript .)
File: CHsvDSCalculate.cpp Version: 9.2.0.0.1380 Line: 4707 Error: (-2147209278)(0x80042FC2)(Error executing VBScript .)
File: CHsvDSCalculate.cpp Version: 9.2.0.0.1380 Line: 10542 Error: (-2147209278)(0x80042FC2)(Error executing VBScript .)
File: CHsvDSCalculate.cpp Version: 9.2.0.0.1380 Line: 10728 Error: (269442)(0x41C82)(Consolidation finished.)
File: CHsvCalculate.cpp Version: 9.2.0.0.1380 Line: 1416 Error: (-2147209278)(0x80042FC2)(Error executing VBScript .)
-----------------------------------------------------
<?xml version="1.0" ?>
<EStr>
<Ref>{4A1F70D6-36DA-40BB-8EDC-C420F5D06FCA}</Ref>
<User>HNCORP\C937482</User>
<DBUpdate>121847648</DBUpdate>
<ESec>
<Num HEX=0x41C81>269441</Num>
<Description Src=HFM>Consolidation started.</Description>
<Type>1</Type>
<DTime>8/17/2012 4:16:17 AM</DTime>
<Svr>RC-APPTST06</Svr>
<File>CHsvDSCalculate.cpp</File>
<Line>10335</Line>
<Ver>9.2.0.0.1380</Ver>
<DStr></DStr>
<ExErr></ExErr>
</ESec>
<ESec>
<Num HEX=0x80042FC2>-2147209278</Num>
<Description Src=HFM>Error executing VBScript Microsoft VBScript runtime error, Line 142.</Description>
<Type>1</Type>
<DTime>8/17/2012 4:16:19 AM</DTime>
<Svr>RC-APPTST06</Svr>
<File>CHsvScriptEngine.cpp</File>
<Line>352</Line>
<Ver>9.2.0.0.1380</Ver>
<DStr></DStr>
<ExErr></ExErr>
<PSec>
<Param>Microsoft VBScript runtime error, Line 142</Param>
</PSec>
</ESec>
<ESec>
<Num HEX=0x80042FC2>-2147209278</Num>
<Description Src=HFM>Error executing VBScript .</Description>
<Type>0</Type>
<DTime>8/17/2012 4:16:19 AM</DTime>
<Svr>RC-APPTST06</Svr>
<File>CHsvDSCalculate.cpp</File>
<Line>2049</Line>
<Ver>9.2.0.0.1380</Ver>
<DStr></DStr>
<ExErr></ExErr>
</ESec>
<ESec>
<Num HEX=0x80042FC2>-2147209278</Num>
<Description Src=HFM>Error executing VBScript .</Description>
<Type>0</Type>
<DTime>8/17/2012 4:16:19 AM</DTime>
<Svr>RC-APPTST06</Svr>
<File>CHsvDSCalculate.cpp</File>
<Line>4304</Line>
<Ver>9.2.0.0.1380</Ver>
<DStr></DStr>
<ExErr></ExErr>
</ESec>
<ESec>
<Num HEX=0x80042FC2>-2147209278</Num>
<Description Src=HFM>Error executing VBScript .</Description>
<Type>0</Type>
<DTime>8/17/2012 4:16:21 AM</DTime>
<Svr>RC-APPTST06</Svr>
<File>CHsvDSCalculate.cpp</File>
<Line>4707</Line>
<Ver>9.2.0.0.1380</Ver>
<DStr></DStr>
<ExErr></ExErr>
</ESec>
<ESec>
<Num HEX=0x80042FC2>-2147209278</Num>
<Description Src=HFM>Error executing VBScript .</Description>
<Type>0</Type>
<DTime>8/17/2012 4:16:21 AM</DTime>
<Svr>RC-APPTST06</Svr>
<File>CHsvDSCalculate.cpp</File>
<Line>10542</Line>
<Ver>9.2.0.0.1380</Ver>
<DStr></DStr>
<ExErr></ExErr>
</ESec>
<ESec>
<Num HEX=0x41C82>269442</Num>
<Description Src=HFM>Consolidation finished.</Description>
<Type>1</Type>
<DTime>8/17/2012 4:16:21 AM</DTime>
<Svr>RC-APPTST06</Svr>
<File>CHsvDSCalculate.cpp</File>
<Line>10728</Line>
<Ver>9.2.0.0.1380</Ver>
<DStr></DStr>
<ExErr></ExErr>
</ESec>
<ESec>
<Num HEX=0x80042FC2>-2147209278</Num>
<Description Src=HFM>Error executing VBScript .</Description>
<Type>0</Type>
<DTime>8/17/2012 4:16:21 AM</DTime>
<Svr>RC-APPTST06</Svr>
<File>CHsvCalculate.cpp</File>
<Line>1416</Line>
<Ver>9.2.0.0.1380</Ver>
<DStr></DStr>
<ExErr></ExErr>
</ESec>
</EStr>
------------------------------------------------------------------------------
While checking the rule line no 142, I found a function which I have used.Below is the function from rule file:


If pov_value = "<Entity Currency>" Then
               If ((pov_entity = "1500") and ((pov_year = "2012" and pov_period >=5) or pov_year > "2012")) then
                    RestructureAutoAdjustment 'line no 142
               End If
          End If
---------

This we have used as per the client requirement:

Sub RestructureAutoAdjustment (pov_entity)
vT3Rcl = HS.GetCell("E#1500.A#411000.I#[ICP None]")

     If (pov_entity = "1500") then
     ' Legal
     HS.Exp "E#1500.A#411000_511000_Rcl.I#[ICP None] = " & -vT3Rcl
     HS.Exp "E#1500.A#511000_411000_Rcl.I#[ICP None] = " & -vT3Rcl
     Elseif (pov_entity = "Adj_Div") then
     ' Division
     HS.Exp "E#Adj_Div.A#411000_511000_Rcl.I#[ICP None] = " & -vT3Rcl
     HS.Exp "E#Adj_Div.A#511000_411000_Rcl.I#[ICP None] = " & -vT3Rcl
     Elseif (pov_entity = "Adj_Gov_Contr_Seg") then
     'Segment
     HS.Exp "E#Adj_Gov_Contr_Seg.A#411000_511000_Rcl.I#[ICP None] = " & -vT3Rcl
     HS.Exp "E#Adj_Gov_Contr_Seg.A#511000_411000_Rcl.I#[ICP None] = " & -vT3Rcl
     End If

End Sub 'End RestructureAutoAdjustment

I humbly request you to help me to fix this issue asap.

Regards,
Ravi Shankar S
  • 1. Re: HFM Consolidation getting aborted at 40%
    beyerch2 Expert
    Currently Being Moderated
    The only thing that immediately jumps out at me is that I'd make sure the variable : vT3Rcl has a numeric value in it as you are attempting to multiple it by -1 in the subroutine.
  • 2. Re: HFM Consolidation getting aborted at 40%
    893832 Explorer
    Currently Being Moderated
    Instead of having:

    RestructureAutoAdjustment

    you should have:

    Call RestructureAutoAdjustment(pov_entity)

    Also, there are a number of issues with that subroutine:

    1. Specifying an entity on the left side of an Exp statement does not work. You can only write to the entity that is being calculated. In this case this rule is only allowed to run on entity '1500' so it will only write data to the entity. When data is needed from another entity and there is not parent-child relationship between them then the Sub Allocate should be used.

    2. You specify a single data value, vT3Rcl, on the right side of your Exp statement but you are not specifying any of the custom dimensions on the left side which means that rule will populate every valid member of every custom dimension with that data value for the accounts you specify. This is called a data explosion. You may be alright if the CustomTopMembers of those accounts are blank or specify [None] but if that is every changed this rule will cause an issue.
  • 3. Re: HFM Consolidation getting aborted at 40%
    851387 Newbie
    Currently Being Moderated

    Did you ever get this resolved?  We are having the exact same issue but we have not made any alterations to our rules file.  I noticed the rules were missing so I reloaded them but that's it.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points