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:
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. asked 11 Nov '16, 15:21 mylesmcd |
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! answered 11 Nov '16, 17:21 collectearth ♦ |