Category / Section
Resolving Database Conflict in Bold BI Embedded Analytics Server During Setup
Published:
The current behavior of the Bold BI application is that the one database cannot be used multiple Bold BI sites, resulting in a conflict as Bold BI tables already exists. When this issue arises, there are two potential solutions to consider.
Clearing Bold BI Database Tables
If you choose to continue using the existing database, and it is not used for any other Bold BI sites then remove all Bold BI tables which have the prefixes values "boldbi_" and "boldtc_" then use the same database for new instance or tenant creation process. By clearing these tables, you can resolve the conflict and ensure the database is compatible with the new build. Here "boldbi_" tables are related to BI tenant sites and "boldtc_" tables are related to UMS site where we manage the BI tenant sites like creating, editing, and deleting.
Creating a New Database
An alternative approach is to create a new database to use for new instances or BI tenant sites. This option is viable if you want to maintain the integrity of the existing database for other purposes. The credentials used to connect to the server instance must have the permissions specified here.
For more details about Application Startup with Database configuration, refer below documentation,
NM
