Failed to load dashboard

RT Users
1

Hello,

I’m getting the following warning on my Apache error log every time I load
pretty much every RT page and I would like to get rid of it:

[warning]: Failed to load dashboard 235: Failed to load dashboard 235:
Couldn’t find row (/opt/rt4/share/html/Elements/Tabs:497)

I guess some dashboard was deleted and it’s somehow still referenced but
not showing up in the UI. ¿How can I manually delete this reference?

Thanks.

Carlos Ramos

2

Hello,

I’m getting the following warning on my Apache error log every time I
load pretty much every RT page and I would like to get rid of it:

[warning]: Failed to load dashboard 235: Failed to load dashboard 235:
Couldn’t find row (/opt/rt4/share/html/Elements/Tabs:497)

I guess some dashboard was deleted and it’s somehow still referenced but
not showing up in the UI. �How can I manually delete this reference?

Thanks.

–
Carlos Ramos

Attached a simple Perl script I use.
The pod also notes the bug report for this.

Chris

rt-find-dashboardsinmenu (1.55 KB)

3

Hi Christian,

This script is great, I was able to identify the users with a reference to
that specific dashboard. But I could not find how this information is
stored in the DB (my best guess is attributes.content which is binary) and
I really don’t know much about the RT API. Do you know if it’s possible to
remove theses invalid references directly in the database?, if not, how can
I do so through the RT API?

In the RT API there is a DeletePreferences in the RT::User class, but i
don’t see how I can delete a specific DashboardInMenu id from the
preferences. Any ideas about this?

Thanks a lot for the help.On Tue, Sep 16, 2014 at 12:07 AM, Christian Loos cloos@netcologne.de wrote:

Am 16.09.2014 um 05:13 schrieb Carlos Ramos:

Hello,

I’m getting the following warning on my Apache error log every time I
load pretty much every RT page and I would like to get rid of it:

[warning]: Failed to load dashboard 235: Failed to load dashboard 235:
Couldn’t find row (/opt/rt4/share/html/Elements/Tabs:497)

I guess some dashboard was deleted and it’s somehow still referenced but
not showing up in the UI. ¿How can I manually delete this reference?

Thanks.

–
Carlos Ramos

Attached a simple Perl script I use.
The pod also notes the bug report for this.

Chris

Carlos Ramos

4

Hi Christian,

This script is great, I was able to identify the users with a reference
to that specific dashboard. But I could not find how this information is
stored in the DB (my best guess is attributes.content which is binary)
and I really don’t know much about the RT API. Do you know if it’s
possible to remove theses invalid references directly in the database?,
if not, how can I do so through the RT API?

In the RT API there is a DeletePreferences in the RT::User class, but i
don’t see how I can delete a specific DashboardInMenu id from the
preferences. Any ideas about this?

Thanks a lot for the help.

On the user modify page (Admin → Users) you can change a users
“Dashboards in menu” preference.
The right select box contains a row without a label for the deleted
dashboard, select this row and hit “Delete”.

Chris

5

Hi Christian,

Thanks a lot, that solved my problem a lot easier than expected. Again
thanks a lot.

Cheers.On Wed, Sep 17, 2014 at 7:05 AM, Christian Loos cloos@netcologne.de wrote:

Am 16.09.2014 um 18:56 schrieb Carlos Ramos:

Hi Christian,

This script is great, I was able to identify the users with a reference
to that specific dashboard. But I could not find how this information is
stored in the DB (my best guess is attributes.content which is binary)
and I really don’t know much about the RT API. Do you know if it’s
possible to remove theses invalid references directly in the database?,
if not, how can I do so through the RT API?

In the RT API there is a DeletePreferences in the RT::User class, but i
don’t see how I can delete a specific DashboardInMenu id from the
preferences. Any ideas about this?

Thanks a lot for the help.

On the user modify page (Admin → Users) you can change a users
“Dashboards in menu” preference.
The right select box contains a row without a label for the deleted
dashboard, select this row and hit “Delete”.

Chris

Carlos Ramos