ERA - cannot hide a deleted beta app

I had a beta-datafield on the store - just for my own needs and testing, and I had added it to ERA (yellow colored).

Just released the official datafield (for everyone) and deleted the beta datafield from the store.

Now I can't get rid of the beta version in ERA.
-When I call the app: "App not found on store!" - what seems to be logical
-When I try to hide th datafield: "Developer key not valid!" - can't be, because the datafield was deleted.

So, it seems I can't get rid of this beta datafield in ERA... or is there any suggestion?

  • I looked into this and the ERA viewer stores its app list in an H2 database in the ERA viewer folder. (On Windows: %APPDATA%\Garmin\era-viewer)

    The database filename is era.db.mv.db.

    I was able to open and edit this file with DBeaver (https://dbeaver.io/download/), available for Windows, macOS and Linux.

    1) Close the ERA viewer

    2) Make backup copy of era.db.mv.db

    3) Open dbeaver

    In dbeaver:

    4) In the app menu, select Database > New Database Connection > H2 Embedded

    5) Database Connection dialog: General > Open > [select era.db.mv.db]

    6) Database Navigator: era.db.mv.db > PUBLIC > Tables > [right-click] APPS > View Table. A new center pane will open with an APPS tab. 

    7) In the center pane, select APPS > Data tab. You will see a list of all your apps with columns such as UUID, NAME, KEYPATH, HIDDEN, BETA and UIORDER

    8) Click on the HIDDEN cell for the app you want to hide until the value changes to [v] / true (or use the drop-down in the Value pane)

    I found that this works for a couple of random apps of mine. I don't have an unhideable app to test, but I don't see any reason why it wouldn't work for that, too.

  • Wow! Thank you! I will check tomorrow and come back!

  • Unfortunately I cannot run DBeaver.

    But I don't want to install other Java bacause now all systems (Monkey C) are running well.

    But thank you for your efforts! Very appreciated!

  • You can just download openjdk-17 as a zip archive and then temporarily replace Java path in Windows Environment Variables from 1.8 bin folder to 17 bin folder. Technically, this is the same as Java installation through exe file, but allows you to easily switch the Java version whenever you need

  • Ok, try https://www.dbvis.com/ instead. It installs its own copy of the JRE which won't interfere with your system-wide JRE.

    The instructions are pretty much the same, but note if you are entering/pasting in the database filename manually:

    - do not include quotes

    - do not include the .mv.db extension

    e.g. if you want to open the following database...

    C:\Users\USERNAME\AppData\Roaming\Garmin\era-viewer\era.db.mv.db

    ...enter the following text

    C:\Users\USERNAME\AppData\Roaming\Garmin\era-viewer\era.db

    I think you need to either use trial mode or purchase a license if you want to edit databases tho. So a longer term solution would be to install dbeaver

  • Speaking of dbeaver, the installation page says that it installs its own JRE, so I'm curious as to why you're getting that error message:

    https://dbeaver.io/download/

    "Java notes:
    DBeaver requires Java 17 or higher. Since version 23.0 all distributions include OpenJDK 17 bundle."

    I see it in my dbeaver install folder, too.

    %localappdata%\dbeaver:

    Did you download the windows installer or the ZIP file?

  • Did you download the windows installer or the ZIP file?

    Yes, installer, but I disabled "Install Java" - I didn't recognize that dbeaver  will install its own Java - not disturbing my system-Java.

    Now I will try again - thank you so far - I will report!

  • YES!!
    It worked as described by you!
    Many thanks for your patience!