Performance Analytics (Incident, Change and Problem Spotlight plugins)creating database view with u_incident_spotlight causing error in dashboard report : Cannot generate the report. Invalid table: incident_spotlight Invalid table: incident_spotlight - Known Error

Performance Analytics (Incident, Change and Problem Spotlight plugins)creating database view with u_incident_spotlight causing error in dashboard report : Cannot generate the report. Invalid table: incident_spotlight Invalid table: incident_spotlight Description Performance Analytics (Incident, Change and Problem Spotlight plugins)creating database view with u_ prefix u_incident_spotlight, u_change_request_spotlight and u_problem_spotlight causing error in respective spotlight dashboards: 1) ERROR: Cannot generate the report. Invalid table: incident_spotlight Invalid table: incident_spotlight 2) ERROR: Cannot generate the report. Invalid table: change_request_spotlight Invalid table: change_request_spotlight 3) ERROR: Cannot generate the report. Invalid table: problem_spotlight Invalid table: problem_spotlight

Steps to Reproduce

1) Activate the following spotlight plugins : - Performance Analytics - Spotlight (com.snc.pa.spotlight) - Performance Analytics - Spotlight - Change Spotlight content pack(com.snc.pa.spotlight.change) - Performance Analytics - Spotlight - Incident Spotlight content pack(com.snc.pa.spotlight.incident) - Performance Analytics - Spotlight - Problem spotlight content pack(com.snc.pa.spotlight.problem)

2) Goto dashboard and view spotlight dashboard for incident, Change and problem and see error message

3) Goto database views and view spotlight views :

Notice all spotlight views are created with u_ prefix.

** Note As a workaround export database view to XML, change the name by removing the u_ prefix. Upload changed XML back to instance and the error is fixed

Workaround Export database view to XML, change the name by removing the u_ prefix. Upload changed XML back to instance and the error is fixed.