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

Submitted by ChristianMichae... on Tue, 05/02/2017 - 04:09
1
0
-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

#bonita
#bonita 7.x
#connector bonita7
#database
DB connector

Comments

Submitted by Sean McP on Tue, 05/02/2017 - 04:34

Tells me you have a problem with the Connector...

What does your SQL statement say?

Permalink
Submitted by ChristianMichae... on Tue, 05/02/2017 - 04:42

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'
)

Permalink
Submitted by Sean McP on Tue, 05/02/2017 - 05:01

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

regards

Permalink
Submitted by ChristianMichae... on Tue, 05/02/2017 - 05:12

Hi Sean,

What do you mean drop the process?

Permalink
Submitted by Sean McP on Tue, 05/02/2017 - 05:28

share it...

Permalink
Submitted by ChristianMichae... on Tue, 05/02/2017 - 06:12

Hi Sean,

Wait ill send to you the .bos file

Permalink
Submitted by Sean McP on Tue, 05/02/2017 - 06:09

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

Permalink
Submitted by ChristianMichae... on Tue, 05/02/2017 - 06:18

Hi Sean,

See link below
https://drive.google.com/file/d/0BwGthmzoisJURUdpYXpTRXVZcVk/view?usp=sh...

Permalink
Submitted by Sean McP on Tue, 05/02/2017 - 06:22

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...

Permalink
Submitted by ChristianMichae... on Tue, 05/02/2017 - 06:32

Hi Sean,

Sorry here is the updated .bos file
https://drive.google.com/file/d/0BwGthmzoisJUeDRYcnl6ZjlmSVk/view?usp=sh...

Permalink
Submitted by Sean McP on Tue, 05/02/2017 - 06:39

there are no connectors in it...

Permalink
Submitted by ChristianMichae... on Tue, 05/02/2017 - 06:46

Hi Sean,

Forgot to include connectors upon export.
https://drive.google.com/file/d/0BwGthmzoisJUeGdrNE9td0lXYmc/view?usp=sh...

Permalink
Submitted by ChristianMichae... on Tue, 05/02/2017 - 06:58

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=sh...

Permalink
Submitted by Sean McP on Wed, 05/03/2017 - 03:41

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

Permalink
Submitted by ChristianMichae... on Mon, 05/08/2017 - 09:02

Hi Sean,

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

Permalink
Submitted by Sean McP on Mon, 05/08/2017 - 09:20

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

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

regards

Permalink
Submitted by ChristianMichae... on Mon, 05/08/2017 - 10:11

Hi Sean,

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

Permalink
Submitted by Sean McP on Mon, 05/08/2017 - 10:15

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

regards

Permalink
Submitted by ChristianMichae... on Mon, 05/08/2017 - 11:30

Hi Sean,

Where could I file this issue if error still persist?

Permalink
Submitted by Sean McP on Mon, 05/08/2017 - 11:54

https://bonita.atlassian.net/secure/Dashboard.jspa

Permalink
No answers yet.
Notifications