Unable to open Fiscal Periods v2010
Symptoms
When selecting a new fiscal year under weekly fiscal periods a time out message appears.
Financial Setup -> Expand Fiscal Periods -> Expand Alloc Weekly -> Select the period
Error/warning messages
Active Server Pages error 'ASP 0113'
Reason
PFMetricData table was very large and the query could not finish prior to the ASP page timing out.
/finance/fiscalperiods/dcfiscalperiodsetup.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeour or by changing the value in the IIS administration tools
Resolution
Here is the SQL query that we used to create the index. Please note that this will take up a large amount of disk space and will take some time to apply it.
CREATE INDEX IX_PFMetricData_IPIPeriodId ON PFMetricData(IPIPeriodId)
Additional Notes
This only resolves the issue if the table PFMetricData is very large.