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

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

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?

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

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

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

Hi Sean,

What do you mean drop the process?

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

share it...

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

Hi Sean,

Wait ill send to you the .bos file

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

Submitted by ChristianMichae... on Tue, 05/02/2017 - 06:18
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...

Submitted by ChristianMichae... on Tue, 05/02/2017 - 06:32
Submitted by Sean McP on Tue, 05/02/2017 - 06:39

there are no connectors in it...

Submitted by ChristianMichae... on Tue, 05/02/2017 - 06:46
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...

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.

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

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.

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

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.

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

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

Hi Sean,

Where could I file this issue if error still persist?

Submitted by Sean McP on Mon, 05/08/2017 - 11:54
No answers yet.
Notifications