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

603540

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

Jpaiva-Oracle

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

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

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

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

The command returns:
RASTER_ID RDT_TABLE_NAME
---------------------- --------------------------------
522 RDT_RAS_DGK

1 rows selected

Jpaiva-Oracle

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

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

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

Can you try GeoRasterViewer against your 64 bits DB to see if you can view the geoRaster object successfully?

603540

Yes, I have already done it as one of the first tests. It's working fine!