[Geoserver-users] GetFeatureInfo error

GeoServer GeoServer User
1

I user mapbuilder 1.0 with geoserver 1.3.I got error when I clicked
getFeatureInfo button and click on map in <div ="featureInfo"></div>
show
_______________
Layer
ServiceExceition
GetFeatureInfo error:Translator error
_______________

and This is Exception in Log file
22329047 [INFO] org.vfny.geoserver.servlets.AbstractService - handling
request: org.vfny.geoserver.wms.requests.GetFeatureInfoRequest@anonymised.com
22329047 [WARNING] org.geotools.filter.SQLEncoderOracle - Invalid filter.
Cannot have a Geometry filter with only one expression.
22329057 [SEVERE] org.geotools.data.jdbc.JDBC1DataStore - Error Performing
SQL query: SELECT "PK250INDEX", "LENGTH", "CLIP_ID", "FNODE_", "TNODE_",
"LPOLY_", "RPOLY_", "THAIFRAM_", "THAIFRAM_I", "GEOM" FROM
"K250_INDEX_THAILAND_LINE" WHERE
22329067 [INFO] org.vfny.geoserver.servlets.PartialBufferStrategy -
OutputStream was successfully aborted.
22329067 [INFO] org.vfny.geoserver.servlets.AbstractService - Had an
undefined error: Error Performing SQL query: SELECT "PK250INDEX", "LENGTH",
"CLIP_ID", "FNODE_", "TNODE_", "LPOLY_", "RPOLY_", "THAIFRAM_",
"THAIFRAM_I", "GEOM" FROM "K250_INDEX_THAILAND_LINE" WHERE
org.vfny.geoserver.wms.WmsException: Error Performing SQL query: SELECT
"PK250INDEX", "LENGTH", "CLIP_ID", "FNODE_", "TNODE_", "LPOLY_", "RPOLY_",
"THAIFRAM_", "THAIFRAM_I", "GEOM" FROM "K250_INDEX_THAILAND_LINE" WHERE
  at
org.vfny.geoserver.wms.WmsExceptionHandler.newServiceException(WmsExceptionHandler.java:64)
  at
org.vfny.geoserver.servlets.AbstractService.sendError(AbstractService.java:749)
  at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:521)
  at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:276)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doResponse(WmsDispatcher.java:156)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doGet(WmsDispatcher.java:115)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
  at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
  at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
  at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
  at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
  at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
  at java.lang.Thread.run(Unknown Source)

This is my config
<GetFeatureInfo id="getFeatureInfo">
    <buttonBar>mainButtonBar</buttonBar>
    <targetModel>featureInfoResponse</targetModel>
    <mouseHandler>mainAoi</mouseHandler>
    <class>RadioButton</class>
    <enabledSrc>/images/QueryEnable.png</enabledSrc>
    <disabledSrc>/images/QueryDisable.png</disabledSrc>
    <context>mainMap</context>
</GetFeatureInfo>

<Model id="featureInfoResponse" template="true">
      <namespace>xmlns:gml='http://www.opengis.net/gml’
xmlns:wfs='http://www.opengis.net/wfs’
xmlns:topp='http://www.openplans.org/topp’
xmlns:thai='../../wfs'</namespace>
      <widgets>
        <FeatureInfo id="features">
          <htmlTagId>featureInfo</htmlTagId>
        </FeatureInfo>
      </widgets>
</Model>

something wrong?
--
View this message in context: http://www.nabble.com/GetFeatureInfo+error-t1704383.html#a4626307
Sent from the GeoServer - User forum at Nabble.com.

2

I try to get featureinfo with another layer alway get same log with "Cannot
have a Geometry filter with only one expression."
and sql select is missing expression after WHERE

I don't know why?

This is fine log

2 ÁÔ.Â. 2549 0:39:17
org.geotools.data.jdbc.ConnectionPool$ConnectionListManager connectionClosed
FINE: Connection closed - adding to available connections.
2 ÁÔ.Â. 2549 0:39:17 org.geotools.filter.SQLEncoderOracle <init>
FINE: SQLEncoderOracle: Geometric Column is: GEOM
2 ÁÔ.Â. 2549 0:39:17 AbstractFilter isLogicFilter
FINER: ENTRY 7
2 ÁÔ.Â. 2549 0:39:17 org.geotools.filter.SQLEncoderOracle <init>
FINE: SQLEncoderOracle: Geometric Column is: GEOM
2 ÁÔ.Â. 2549 0:39:17 AbstractFilter isLogicFilter
FINER: ENTRY 7
2 ÁÔ.Â. 2549 0:39:17 org.geotools.data.jdbc.JDBC1DataStore constructQuery
FINE: calling sql builder with filter [ POLYGON ((100.39417175
16.736972972972975, 100.48859275 16.736972972972975, 100.48859275
16.65363135135135, 100.39417175 16.65363135135135, 100.39417175
16.736972972972975)) intersects null ]
2 ÁÔ.Â. 2549 0:39:17 AbstractFilter isLogicFilter
FINER: ENTRY 7
2 ÁÔ.Â. 2549 0:39:17 org.geotools.filter.SQLEncoderOracle visit
FINER: Visiting a Geometry filter
2 ÁÔ.Â. 2549 0:39:17 org.geotools.filter.SQLEncoderOracle doSdoRelate
WARNING: Invalid filter. Cannot have a Geometry filter with only one
expression.
2 ÁÔ.Â. 2549 0:39:17 org.geotools.data.jdbc.JDBC1DataStore constructQuery
FINE: sql is SELECT "PK250INDEX", "LENGTH", "CLIP_ID", "FNODE_", "TNODE_",
"LPOLY_", "RPOLY_", "THAIFRAM_", "THAIFRAM_I", "GEOM" FROM
"K250_INDEX_THAILAND_LINE" WHERE
2 ÁÔ.Â. 2549 0:39:17 org.geotools.data.jdbc.JDBC1DataStore executeQuery
FINE: About to execute query: SELECT "PK250INDEX", "LENGTH", "CLIP_ID",
"FNODE_", "TNODE_", "LPOLY_", "RPOLY_", "THAIFRAM_", "THAIFRAM_I", "GEOM"
FROM "K250_INDEX_THAILAND_LINE" WHERE
2 ÁÔ.Â. 2549 0:39:17 org.geotools.data.jdbc.ConnectionPool getConnection
FINE: Getting available connection.
2 ÁÔ.Â. 2549 0:39:17 org.geotools.data.jdbc.JDBC1DataStore executeQuery
SEVERE: Error Performing SQL query: SELECT "PK250INDEX", "LENGTH",
"CLIP_ID", "FNODE_", "TNODE_", "LPOLY_", "RPOLY_", "THAIFRAM_",
"THAIFRAM_I", "GEOM" FROM "K250_INDEX_THAILAND_LINE" WHERE
java.sql.SQLException: ORA-00936: missing expression

  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
  at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
  at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
  at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
  at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
  at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
  at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
  at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:623)
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:925)
  at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:684)
  at
org.geotools.data.jdbc.JDBCFeatureSource$1.reader(JDBCFeatureSource.java:206)
  at
org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:395)
  at
org.geotools.xml.transform.TransformerBase$XMLReaderSupport.parse(TransformerBase.java:603)
  at org.apache.xalan.transformer.TransformerIdentityImpl.transform(Unknown
Source)
  at
org.geotools.xml.transform.TransformerBase$Task.run(TransformerBase.java:285)
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:118)
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:97)
  at
org.vfny.geoserver.wfs.responses.GML2FeatureResponseDelegate.encode(GML2FeatureResponseDelegate.java:225)
  at
org.vfny.geoserver.wms.responses.featureInfo.GmlFeatureInfoResponse.writeTo(GmlFeatureInfoResponse.java:86)
  at
org.vfny.geoserver.wms.responses.GetFeatureInfoResponse.writeTo(GetFeatureInfoResponse.java:162)
  at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:510)
  at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:276)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doResponse(WmsDispatcher.java:156)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doGet(WmsDispatcher.java:115)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipelisform.TransformerBase.transform(TransformerBase.java:118)
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:97)
  at
org.vfny.geoserver.wfs.responses.GML2FeatureResponseDelegate.encode(GML2FeatureResponseDelegate.java:225)
  at
org.vfny.geoserver.wms.responses.featureInfo.GmlFeatureInfoResponse.writeTo(GmlFeatureInfoResponse.java:86)
  at
org.vfny.geoserver.wms.responses.GetFeatureInfoResponse.writeTo(GetFeatureInfoResponse.java:162)
  at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:510)
  at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:276)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doResponse(WmsDispatcher.java:156)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doGet(WmsDispatcher.java:115)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
  at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
  at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
  at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
  at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
  at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
  at java.lang.Thread.run(Unknown Source)
2 ÁÔ.Â. 2549 0:39:17
org.geotools.data.jdbc.ConnectionPool$ConnectionListManager connectionClosed
FINE: Connection closed - adding to available connections.
2 ÁÔ.Â. 2549 0:39:17 org.vfny.geoserver.ServiceException <init>
FINE: GetFeatureInfo error:Translator error
2 ÁÔ.Â. 2549 0:39:17 org.vfny.geoserver.wms.responses.GetFeatureInfoResponse
abort
FINE: asking delegate for aborting the process
2 ÁÔ.Â. 2549 0:39:17 org.vfny.geoserver.servlets.PartialBufferStrategy abort
INFO: OutputStream was successfully aborted.
2 ÁÔ.Â. 2549 0:39:17 org.vfny.geoserver.ServiceException getXmlResponse
WARNING: encountered error: GetFeatureInfo error:Translator error
StackTrace: javax.xml.transform.TransformerException: Translator error
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:122)
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:97)
  at
org.vfny.geoserver.wfs.responses.GML2FeatureResponseDelegate.encode(GML2FeatureResponseDelegate.java:225)
  at
org.vfny.geoserver.wms.responses.featureInfo.GmlFeatureInfoResponse.writeTo(GmlFeatureInfoResponse.java:86)
  at
org.vfny.geoserver.wms.responses.GetFeatureInfoResponse.writeTo(GetFeatureInfoResponse.java:162)
  at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:510)
  at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:276)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doResponse(WmsDispatcher.java:156)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doGet(WmsDispatcher.java:115)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
  at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
  at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
  at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
  at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
  at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
  at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: error reading FeatureResults
  at
org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:404)
  at
org.geotools.xml.transform.TransformerBase$XMLReaderSupport.parse(TransformerBase.java:603)
  at org.apache.xalan.transformer.TransformerIdentityImpl.transform(Unknown
Source)
  at
org.geotools.xml.transform.TransformerBase$Task.run(TransformerBase.java:285)
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:118)
  ... 39 more
Caused by: org.geotoolne.java:567)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
  at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
  at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
  at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
  at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
  at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
  at java.lang.Thread.run(Unknown Source)
2 ÁÔ.Â. 2549 0:39:17
org.geotools.data.jdbc.ConnectionPool$ConnectionListManager connectionClosed
FINE: Connection closed - adding to available connections.
2 ÁÔ.Â. 2549 0:39:17 org.vfny.geoserver.ServiceException <init>
FINE: GetFeatureInfo error:Translator error
2 ÁÔ.Â. 2549 0:39:17 org.vfny.geoserver.wms.responses.GetFeatureInfoResponse
abort
FINE: asking delegate for aborting the process
2 ÁÔ.Â. 2549 0:39:17 org.vfny.geoserver.servlets.PartialBufferStrategy abort
INFO: OutputStream was successfully aborted.
2 ÁÔ.Â. 2549 0:39:17 org.vfny.geoserver.ServiceException getXmlResponse
WARNING: encountered error: GetFeatureInfo error:Translator error
StackTrace: javax.xml.transform.TransformerException: Translator error
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:122)
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:97)
  at
org.vfny.geoserver.wfs.responses.GML2FeatureResponseDelegate.encode(GML2FeatureResponseDelegate.java:225)
  at
org.vfny.geoserver.wms.responses.featureInfo.GmlFeatureInfoResponse.writeTo(GmlFeatureInfoResponse.java:86)
  at
org.vfny.geoserver.wms.responses.GetFeatureInfoResponse.writeTo(GetFeatureInfoResponse.java:162)
  at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:510)
  at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:276)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doResponse(WmsDispatcher.java:156)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doGet(WmsDispatcher.java:115)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
  at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
  at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
  at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
  at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
  at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
  at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: error reading FeatureResults
  at
org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:404)
  at
org.geotools.xml.transform.TransformerBase$XMLReaderSupport.parse(TransformerBase.java:603)
  at org.apache.xalan.transformer.TransformerIdentityImpl.transform(Unknown
Source)
  at
org.geotools.xml.transform.TransformerBase$Task.run(TransformerBase.java:285)
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:118)
  ... 39 more
Caused by: org.geotools.data.DataSourceException: Error Performing SQL
query: SELECT "PK250INDEX", "LENGTH", "CLIP_ID", "FNODE_", "TNODE_",
"LPOLY_", "RPOLY_", "THAIFRAM_", "THAIFRAM_I", "GEOM" FROM
"K250_INDEX_THAILAND_LINE" WHERE
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:936)
  at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:684)
  at
org.geotools.data.jdbc.JDBCFeatureSource$1.reader(JDBCFeatureSource.java:206)
  at
org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:395)
  ... 43 more
Caused by: java.sql.SQLException: ORA-00936: missing expression

  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
  at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
  at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
  at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
  at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
  at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
  at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
  at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:623)
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:925)
  ... 46 more
---------
java.lang.RuntimeException: error reading FeatureResults
  at
org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:404)
  at
org.geotools.xml.transform.TransformerBase$XMLReaderSupport.parse(TransformerBase.java:603)
  at org.apache.xalan.transformer.TransformerIdentityImpl.transform(Unknown
Source)
  at
org.geotools.xml.transform.TransformerBase$Task.run(TransformerBase.java:285)
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:118)
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:97)
  at
org.vfny.geoserver.wfs.responses.GML2FeatureResponseDelegate.encode(GML2FeatureResponseDelegate.java:225)
  at
org.vfny.geoserver.wms.responses.featureInfo.GmlFeatureInfoResponse.writeTo(GmlFeatureInfoResponse.java:86)
  at org.vfny.geoserver.wms.resps.data.DataSourceException: Error Performing
SQL query: SELECT "PK250INDEX", "LENGTH", "CLIP_ID", "FNODE_", "TNODE_",
"LPOLY_", "RPOLY_", "THAIFRAM_", "THAIFRAM_I", "GEOM" FROM
"K250_INDEX_THAILAND_LINE" WHERE
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:936)
  at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:684)
  at
org.geotools.data.jdbc.JDBCFeatureSource$1.reader(JDBCFeatureSource.java:206)
  at
org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:395)
  ... 43 more
Caused by: java.sql.SQLException: ORA-00936: missing expression

  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
  at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
  at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
  at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
  at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
  at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
  at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
  at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:623)
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:925)
  ... 46 more
---------
java.lang.RuntimeException: error reading FeatureResults
  at
org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:404)
  at
org.geotools.xml.transform.TransformerBase$XMLReaderSupport.parse(TransformerBase.java:603)
  at org.apache.xalan.transformer.TransformerIdentityImpl.transform(Unknown
Source)
  at
org.geotools.xml.transform.TransformerBase$Task.run(TransformerBase.java:285)
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:118)
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:97)
  at
org.vfny.geoserver.wfs.responses.GML2FeatureResponseDelegate.encode(GML2FeatureResponseDelegate.java:225)
  at
org.vfny.geoserver.wms.responses.featureInfo.GmlFeatureInfoResponse.writeTo(GmlFeatureInfoResponse.java:86)
  at
org.vfny.geoserver.wms.responses.GetFeatureInfoResponse.writeTo(GetFeatureInfoResponse.java:162)
  at
org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:510)
  at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:276)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doResponse(WmsDispatcher.java:156)
  at
org.vfny.geoserver.wms.servlets.WmsDispatcher.doGet(WmsDispatcher.java:115)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
  at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
  at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
  at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
  at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
  at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
  at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
  at java.lang.Thread.run(Unknown Source)
Caused by: org.geotools.data.DataSourceException: Error Performing SQL
query: SELECT "PK250INDEX", "LENGTH", "CLIP_ID", "FNODE_", "TNODE_",
"LPOLY_", "RPOLY_", "THAIFRAM_", "THAIFRAM_I", "GEOM" FROM
"K250_INDEX_THAILAND_LINE" WHERE
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:936)
  at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:684)
  at
org.geotools.data.jdbc.JDBCFeatureSource$1.reader(JDBCFeatureSource.java:206)
  at
org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:395)
  ... 43 more
Caused by: java.sql.SQLException: ORA-00936: missing expression

  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
  at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
  at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
  at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
  at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
  at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
  at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
  at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:623)
  at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:925)
  ... 46 more

--
View this message in context: http://www.nabble.com/GetFeatureInfo-error-t1704383.html#a4673898
Sent from the GeoServer - User forum at Nabble.com.