java.sql.SQLException: Error executing count query: select count(*) as COUNT from haz.tsevent_vsqp, haz.signif_to_tsevent, haz.tsrunup_vsqp, haz.tsevent_and_vol_event where (tsevent_vsqp.YEAR <= 2004 and tsevent_vsqp.YEAR >= 2004) and lower(tsevent_vsqp.LOCATION_NAME) like '%sumatra%' and haz.tsevent_vsqp.id = haz.signif_to_tsevent.tsu_id(+) and haz.tsevent_vsqp.id = haz.tsrunup_vsqp.tsevent_id(+) and haz.tsevent_vsqp.id = haz.tsevent_and_vol_event.sig_id(+): ORA-00904: "HAZ"."TSEVENT_AND_VOL_EVENT"."SIG_ID": invalid identifier at gov.noaa.nndc.idb.render.QueryResultRenderer$1.call(QueryResultRenderer.java:298) at gov.noaa.nndc.idb.render.QueryResultRenderer$1.call(QueryResultRenderer.java:285) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.lang.Thread.run(Thread.java:619) Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "HAZ"."TSEVENT_AND_VOL_EVENT"."SIG_ID": invalid identifier at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) at gov.noaa.nndc.idb.render.QueryResultRenderer$1.call(QueryResultRenderer.java:291) ... 4 more