--- title: "Java problem with Collect Earth 1.4.3 Saiku on Windows 10" url: "https://openforis.support/questions/886/java-problem-with-collect-earth-143-saiku-on-windows-10" tags: ["saiku", "openforis"] status: "answered" score: 0 answer_count: 1 asked: "2016-11-11T15:21:28" last_activity: "2016-11-11T17:21:56" source: "Open Foris Support - Q&A Forum" license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license." --- # Java problem with Collect Earth 1.4.3 Saiku on Windows 10 Asked by mylesmcd on 2016-11-11 Hi, I have just installed Collect Earth 1.4.3 under Windows 10 and have hit what looks like an installation problem. When I go to run Saiku Analysis I get the following message: Windows cannot find 'C:\OpenForis\CollectEarth**/**java\bin\java.' Make sure you've typed the name correctly, then try again. A couple of things: 1. Note the stray forward slash in the middle of the message - hybrid Unix/Windows path?? 2. The Java folder at C:\OpenForis\CollectEarth\java is actually empty of any files. 3. Even so, I have added JAVA_HOME and COLLECT_EARTH_JRE_HOME (with correct underscores) and pointed both to C:\OpenForis\CollectEarth\java. The problem persists. I did a full reinstall and the problem persists. 4. The application log file is here (apologies for the length): ERROR 2016-11-11 12:47:37,724 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No DEM information org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, elevation, slope, aspect FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: elevation); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignDimensionValues(AnalysisSaikuService.java:133) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:653) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 12:47:37,968 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No PNG Alu information available org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, land_use_subcategory FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignLUCDimensionValues(AnalysisSaikuService.java:231) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:661) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 12:47:38,130 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE= ERROR 2016-11-11 12:47:38,172 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 12:47:38,176 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 12:47:38,177 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 12:47:38,177 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 12:47:38,177 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 12:47:38,177 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 12:48:21,874 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE= ERROR 2016-11-11 12:48:21,902 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 12:48:21,906 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 12:48:21,906 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 12:48:21,906 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 12:48:21,906 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 12:48:21,907 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 12:48:21,911 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 12:48:25,274 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No DEM information org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, elevation, slope, aspect FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: elevation); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignDimensionValues(AnalysisSaikuService.java:133) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:653) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 12:48:25,553 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No PNG Alu information available org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, land_use_subcategory FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignLUCDimensionValues(AnalysisSaikuService.java:231) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:661) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 12:48:25,663 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE= ERROR 2016-11-11 12:48:25,682 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 12:48:25,686 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 12:48:25,686 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 12:48:25,686 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 12:48:25,687 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 12:48:25,687 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 12:52:09,566 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the file C:\OpenForis\CollectEarth/java\bin\java. ERROR 2016-11-11 12:52:10,927 [Thread-16] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the file C:\OpenForis\CollectEarth/java\bin\java. ERROR 2016-11-11 14:08:25,638 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE= ERROR 2016-11-11 14:08:25,657 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 14:08:25,661 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 14:08:25,661 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 14:08:25,661 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 14:08:25,662 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 14:08:25,662 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 14:08:25,666 [Thread-26] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 14:08:25,718 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE= ERROR 2016-11-11 14:08:25,736 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 14:08:25,741 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 14:08:25,741 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 14:08:25,741 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 14:08:25,741 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 14:08:25,742 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 14:08:32,318 [Thread-28] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the file C:\OpenForis\CollectEarth/java\bin\java. ERROR 2016-11-11 15:01:37,457 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No DEM information org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, elevation, slope, aspect FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: elevation); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignDimensionValues(AnalysisSaikuService.java:133) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:653) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:01:37,755 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No PNG Alu information available org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, land_use_subcategory FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignLUCDimensionValues(AnalysisSaikuService.java:231) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:661) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:01:37,947 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using JAVA_HOME ERROR 2016-11-11 15:01:37,948 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:01:37,999 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:01:38,005 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:01:38,005 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:01:38,005 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:01:38,006 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 15:01:38,006 [Thread-6] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:08:35,760 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using JAVA_HOME ERROR 2016-11-11 15:08:35,762 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:08:35,825 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:08:35,830 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:08:35,831 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:08:35,831 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:08:35,831 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 15:08:35,831 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:08:35,835 [Thread-13] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 15:08:39,263 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No DEM information org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, elevation, slope, aspect FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: elevation); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignDimensionValues(AnalysisSaikuService.java:133) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:653) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: elevation) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:08:39,523 [Start Saiku server/initialize RDB] org.openforis.collect.earth.app.service.AnalysisSaikuService: No PNG Alu information available org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT _plot_id, land_use_subcategory FROM plot]; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480) at org.openforis.collect.earth.app.service.AnalysisSaikuService.assignLUCDimensionValues(AnalysisSaikuService.java:231) at org.openforis.collect.earth.app.service.AnalysisSaikuService.processQuantityData(AnalysisSaikuService.java:661) at org.openforis.collect.earth.app.service.AnalysisSaikuService.exportDataToRDB(AnalysisSaikuService.java:611) at org.openforis.collect.earth.app.service.AnalysisSaikuService.prepareDataForAnalysis(AnalysisSaikuService.java:534) at org.openforis.collect.earth.app.view.SaikuStarter$1.run(SaikuStarter.java:56) Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_subcategory) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:81) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:454) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) ... 7 more ERROR 2016-11-11 15:08:39,645 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using JAVA_HOME ERROR 2016-11-11 15:08:39,645 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:08:39,676 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:08:39,680 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:08:39,680 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:08:39,680 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:08:39,680 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 15:08:39,681 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:08:42,227 [Thread-15] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the file C:\OpenForis\CollectEarth/java\bin\java. ERROR 2016-11-11 15:08:43,649 [AWT-EventQueue-0] org.openforis.collect.earth.app.view.SaikuAnalysisListener: Error starting Saiku server java.lang.NullPointerException at org.openforis.collect.earth.app.view.InfiniteProgressMonitor.show(InfiniteProgressMonitor.java:131) at org.openforis.collect.earth.app.view.SaikuStarter.initializeAndOpen(SaikuStarter.java:73) at org.openforis.collect.earth.app.view.SaikuAnalysisListener.exportDataToRDB(SaikuAnalysisListener.java:58) at org.openforis.collect.earth.app.view.SaikuAnalysisListener.actionPerformed(SaikuAnalysisListener.java:28) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.AbstractButton.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$500(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.awt.EventQueue$4.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) ERROR 2016-11-11 15:09:21,941 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using JAVA_HOME ERROR 2016-11-11 15:09:21,942 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: Using JAVA_HOME ERROR 2016-11-11 15:09:21,942 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:09:21,943 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: DEBUG: JAVA EXECUTABLE=C:\OpenForis\CollectEarth\java\bin\java.exe ERROR 2016-11-11 15:09:21,982 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:09:21,997 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:09:21,998 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:09:21,998 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:09:21,999 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 15:09:22,000 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:09:22,007 [Thread-22] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 15:09:22,010 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: SET ABSOLUTE REFERENCE TO COLLECT EARTH JRE ERROR 2016-11-11 15:09:22,040 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_BASE: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:09:22,041 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_HOME: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat ERROR 2016-11-11 15:09:22,041 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CATALINA_TMPDIR: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\temp ERROR 2016-11-11 15:09:22,041 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using COLLECT_EARTH_JRE_HOME: ERROR 2016-11-11 15:09:22,042 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: Using CLASSPATH: C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\bin\bootstrap.jar ERROR 2016-11-11 15:09:22,142 [Thread-20] org.openforis.collect.earth.app.service.ProcessLoggerThread: The system cannot find the path specified. ERROR 2016-11-11 15:09:22,662 [Thread-3] org.openforis.collect.earth.app.service.BrowserService: Error quitting the browser org.openqa.selenium.remote.UnreachableBrowserException: Error communicating with the remote browser. It may have died. Build info: version: '2.53.1', revision: 'a36b8b1cd5757287168e54b817830adce9b0158d', time: '2016-06-30 19:26:09' System info: host: 'DESKTOP-4DTVLFC', ip: '172.30.106.138', os.name: 'Windows 10', os.arch: 'x86', os.version: '10.0', java.version: '1.8.0_101' Driver info: driver.version: RemoteWebDriver Capabilities [{applicationCacheEnabled=false, rotatable=false, mobileEmulationEnabled=false, networkConnectionEnabled=false, chrome={chromedriverVersion=2.24.417431 (9aea000394714d2fbb20850021f6204f2256b9cf), userDataDir=C:\Users\Myles\AppData\Local\Temp\scoped_dir8320_10904}, takesHeapSnapshot=true, pageLoadStrategy=normal, databaseEnabled=false, handlesAlerts=true, hasTouchScreen=false, version=54.0.2840.71, platform=XP, browserConnectionEnabled=false, nativeEvents=true, acceptSslCerts=true, locationContextEnabled=true, webStorageEnabled=true, browserName=chrome, takesScreenshot=true, javascriptEnabled=true, cssSelectorsEnabled=true}] Session ID: 1a29d354ef5b967b4984191791972aa8 at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:665) at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:701) at org.openqa.selenium.remote.RemoteWebDriver.quit(RemoteWebDriver.java:526) at org.openforis.collect.earth.app.service.BrowserService$8.run(BrowserService.java:882) Caused by: java.lang.RuntimeException: Process refused to die after 10 seconds, and couldn't taskkill it: Unable to find executable for: taskkill at org.openqa.selenium.os.ProcessUtils.killWinProcess(ProcessUtils.java:143) at org.openqa.selenium.os.ProcessUtils.killProcess(ProcessUtils.java:81) at org.openqa.selenium.os.UnixProcess$SeleniumWatchDog.destroyHarder(UnixProcess.java:247) at org.openqa.selenium.os.UnixProcess$SeleniumWatchDog.access$200(UnixProcess.java:201) at org.openqa.selenium.os.UnixProcess.destroy(UnixProcess.java:125) at org.openqa.selenium.os.CommandLine.destroy(CommandLine.java:155) at org.openqa.selenium.remote.service.DriverService.stop(DriverService.java:196) at org.openqa.selenium.remote.service.DriverCommandExecutor.execute(DriverCommandExecutor.java:94) at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:644) ... 3 more Caused by: java.lang.NullPointerException: Unable to find executable for: taskkill at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:251) at org.openqa.selenium.os.UnixProcess.(UnixProcess.java:62) at org.openqa.selenium.os.CommandLine.(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.(UnixProcess.java:62) at org.openqa.selenium.os.CommandLine.(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.(UnixProcess.java:62) at org.openqa.selenium.os.CommandLine.(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.(UnixProcess.java:62) at org.openqa.selenium.os.CommandLine.(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.(UnixProcess.java:62) at org.openqa.selenium.os.CommandLine.(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. ## Answer (score 0, by collectearth on 2016-11-11) Link: https://openforis.support/questions/886/java-problem-with-collect-earth-143-saiku-on-windows-10/889 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][1] (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! [1]: http://www.openforis.org/nexus/service/local/artifact/maven/redirect?r=releases&g=org.openforis.collect.earth&a=collect-earth-installer&v=LATEST&c=windows&e=exe