Troubleshooting - Common Errors

Introduction

Common errors

File and directory issues

• Missing Configuration Files
  • Error:
    
    ERROR org.joget.commons.util.DynamicDataSourceManager - java.io.FileNotFoundException: .\wflow\app_datasource.properties (The system cannot find the file specified)
    Reason: The .\wflow\app_datasource.properties file is missing but Joget will present option on browser screen to connect to a database and build the tables
  • Error:
    ERROR org.joget.commons.util.DynamicDataSourceManager - java.io.FileNotFoundException: .\wflowxx\app_datasource.properties (The system cannot find the path specified)
    Reason: The "joget-start.bat" file has an incorrect "set JAVA_OPTS=-Dwflow.home=./wflow/" folder name or the folder does not exist or the folder has no read write permission.
• Incorrect File Paths and Permissions
  Error:
  
  ERROR org.joget.commons.util.DynamicDataSourceManager - java.io.FileNotFoundException: C:\Users\Andrew\wflow\app_datasource.properties (The system cannot find the path specified) java.io.FileNotFoundException: C:\Users\Andrew\wflow\app_datasource.properties (The system cannot find the path specified)
  Reason: The "joget-start.bat" file is missing the "set JAVA_OPTS=-Xmx512M -Dwflow.home=./wflow/ -javaagent:./wflow/aspectjweaver-1.8.5.jar" line. The missing "Dwflow.home=./wflow/" parameter will also cause Joget to think that the database datasource is missing and will present you with the setup database screen.

Database connection and configuration issues

• Troubleshooting Connection Refusals
  Error:
  
  org.joget.commons.spring.web.CustomContextLoaderListener - ===== Error initializing WebApplicationContext ===== SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool. java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=localhost)(port=3307)(type=master) : Connection refused: connect
  Reason: Joget could not connect to the database, either the database is not running or the datasource values (db name, port, username, password) are wrong in .\wflow\app_datasource*.properties.
• Resolving Authentication and Authorization Problems
  Error:
  
  SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool. java.sql.SQLSyntaxErrorException: Could not connect: Access denied for user ''@'localhost' to database 'jwdb'
  Reason: The database username is likely wrong.
• Fixing Database Driver Errors
  Error:
  
  SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool. java.sql.SQLException: Driver:com.mysql.jdbc.Driver@1edd5c1 returned null for URL:jdbc:mysqxl://localhost:3307/jwdb_snapshot2?characterEncoding=UTF-8&useSSL=false
  Reason: The database driver name is likely wrong.
• Invalid Authorization Specifications
  Error:
  
  SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool. java.sql.SQLInvalidAuthorizationSpecException: Could not connect: Access denied for user 'root'@'localhost' (using password: YES)
  Reason: The database password is likely wrong.
• Connection Refusal
  Error:
  SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool. java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=localhost)(port=3306)(type=master) : Connection refused: connect
  Reason: The database port is likely wrong.
• Unknown Database
  Error:
  SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool. java.sql.SQLSyntaxErrorException: Could not connect: Unknown database 'jwdb_x'
  Reason: The database name is likely wrong.

Server and deployment issues

• Addressing Port Conflicts
  Error:
  SEVERE [main] org.apache.coyote.AbstractProtocol.init Failed to initialize end point associated with ProtocolHandler ["http-nio-8080"] java.net.BindException: Address already in use: bind SEVERE [main] org.apache.catalina.core.StandardService.initInternal Failed to initialize connector [Connector[HTTP/1.1-8080]] org.apache.catalina.LifecycleException: Failed to initialize component [Connector[HTTP/1.1-8080]] Caused by: org.apache.catalina.LifecycleException: Protocol handler initialization failed Caused by: java.net.BindException: Address already in use: bind
  Reason: You are running two tomcat instances on the same port. The second tomcat instances will fail to run due to port conflict. You can change the port number in "...\apache-tomcat-8.5.23\conf\server.xml" file.
• Resolving Server Initialization Issues
  Error:
  
  SEVERE [localhost-startStop-1] org.aspectj.weaver.tools.Jdk14Trace.error register definition failed java.lang.RuntimeException: Cannot register non aspect: org$enhydra$shark$SharkUtilitiesAspect , org.enhydra.shark.SharkUtilitiesAspect at org.aspectj.weaver.bcel.BcelWeaver.addLibraryAspect(BcelWeaver.java:219) SEVERE [localhost-startStop-1] org.apache.catalina.core.ContainerBase.addChildInternal ContainerBase.addChild: start: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/jw]] Caused by: java.lang.NoClassDefFoundError: org/springframework/web/bind/MissingServletRequestParameterException Caused by: java.lang.ClassNotFoundException: org.springframework.web.bind.MissingServletRequestParameterException SEVERE [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Error deploying web application archive java.lang.IllegalStateException: ContainerBase.addChild: start: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/jw]]
  Reason: There is a problem with the "...\apache-tomcat-8.5.23\webapps\jw\WEB-INF\lib" folder. Stop the Tomcat, delete the "...\apache-tomcat-8.5.23\webapps\jw" folder and restart Tomcat.
• 404 Not Found Errors
  Error:
  Browser: HTTP Status 404 – Not Found Message /jw/... Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.
  Reason: There is a problem with the "...\apache-tomcat-8.5.23\webapps\jw\WEB-INF\classes" or "lib" folder. Stop the Tomcat, delete the "...\apache-tomcat-8.5.23\webapps\jw" folder and restart Tomcat.
• Tag Library Issues
  Error:
  ERROR UserviewUtil - ubuilder/adminBar.jsp org.apache.jasper.JasperException: /WEB-INF/jsp/console/apps/adminBar.jsp (line: [78], column: [8]) No tag [popupdialog] defined in tag library imported with prefix [ui]
  Reason: There is a problem with the "...\apache-tomcat-8.5.23\webapps\jw\WEB-INF\tags" folder. Stop the Tomcat, delete the "...\apache-tomcat-8.5.23\webapps\jw" folder and restart Tomcat

AspectJ weaver problems

• Diagnosing and Fixing AspectJ Weaver Errors
  Error:
  ERROR Shark - Problem while initializing caches !!! java.io.StreamCorruptedException: invalid stream header: 48414841 at java.base/java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:911) at java.base/java.io.ObjectInputStream.<init>(ObjectInputStream.java:350) at org.enhydra.shark.xpdl.XMLUtil.deserialize(XMLUtil.java:1604) at org.enhydra.shark.xpdl.XMLInterfaceForJDK13.openPackageFromStream(XMLInterfaceForJDK13.java:309) at org.enhydra.shark.SharkUtilities.restorePackage(SharkUtilities.java:1463) at org.enhydra.shark.SharkUtilities.synchronizeXPDLCache(SharkUtilities.java:1418) at org.enhydra.shark.SharkUtilities.restorePackages(SharkUtilities.java:1450) at org.enhydra.shark.SharkEngineManager.initCaches(SharkEngineManager.java:978) at org.enhydra.shark.SharkEngineManager.init(SharkEngineManager.java:874) at org.enhydra.shark.SharkEngineManager.configure(SharkEngineManager.java:535)
  Reason: AspectJ Weaver is missing. Add "-javaagent:$JOGET_HOME/lib/aspectjweaver-1.8.5.jar" into JAVA_OPTS start up script.