How to recover missing dashboard Page ??

[Phillip Weeks]

I have a dashboard page in my UI menu that works as usual. However I cannot find this page anywhere in the system using page editor or the dashboard editor? It is as if it didn't exist. When I edit the menu item for the page it shows an empty container for the link to a custom page however it is still on my browser. Is there a way to recover the source to this page from my cache or where ever the page is coming from?

[phildunlap]

Hi Phillip,

This is all happening inside the jsonStore table. You can go to /ui/administration/json-store to edit these items. You should be able to see an entry that corresponds to the page in question. I would guess that a section corresponding to the XID of the page in question is not to be found in your mangoUI-pages jsonStore entry currently. So, you would want to edit the mangoUI-pages JSON store item to add in a suiting,

{
    "xid": "your-page-xid",
    "name": "your-page-name",
    "editPermission": "edit-ui-pages",
    "readPermission": "user"
}

to the list of pages.(and add any necessary comma for the list)

[ThomasEinasto]

I am not sure if you can but I noticed that Mango Saves some of the data of pages to JSONDATA database table. Just see if there is a record of your page in the table and in the pages object by using SQL module.

SELECT * FROM JSONDATA WHERE EDITPERMISSION='edit-ui-pages'

For filtering out the pages if you have your own JSONstore data in the table.

Then see if your record exists in the first "mangoUI-pages" Xid data object. And then see if your record exists seperately as a record. Maybe it got deleted from the object but is still available in the database or vise-versa.

Also maybe you could restore the database to the date where you had the page, then revert it to current state.

These are just my suggestions but I am not absolutely sure how the pages are saved in mango so IAS staff can help you more with this I guess.

Edit. Phil already helped you with this. so no need to read. :)

[phildunlap]

Thanks for answering though, Thomas!

The JSON data table is also tracked in the audit system. Try this in the SQL console and you may see some page entries you deleted (change type 3, as defined in com.serotonin.m2m2.vo.event.AuditEventInstanceVO)

select * from audit where typename='JSON_DATA' and changeType=3 order by id desc limit 10;

So you can even revert to old versions of a page, if your audit table still has the entries for the create or modify events (change types 1 and 2)!

[Phillip Weeks]

Thanks Guys. Found it in the Jason Store and just copied it out to a new page.

[glamprecht]

@phildunlap said in How to recover missing dashboard Page ??:

/ui/administration/json-store

Can you please provide the full path:
find / | grep json-store
does not return anything.
find / | grep /ui/administration
does not return anything.

I found these, but it does nothing looks anything to what you describe. I have the latest version installed. My page went missing during an update the last couple of months.

/opt/mango/web/resources/amd/dojox/app/schema/store.json
/opt/mango/web/resources/dstore/bower.json
/opt/mango/web/resources/dstore/package.json
/opt/mango/web/resources/dojox/app/schema/store.json

[phildunlap]

Hi glamprecht,

While I do ambiguously omit the http://host.extension:port/ I do so because I abhor loose hyperlinks. If I have a path that begins with /ui/ it's probably a path in Mango. Same if it ends with .shtm . You can edit the JSON Store through the JSON Store menu item under the administration menu in the UI or by going directly to the URL.