#database

Failed to update database "BONITA_BPM" because the database is read-only

Hi,

I'm trying to start Bonita but it failed. The full error message I got is:

PreparedStatementCallback; uncategorized SQLException for SQL [UPDATE configuration SET resource_content=? WHERE content_type=? AND resource_name=?]; SQL state [S0002]; error code [3906]; Failed to update database "BONITA_BPM" because the database is read-only.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Failed to update database "BONITA_BPM" because the database is read-only

Database Configuration for Postgresql

I have checked the documentation related to Database Configuration.of Bonita. For Oracle, MSSQL and Mysql, there are available examples but none for Postgresql. Does anyone have a good step by step example switching or using Postgresql?

How to store Business Data Object into Database (groovy/java)

For example I have business data object Cup.

I can define it on Groovy script easily.

def new_cup = new Cup();
new_cup.name = "Tiny Cup";
new_cup.description = "Nice tiny cup";
new_cup.ownerId = 5;

But how I can store it into database programmatically now?

Connect to SQL Server instance

What is the best way to connect Bonita Engine Database and BDM to an instantiated SQL Server Database.

All attempts using "/", "\" failed.

Is there any documentation that I can follow guiding me to connect successfully?

Thanks

Quelle collation, character set, encoding configuer pour utiliser Bonita 2021.2 avec MS SQL 2017?

Bonjour,

La documentation d'installation de la base de donnees indique "Your database(s) must be configured to use the UTF-8 character set."

D'apres la matrice, nous devons utiliser MS SQL 2017 qui ne supporte pas l'UTF-8.

Seul MS SQL 2019 offre ce support.

Actuellement nous utilisons la collation : Latin1_General_CI_AS_WS au niveau du serveur, est-ce conforme pour Bonita ?

Quelles sont les collation supportees pour MS SQL 2017?

Merci d'avance

What are the startDate and lastUpdate values on process_instance table?

Hi

We have noticed that for many of our cases in progress, having some completed tasks, the lastUpdate value is the same as the startDate value in the process_instance table.

We have developed our own application, which displays the start date and the last updated date to our users. We are reading data from the process_instance table and assumed that every time a task is submitted the lastUpdate field on this table will be updated accordingly.

Could you please clarify what is the lastUpdate value and the startDate value in the process_instance table?

How to upload a file URL to the postgres database using process variables. Also how to call that uploaded file in a form again to download it

I have prepared a form using the process variable. Now I have to attach a file from the user, This File must be uploaded on the database and another user will download it from another form. So how to upload files to the database and call them for downloading

Edit table Row and Save data in MS SQL DataBase

Good afternoon,

I m working on a process that should get data from MS SQL DB using a connector , and display data in Table. But , I need to add edit and save actions to that Table in order to update some Cells in a table Row and to Save the new row to The same DB.

Im thinking about using another connector to save my Data to DB. But my main concern is : How can I achieve this task.?

(ps:Im not using any BDM ,just some process variables) , any suggestions!

regards !

Is there a method to migrate data from oracle to postgres database for Bonita 6.4.1?

I have a java application with BonitaBPMCommunity-6.4.1-JBoss-7.1.1 with oracle database. I want to migrate this oracle 11.2.0 EE bonita database in postgres 10 bonita database.
I proceeded with a manual migration with the ora2pg tool but I have doubts about scheduled jobs.

In fact at startup I got the following errors

Hibernate error on named query, server doesn't start : how to fix BDM on server without any access to the admin interface ?

Hello.

I have a problem with an hibernate error on a named query.

I have deployed on a Bonita server a bad BDM with an error in a custom query. The deploy succeed but an hibernate error occurs and the server doesn't start after the update.

Notifications