Resolving an Insight error begins with isolating the issue. Errors such as "ORA-01476: divisor is equal to zero" usually occur due to an Insight calculation not liking particular data being passed through to the calculation.
Identify the Problem
Identify the problem by isolating the column causing the error. To isolate the error, we recommend the following steps.
Run the original report.
Save a copy of the report. This copy will be used to troubleshoot.
Using the copy of the original report, remove a calculation* column from the report, save, rerun the report making sure to refresh the data.
Repeat step 3. until the error no longer displays.
Once the error no longer displays, this confirms the last column removed as the cause of the issue.
Investigate the Data
Interrogate or review what data is returning for this column in relation to the error message.
e.g. A common cause of "ORA-01476: divisor is equal to zero" is that an employee incorrectly has a 0 entered for fte hours, contract hours or salary. The solution may be to update the employee's contract with the correct data OR add an NVL to the calculation.
*Unsure if it's a Calculation? Simply remove each column one-by-one, beginning with number columns.
Error Console
If still unsure, try using the Error Console for further assistance. To use the Error Console.
Run the original report until the error displays.
Select Actions.
Select Error Console.
Select the relevant error message based on Run Time and Run By.
Scroll down to see a more detailed error message.
Use the error message to further help troubleshoot the issue.
Note: the error message displays technical information which may require a Business or BI analyst to review. This information may also be shared with Customer Support.