Forum Stats

  • 3,815,685 Users
  • 2,259,067 Discussions
  • 7,893,206 Comments

Discussions

MapBuilder Error:Can not find a GeoRaster object with specified rdt and rid

603540
603540 Member Posts: 52
edited Nov 24, 2008 11:15AM in MapViewer
Hello,
I can't GeoRaster data in the preview of the MapBuilder and MapViewer. The GeoRasterViewer shows the Raster images without problems.

MapBuilders error message:

19.11.2008 13:07:11 oracle.sdovis.theme.GeoRasterThemeProducer prepareData
SCHWERWIEGEND: GeoRaster load Exception:
oracle.spatial.georaster.GeoRasterException: Can not find a GeoRaster object with specified rdt and rid.
at oracle.spatial.georaster.JGeoRaster.validateConn(JGeoRaster.java:608)
at oracle.sdovis.theme.GeoRasterThemeProducer$JGeoRasterGTP.<init>(GeoRasterThemeProducer.java:2037)
at oracle.sdovis.theme.GeoRasterThemeProducer.prepareData(GeoRasterThemeProducer.java:694)
at oracle.sdovis.GeoRasterTheme.prepareData(GeoRasterTheme.java:95)
at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:75)
19.11.2008 13:07:11 oracle.sdovis.LoadThemeData run
SCHWERWIEGEND: Exception fetching data for theme RAS_DGK.
Message:GeoRaster load Exception: Can not find a GeoRaster object with specified rdt and rid.
Description:
at oracle.sdovis.theme.GeoRasterThemeProducer.prepareData(GeoRasterThemeProducer.java:1109)
at oracle.sdovis.GeoRasterTheme.prepareData(GeoRasterTheme.java:95)
at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:75)
19.11.2008 13:07:11 oracle.sdovis.MapMaker buildDataMBR
WARNUNG: null MBR resulted from buildDataMBR.

The errror message of MapViewer is nearly the same with some more informations about the spatial query and the coordintes of the query window. If I run that spatial query in the sqldeveloper it returns a result!

I did following stebs:
- saved a tiff-Image in a GeoRaster table with pyramid an tiled images.
- checked the sdo_geom_metadata --> they are correct
- checked the sdo_georaster object for the rdt table name and rasterid --> they are correct
- checked the rdt table --> objects with that rid are saved
- checked the mdsys.sdo_geor_sysdata table --> entry is correct
- validate the geraster with the sdo_geor.validategeoraster function --> object is valid
- updated the spatial extend of the image and try again the preview functio--> the same error

The databse server is a virtual Linux server with Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit.
The web server is a Window 2003 R2 Server with a weblogic server and mapviewer patch 5 (Ver1033p5_B081010).

For a test I did the same (the same table script, the same raster data, the same import method) on a developer pc (WinXP Pro SP2) with Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 (32bit) the same mapbuilder version but with the MapViewer QuickStartKid and it works fine!!!
Has anyone an idea?

Greeting,
Cord

Edited by: Corti on Nov 19, 2008 2:14 PM
Tagged:
«1

Answers

  • Jpaiva-Oracle
    Jpaiva-Oracle Member Posts: 1,326 Employee
    Hi Cord,
    are you previewing a theme or previewing directly from the GeoRaster table in MapBuilder?
    If you are using a theme, maybe the raster id in the theme definition may not be matching your current table data.
    If using a theme how did you create the theme definition?

    Set the log level to finest in MapBuilder (Tools/Preferences), and post all log information when you try to visualize the theme.
    Also if using a theme, post the theme definition.

    Thanks.

    Joao
  • 603540
    603540 Member Posts: 52
    Hi Joao,
    Thanks so far.

    I'm previewing a GeoRaster theme. I created it with the MapBuilder GeoRaster wizard. The theme difinition is (out of the export file):

    RAS_DGK|
    null|
    RAS_DGK|
    GEORASTER|
    <?xml version="1.0" standalone="yes"?>
    <styling_rules theme_type="georaster">
    </styling_rules>|

    (GeoRaster table name is "RAS_DGK", theme name is also "RAS_DGK")

    I get following log information:

    preview without a coordinate or scale:
    MapBuilder Error (as pop up): MAPVIEWER 01005: no spatial data to render

    log file:
    20.11.2008 10:17:27 oracle.sdovis.LoadThemeData run
    FEINER: LoadThemeData running thread: Thread-43
    20.11.2008 10:17:27 oracle.sdovis.theme.GeoRasterThemeProducer prepareData
    FEINER: Original query window: -Infinity,-Infinity,NaN,NaN
    20.11.2008 10:17:27 oracle.sdovis.theme.GeoRasterThemeProducer prepareData
    FEINER: [Query] select grt.GEORASTER, grt.GEORASTER.metadata.getClobVal() from RAS_DGK grt
    20.11.2008 10:17:27 oracle.sdovis.theme.GeoRasterThemeProducer prepareData
    FEINER: Fetch size: 100
    20.11.2008 10:17:27 oracle.sdovis.theme.GeoRasterThemeProducer prepareData
    SCHWERWIEGEND: GeoRaster load Exception:
    oracle.spatial.georaster.GeoRasterException: Can not find a GeoRaster object with specified rdt and rid.
    at oracle.spatial.georaster.JGeoRaster.validateConn(JGeoRaster.java:608)
    at oracle.sdovis.theme.GeoRasterThemeProducer$JGeoRasterGTP.<init>(GeoRasterThemeProducer.java:2037)
    at oracle.sdovis.theme.GeoRasterThemeProducer.prepareData(GeoRasterThemeProducer.java:694)
    at oracle.sdovis.GeoRasterTheme.prepareData(GeoRasterTheme.java:95)
    at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:75)
    20.11.2008 10:17:27 oracle.sdovis.LoadThemeData run
    SCHWERWIEGEND: Exception fetching data for theme RAS_DGK.
    Message:GeoRaster load Exception: Can not find a GeoRaster object with specified rdt and rid.
    Description:
    at oracle.sdovis.theme.GeoRasterThemeProducer.prepareData(GeoRasterThemeProducer.java:1109)
    at oracle.sdovis.GeoRasterTheme.prepareData(GeoRasterTheme.java:95)
    at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:75)
    20.11.2008 10:17:27 oracle.sdovis.MapMaker buildDataMBR
    WARNUNG: null MBR resulted from buildDataMBR.


    preview with a center coordinate of the image and a scale:

    20.11.2008 10:18:43 oracle.sdovis.SRS getOptimalQueryWindow
    AM FEINSTEN: *** isGeodetic=false, unit=METER
    20.11.2008 10:18:43 oracle.sdovis.LoadThemeData run
    FEINER: LoadThemeData running thread: Thread-45
    20.11.2008 10:18:43 oracle.sdovis.theme.GeoRasterThemeProducer prepareData
    FEINER: Original query window: 2550045.7746478873,5608500.0,2551954.2253521127,5609500.0
    20.11.2008 10:18:43 oracle.sdovis.theme.GeoRasterThemeProducer prepareData
    FEINER: [Query] select grt.GEORASTER, grt.GEORASTER.metadata.getClobVal() from RAS_DGK grt WHERE MDSYS.SDO_FILTER(grt.GEORASTER.spatialextent, MDSYS.SDO_GEOMETRY(2003, 31466, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?,?,?,?)), 'querytype=WINDOW') = 'TRUE'
    20.11.2008 10:18:43 oracle.sdovis.theme.GeoRasterThemeProducer prepareData
    FEINER: Fetch size: 100
    20.11.2008 10:18:43 oracle.sdovis.theme.GeoRasterThemeProducer prepareData
    SCHWERWIEGEND: GeoRaster load Exception:
    oracle.spatial.georaster.GeoRasterException: Can not find a GeoRaster object with specified rdt and rid.
    at oracle.spatial.georaster.JGeoRaster.validateConn(JGeoRaster.java:608)
    at oracle.sdovis.theme.GeoRasterThemeProducer$JGeoRasterGTP.<init>(GeoRasterThemeProducer.java:2037)
    at oracle.sdovis.theme.GeoRasterThemeProducer.prepareData(GeoRasterThemeProducer.java:694)
    at oracle.sdovis.GeoRasterTheme.prepareData(GeoRasterTheme.java:95)
    at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:75)
    20.11.2008 10:18:43 oracle.sdovis.LoadThemeData run
    SCHWERWIEGEND: Exception fetching data for theme RAS_DGK.
    Message:GeoRaster load Exception: Can not find a GeoRaster object with specified rdt and rid.
    Description:
    at oracle.sdovis.theme.GeoRasterThemeProducer.prepareData(GeoRasterThemeProducer.java:1109)
    at oracle.sdovis.GeoRasterTheme.prepareData(GeoRasterTheme.java:95)
    at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:75)
    20.11.2008 10:18:43 oracle.sdovis.DBMapMaker renderEm
    INFO: **** time spent on loading features: 234ms.
    20.11.2008 10:18:43 oracle.sdovis.RenderingEngine prepareForRendering
    AM FEINSTEN: xfm: 0.284 0.0 0.0 -0.284 -724212.9999999999 1593097.9999999998
    20.11.2008 10:18:43 oracle.sdovis.ImageRenderer renderGeoRasterTheme
    WARNUNG: GeoRaster theme RAS_DGK has no rendered images.
    20.11.2008 10:18:43 oracle.sdovis.VectorRenderer render
    FEINER: time to render theme RAS_DGK with 0 styled features: 0ms
    20.11.2008 10:18:43 oracle.sdovis.DBMapMaker renderEm
    INFO: **** time spent on rendering: 16ms

    If I run the sql statement in the log file, it returns a result.

    select grt.georid, grt.GEORASTER, grt.GEORASTER.metadata.getClobVal()
    from ras_dgk grt
    WHERE MDSYS.SDO_FILTER(grt.GEORASTER.spatialextent,
    MDSYS.SDO_GEOMETRY(2003, 31466, NULL,
    MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3),
    MDSYS.SDO_ORDINATE_ARRAY(2550045.7746478873,5608500.0,2551954.2253521127,5609500.0)), 'querytype=WINDOW') = 'TRUE';


    GEORID
    ----------------------------------
    2

    GEORASTER
    ----------------------------------
    MDSYS.SDO_GEORASTER(20001,MDSYS.SDO_GEOMETRY(2003,31466,null,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(2550000,5608000,2552000,5610000)),RDT_RAS_DGK,522,[email protected])

    GEORASTER.metadata.getClobVal()
    ----------------------------------
    <georasterMetadata xmlns="http://xmlns.oracle.com/spatial/georaster">
    <objectInfo>
    <rasterType>20001</rasterType>
    <isBlank>false</isBlank>
    <defaultRed>1</defaultRed>
    <defaultGreen>1</defaultGreen>
    <defaultBlue>1</defaultBlue>
    </objectInfo>
    <rasterInfo>
    <cellRepresentation>UNDEFINED</cellRepresentation>
    <cellDepth>8BIT_U</cellDepth>
    <totalDimensions>2</totalDimensions>
    <dimensionSize type="ROW">
    <size>6299</size>
    </dimensionSize>
    <dimensionSize type="COLUMN">
    <size>6299</size>
    </dimensionSize>
    <ULTCoordinate>
    <row>0</row>
    <column>0</column>
    </ULTCoordinate>
    <blocking>
    <type>REGULAR</type>
    <totalRowBlocks>4</totalRowBlocks>
    <totalColumnBlocks>4</totalColumnBlocks>
    <rowBlockSize>2048</rowBlockSize>
    <columnBlockSize>2048</columnBlockSize>
    </blocking>
    <interleaving>BSQ</interleaving>
    <pyramid>
    <type>DECREASE</type>
    <resampling>NN</resampling>
    <maxLevel>6</maxLevel>
    </pyramid>
    <compression>
    <type>NONE</type>
    </compression>
    </rasterInfo>
    <spatialReferenceInfo>
    <isReferenced>true</isReferenced>
    <SRID>31466</SRID>
    <modelCoordinateLocation>UPPERLEFT</modelCoordinateLocation>
    <modelType>FunctionalFitting</modelType>
    <polynomialModel rowOff="0" columnOff="0" xOff="0" yOff="0" zOff="0" rowScale="1" columnScale="1" xScale="1" yScale="1" zScale="1">
    <pPolynomial pType="1" nVars="2" order="1" nCoefficients="3">
    <polynomialCoefficients>17668678.695368 0 -3.14949718277477</polynomialCoefficients>
    </pPolynomial>
    <qPolynomial pType="1" nVars="0" order="0" nCoefficients="1">
    <polynomialCoefficients>1</polynomialCoefficients>
    </qPolynomial>
    <rPolynomial pType="1" nVars="2" order="1" nCoefficients="3">
    <polynomialCoefficients>-8031218.31607409 3.14949718277477 0</polynomialCoefficients>
    </rPolynomial>
    <sPolynomial pType="1" nVars="0" order="0" nCoefficients="1">
    <polynomialCoefficients>1</polynomialCoefficients>
    </sPolynomial>
    </polynomialModel>
    </spatialReferenceInfo>
    <layerInfo>
    <layerDimension>BAND</layerDimension>
    <subLayer>
    <layerNumber>1</layerNumber>
    <layerDimensionOrdinate>0</layerDimensionOrdinate>
    <layerID>1</layerID>
    <colorMap>
    <colors>
    <cell value="0" blue="255" red="255" green="255" alpha="255"/>
    <cell value="1" blue="0" red="0" green="0" alpha="255"/>
    </colors>
    </colorMap>
    </subLayer>
    </layerInfo>
    </georasterMetadata>


    I checked also the content of rdt table and it contains entries with that raster id (= 522).


    Finally the log file when I use the preview directly on the GeoRaster table without a theme:

    20.11.2008 10:23:46 oracle.sdovis.LoadThemeData run
    FEINER: LoadThemeData running thread: Thread-55
    20.11.2008 10:23:46 oracle.sdovis.theme.GeoRasterThemeProducer prepareData
    FEINER: Original query window: -Infinity,-Infinity,NaN,NaN
    20.11.2008 10:23:46 oracle.sdovis.theme.GeoRasterThemeProducer prepareData
    FEINER: [Query] select grt.GEORASTER from RAS_DGK grt where grt.GEORASTER.rasterid = ? and grt.GEORASTER.rasterdatatable = ?
    20.11.2008 10:23:46 oracle.sdovis.theme.GeoRasterThemeProducer prepareData
    FEINER: Fetch size: 100
    20.11.2008 10:23:46 oracle.sdovis.theme.GeoRasterThemeProducer prepareData
    SCHWERWIEGEND: GeoRaster load Exception:
    oracle.spatial.georaster.GeoRasterException: Can not find a GeoRaster object with specified rdt and rid.
    at oracle.spatial.georaster.JGeoRaster.validateConn(JGeoRaster.java:608)
    at oracle.sdovis.theme.GeoRasterThemeProducer$JGeoRasterGTP.<init>(GeoRasterThemeProducer.java:2037)
    at oracle.sdovis.theme.GeoRasterThemeProducer.prepareData(GeoRasterThemeProducer.java:694)
    at oracle.sdovis.GeoRasterTheme.prepareData(GeoRasterTheme.java:95)
    at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:75)
    20.11.2008 10:23:46 oracle.sdovis.LoadThemeData run
    SCHWERWIEGEND: Exception fetching data for theme RAS_DGK.
    Message:GeoRaster load Exception: Can not find a GeoRaster object with specified rdt and rid.
    Description:
    at oracle.sdovis.theme.GeoRasterThemeProducer.prepareData(GeoRasterThemeProducer.java:1109)
    at oracle.sdovis.GeoRasterTheme.prepareData(GeoRasterTheme.java:95)
    at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:75)
    20.11.2008 10:23:46 oracle.sdovis.MapMaker buildDataMBR
    WARNUNG: null MBR resulted from buildDataMBR.


    If you need more information - please ask for it.

    Cord
  • 603540
    603540 Member Posts: 52
    I think it could be a database problem. And so I compared the packages in the mdsys schema of my devolper to the original database. I found out that the original one has no sdo_geor_def package. Did somebody knows for what it is good for and where to get and how to install it?

    Greetings
    Cord
  • Jpaiva-Oracle
    Jpaiva-Oracle Member Posts: 1,326 Employee
    It may be a database issue, but lets check some more information. Run the following SQL command.

    select raster_id, rdt_table_name from user_sdo_geor_sysdata where table_name = 'RAS_DGK';

    Thanks.

    Joao
  • 603540
    603540 Member Posts: 52
    The command returns:
    RASTER_ID RDT_TABLE_NAME
    ---------------------- --------------------------------
    522 RDT_RAS_DGK

    1 rows selected
  • Jpaiva-Oracle
    Jpaiva-Oracle Member Posts: 1,326 Employee
    It may be something related with the GeoRaster java library and the 64 bits plataform, as when you run the SQL commands in the previous
    posts they work. We will investigate more and post comments later. Thanks.
  • zzhang-Oracle
    zzhang-Oracle Member Posts: 175 Employee
    Hi Cord,

    Could you run queries below from sql/plus?

    select count(*) from all_sdo_geor_sysdata where raster_id=522.0 and rdt_table_name='RDT_RAS_DGK';


    select count(*) from all_sdo_geor_sysdata where raster_id=522 and rdt_table_name='RDT_RAS_DGK';


    Zhihai
  • 603540
    603540 Member Posts: 52
    Hi Zhihai,

    both queries return:

    COUNT(*)
    ----------------------
    1

    1 rows selected

    (The ras_dgk table contains only 1 record set. The image has pyramids and tiles and so 25 record sets in the rdt_ras_dgk table.)

    Cord
  • zzhang-Oracle
    zzhang-Oracle Member Posts: 175 Employee
    Can you try GeoRasterViewer against your 64 bits DB to see if you can view the geoRaster object successfully?
  • 603540
    603540 Member Posts: 52
    Yes, I have already done it as one of the first tests. It's working fine!
This discussion has been closed.