Unable to find table: homepage_grid

[felladin]

I am having an issue with an OOB homepage in all our environments (dev, test, prod); trying to open Web API Usage Overview.

An error message appears when opening them claiming "Unable to find table: homepage_grid"

This issue has been noted before in the community, but there is not relevant solution that I can find.

Screenshots of homepage overview and error message. When clicking OK, the options to add fields will only create a new page for my logged on user.

Seen this before on another OOB page, but then it wasn't that important so I ignored it.

[kevinray]

Interestingly, we just had a report of this exact same issue but with a different OOTB PA dashboard. Our is happening on "Incident Premium" dashboard but only on two of the tabs...very odd.

[felladin]

My previous occurrence was in my dev-environment on the CMDB overview after I had just activated it. Never got it to work in the dev, but didn't mean that much.

With regards

Anton Vettefyr

[daburges]

We are having the exact same behavior. Only the first two tabs of the Incident Premium dashboard are throwing this error.

[sandra_villarre]

Hi All,

For cases with Performance Analytics this is an indication that there is a missing or inactive UI Macro.   I suspect it might be similar for Anton question.

On the second image, it looks like you are viewing the sys_portal_page.   From the sys_portal_page you should be able to right click on grey header bar > show xml.

The Layout tag should show something like:

<layout display_value=" ">sys_id</layout>

This sysid is the sys id of the UI Macro.   You should be able to access that same sys_port_page in the instance where issue does not occur and confirm the same sys id is referenced.   If so, access /sys_ui_macro_list.do and filter/query by sys id.   Once you obtain the record, export the sys_ui_macro and import into the instance which has it missing.

In my particular case it was the UI macro named "Admin 1 Row 1 Column" with sys_id "590783c2ef222000876004167b22560a" (sys_ui_macro_590783c2ef222000876004167b22560a) but this can vary.   Additionally if it does exist make sure that the macro is active.

For PA to confirm which portal page your dashboard is using, access   pa_m2m_dashboard_tabs_list.do to obtain a list of tabs that are found on the dashboard in question.   Then Access pa_tabs_list.do to find the tab from step 1.   Add the "page" column (if not already visible).   The page column references the name of the portal page.

I hope the above steps can help if this is the same one your missing or something else.

Thanks,

Sandra