Java problem with Collect Earth 1.4.3 Saiku on Windows 10

  • Asked
  • Active
  • Viewed 6179 times
0

Hi, I have just installed Collect Earth 1.4.3 under Windows 10 and have hit what looks like an installation problem.

When I go to run Saiku Analysis I get the following message:

Windows cannot find 'C:\OpenForis\CollectEarth/java\bin\java.' Make sure you've typed the name correctly, then try again.

A couple of things:

  1. Note the stray forward slash in the middle of the message - hybrid Unix/Windows path??
  2. The Java folder at C:\OpenForis\CollectEarth\java is actually empty of any files.
  3. Even so, I have added JAVA_HOME and COLLECT_EARTH_JRE_HOME (with correct underscores) and pointed both to C:\OpenForis\CollectEarth\java. The problem persists. I did a full reinstall and the problem persists.
  4. The application log file is here (apologies for the length):

ERROR 2016-11-11 12:47:37,724 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No DEM information org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, elevation, slope, aspect FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: elevation); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignDimensionValues(AnalysisSaikuService.java:133) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:653) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 12:47:37,968 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No PNG Alu information available org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, land_use_subcategory FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignLUCDimensionValues(AnalysisSaikuService.java:231) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:661) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 12:47:38,130 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE= ERROR 2016-11-11 12:47:38,172 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 12:47:38,176 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 12:47:38,177 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 12:47:38,177 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 12:47:38,177 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 12:47:38,177 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 12:48:21,874 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE= ERROR 2016-11-11 12:48:21,902 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 12:48:21,906 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 12:48:21,906 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 12:48:21,906 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 12:48:21,906 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 12:48:21,907 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 12:48:21,911 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 12:48:25,274 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No DEM information org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, elevation, slope, aspect FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: elevation); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignDimensionValues(AnalysisSaikuService.java:133) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:653) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 12:48:25,553 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No PNG Alu information available org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, land_use_subcategory FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignLUCDimensionValues(AnalysisSaikuService.java:231) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:661) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 12:48:25,663 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE= ERROR 2016-11-11 12:48:25,682 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 12:48:25,686 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 12:48:25,686 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 12:48:25,686 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 12:48:25,687 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 12:48:25,687 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 12:52:09,566 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the file C:\OpenForis\CollectEarth/java\bin\java. ERROR 2016-11-11 12:52:10,927 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the file C:\OpenForis\CollectEarth/java\bin\java. ERROR 2016-11-11 14:08:25,638 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE= ERROR 2016-11-11 14:08:25,657 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 14:08:25,661 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 14:08:25,661 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 14:08:25,661 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 14:08:25,662 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 14:08:25,662 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 14:08:25,666 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 14:08:25,718 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE= ERROR 2016-11-11 14:08:25,736 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 14:08:25,741 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 14:08:25,741 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 14:08:25,741 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 14:08:25,741 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 14:08:25,742 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 14:08:32,318 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the file C:\OpenForis\CollectEarth/java\bin\java. ERROR 2016-11-11 15:01:37,457 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No DEM information org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, elevation, slope, aspect FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: elevation); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignDimensionValues(AnalysisSaikuService.java:133) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:653) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:01:37,755 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No PNG Alu information available org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, land_use_subcategory FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignLUCDimensionValues(AnalysisSaikuService.java:231) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:661) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:01:37,947 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using JAVA_HOME ERROR 2016-11-11 15:01:37,948 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:01:37,999 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:01:38,005 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:01:38,005 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:01:38,005 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:01:38,006 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 15:01:38,006 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:08:35,760 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using JAVA_HOME ERROR 2016-11-11 15:08:35,762 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:08:35,825 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:08:35,830 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:08:35,831 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:08:35,831 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:08:35,831 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 15:08:35,831 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:08:35,835 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 15:08:39,263 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No DEM information org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, elevation, slope, aspect FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: elevation); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignDimensionValues(AnalysisSaikuService.java:133) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:653) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:08:39,523 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No PNG Alu information available org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, land_use_subcategory FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignLUCDimensionValues(AnalysisSaikuService.java:231) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:661) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:08:39,645 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using JAVA_HOME ERROR 2016-11-11 15:08:39,645 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:08:39,676 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:08:39,680 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:08:39,680 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:08:39,680 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:08:39,680 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 15:08:39,681 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:08:42,227 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the file C:\OpenForis\CollectEarth/java\bin\java. ERROR 2016-11-11 15:08:43,649 [AWT-EventQueue-0] org.openforis.collect.earth.app.view.SaikuAnalysisListener: Error starting Saiku server java.lang.NullPointerException at org.openforis.collect.earth.app.view.InfiniteProgressMonitor.show(InfiniteProgressMonitor.java:131) at org.openforis.collect.earth.app.view.SaikuStarter.initializeAndOpen(SaikuStarter.java:73) at org.openforis.collect.earth.app.view.SaikuAnalysisListener.exportDataToRDB(SaikuAnalysisListener.java:58) at org.openforis.collect.earth.app.view.SaikuAnalysisListener.actionPerformed(SaikuAnalysisListener.java:28) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.AbstractButton.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$500(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) ERROR 2016-11-11 15:09:21,941 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using JAVA_HOME ERROR 2016-11-11 15:09:21,942 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using JAVA_HOME ERROR 2016-11-11 15:09:21,942 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:09:21,943 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:09:21,982 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:09:21,997 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:09:21,998 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:09:21,998 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:09:21,999 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 15:09:22,000 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:09:22,007 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 15:09:22,010 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:09:22,040 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:09:22,041 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:09:22,041 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:09:22,041 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 15:09:22,042 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:09:22,142 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 15:09:22,662 [Thread-3] org.openforis.collect.earth.app.service.BrowserService: Error quitting the browser org.openqa.selenium.remote.UnreachableBrowserException: Error communicating with the remote browser. It may have died. Build info: version: '2.53.1', revision: 'a36b8b1cd5757287168e54b817830adce9b0158d', time: '2016-06-30 19:26:09' System info: host: 'DESKTOP-4DTVLFC', ip: '172.30.106.138', os.name: 'Windows 10', os.arch: 'x86', os.version: '10.0', java.version: '1.8.0_101' Driver info: driver.version: RemoteWebDriver Capabilities [{applicationCacheEnabled=false, rotatable=false, mobileEmulationEnabled=false, networkConnectionEnabled=false, chrome={chromedriverVersion=2.24.417431 (9aea000394714d2fbb20850021f6204f2256b9cf), userDataDir=C:\Users\Myles\AppData\Local\Temp\scoped_dir8320_10904}, takesHeapSnapshot=true, pageLoadStrategy=normal, databaseEnabled=false, handlesAlerts=true, hasTouchScreen=false, version=54.0.2840.71, platform=XP, browserConnectionEnabled=false, nativeEvents=true, acceptSslCerts=true, locationContextEnabled=true, webStorageEnabled=true, browserName=chrome, takesScreenshot=true, javascriptEnabled=true, cssSelectorsEnabled=true}] Session ID: 1a29d354ef5b967b4984191791972aa8 at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:665) at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:701) at org.openqa.selenium.remote.RemoteWebDriver.quit(RemoteWebDriver.java:526) at org.openforis.collect.earth.app.service.BrowserService$8.run(BrowserService.java:882) Caused by: java.lang.RuntimeException: Process refused to die after 10 seconds, and couldn't taskkill it: Unable to find executable for: taskkill at org.openqa.selenium.os.ProcessUtils.killWinProcess(ProcessUtils.java:143) at org.openqa.selenium.os.ProcessUtils.killProcess(ProcessUtils.java:81) at org.openqa.selenium.os.UnixProcess$SeleniumWatchDog.destroyHarder(UnixProcess.java:247) at org.openqa.selenium.os.UnixProcess$SeleniumWatchDog.access$200(UnixProcess.java:201) at org.openqa.selenium.os.UnixProcess.destroy(UnixProcess.java:125) at org.openqa.selenium.os.CommandLine.destroy(CommandLine.java:155) at org.openqa.selenium.remote.service.DriverService.stop(DriverService.java:196) at org.openqa.selenium.remote.service.DriverCommandExecutor.execute(DriverCommandExecutor.java:94) at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:644) ... 3 more Caused by: java.lang.NullPointerException: Unable to find executable for: taskkill at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:251) at org.openqa.selenium.os.UnixProcess.<init>(UnixProcess.java:62) at org.openqa.selenium.os.CommandLine.<init>(CommandLine.java:38) at org.openqa.selenium.os.WindowsUtils.killPID(WindowsUtils.java:178) at org.openqa.selenium.os.ProcessUtils.killWinProcess(ProcessUtils.java:138) ... 11 more ERROR 2016-11-11 15:09:23,209 [Thread-3] org.openforis.collect.earth.app.service.BrowserService: Error quitting the browser org.openqa.selenium.remote.UnreachableBrowserException: Error communicating with the remote browser. It may have died. Build info: version: '2.53.1', revision: 'a36b8b1cd5757287168e54b817830adce9b0158d', time: '2016-06-30 19:26:09' System info: host: 'DESKTOP-4DTVLFC', ip: '172.30.106.138', os.name: 'Windows 10', os.arch: 'x86', os.version: '10.0', java.version: '1.8.0_101' Driver info: driver.version: RemoteWebDriver Capabilities [{applicationCacheEnabled=false, rotatable=false, mobileEmulationEnabled=false, networkConnectionEnabled=false, chrome={chromedriverVersion=2.24.417431 (9aea000394714d2fbb20850021f6204f2256b9cf), userDataDir=C:\Users\Myles\AppData\Local\Temp\scoped_dir11008_10988}, takesHeapSnapshot=true, pageLoadStrategy=normal, databaseEnabled=false, handlesAlerts=true, hasTouchScreen=false, version=54.0.2840.71, platform=XP, browserConnectionEnabled=false, nativeEvents=true, acceptSslCerts=true, locationContextEnabled=true, webStorageEnabled=true, browserName=chrome, takesScreenshot=true, javascriptEnabled=true, cssSelectorsEnabled=true}] Session ID: 52ab1b7be5b83ad14597ce476d641bcc at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:665) at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:701) at org.openqa.selenium.remote.RemoteWebDriver.quit(RemoteWebDriver.java:526) at org.openforis.collect.earth.app.service.BrowserService$8.run(BrowserService.java:882) Caused by: java.lang.RuntimeException: Process refused to die after 10 seconds, and couldn't taskkill it: Unable to find executable for: taskkill at org.openqa.selenium.os.ProcessUtils.killWinProcess(ProcessUtils.java:143) at org.openqa.selenium.os.ProcessUtils.killProcess(ProcessUtils.java:81) at org.openqa.selenium.os.UnixProcess$SeleniumWatchDog.destroyHarder(UnixProcess.java:247) at org.openqa.selenium.os.UnixProcess$SeleniumWatchDog.access$200(UnixProcess.java:201) at org.openqa.selenium.os.UnixProcess.destroy(UnixProcess.java:125) at org.openqa.selenium.os.CommandLine.destroy(CommandLine.java:155) at org.openqa.selenium.remote.service.DriverService.stop(DriverService.java:196) at org.openqa.selenium.remote.service.DriverCommandExecutor.execute(DriverCommandExecutor.java:94) at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:644) ... 3 more Caused by: java.lang.NullPointerException: Unable to find executable for: taskkill at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:251) at org.openqa.selenium.os.UnixProcess.<init>(UnixProcess.java:62) at org.openqa.selenium.os.CommandLine.<init>(CommandLine.java:38) at org.openqa.selenium.os.WindowsUtils.killPID(WindowsUtils.java:178) at org.openqa.selenium.os.ProcessUtils.killWinProcess(ProcessUtils.java:138) ... 11 more ERROR 2016-11-11 15:16:00,203 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No DEM information org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, elevation, slope, aspect FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: elevation); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignDimensionValues(AnalysisSaikuService.java:133) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:653) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:16:00,477 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No PNG Alu information available org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, land_use_subcategory FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignLUCDimensionValues(AnalysisSaikuService.java:231) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:661) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:16:00,646 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE= ERROR 2016-11-11 15:16:00,681 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:16:00,685 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:16:00,685 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:16:00,685 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:16:00,686 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 15:16:00,687 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:16:07,234 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the file C:\OpenForis\CollectEarth/java\bin\java. ERROR 2016-11-11 15:20:17,016 [Thread-11] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE= ERROR 2016-11-11 15:20:17,035 [Thread-11] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:20:17,039 [Thread-11] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:20:17,039 [Thread-11] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:20:17,039 [Thread-11] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:20:17,040 [Thread-11] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 15:20:17,040 [Thread-11] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:20:17,046 [Thread-11] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 15:20:17,644 [Thread-3] org.openforis.collect.earth.app.service.BrowserService: Error quitting the browser org.openqa.selenium.remote.UnreachableBrowserException: Error communicating with the remote browser. It may have died. Build info: version: '2.53.1', revision: 'a36b8b1cd5757287168e54b817830adce9b0158d', time: '2016-06-30 19:26:09' System info: host: 'DESKTOP-4DTVLFC', ip: '172.30.106.138', os.name: 'Windows 10', os.arch: 'x86', os.version: '10.0', java.version: '1.8.0_101' Driver info: driver.version: RemoteWebDriver Capabilities [{applicationCacheEnabled=false, rotatable=false, mobileEmulationEnabled=false, networkConnectionEnabled=false, chrome={chromedriverVersion=2.24.417431 (9aea000394714d2fbb20850021f6204f2256b9cf), userDataDir=C:\Users\Myles\AppData\Local\Temp\scoped_dir3672_21228}, takesHeapSnapshot=true, pageLoadStrategy=normal, databaseEnabled=false, handlesAlerts=true, hasTouchScreen=false, version=54.0.2840.71, platform=XP, browserConnectionEnabled=false, nativeEvents=true, acceptSslCerts=true, locationContextEnabled=true, webStorageEnabled=true, browserName=chrome, takesScreenshot=true, javascriptEnabled=true, cssSelectorsEnabled=true}] Session ID: 7b67026b8d159c12534ab135124a385e at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:665) at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:701) at org.openqa.selenium.remote.RemoteWebDriver.quit(RemoteWebDriver.java:526) at org.openforis.collect.earth.app.service.BrowserService$8.run(BrowserService.java:882) Caused by: java.lang.RuntimeException: Process refused to die after 10 seconds, and couldn't taskkill it: Unable to find executable for: taskkill at org.openqa.selenium.os.ProcessUtils.killWinProcess(ProcessUtils.java:143) at org.openqa.selenium.os.ProcessUtils.killProcess(ProcessUtils.java:81) at org.openqa.selenium.os.UnixProcess$SeleniumWatchDog.destroyHarder(UnixProcess.java:247) at org.openqa.selenium.os.UnixProcess$SeleniumWatchDog.access$200(UnixProcess.java:201) at org.openqa.selenium.os.UnixProcess.destroy(UnixProcess.java:125) at org.openqa.selenium.os.CommandLine.destroy(CommandLine.java:155) at org.openqa.selenium.remote.service.DriverService.stop(DriverService.java:196) at org.openqa.selenium.remote.service.DriverCommandExecutor.execute(DriverCommandExecutor.java:94) at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:644) ... 3 more Caused by: java.lang.NullPointerException: Unable to find executable for: taskkill at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:251) at org.openqa.selenium.os.UnixProcess.<init>(UnixProcess.java:62) at org.openqa.selenium.os.CommandLine.<init>(CommandLine.java:38) at org.openqa.selenium.os.WindowsUtils.killPID(WindowsUtils.java:178) at org.openqa.selenium.os.ProcessUtils.killWinProcess(ProcessUtils.java:138) ... 11 more ERROR 2016-11-11 15:21:29,086 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No DEM information org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, elevation, slope, aspect FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: elevation); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignDimensionValues(AnalysisSaikuService.java:133) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:653) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:21:29,321 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No PNG Alu information available org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, land_use_subcategory FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignLUCDimensionValues(AnalysisSaikuService.java:231) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:661) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:21:29,445 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using COLLECT_EARTH_JRE_HOME ERROR 2016-11-11 15:21:29,445 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:21:29,465 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:21:29,469 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:21:29,470 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:21:29,470 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:21:29,470 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: C:\OpenForis\CollectEarth\java ERROR 2016-11-11 15:21:29,470 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:35:34,810 [Thread-10] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using COLLECT_EARTH_JRE_HOME ERROR 2016-11-11 15:35:34,811 [Thread-10] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:35:34,833 [Thread-10] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:35:34,838 [Thread-10] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:35:34,838 [Thread-10] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:35:34,839 [Thread-10] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:35:34,839 [Thread-10] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: C:\OpenForis\CollectEarth\java ERROR 2016-11-11 15:35:34,839 [Thread-10] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:35:34,844 [Thread-10] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 15:35:38,064 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No DEM information org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, elevation, slope, aspect FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: elevation); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignDimensionValues(AnalysisSaikuService.java:133) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:653) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:35:38,296 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No PNG Alu information available org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, land_use_subcategory FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignLUCDimensionValues(AnalysisSaikuService.java:231) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:661) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:35:38,406 [Thread-12] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using COLLECT_EARTH_JRE_HOME ERROR 2016-11-11 15:35:38,407 [Thread-12] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:35:38,431 [Thread-12] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:35:38,437 [Thread-12] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:35:38,438 [Thread-12] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:35:38,438 [Thread-12] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:35:38,438 [Thread-12] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: C:\OpenForis\CollectEarth\java ERROR 2016-11-11 15:35:38,439 [Thread-12] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:35:42,192 [Thread-12] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the file C:\OpenForis\CollectEarth/java\bin\java. ERROR 2016-11-11 15:36:24,113 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using COLLECT_EARTH_JRE_HOME ERROR 2016-11-11 15:36:24,114 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:36:24,138 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:36:24,143 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:36:24,143 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:36:24,143 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:36:24,143 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: C:\OpenForis\CollectEarth\java ERROR 2016-11-11 15:36:24,143 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:36:24,148 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 15:36:27,233 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No DEM information org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, elevation, slope, aspect FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: elevation); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignDimensionValues(AnalysisSaikuService.java:133) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:653) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:36:27,476 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No PNG Alu information available org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, land_use_subcategory FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignLUCDimensionValues(AnalysisSaikuService.java:231) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:661) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:36:27,576 [Thread-18] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using COLLECT_EARTH_JRE_HOME ERROR 2016-11-11 15:36:27,576 [Thread-18] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:36:27,600 [Thread-18] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:36:27,605 [Thread-18] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:36:27,606 [Thread-18] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:36:27,606 [Thread-18] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:36:27,606 [Thread-18] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: C:\OpenForis\CollectEarth\java ERROR 2016-11-11 15:36:27,606 [Thread-18] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:36:31,527 [Thread-18] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the file C:\OpenForis\CollectEarth/java\bin\java. ERROR 2016-11-11 15:44:55,572 [Thread-23] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using COLLECT_EARTH_JRE_HOME ERROR 2016-11-11 15:44:55,573 [Thread-23] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:44:55,604 [Thread-25] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using COLLECT_EARTH_JRE_HOME ERROR 2016-11-11 15:44:55,606 [Thread-25] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:44:55,648 [Thread-23] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:44:55,650 [Thread-27] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using COLLECT_EARTH_JRE_HOME ERROR 2016-11-11 15:44:55,653 [Thread-27] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:44:55,656 [Thread-23] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:44:55,656 [Thread-23] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:44:55,656 [Thread-23] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:44:55,656 [Thread-23] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: C:\OpenForis\CollectEarth\java ERROR 2016-11-11 15:44:55,657 [Thread-23] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:44:55,662 [Thread-23] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 15:44:55,674 [Thread-25] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:44:55,687 [Thread-25] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:44:55,687 [Thread-25] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:44:55,688 [Thread-25] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:44:55,688 [Thread-25] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: C:\OpenForis\CollectEarth\java ERROR 2016-11-11 15:44:55,689 [Thread-25] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:44:55,694 [Thread-25] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 15:44:55,707 [Thread-27] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:44:55,716 [Thread-27] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:44:55,716 [Thread-27] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:44:55,717 [Thread-27] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:44:55,718 [Thread-27] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: C:\OpenForis\CollectEarth\java ERROR 2016-11-11 15:44:55,719 [Thread-27] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:44:55,725 [Thread-27] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 15:44:56,193 [Thread-3] org.openforis.collect.earth.app.service.BrowserService: Error quitting the browser org.openqa.selenium.remote.UnreachableBrowserException: Error communicating with the remote browser. It may have died. Build info: version: '2.53.1', revision: 'a36b8b1cd5757287168e54b817830adce9b0158d', time: '2016-06-30 19:26:09' System info: host: 'DESKTOP-4DTVLFC', ip: '172.30.106.138', os.name: 'Windows 10', os.arch: 'x86', os.version: '10.0', java.version: '1.8.0_101' Driver info: driver.version: RemoteWebDriver Capabilities [{applicationCacheEnabled=false, rotatable=false, mobileEmulationEnabled=false, networkConnectionEnabled=false, chrome={chromedriverVersion=2.24.417431 (9aea000394714d2fbb20850021f6204f2256b9cf), userDataDir=C:\Users\Myles\AppData\Local\Temp\scoped_dir4172_24029}, takesHeapSnapshot=true, pageLoadStrategy=normal, databaseEnabled=false, handlesAlerts=true, hasTouchScreen=false, version=54.0.2840.71, platform=XP, browserConnectionEnabled=false, nativeEvents=true, acceptSslCerts=true, locationContextEnabled=true, webStorageEnabled=true, browserName=chrome, takesScreenshot=true, javascriptEnabled=true, cssSelectorsEnabled=true}] Session ID: 06990647f5a7b32c545286f4ca0be6bf at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:665) at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:701) at org.openqa.selenium.remote.RemoteWebDriver.quit(RemoteWebDriver.java:526) at org.openforis.collect.earth.app.service.BrowserService$8.run(BrowserService.java:882) Caused by: java.lang.RuntimeException: Process refused to die after 10 seconds, and couldn't taskkill it: Unable to find executable for: taskkill at org.openqa.selenium.os.ProcessUtils.killWinProcess(ProcessUtils.java:143) at org.openqa.selenium.os.ProcessUtils.killProcess(ProcessUtils.java:81) at org.openqa.selenium.os.UnixProcess$SeleniumWatchDog.destroyHarder(UnixProcess.java:247) at org.openqa.selenium.os.UnixProcess$SeleniumWatchDog.access$200(UnixProcess.java:201) at org.openqa.selenium.os.UnixProcess.destroy(UnixProcess.java:125) at org.openqa.selenium.os.CommandLine.destroy(CommandLine.java:155) at org.openqa.selenium.remote.service.DriverService.stop(DriverService.java:196) at org.openqa.selenium.remote.service.DriverCommandExecutor.execute(DriverCommandExecutor.java:94) at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:644) ... 3 more Caused by: java.lang.NullPointerException: Unable to find executable for: taskkill at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:251) at org.openqa.selenium.os.UnixProcess.<init>(UnixProcess.java:62) at org.openqa.selenium.os.CommandLine.<init>(CommandLine.java:38) at org.openqa.selenium.os.WindowsUtils.killPID(WindowsUtils.java:178) at org.openqa.selenium.os.ProcessUtils.killWinProcess(ProcessUtils.java:138) ... 11 more ERROR 2016-11-11 15:44:56,888 [Thread-3] org.openforis.collect.earth.app.service.BrowserService: Error quitting the browser org.openqa.selenium.remote.UnreachableBrowserException: Error communicating with the remote browser. It may have died. Build info: version: '2.53.1', revision: 'a36b8b1cd5757287168e54b817830adce9b0158d', time: '2016-06-30 19:26:09' System info: host: 'DESKTOP-4DTVLFC', ip: '172.30.106.138', os.name: 'Windows 10', os.arch: 'x86', os.version: '10.0', java.version: '1.8.0_101' Driver info: driver.version: RemoteWebDriver Capabilities [{applicationCacheEnabled=false, rotatable=false, mobileEmulationEnabled=false, networkConnectionEnabled=false, chrome={chromedriverVersion=2.24.417431 (9aea000394714d2fbb20850021f6204f2256b9cf), userDataDir=C:\Users\Myles\AppData\Local\Temp\scoped_dir1604_3085}, takesHeapSnapshot=true, pageLoadStrategy=normal, databaseEnabled=false, handlesAlerts=true, hasTouchScreen=false, version=54.0.2840.71, platform=XP, browserConnectionEnabled=false, nativeEvents=true, acceptSslCerts=true, locationContextEnabled=true, webStorageEnabled=true, browserName=chrome, takesScreenshot=true, javascriptEnabled=true, cssSelectorsEnabled=true}] Session ID: cfc9be07919b34a6110bdeb309904a6f at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:665) at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:701) at org.openqa.selenium.remote.RemoteWebDriver.quit(RemoteWebDriver.java:526) at org.openforis.collect.earth.app.service.BrowserService$8.run(BrowserService.java:882) Caused by: java.lang.RuntimeException: Process refused to die after 10 seconds, and couldn't taskkill it: Unable to find executable for: taskkill at org.openqa.selenium.os.ProcessUtils.killWinProcess(ProcessUtils.java:143) at org.openqa.selenium.os.ProcessUtils.killProcess(ProcessUtils.java:81) at org.openqa.selenium.os.UnixProcess$SeleniumWatchDog.destroyHarder(UnixProcess.java:247) at org.openqa.selenium.os.UnixProcess$SeleniumWatchDog.access$200(UnixProcess.java:201) at org.openqa.selenium.os.UnixProcess.destroy(UnixProcess.java:125) at org.openqa.selenium.os.CommandLine.destroy(CommandLine.java:155) at org.openqa.selenium.remote.service.DriverService.stop(DriverService.java:196) at org.openqa.selenium.remote.service.DriverCommandExecutor.execute(DriverCommandExecutor.java:94) at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:644) ... 3 more Caused by: java.lang.NullPointerException: Unable to find executable for: taskkill at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:251) at org.openqa.selenium.os.UnixProcess.<init>(UnixProcess.java:62) at org.openqa.selenium.os.CommandLine.<init>(CommandLine.java:38) at org.openqa.selenium.os.WindowsUtils.killPID(WindowsUtils.java:178) at org.openqa.selenium.os.ProcessUtils.killWinProcess(ProcessUtils.java:138) ... 11 more ERROR 2016-11-11 15:45:58,413 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No DEM information org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, elevation, slope, aspect FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: elevation); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignDimensionValues(AnalysisSaikuService.java:133) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:653) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:45:58,679 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No PNG Alu information available org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, land_use_subcategory FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignLUCDimensionValues(AnalysisSaikuService.java:231) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:661) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:45:58,804 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using JAVA_HOME ERROR 2016-11-11 15:45:58,805 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:45:58,825 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:45:58,829 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:45:58,829 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:45:58,829 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:45:58,829 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: C:\OpenForis\CollectEarth\java ERROR 2016-11-11 15:45:58,829 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:46:48,486 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the file C:\OpenForis\CollectEarth/java\bin\java.

0

Accepted answer

Thanks for reporting the issue!

This problem is due to the Windows installer for version 1.4.3 missing the associated Java Runtime Environment

We just released a new version (1.4.5) that fixes the issue.

Please proceed to download the installer again LINK (a simple update will not be enough, as the updater file does not include the JRE) and install the application again( the new version 1.4.5) . The data you already collected and everything else will be kept so don't worry about that.

Thank you again for reporting the issue!

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.