When we go into the General Overview > Project Dashboard, the Project Manager Schedule Dashboard Portlet is only showing a red 'Error' message. No other error message details are seen on the page. In the application log file, a more descriptive error message is shown:
ERROR 2012-06-11 18:15:08,306 [http-14001-29] dal.NSQLClient
Unable to retrieve NSQL cube. NSQLException was thrown.
SQL error code: 1476
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01476: divisor is equal to zero
ORA-06512: at "CLARITY.COP_DAYS_LATE_PCT_FCT", line 56
NPT-0103: Error when trying to execute the query. Native message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered.
Here is one use-case reported by a customer that seems to generate this error message.
Steps to Reproduce:
Expected Result: The portlet should display the project data without any errors
Actual Result: The portlet does not display project data and shows an error message
Contact CA Technical Support for a workaround to implement an update to the database function on the portlet. Reference PMO-870.
This issue is documented as PMO-870 and is resolved in PMO 3.1
Keywords: CLARITYKB, PMO-870, clarity13resolved, pmo31resolved.