This discussion is archived
1 Reply Latest reply: Aug 21, 2012 6:57 AM by diegoweber RSS

themebased -FOI error

920209 Newbie
Currently Being Moderated
[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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points