For any discussion or question related to installation of Joget Workflow. The installation bundles can be downloaded from http://www.joget.org/download
For any discussion or question related to installation of Joget Workflow. The installation bundles can be downloaded from http://www.joget.org/download
20 Comments
gonzalo cepeda
Hi,
I installed Joget in a server, and in the server irself is working properly but I can't see it from another computer/browser in the net.
I think is something related with Apache configuration.
Please Helpo
Tiensoon
Are you able to ping the server's hostname/IP from other computer?
Paula Lovera
Hi,
I installed joget, but when I want to start the server, it doesn't work. The command window shows that the server it's going to start in XXXX minutes, but the number of minutes never change.
What is the problem?
Tiensoon
Hi Paula,
When you are starting up Joget server (by using the Start Joget Server menu in Windows for example), a black console window will popup, and it will stop at a line like:
INFO: Server startup in 18731 ms
The actual ms could differ. Don't close this console window, leave it open.
Then, go to your web browser, enter *http://localhost:8080/wflow-wfweb*, or open the "Joget Workflow v2 > Workflow Management Console" in your Windows Start menu. Please refer to "Designing a Process" in the Knowledge Base for reference.
Paul
Hi,
I get an error page every so often. It typically happens with I login or I'm editing something. If I click Refresh I can ALWAYS continue. Sometimes it takes a couple refreshes, but usually after the first refresh JoGet is fine and I can continue my work. I'm running V2 on Linux (CentOS) and MySQL ver is 5.1.56.
Here is the error output:
Oops, a problem has occurred (Code 500)
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataAccessResourceFailureException: could not execute query; nested exception is org.hibernate.exception.JDBCConnectionException: could not execute query
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:583)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
....
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)
... 121 more
Any suggestions?
Tiensoon
Hi Paul, the MySQL JDBC driver in Joget Workflow v2.0.1 and earlier is having a known issue like what you have described, with MySQL 5.1.56. May I suggest you to upgrade your Joget Workflow to v2.0.2?
Then, login to Workflow Management Console, Settings > System Setup. In the "Datasource and Profile Settings", append &autoReconnect=true to all the five datasource URLs. Save the changes, and restart Joget Workflow.
Paul
Thanks for the info. I made those changes. It seems better. However I still get the error (just less often). It typically happens when I leave the site for a minute and then return to do an update. Is the db timing out? Perhaps this is a different issue?
I get this error:
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataAccessResourceFailureException: could not load an entity: [FormVariable#45d680a6-ae799a3f-3b59a690-64e78121]; nested exception is org.hibernate.exception.JDBCConnectionException: could not load an entity: [FormVariable#45d680a6-ae799a3f-3b59a690-64e78121]
...
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Paul
Would this work? http://www.databasesandlife.com/automatic-reconnect-from-hibernate-to-mysql/
How would I do this?
Paul
Here is the tomcat output... the error seems to happen after 60 seconds of inactivity (even with no action taken in the workflow manager):
ERROR 20 Jul 2011 13:10:07 DatabaseManager - <SqlQueryExecute><SqlQueryException>(<Replicated>:Communications link failure
The last packet successfully received from the server was 60,406 milliseconds ago. The last packet sent successfully to the server was 19 milliseconds ago.)
ERROR 20 Jul 2011 13:10:07 Shark - SharkConnectionImpl -> Unexpected error while user roleAnonymous loggs on
com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:Communications link failure
The last packet successfully received from the server was 60,406 milliseconds ago. The last packet sent successfully to the server was 19 milliseconds ago.) at org.enhydra.shark.instancepersistence.data.ResourceQuery._runQuery(ResourceQuery.java:1181) at org.enhydra.shark.instancepersistence.data.ResourceQuery.runQuery(ResourceQuery.java:632) at org.enhydra.shark.instancepersistence.data.ResourceQuery.getNextDO(ResourceQuery.java:1406)
ERROR 20 Jul 2011 13:10:07 DatabaseManager - <SqlQueryExecute><SqlQueryException>(<Replicated>:Communications link failure
The last packet successfully received from the server was 60,406 milliseconds ago. The last packet sent successfully to the server was 19 milliseconds ago.)
ERROR 20 Jul 2011 13:10:07 Shark - SharkConnectionImpl -> Unexpected error while user roleAnonymous loggs on
com.lutris.dods.builder.generator.query.DataObjectException: Unknown SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:Communications link failure
The last packet successfully received from the server was 60,406 milliseconds ago. The last packet sent successfully to the server was 19 milliseconds ago.)
at org.enhydra.shark.instancepersistence.data.ResourceQuery._runQuery(ResourceQuery.java:1181)
at org.enhydra.shark.instancepersistence.data.ResourceQuery.runQuery(ResourceQuery.java:632)
at org.enhydra.shark.instancepersistence.data.ResourceQuery.getNextDO(ResourceQuery.java:1406)
s77007
Hi,
Can i remove/uninstall joget completely from windows pc, tried to remove it from control panel but its not removed completely?
Any ideas or uninstaller available for this task?
Thanks
Tiensoon
In Windows, running the Uninstall.exe will remove Joget Workflow application files from the PC. What's intentionally left behind, is the database data and the /wflow folder. It's intentionally left behind, so that the next time when you install Joget Workflow again, the data still exists. However, if you prefer to remove everything, you can just delete the whole Joget folder from its installation direction.
Eduardo Cabrera
Hi, I have problems when I start Tomcat on Ubuntu 11.04. The error message is as follows. Can you help me ?
edo@edo-virtual-machine:/opt/joget/joget-linux-2.0.1$ sudo sh tomcat6.sh run
Using CATALINA_BASE: /opt/joget/joget-linux-2.0.1/apache-tomcat-6.0.18
Using CATALINA_HOME: /opt/joget/joget-linux-2.0.1/apache-tomcat-6.0.18
Using CATALINA_TMPDIR: /opt/joget/joget-linux-2.0.1/apache-tomcat-6.0.18/temp
Using JRE_HOME: /usr
30-ago-2011 18:34:32 org.apache.catalina.core.AprLifecycleListener init
INFO: Loaded APR based Apache Tomcat Native library 1.1.20.
30-ago-2011 18:34:32 org.apache.catalina.core.AprLifecycleListener init
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
30-ago-2011 18:34:32 org.apache.coyote.http11.Http11AprProtocol init
GRAVE: Error inicializando punto final (endpoint)
java.lang.Exception: Socket bind failed: [22] Invalid argument
at org.apache.tomcat.util.net.AprEndpoint.init(AprEndpoint.java:612)
at org.apache.coyote.http11.Http11AprProtocol.init(Http11AprProtocol.java:107)
at org.apache.catalina.connector.Connector.initialize(Connector.java:1058)
at org.apache.catalina.core.StandardService.initialize(StandardService.java:677)
at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:795)
at org.apache.catalina.startup.Catalina.load(Catalina.java:530)
at org.apache.catalina.startup.Catalina.load(Catalina.java:550)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:260)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:412)
30-ago-2011 18:34:32 org.apache.catalina.startup.Catalina load
GRAVE: Catalina.start
LifecycleException: Fall� la inicializaci�n del manejador de protocolo: java.lang.Exception: Socket bind failed: [22] Invalid argument
at org.apache.catalina.connector.Connector.initialize(Connector.java:1060)
at org.apache.catalina.core.StandardService.initialize(StandardService.java:677)
at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:795)
at org.apache.catalina.startup.Catalina.load(Catalina.java:530)
at org.apache.catalina.startup.Catalina.load(Catalina.java:550)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:260)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:412)
30-ago-2011 18:34:32 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1832 ms
30-ago-2011 18:34:33 org.apache.catalina.core.StandardService start
INFO: Arrancando servicio Catalina
30-ago-2011 18:34:33 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
INFO 30 ago 2011 18:34:46 org.joget.commons.util.SetupManager - Using base directory: ./wflow/
INFO 30 ago 2011 18:34:46 org.joget.commons.util.DynamicDataSource - datasourceName=workflow, url=jdbc:mysql://localhost:3306/wflowdb?characterEncoding=UTF-8, user=root
INFO 30 ago 2011 18:34:48 org.joget.plugin.base.PluginManager - PluginManager initialized
INFO 30 ago 2011 18:34:53 org.joget.plugin.base.PluginManager - Bundle org.joget.plugin.referenceid.wflow-plugin-referenceId started
INFO 30 ago 2011 18:34:53 org.joget.plugin.base.PluginManager - Bundle org.joget.plugin.json.wflow-plugin-json started
INFO 30 ago 2011 18:34:54 org.joget.plugin.base.PluginManager - Bundle org.joget.plugin.etl.wflow-plugin-mysql started
INFO 30 ago 2011 18:34:54 org.joget.plugin.base.PluginManager - Bundle org.joget.wflow-plugin-formDataEtl started
INFO 30 ago 2011 18:34:54 org.joget.plugin.base.PluginManager - Bundle org.joget.wflow-plugin-report started
INFO 30 ago 2011 18:34:54 org.joget.plugin.base.PluginManager - Bundle org.joget.wflow-plugin-userNotification started
INFO 30 ago 2011 18:34:55 org.joget.plugin.base.PluginManager - Bundle org.joget.wflow-plugin-beanshell started
INFO 30 ago 2011 18:34:55 org.joget.plugin.base.PluginManager - Bundle org.joget.wflow-plugin-email started
INFO 30 ago 2011 18:34:55 org.joget.commons.util.DynamicDataSource - datasourceName=directory, url=jdbc:mysql://localhost:3306/wflowdb?characterEncoding=UTF-8, user=root
INFO 30 ago 2011 18:34:56 org.joget.commons.util.DynamicDataSource - datasourceName=workflow, url=jdbc:mysql://localhost:3306/wflowdb?characterEncoding=UTF-8, user=root
INFO 30 ago 2011 18:34:57 org.joget.commons.util.DynamicDataSource - datasourceName=form, url=jdbc:mysql://localhost:3306/wflowdb?characterEncoding=UTF-8, user=root
INFO 30 ago 2011 18:34:57 org.joget.commons.util.DynamicDataSource - datasourceName=workflow, url=jdbc:mysql://localhost:3306/wflowdb?characterEncoding=UTF-8, user=root
SharkEngineManager -> Shark engine is being initialized ...
2011-08-30 18:35:00,082: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API
2011-08-30 18:35:00,087: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactory' implementation of core SharkObjectFactory API
2011-08-30 18:35:00,087: SharkEngineManager -> Working with 'org.joget.workflow.shark.WorkflowToolActivityHandler' implementation of core ToolAgentManager API
2011-08-30 18:35:00,087: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API
2011-08-30 18:35:00,158: WorkflowAssignmentManager -> Working with 'org.joget.workflow.shark.WorkflowUserGroupManagerAdmin' implementation of UserGroup API
2011-08-30 18:35:00,158: WorkflowAssignmentManager. -> Working without ParticipantMapping API implementation - ParticipantMappingManager is not specified.
2011-08-30 18:35:00,158: SharkEngineManager -> Working with 'org.joget.workflow.shark.WorkflowAssignmentManager' implementation of Assignment API
2011-08-30 18:35:00,158: SharkEngineManager -> Working without Caching API implementation - CacheManager is not specified.
2011-08-30 18:35:00,236: DODSPersistentManager -> Adding shutdown hook for HSQL DB
2011-08-30 18:35:00,524: datasourceName=shark, url=jdbc:mysql://localhost:3306/wflowdb?characterEncoding=UTF-8, user=root
2011-08-30 18:35:01,477: Starting synchronous cache load for class: org.enhydra.shark.instancepersistence.data.ProcessStateDO
2011-08-30 18:35:01,580: Finished synchronous cache load for class: org.enhydra.shark.instancepersistence.data.ProcessStateDO
2011-08-30 18:35:01,897: Starting synchronous cache load for class: org.enhydra.shark.instancepersistence.data.ActivityStateDO
2011-08-30 18:35:01,909: Finished synchronous cache load for class: org.enhydra.shark.instancepersistence.data.ActivityStateDO
2011-08-30 18:35:01,978: DODSPersistentManager -> persisting String variables into BLOB for sizes greater than 4000
2011-08-30 18:35:01,978: SharkEngineManager -> Working with 'org.joget.workflow.shark.WorkflowDODSPersistentManager' implementation of InstancePersistence API
2011-08-30 18:35:01,981: SharkEngineManager -> Working with 'org.joget.workflow.shark.WorkflowEventAuditManager' implementation of EventAudit API
2011-08-30 18:35:02,175: SharkEngineManager -> Working with 'org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager' implementation of RepositoryPersistence API
2011-08-30 18:35:02,184: SharkEngineManager -> Working with 'org.joget.workflow.shark.WorkflowScriptingManager' implementation of Scripting API
2011-08-30 18:35:02,185: SharkEngineManager -> Working without Security API implementation - SecurityManager is not specified.
2011-08-30 18:35:02,716: StandardToolAgentManager -> Working with 'org.enhydra.shark.appmappersistence.DODSApplicationMappingAdmin' implementation of ApplicationMapPersistence API
2011-08-30 18:35:02,716: SharkEngineManager -> Working with 'org.enhydra.shark.toolagent.StandardToolAgentManager' implementation of ToolAgentManager API
2011-08-30 18:35:02,716: SharkEngineManager -> Working without wfEngineInteroperability API implementation - WfEngineInteroperability implementation is not specified.
2011-08-30 18:35:02,804: SharkUtilities -> synchronizing XPDL cache
Shark -> shark engine initialization is finished, it lasted 2 [s]
Shark -> SharkExampleJSP ready and waiting ...
2011-08-30 18:35:03,145: datasourceName=report, url=jdbc:mysql://localhost:3306/wflowdb?characterEncoding=UTF-8, user=root
30-ago-2011 18:35:07 org.apache.coyote.http11.Http11AprProtocol start
GRAVE: Error arrancando punto final (endpoint)
java.lang.Exception: Socket bind failed: [22] Invalid argument
at org.apache.tomcat.util.net.AprEndpoint.init(AprEndpoint.java:612)
at org.apache.tomcat.util.net.AprEndpoint.start(AprEndpoint.java:717)
at org.apache.coyote.http11.Http11AprProtocol.start(Http11AprProtocol.java:137)
at org.apache.catalina.connector.Connector.start(Connector.java:1131)
at org.apache.catalina.core.StandardService.start(StandardService.java:531)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
30-ago-2011 18:35:07 org.apache.catalina.startup.Catalina start
GRAVE: Catalina.start:
LifecycleException: service.getName(): "Catalina"; Fall� el arranque del manejador de protocolo: java.lang.Exception: Socket bind failed: [22] Invalid argument
at org.apache.catalina.connector.Connector.start(Connector.java:1138)
at org.apache.catalina.core.StandardService.start(StandardService.java:531)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
30-ago-2011 18:35:07 org.apache.catalina.startup.Catalina start
INFO: Server startup in 35019 ms
30-ago-2011 18:35:07 org.apache.catalina.core.StandardServer await
GRAVE: StandardServer.await: create[8005]:
java.net.BindException: Address already in use
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:353)
at java.net.ServerSocket.bind(ServerSocket.java:336)
at java.net.ServerSocket.<init>(ServerSocket.java:202)
at org.apache.catalina.core.StandardServer.await(StandardServer.java:373)
at org.apache.catalina.startup.Catalina.await(Catalina.java:642)
at org.apache.catalina.startup.Catalina.start(Catalina.java:602)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
30-ago-2011 18:35:07 org.apache.coyote.http11.Http11AprProtocol pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
30-ago-2011 18:35:07 org.apache.coyote.ajp.AjpAprProtocol pause
INFO: Pausing Coyote AJP/1.3 on ajp-8009
30-ago-2011 18:35:08 org.apache.catalina.core.StandardService stop
INFO: Parando servicio Catalina
30-ago-2011 18:35:09 org.apache.catalina.connector.MapperListener destroy
ADVERTENCIA: Error unregistering MBeanServerDelegate
java.lang.NullPointerException
at org.apache.catalina.connector.MapperListener.destroy(MapperListener.java:165)
at org.apache.catalina.connector.Connector.stop(Connector.java:1179)
at org.apache.catalina.core.StandardService.stop(StandardService.java:593)
at org.apache.catalina.core.StandardServer.stop(StandardServer.java:744)
at org.apache.catalina.startup.Catalina.stop(Catalina.java:628)
at org.apache.catalina.startup.Catalina$CatalinaShutdownHook.run(Catalina.java:671)
30-ago-2011 18:35:09 org.apache.coyote.http11.Http11AprProtocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
30-ago-2011 18:35:09 org.apache.catalina.connector.Connector stop
GRAVE: El conector Coyote no ha sido arrancado
APR Statistical data ....
Poll Statistics .........
Polls created : 0
Polls destroyed : 0
Polls cleared : 0
Network Statistics ......
Sockets created : 2
Sockets accepted : 0
Sockets closed : 1
Sockets cleared : 1
Total send calls : 0
Minimum send length : 10000000
Maximum send length : 0
Average send length : -nan
Total recv calls : 0
Minimum recv length : 10000000
Maximum recv length : 0
Average recv length : -nan
Receive timeouts : 0
Receive errors : 0
Receive resets : 0
Last receive error : 0
Total sendfile calls : 0
Minimum sendfile lenght : 10000000
Maximum sendfile lenght : 0
SSL Network Statistics ..
Sockets created : 0
Sockets accepted : 0
Sockets closed : 0
Sockets cleared : 0
APR Terminated
edo@edo-virtual-machine:/opt/joget/joget-linux-2.0.1$
Eduardo Cabrera
In addition to my previous question, how I can insert into a MySQL table when an activity occurs an event of approval or rejection in a form?
Thanks
Edo.
Paul
In your workflow create a Tool in the System swimlane. In the Joget Console set this Tool to use the MySQL plugin. Then configure the Tool to do the SQL insert.
And in your workflow create a workflow variable called something like 'activtiy_status' and then have two transition arrows.... each with a Condition activity_status=='approval' or activity_status=='reject'. And have each transition go to the appropriate Tool that does the MySQL insert.
Eduardo Cabrera
Ok, Thanks
But I have another question.
How to get the data form to insert data in MySql?
For example : INSERT INTO table VALUES (data1-form, data2-form, etc.)
Paul
Hashvariables. You'll use them in LOTs of places. You can pull data from Forms, Workflow Variables, Activity Info, User Info,etc.
Go to the Hash Variables page for more details.
For the data form you want to do this:
For example : INSERT INTO table VALUES (#form.FORMDATATABLENAME.FIELDNAME#)
Replace FORMDATATABLENAME with the name of the form you want to pull from and replace FIELDNAME with the name of the field on the form. Be sure to give all the fields on your form logical names, it'll make your life much easier.
Eduardo Cabrera
Excellent, thank you very much
Regards,
Edo.
Eduardo Cabrera
Can you help me with the error described above thet says:
Hi, I have problems when I start Tomcat on Ubuntu 11.04. The error message is as follows. Can you help me ?
Tiensoon
The error says "Socket bind failed".
Is there any other app already using port 8080? You can try to change the Tomcat HTTP connector port by modifying /apache-tomcat-6.0.18/conf/server.xml
Eduardo Cabrera
Ok, thanks.
I will follow your instructions.