3 Replies Latest reply: Jul 12, 2013 8:05 AM by 851387 RSS

    HFM Consolidation getting aborted at 40%

    711039
      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
          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%
            BMaguire
            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

              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.