Clear Invalid Records Time Out

<p>&nbsp;</p> <table style="font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px; table-layout: fixed;" border="0" summary="" width="100%" cellspacing="0" cellpadding="0"> <tbody> <tr> <td valign="top"> <div id="kmPgTpl:psl1::c" style="overflow: hidden;"> <div id="kmPgTpl:r1" class="xpg"> <div id="kmPgTpl:r1:0:docMainPanel" class="x1a"> <div id="kmPgTpl:r1:0:psl1" class="p_AFHoverTarget xpj kmDocBorderExternal xpf" style="position: static; width: auto; height: auto; overflow: visible; margin-left: 0px; margin-right: 0px; box-sizing: border-box;"> <div id="kmPgTpl:r1:0:psl1::t" style="position: relative; overflow: hidden; width: 1898px;"> <div id="kmPgTpl:r1:0:pgl14" class="x1a"> <div><img id="kmPgTpl:r1:0:s111" src="https://concentric-solutions-ltd.kayako.com/media/url/gLIBKuYU593rqoxUkjUVCOaErQoUuIwn" alt="" width="10" height="5" /></div> <div> <table id="kmPgTpl:r1:0:Headpgl" class="x1a" border="0" summary="" cellspacing="0" cellpadding="0"> <tbody> <tr> <td>&nbsp;</td> </tr> </tbody> </table> </div> <div> <table id="kmPgTpl:r1:0:tl5" border="0" summary="" width="100%" cellspacing="0" cellpadding="0"> <tbody> <tr id="kmPgTpl:r1:0:rl12"> <td id="kmPgTpl:r1:0:cf41" align="left" width="10"><a id="kmPgTpl:r1:0:cil4" class="xfd" style="font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px; white-space: nowrap; text-decoration: none;" title="Click to add to Favorites" href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=555328875335418&parent=SrDetailText&sourceId=3-12763112921&id=945466.1&_afrWindowMode=0&_adf.ctrl-state=5uy8qouow_118#"><img id="kmPgTpl:r1:0:cil4::icon" class="x137" style="border: none; vertical-align: middle; display: inline;" title="Click to add to Favorites" src="https://concentric-solutions-ltd.kayako.com/media/url/hrpp83dnxYAHAo79Tn5GHQIQROQjxhbX" alt="Click to add to Favorites" /></a><span id="kmPgTpl:r1:0:pglhts1" class="x1a"><span id="kmPgTpl:r1:0:sug1:pglcl" class="x1a"></span></span><span id="kmPgTpl:r1:0:sug2:pglcl" class="x1a"></span></td> <td id="kmPgTpl:r1:0:cf40" width="10"><img id="kmPgTpl:r1:0:s13" src="https://concentric-solutions-ltd.kayako.com/media/url/gLIBKuYU593rqoxUkjUVCOaErQoUuIwn" alt="" width="10" height="10" /></td> <td id="kmPgTpl:r1:0:cf49" align="left"><span id="kmPgTpl:r1:0:ol22" class="xq" style="font-family: Tahoma, Verdana, Helvetica, sans-serif; text-align: right; color: black; padding: 0px 6px 0px 0px; font-weight: bold;"><label>"Delete Invalid Records" process fails with "unknown error has occurred in the HsvDSData2 object" (Doc ID 945466.1)</label></span></td> <td id="kmPgTpl:r1:0:cf48" align="right"><a id="kmPgTpl:r1:0:toBottom" class="xfd" style="font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px; white-space: nowrap; text-decoration: none;" title="To Bottom" href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=555328875335418&parent=SrDetailText&sourceId=3-12763112921&id=945466.1&_afrWindowMode=0&_adf.ctrl-state=5uy8qouow_118#"><img id="kmPgTpl:r1:0:toBottom::icon" class="x137" style="border: none; vertical-align: middle; display: inline;" title="To Bottom" src="https://concentric-solutions-ltd.kayako.com/media/url/0gZjUUEt4Vfo6VP7ZSYuXjddxPtl46gr" alt="To Bottom" /><span class="x133" style="color: #003286; margin-left: 3px;">To Bottom</span></a></td> <td id="kmPgTpl:r1:0:cf50"><img id="kmPgTpl:r1:0:s6" src="https://concentric-solutions-ltd.kayako.com/media/url/gLIBKuYU593rqoxUkjUVCOaErQoUuIwn" alt="" width="20" height="10" /></td> </tr> </tbody> </table> </div> <div><hr id="kmPgTpl:r1:0:s4" class="x1j" style="margin-top: 3px; margin-bottom: 3px; border-right-width: 0px; border-left-width: 0px; border-top-style: solid; border-top-color: #adb6c7; border-bottom-style: solid; border-bottom-color: #ffffff;" /></div> </div> </div> <div style="overflow: hidden;"> <div id="kmPgTpl:r1:0:psl1::c" style="overflow: hidden;"> <div id="kmPgTpl:r1:0:kmDocPanel" class="xpj x1a" style="margin-left: 0px; margin-right: 0px; box-sizing: border-box; width: 1898px; height: 1126px; overflow: auto;"> <div><img id="kmPgTpl:r1:0:s23" src="https://concentric-solutions-ltd.kayako.com/media/url/gLIBKuYU593rqoxUkjUVCOaErQoUuIwn" alt="" width="10" height="5" /></div> <div> <table id="kmPgTpl:r1:0:tl7" style="table-layout: fixed; overflow: hidden;" border="0" summary="" width="100%" cellspacing="0" cellpadding="0"> <tbody> <tr id="kmPgTpl:r1:0:rl14"> <td id="kmPgTpl:r1:0:cf54" style="overflow: hidden; vertical-align: top;"> <div id="kmPgTpl:r1:0:pgl25" class="x1a" style="overflow: auto;"> <p><strong>In this Document</strong></p> <table> <tbody> <tr> <td width="0">&nbsp;</td> <td><a href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=555328875335418&parent=SrDetailText&sourceId=3-12763112921&id=945466.1&_afrWindowMode=0&_adf.ctrl-state=5uy8qouow_118#SYMPTOM">Symptoms</a></td> </tr> </tbody> </table> <table> <tbody> <tr> <td width="0">&nbsp;</td> <td><a href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=555328875335418&parent=SrDetailText&sourceId=3-12763112921&id=945466.1&_afrWindowMode=0&_adf.ctrl-state=5uy8qouow_118#CHANGE">Changes</a></td> </tr> </tbody> </table> <table> <tbody> <tr> <td width="0">&nbsp;</td> <td><a href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=555328875335418&parent=SrDetailText&sourceId=3-12763112921&id=945466.1&_afrWindowMode=0&_adf.ctrl-state=5uy8qouow_118#CAUSE">Cause</a></td> </tr> </tbody> </table> <table> <tbody> <tr> <td width="0">&nbsp;</td> <td><a href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=555328875335418&parent=SrDetailText&sourceId=3-12763112921&id=945466.1&_afrWindowMode=0&_adf.ctrl-state=5uy8qouow_118#FIX">Solution</a></td> </tr> </tbody> </table> <table> <tbody> <tr> <td width="0">&nbsp;</td> <td><a href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=555328875335418&parent=SrDetailText&sourceId=3-12763112921&id=945466.1&_afrWindowMode=0&_adf.ctrl-state=5uy8qouow_118#REF">References</a></td> </tr> </tbody> </table> <hr size="1" /> <p>&nbsp;</p> <h2 class="km" style="font-family: Arial, Helvetica, sans-serif; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #c4d1e6; font-size: 16px; background-color: #777773; color: #ffffff; text-transform: uppercase; padding-top: 6px; padding-bottom: 6px; padding-left: 8px;">APPLIES TO:&nbsp;</h2> <span class="kmContent" style="font-size: small; color: black;"><span class="kmContent" style="font-size: small; color: black;">Hyperion Financial Management - Version 9.2.0.1.00 to 11.1.2.3.702 [Release 9.2 to 11.1]<br />Information in this document applies to any platform.<br /></span></span> <h2 class="km" style="font-family: Arial, Helvetica, sans-serif; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #c4d1e6; font-size: 16px; background-color: #777773; color: #ffffff; text-transform: uppercase; padding-top: 6px; padding-bottom: 6px; padding-left: 8px;"><a name="SYMPTOM"></a>SYMPTOMS</h2> <p><em>Delete Invalid Records</em>&nbsp;does not complete.&nbsp;<br />HsvEventLog.log contains errors like this:</p> <div class="kmcodeblock" style="overflow: auto; border: 1px solid #c4d1e6; padding: 0.5em; margin: 5px 0px 0px; font-family: 'Courier New', Courier, monospace; font-size: 12px; background-color: #e0eaf1; width: 1425.9375px;">&lt;num HEX=0x80041E80>-2147213696</Num><br />&lt;description Src=HFM>An unknown error has occurred in the HsvDSData2 object </Description><br />&lt;type>1</Type><br />&lt;dtime>8/18/2009 4:39:20 PM</DTime><br />&lt;svr>...</Svr><br /><File>CHsvDSData2RefInt.cpp</File><br /><Line>2610</Line><br /><Ver>9.2.1.0.2143</Ver></div> <h2 class="km" style="font-family: Arial, Helvetica, sans-serif; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #c4d1e6; font-size: 16px; background-color: #777773; color: #ffffff; text-transform: uppercase; padding-top: 6px; padding-bottom: 6px; padding-left: 8px;"><a name="CHANGE"></a>CHANGES</h2> <p>This is usually observed when big changes are implemented in metadata, resulting in great numbers of records becoming invalid. It is very likely to appear after deleting an entire Scenario, for example.</p> <h2 class="km" style="font-family: Arial, Helvetica, sans-serif; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #c4d1e6; font-size: 16px; background-color: #777773; color: #ffffff; text-transform: uppercase; padding-top: 6px; padding-bottom: 6px; padding-left: 8px;"><a name="CAUSE"></a>CAUSE</h2> <p>The process heavily relies on database performance. As soon as the database cannot keep up with requests from the application, the process is aborted. There appears to be less tolerance of database failures in this particular feature of FinancialManagement.<br />Database performance can be slow for a number of reasons (heavy usage, bad network, bad indexes etc) which are not covered in this note.</p> <h2 class="km" style="font-family: Arial, Helvetica, sans-serif; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #c4d1e6; font-size: 16px; background-color: #777773; color: #ffffff; text-transform: uppercase; padding-top: 6px; padding-bottom: 6px; padding-left: 8px;"><a name="FIX"></a>SOLUTION</h2> <p>The process will completes as long as you set the&nbsp;<em>SQLCommandTimeout</em>&nbsp;to a high enough value, for example 240.&nbsp;<br /><br />You can change this value on the FinancialManagement application server under Windows registry key&nbsp;<em>HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Hyperion Financial Management\Server</em>. Create a DWORD called&nbsp;<em>SQLCommandTimeout</em>&nbsp;if not there already. Reboot the application server after the change.<br /><br />This value may not be optimal for day-to-day operations of Financial Management. Unless you are also experiencing other issues / errors related to slow database performance, it is recommended to revert back to the original value (or delete the parameter) after a successful run of&nbsp;<em>Delete Invalid Records</em>.<br /><br />Please make sure a full backup of the registry exists.</p> </div> </td> </tr> </tbody> </table> </div> </div> </div> </div> </div> </div> </div> </div> </td> </tr> </tbody> </table>