Step 4 of Financial analysis Job fails (finannsummary_forecast) v2012
Symptoms
Step 4 of Financial analysis Job fails (finannsummary_forecast)
Error/warning messages:
Warning: The join order has been enforced because a local join hint is used. [SQLSTATE 01000] (Message 8625) Divide by zero error encountered [SQLSTATE 22012] (Error 8134) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed
Reason
Defect in version 2012
Resolution
General Patch 16.00.549.000 available through Client Portal fixes :
• Resolve the problem that FinAnnSummary job failed at step ‘FinAnnSummary_Forecast’ with the ‘Divide by Zero’ error.
• Optimize performance for FinAnnSummary job upon the completion of step ‘FinAnnSummary_Unbillable’.
• Resolve the problem that PopulateDemandAndCapacity job failed with ''Divide By Zero'' error.