Migrating from SQL Server to Postgres


I've been reading the Migration Tool documentation but I'm not seeing any direct references to migration from one db vendor to another.

I'm hopping someone can enlighten me. I'm trying to migrate from 7.10.3 SQL Server on a remote machine to 7.10.3 postgres local install.

Thank you all!

Cambio de Tomcat a Wildfly con la misma base de datos Postgres

Hice la instalación del Bonita Suscripción Tomcat Bundle con acceso a la base de datos Postgres y con licencia válida con éxito.

Paré el servicio e hice una nueva instalación en el mismo servidor en path diferente usando el Bonita Subscription Wildfly Bundle con acceso a la misma base de datos ya existente y la misma licencia de la instalación con Tomcat y con eso el BonitaSoft no subió correctamente. ¿Es posible realizar este tipo de instalación? ¿Y cuál es la mejor referencia para eso?

Problem to install Bonitat 7.5.4 on Debian9, Tomcat8, Postgres

I have try to install Bonitat 7.5.4 on Debian9 with Tomcat8 and Postgres.
I have follow this tutorial

But when I want to start Tomcat service, it give me an error and dont start.
the log is :


How to Configure BonitaBPM Platform for BonitaBPMCommunity Tomcat Bundle

I have tried simple process variable example given at link using BonitaBPMCommunity-7.3.1-Tomcat-7.0.67. Its working well in bonita studio and with default h2 database configuration with tomcat bundle. But when i configure tomcat bundle with PostgreSQL database its not working well with Bonita ui forms but working well with process containing 6.x forms.

Bonita Tomcat-7.0.67 configuration with PostgresSql

I am trying to configure bonita tomcat bundle with Postgres. I have successfully connected PostgresSql with bonita tomcat bundle.But its not working with Bonita ui designer forms. Process containing Bonita ui designer forms running successfully in Bonita studio but not working in tomcat bundle in form of .bar file. I have following the steps below to connect with PostgresSql with Bonita Tomcat-7.0.67 bundle. Tell me if i am missing any step. After configuration i got 81 tables in bonita database.

Bonita ui designer forms are not working with Postgres

I have tired simple process variable example given at link using BonitaBPMCommunity-7.3.1-Tomcat-7.0.67. Its working well in bonita studio. I have made .bar file of process and upload it in process tab in bonita tomcat bundle portal. But neither its fetching process variable values nor passing to next Step Step1/Step2.

Postgres KPI capturing task information

I am using Subscription Bonita 7.3.0 and Postgres 9.2.18.

Having successfully set up a postgres KPI I am attempting to create entry and exit activity KPI. These would ideally capture the user who started and finished an activity, the activity information (process, case, and task) and the start and finish date & time.

Postgres KPI Request Formatting

I am using Bonita Subscription 7.3.0 and a Postgres database 9.2.18.

I have a question regarding formatting, I have recently begun setting up KPIs with a Postgres database. Which is operating normally, and was actually really easy and straightforward to set up. However when creating the actual KPI request, there are two options "Use graphical mode" or "Use Manual mode."

If I use "Graphical mode" the request comes out like"
"INSERT INTO Bonita_Entry_Info (Process_ID) VALUES (${process_ID})"

Which is actually incorrect.

Trying to get data from Postgres into BDM

My goal - read the entire postgres table customers and put it into a BDM table.

BOS file, log output, and Postgres table definition are in the "CASE1" folder in my Google Drive public folder. I know that the test is nt BPMN2 compliant.

I've created two BDM tables. One a working table, the other a reference table (bdocustomer and bdoPGcustomer respectively).

Is a Postgres/SQL UPDATE statement limited to a maximum length?

Hi all,

I am using a sql update statement like this in a Groovy Out connector:

"sql.execute("UPDATE table SET col3=$bdmvar3, [and another 40 variables...].WHERE col1=$bdmvar1")"

The length of this statement is approximately 1300 characters. When I try to execute it, I get this syntax error:

Caused by: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "is" Position: 588