How to check "One or more layers Failed to draw. Underlying dbms error" ?

tongkimongki

Dear experts,

I loaded SDO_Geometry type data directly from oracle 10gR2.. Then I open some feature classes via arcmap. I pan around here and there and suddenly when i pan to this particular area  I encounter error "One or more layers Failed to draw. Underlying dbms error". Only when I pan to this particular area gives me the error. Some feature classes dont have this error.

There are many feature classes (hundreds of them). How do i make sure that all the data are free of this kind of error ? I dont want to load all feature classes one by one and panning around to test it. Is there a way to find out this error automatically (or at least without checking them one by one and panning around) ?

My environment : oracle 10gr2, arcgis 9.2 sp6, arcsde 9.2 sp6. I load the data via oracle and register them manually

many thanks

VinceAngelo

Have you looked in the error logs of both ArcSDE and Oracle?

If the error is invalid geometry, the only way to detect that is to run queries against each table.
The 9.0 API introduced a "invalid_shape_mode" flag to streams, allowing the API to pass back
invalid geometry instead of crashing the stream, but ArcGIS doesn't use this (probably because
it needs valid geometry to render anyway). I added a hidden "+INVALIDSHAPE" flag to the
'sdequery' utility of se_toolkit, but it's not as useful as it might be, since it doesn't capture just
the invalid shapes (it just adds "Invalid" before the shape type -- e.g., "Shape: Invalid Line
shape (3 parts, 206 vertices)". Yet you could still scan all the layers, looking for 'Invalid', and
then do further research on the ones that had hits:

#!/bin/sh
SDEUSER=browse_user
SDEPASSWORD=password
export SDEUSER SDEPASSWORD
for layer in `sdelist -o layer`
do
        count=`sdequery -C shape -l $layer -\# 999999999 +INVALIDSHAPE | grep Invalid | wc -l`
        test $count -gt 0 && echo $layer $count
done

I'll add doing something more useful with SE_stream_set_invalid_shape_mode to my
"SDEQUERY_TO_DO" list.

- V

PS: Oracle has a validation function for SDO_GEOMETRY;  that won't necessarily catch
all the topology errors that ArcSDE will catch, but it would be a good start.