Error Encountered When Running Processes in Bonita after Setting up a Database Connector

Q&A
1

Hi Guys,

I have a database connector that executes an insert statement. I created a variable that will be used in insert statement and then I run the process. I also try insert statement with values without using the variable to see if it really inserts data but encountered the error below.

Error:
java.lang.reflect.InvocationTargetException
org.bonitasoft.studio.engine.export.BarCreationException: Failed to add Process resources from configuration.
org.bonitasoft.studio.groovy.provider.JarExportFailedException: Error while building Jar for Groovy scripts provided by Bonita BPM.
Exported with compile errors: default/src-providedGroovy/script1493099919580.groovy
Exported with compile errors: default/src-providedGroovy/script1493099919782.groovy
Exported with compile errors: default/src-providedGroovy/script1493099927177.groovy
Exported with compile errors: default/src-providedGroovy/script1493099924946.groovy
Exported with compile errors: default/src-providedGroovy/script1493099927645.groovy
Exported with compile errors: default/src-providedGroovy/script1493099927817.groovy

2

Tells me you have a problem with the Connector…

What does your SQL statement say?

3

Hi Sean,

This is my insert statement. I test it first to see if it really inserts but the error above occurs.

INSERT INTO [dbo].[sm_gatepass_request_header]
(gatePassNo
,name
,branch
,company
,bearerCompany
,preparedBy
,preparedDate
,approvedBy
,approvedDate
,issuedBy
,issuedDate
,isApprovedHead
,isApprovedBldgAdmin
,isApprovedRelease
,receivedBy
,receivedDate
,commentByHead
,commentByBldgAdmin
,commentByCRS
,commentByBldgAdminHead
,isApprovedBldgHead
,approvedByBldgHead
,approvedDateBldgHead)
VALUES
(‘000001’
,‘Christian Arizala’
,‘Head Office’
,‘SM Retail Inc.,’
,‘Accenture’
,1
,‘02/27/2017’
,2
,‘02/27/2017’
,3
,‘02/27/2017’
,‘Passed’
,‘Pending’
,NULL
,4
,‘02/27/2017’
,NULL
,NULL
,NULL
,NULL
,NULL
,5
,‘02/27/2017’
)

4

are you able to drop the process so I can have a look, SQL looks fine…

regards

5

Hi Sean,

What do you mean drop the process?

6

share it…

7

Hi Sean,

Wait ill send to you the .bos file

8

yes, put it on a file share somewhere, dropbox fileshare or whatever you use…

9

Hi Sean,

See link below

https://drive.google.com/file/d/0BwGthmzoisJURUdpYXpTRXVZcVk/view?usp=sharing

10

Please export only the ONE process you are having problems with - I cannot process/import atll of them.

Close all diagrams except the one you want to send
Diagram->Export-> do not select all - just leave as is (it selects all the right things)
and send that…

11

Hi Sean,

Sorry here is the updated .bos file

https://drive.google.com/file/d/0BwGthmzoisJUeDRYcnl6ZjlmSVk/view?usp=sharing

12

there are no connectors in it…

13

Hi Sean,

Forgot to include connectors upon export.

https://drive.google.com/file/d/0BwGthmzoisJUeGdrNE9td0lXYmc/view?usp=sharing

14

Hi Sean,

Sorry i checked it again i remove the database connector because of the error. See again the file

https://drive.google.com/file/d/0BwGthmzoisJUaml0QTd0Z1VZbWs/view?usp=sharing

15

Hi Christian,

sorry to say this but the process works on my system - the only thing I changed was the JDBC and sign-in name/password though.

This is what I used (configured using my server and database names). Everything else is the same.

jdbc:sqlserver://localhost:1433;databaseName=CONTI;

I’m using MS SQL Server 2016 but that shouldn’t matter. I used exactly the same SQL JAR file etc.

regards
Seán

16

Hi Sean,

When you run the process is there a connector included? It still not working for me and error still persist.

17

obviously - that’s where I changed the JDBC details.

data is added and I can retrieve it also in SQL Management Studio

regards

18

Hi Sean,

It still not working. I created a new workflow and restart bonita it but error still persist.

19

I would submit the call to the bug system, it works for me so I can’t understand your issue.

regards

20

Hi Sean,

Where could I file this issue if error still persist?