1 Reply Latest reply: Aug 21, 2012 8:57 AM by diegoweber RSS

    themebased -FOI error

    920209
      [MVThemeBasedFOIControl.foiLoaded]MAPVIEWER-05523:Cannot process response from Mapviewer server.(mapviewer -06009:error processing an FOI request.
      Root cause:FOIServlet:Mapviewer-01015: Unable to retrieve theme_definition.[mvdemo.cities_near_customer])
      this error I am continuously getting....
      I have followed instructions given on oracle maps blog:
      http://oraclemaps.blogspot.in/2011/09/finding-sales-offices-within-certain.html

      This is my mapviewer log information

      Jun 9, 2012 1:29:13 AM oracle.lbs.foi.FOIServlet sendGZippedResponse
      FINEST: Sending FOI response in gzip format.
      Jun 9, 2012 1:29:16 AM oracle.lbs.foi.FOIServlet doPost
      FINER: [foi] received request.
      Jun 9, 2012 1:29:16 AM oracle.lbs.foi.FOIServlet dumpURLParams
      FINEST: Servlet URL parameters (/foi):
      [request] [getthemeid]
      End of servlet URL parameters (/foi).

      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: J2EE user: oc4jadmin
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Osso-User-Dn: null
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Osso-User-Guid: null
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Osso-Subscriber: null
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Osso-Subscriber-Dn: null
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Osso-Subscriber-Guid: null
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Lang/Territory: en-US,en;q=0.8
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Session USER_NAME:null
      Jun 9, 2012 1:29:16 AM oracle.lbs.foi.FOIServlet doPost
      FINER: [foi] received request.
      Jun 9, 2012 1:29:16 AM oracle.lbs.foi.FOIServlet dumpURLParams
      FINEST: Servlet URL parameters (/foi):
      [param2] [37.80411]
      [aw] [no]
      [paramnum] [3]
      [width] [2816]
      [theme] [mvdemo.cities_near_customer]
      [height] [1024]
      [tid] [1_7
      ]
      [dstsrid] [8307]
      [cachefoi] [yes]
      [bbox] [-123.3238821158981:37.43642075137882:-121.45730338318816:38.11517665418242]
      [param1] [-122.43026]
      [request] [getfoi]
      [area] [yes]
      [clickable] [yes]
      [param3] [distance=50 unit=mile]
      [version] [1.0]
      End of servlet URL parameters (/foi).

      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: J2EE user: oc4jadmin
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Osso-User-Dn: null
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Osso-User-Guid: null
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Osso-Subscriber: null
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Osso-Subscriber-Dn: null
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Osso-Subscriber-Guid: null
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Lang/Territory: en-US,en;q=0.8
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
      FINEST: Session USER_NAME:null
      Jun 9, 2012 1:29:16 AM oracle.lbs.foi.FOIServer renderFOILayer
      FINEST: Total time spent on aborting theme:0
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.core.MapperPool getMapper
      FINER: getMapper(mvdemo) begins...
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.core.MapperPool getMapper
      FINER: getMapper() succeeded.
      Jun 9, 2012 1:29:16 AM oracle.sdovis.theme.CommonThemeAttrs getAttributes
      FINEST: key_column using default: ROWID
      Jun 9, 2012 1:29:16 AM oracle.sdovis.CacheMgr2 createGeomGroup
      INFO: Creating/replacing a geometry cache group: sdovis_subreg_mvdemo_jdbc:oracle:thin:@localhost:1522:orcl1 : CITIES_LOCATION_PDT_GEOM.
      Jun 9, 2012 1:29:16 AM oracle.sdovis.theme.PredGeomThemeQueryHelper createBaseQuery
      FINEST: Theme CITIES_NEAR_CUSTOMER uses index hint: /*+ index(CITIES CITIES_SDX) */
      Jun 9, 2012 1:29:16 AM oracle.sdovis.theme.PredGeomThemeQueryHelper createBaseQuery
      FINEST: Theme base-query [CITIES_NEAR_CUSTOMER]: SELECT /*+ index(CITIES CITIES_SDX) */ ROWID, #GEOMCOL#, 'M.QUAKE', null, 'null', -1, 'rule#0' FROM CITIES WHERE #SDOOP# #NSDPFLTROP# AND (sdo_within_distance(location,
      sdo_geometry(2001, 8307, sdo_point_type(:1, :2, null), null, null),
      :3)='TRUE'
      Jun 9, 2012 1:29:16 AM oracle.sdovis.LoadThemeData2 run
      FINER: LoadThemeData2 running thread: Thread-229
      Jun 9, 2012 1:29:16 AM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInWindow
      FINER: [Master scale] 0.06363336588783763 [Theme scale factor] 1.0
      Jun 9, 2012 1:29:16 AM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInWindow
      FINEST: ptvpxfmfxed: xl=-124.0
      Jun 9, 2012 1:29:16 AM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInWindow
      FINEST: [ CITIES_NEAR_CUSTOMER ]: -124.0,37.43642075137882,-121.45730338318816,38.11517665418242
      Jun 9, 2012 1:29:16 AM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInWindow
      FINEST: Theme query [ CITIES_NEAR_CUSTOMER ]: SELECT /*+ index(CITIES CITIES_SDX) */ ROWID, LOCATION, 'M.QUAKE', null, 'null', -1, 'rule#0' FROM CITIES WHERE 's'='s' AND (sdo_within_distance(location,
      sdo_geometry(2001, 8307, sdo_point_type(:1, :2, null), null, null),
      :3)='TRUE'
      Jun 9, 2012 1:29:16 AM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInWindow
      FINER: [ CITIES_NEAR_CUSTOMER ] Fetch size: 100
      Jun 9, 2012 1:29:16 AM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInWindow
      INFO: [ CITIES_NEAR_CUSTOMER ] sql exec time: -1339185556546ms, total time loading 0 features: 93ms.
      Jun 9, 2012 1:29:16 AM oracle.sdovis.theme.PredGeomThemeProducer prepareData
      SEVERE: *** Exception while querying theme: CITIES_NEAR_CUSTOMER
      java.sql.SQLException: ORA-00911: invalid character

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
      at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
      at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:769)
      at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:280)
      at oracle.sdovis.Theme.prepareData(Theme.java:189)
      at oracle.sdovis.LoadThemeData2.run(LoadThemeData2.java:88)
      at oracle.sdovis.DBMapMaker.prepareThemes2(DBMapMaker.java:2230)
      at oracle.sdovis.DBMapMaker.prepareThemes(DBMapMaker.java:2164)
      at oracle.lbs.foi.FOIDataProducer.getFoiData(FOIDataProducer.java:151)
      at oracle.lbs.foi.ThemeRenderingThread.getFeatures(ThemeRenderingThread.java:885)
      at oracle.lbs.foi.ThemeRenderingThread.getFeatures(ThemeRenderingThread.java:771)
      at oracle.lbs.foi.ThemeRenderingThread.render(ThemeRenderingThread.java:300)
      at oracle.lbs.foi.ThemeRenderingThread.run(ThemeRenderingThread.java:212)
      Jun 9, 2012 1:29:16 AM oracle.sdovis.LoadThemeData2 run
      SEVERE: Exception fetching data for theme CITIES_NEAR_CUSTOMER.
      Message:Exception while querying theme: CITIES_NEAR_CUSTOMER
      Description: Nested exception is:
      java.sql.SQLException: ORA-00911: invalid character

      java.sql.SQLException: ORA-00911: invalid character

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
      at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
      at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:769)
      at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:280)
      at oracle.sdovis.Theme.prepareData(Theme.java:189)
      at oracle.sdovis.LoadThemeData2.run(LoadThemeData2.java:88)
      at oracle.sdovis.DBMapMaker.prepareThemes2(DBMapMaker.java:2230)
      at oracle.sdovis.DBMapMaker.prepareThemes(DBMapMaker.java:2164)
      at oracle.lbs.foi.FOIDataProducer.getFoiData(FOIDataProducer.java:151)
      at oracle.lbs.foi.ThemeRenderingThread.getFeatures(ThemeRenderingThread.java:885)
      at oracle.lbs.foi.ThemeRenderingThread.getFeatures(ThemeRenderingThread.java:771)
      at oracle.lbs.foi.ThemeRenderingThread.render(ThemeRenderingThread.java:300)
      at oracle.lbs.foi.ThemeRenderingThread.run(ThemeRenderingThread.java:212)
      Jun 9, 2012 1:29:16 AM oracle.lbs.mapserver.core.MapperPool freeMapper
      FINER: freeMapper() begins...
      Jun 9, 2012 1:29:16 AM oracle.lbs.foi.FOIServer renderFOILayer
      FINEST: Total time spent in ThemeRenderingThread.run():140
      Jun 9, 2012 1:29:16 AM oracle.lbs.foi.FOIServer renderFOILayer
      FINE: Total time spent in FOIServer.renderFOILayer:156
      Jun 9, 2012 1:29:16 AM oracle.lbs.foi.FOIServlet doPost
      SEVERE: MAPVIEWER-06009: Error processing an FOI request.
      Message:Error fetching theme based FOI data.
      Sat Jun 09 01:29:16 IST 2012
      Severity: 0
      Description:
      Message:Exception while querying theme: CITIES_NEAR_CUSTOMER
      Description: Nested exception is:
      java.sql.SQLException: ORA-00911: invalid character

      java.sql.SQLException: ORA-00911: invalid character

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
      at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
      at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:769)
      at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:280)
      at oracle.sdovis.Theme.prepareData(Theme.java:189)
      at oracle.sdovis.LoadThemeData2.run(LoadThemeData2.java:88)
      at oracle.sdovis.DBMapMaker.prepareThemes2(DBMapMaker.java:2230)
      at oracle.sdovis.DBMapMaker.prepareThemes(DBMapMaker.java:2164)
      at oracle.lbs.foi.FOIDataProducer.getFoiData(FOIDataProducer.java:151)
      at oracle.lbs.foi.ThemeRenderingThread.getFeatures(ThemeRenderingThread.java:885)
      at oracle.lbs.foi.ThemeRenderingThread.getFeatures(ThemeRenderingThread.java:771)
      at oracle.lbs.foi.ThemeRenderingThread.render(ThemeRenderingThread.java:300)
      at oracle.lbs.foi.ThemeRenderingThread.run(ThemeRenderingThread.java:212)
      Please help me to rectify error.
      Thanks
      Rema