Bonita ui designer forms are not working with Postgres

1
0
-1

I have tired simple process variable example given at link http://community.bonitasoft.com/project/process-variable-example 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. Process variable example is working fine with default h2 database configuration but when i configured tomcat bundle with Postgres database its not working with bonita ui forms. I have used database connection instructions given at link http://documentation.bonitasoft.com/?page=tomcat-bundle . There is no error in log file for postgres but when i run process it gives error at Step2 that

2016-11-23 08:32:49.078 +0500 INFO: org.restlet.Component.BonitaRestletApplication Error while validating expected inputs Explanations: Expected input [newVariableValue] is missing

Bonita Log file:

2016-11-23 08:20:27.182 +0500 INFO: org.bonitasoft.platform.setup.PlatformSetup System property org.bonitasoft.platform.setup.folder is set to C:\Users\User\Documents\BonitaBPMCommunity-7.3.1-Tomcat-7.0.67\setup
2016-11-23 08:20:27.226 +0500 INFO: org.bonitasoft.platform.setup.PlatformSetup Connected to 'postgres' database with url: 'jdbc:postgresql://localhost:5432/bonitaengine' with user: 'bonitaengine'
2016-11-23 08:20:27.229 +0500 INFO: org.bonitasoft.platform.setup.ScriptExecutor configuration for Database vendor: postgres
2016-11-23 08:20:27.415 +0500 INFO: org.bonitasoft.platform.setup.PlatformSetup Platform is already created. Nothing to do.
2016-11-23 08:20:27.627 +0500 INFO: org.bonitasoft.engine.EngineInitializer Initializing Bonita Engine...
2016-11-23 08:20:27.628 +0500 INFO: org.bonitasoft.engine.EngineInitializer Initializing Spring context...
2016-11-23 08:20:35.613 +0500 WARNING: org.hibernate.type.TypeFactory HHH000233: Scoping types to session factory org.hibernate.internal.SessionFactoryImpl@7423bec4 after already scoped org.hibernate.internal.SessionFactoryImpl@44308726
2016-11-23 08:20:41.867 +0500 INFO: org.bonitasoft.engine.EngineInitializer Starting platform...
2016-11-23 08:20:48.509 +0500 INFO: org.bonitasoft.engine.EngineInitializer Platform started successfully
2016-11-23 08:20:48.510 +0500 INFO: org.bonitasoft.engine.EngineInitializer Initialization of Bonita Engine done! ( took 20882ms)
2016-11-23 08:21:39.163 +0500 INFO: org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita] RestletServlet: [Restlet] ServerServlet: component class is null
2016-11-23 08:21:39.533 +0500 INFO: org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita] RestletServlet: [Restlet] Attaching application: org.bonitasoft.web.rest.server.BonitaRestletApplication@5efff180 to URI: /bonita/API
2016-11-23 08:21:39.557 +0500 INFO: org.restlet.Component.BonitaRestletApplication Starting org.bonitasoft.web.rest.server.BonitaRestletApplication application
2016-11-23 08:21:54.415 +0500 SEVERE: org.bonitasoft.console.common.server.login.credentials.LoginDatastore Error while logging in the engine API.
2016-11-23 08:24:47.160 +0500 INFO: org.restlet.Component.BonitaRestletApplication Error while validating expected inputs
Explanations:
Expected input [myInput] is missingExpected input [mysInput] is missingExpected input [myMultipleDocumentsContract] is missingExpected input [myMultipleDocumentsDeleteContract] is missingExpected input [brnchInput] is missingExpected input [secInput] is missing
2016-11-23 08:29:18.201 +0500 INFO: org.restlet.Component.BonitaRestletApplication Error while validating expected inputs
Explanations:
Expected input [newVariableValue] is missing
2016-11-23 08:32:49.078 +0500 INFO: org.restlet.Component.BonitaRestletApplication Error while validating expected inputs
Explanations:
Expected input [newVariableValue] is missing

catalina Server log file:

2016-11-23 08:20:16.487 +0500 INFO: org.apache.catalina.core.AprLifecycleListener The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre1.8.0_101\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files\Java\jdk1.8.0_101\bin;C:\Program Files (x86)\PuTTY\;E:\DevProgramm\maven\bin;C:\Program Files (x86)\SSH Communications Security\SSH Secure Shell;.
2016-11-23 08:20:17.317 +0500 INFO: org.apache.coyote.http11.Http11Protocol Initializing ProtocolHandler ["http-bio-8080"]
2016-11-23 08:20:17.353 +0500 INFO: org.apache.coyote.ajp.AjpProtocol Initializing ProtocolHandler ["ajp-bio-8009"]
2016-11-23 08:20:17.361 +0500 INFO: org.apache.catalina.startup.Catalina Initialization processed in 2175 ms
2016-11-23 08:20:17.362 +0500 INFO: bitronix.tm.integration.tomcat55.BTMLifecycleListener Starting Bitronix Transaction Manager
2016-11-23 08:20:17.396 +0500 INFO: bitronix.tm.BitronixTransactionManager Bitronix Transaction Manager version 2.1.3
2016-11-23 08:20:17.400 +0500 INFO: bitronix.tm.Configuration JVM unique ID:
2016-11-23 08:20:17.458 +0500 WARNING: bitronix.tm.journal.DiskJournal active log file is unclean, did you call BitronixTransactionManager.shutdown() at the end of the last run?
2016-11-23 08:20:17.464 +0500 INFO: bitronix.tm.resource.ResourceLoader reading resources configuration from C:\Users\User\Documents\BonitaBPMCommunity-7.3.1-Tomcat-7.0.67/conf/bitronix-resources.properties
2016-11-23 08:20:21.822 +0500 INFO: bitronix.tm.recovery.Recoverer recovery committed 0 dangling transaction(s) and rolled back 0 aborted transaction(s) on 2 resource(s) [jdbc/BusinessDataDSXA, jdbc/bonitaDSXA] (restricted to serverId 'bonita-tomcat-btm-node0')
2016-11-23 08:20:21.917 +0500 INFO: org.apache.catalina.core.StandardService Starting service Catalina
2016-11-23 08:20:21.918 +0500 INFO: org.apache.catalina.core.StandardEngine Starting Servlet Engine: Apache Tomcat/7.0.67
2016-11-23 08:20:21.945 +0500 INFO: org.apache.catalina.startup.HostConfig Deploying configuration descriptor C:\Users\User\Documents\BonitaBPMCommunity-7.3.1-Tomcat-7.0.67\conf\Catalina\localhost\bonita.xml
2016-11-23 08:20:48.292 +0500 INFO: org.quartz.core.SchedulerSignalerImpl Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
2016-11-23 08:20:48.293 +0500 INFO: org.quartz.core.QuartzScheduler Quartz Scheduler v.2.2.1 created.
2016-11-23 08:20:48.295 +0500 INFO: org.quartz.plugins.management.ShutdownHookPlugin Registering Quartz shutdown hook.
2016-11-23 08:20:48.300 +0500 INFO: org.quartz.core.QuartzScheduler Scheduler meta-data: Quartz Scheduler (v2.2.1) 'QuartzScheduler' with instanceId 'NON_CLUSTERED'
Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
NOT STARTED.
Currently in standby mode.
Number of jobs executed: 0
Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 5 threads.
Using job-store 'org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT' - which supports persistence. and is not clustered.

2016-11-23 08:20:48.302 +0500 INFO: org.quartz.core.QuartzScheduler JobFactory set to: org.bonitasoft.engine.scheduler.impl.TransactionalSimpleJobFactory@26246754
2016-11-23 08:20:48.469 +0500 INFO: org.quartz.core.QuartzScheduler Scheduler QuartzScheduler_$_NON_CLUSTERED started.
2016-11-23 08:20:52.145 +0500 INFO: org.apache.catalina.startup.HostConfig Deployment of configuration descriptor C:\Users\User\Documents\BonitaBPMCommunity-7.3.1-Tomcat-7.0.67\conf\Catalina\localhost\bonita.xml has finished in 30,201 ms
2016-11-23 08:20:52.148 +0500 INFO: org.apache.catalina.startup.HostConfig Deploying web application directory C:\Users\User\Documents\BonitaBPMCommunity-7.3.1-Tomcat-7.0.67\webapps\manager
2016-11-23 08:20:52.324 +0500 INFO: org.apache.catalina.startup.HostConfig Deployment of web application directory C:\Users\User\Documents\BonitaBPMCommunity-7.3.1-Tomcat-7.0.67\webapps\manager has finished in 177 ms
2016-11-23 08:20:52.325 +0500 INFO: org.apache.catalina.startup.HostConfig Deploying web application directory C:\Users\User\Documents\BonitaBPMCommunity-7.3.1-Tomcat-7.0.67\webapps\ROOT
2016-11-23 08:20:52.462 +0500 INFO: org.apache.catalina.startup.HostConfig Deployment of web application directory C:\Users\User\Documents\BonitaBPMCommunity-7.3.1-Tomcat-7.0.67\webapps\ROOT has finished in 137 ms
2016-11-23 08:20:52.465 +0500 INFO: org.apache.coyote.http11.Http11Protocol Starting ProtocolHandler ["http-bio-8080"]
2016-11-23 08:20:52.500 +0500 INFO: org.apache.coyote.ajp.AjpProtocol Starting ProtocolHandler ["ajp-bio-8009"]
2016-11-23 08:20:52.503 +0500 INFO: org.apache.catalina.startup.Catalina Server startup in 35140 ms
there are 81 tables created in postgres bonita databsase in postgres.

Comments

Submitted by Sean McP on Wed, 11/23/2016 - 19:17

Can you share the process so we can look? This isn't a PostgreSQL problem...

Submitted by mainamaan77 on Wed, 11/23/2016 - 20:54

http://community.bonitasoft.com/project/process-variable-example process variable example is not working. Its not getting Input value at "Step 1" after instantiation form when i configure Bonita tomcat bundle with PostgreSQL. With default embedded h2 database this example is working fine thats why i am thinking that there might be some problem with configuration of PostgreSQL and Bonita tomcat bundle.

Submitted by Lionel Palacin on Wed, 11/23/2016 - 23:41

For me it doesn't look like a PostGreSQL issue either. From the logs file, it sounds like the inputs required by the contracts are not provided.

Depends the web browser you use, you can use the developer console to check the POST request sent at the submit. Make sure that the payload contains the expected inputs.

Submitted by mainamaan77 on Thu, 11/24/2016 - 09:07

This is the error i Got in firefoxin developer mode. I don't know what is that ... myProcessVariable is a Process Variable defined in process.
Error evaluating < formOutput > data: $data.processVariableValue is undefinedvendor.min.js:105:441
GET
XHR
http://localhost:8888/bonita/portal/resource/taskInstance/ProcessVariabl... [HTTP/1.1 403 Forbidden 0ms]
no element found

Submitted by mainamaan77 on Thu, 11/24/2016 - 09:07

This is the error i Got in firefoxin developer mode. I don't know what is that ... myProcessVariable is a Process Variable defined in process.
Error evaluating < formOutput > data: $data.processVariableValue is undefinedvendor.min.js:105:441
GET
XHR
http://localhost:8888/bonita/portal/resource/taskInstance/ProcessVariabl... [HTTP/1.1 403 Forbidden 0ms]
no element found

Submitted by mainamaan77 on Thu, 11/24/2016 - 09:35

i have used the same processVraiable example given at http://community.bonitasoft.com/project/process-variable-example. I import this .bos example in bonita studio and build .bar file. Simply install this .bar file in bonita portal and got all these errors which i have told you.

Submitted by mainamaan77 on Thu, 11/24/2016 - 11:15

I have OS Windows 7 64 bit.

Submitted by mainamaan77 on Tue, 11/29/2016 - 06:13

I am using jdk 8 and set java_home in system variables. what is the problem i don't know :(.

Submitted by mainamaan77 on Tue, 11/29/2016 - 06:13

I am using jdk 8 and set java_home in system variables. what is the problem i don't know :(.

Submitted by mainamaan77 on Tue, 11/29/2016 - 06:24

i am missing something in configuration or uploading ??please help.

Submitted by mainamaan77 on Tue, 11/29/2016 - 07:43

I am using windows 7 64 bit.

1 answer

1
0
-1
This one is the BEST answer!

Hi,

Please check the new version of the example . The issue has been fixed.

Cheers

Notifications