How do we know that was is stored in DB and free-up the DB

[john32]

How is it possible to know which data in the DB took the most size and delete it? My guess is it’s “openrpa_instances” but deleting its records doesn’t reduce current database usage.

[yashshah]

Connect to database using mongodb Compass that will help you to understand storage usage

[Allan_Zimmermann]

how are you measuring that ?
when you delete something it goes into the log ( or journal for mongodb ) so if you are looking at the disk, it will not have any effect until you do a backup of the database and run a compact.

[john32]

Hey, what is the connection URI for database connection when using Compass to connect to openIAP db?

[yashshah]

You can find that in docker file. Database name is always openflow

[john32]

I’m asking about the app.openiap.io website. My openiap is hosted there. I want to free space and I need to connect to the DB. Is it possible to connect to my account’s mongoDB on the openiap website? what’s the connection string?

If it’s not possible to connect directly, then how can I free up some space from the website UI? I removed everything from “openrpa_instances” entities but it takes multiple hour for space to get free.

[Allan_Zimmermann]

No, mongodb for app.openiap.io is not public.
Disk Space is calculated once a day.
You can click the grafana link to see what collections contains data that was used to, doing last scan.

If most of the space is used in _hist collections, then please let me know, then i can purge that manually. For security reasons, you cannot delete data from _hist collections yourself … I will add a setting and a button button to do that in the web interface at some point, but right now that can only be done directly in the database.

[john32]

Thanks. Is it possible to disable logging workflow execution records in “openrpa_instances”? It takes a lot of space and I have to delete it every day.

[Allan_Zimmermann]

There are a few options, see

Common Security Concerns

OpenRPA will store data in openflow, so if you are using the openflow at https://app.openiap.io , Employees at OpenIAP ApS will have access to certain data, including some sensitive data. First up is user passwords. Passwords are stored using asymmetric encryption meaning no one can decrypt and read it. it’s NEVER a good idea to use passwords if you can use federation instead, so I highly recommend using Google id, office 365 or Microsoft Live account instead, the security around those accounts…

And OpenRPA configuration | OpenIAP Documentation

Like skip_online_state and disable_instance_store