[Thu Jun 10 12:21:30 2010] [120071] [dbmirror] db_stream_prepare_stmt::db_sda_prepare_stmt: OCIStmtPrepare Error (0).
db_sda_prepare_stmt: Error parsing SQL statement: SELECT SHAPE, V__10130.OBJECTID, V__10130.SE_ANNO_CAD_DATA FROM (SELECT b.SHAPE ,b.OBJECTID,b.SE_ANNO_CAD_DATA FROM OWNER1.FC b WHERE b.OBJECTID NOT IN (SELECT /*+ HASH_AJ */ SDE_DELETES_ROW_ID FROM OWNER1.D10130 WHERE DELETED_AT IN (SELECT l.lineage_id FROM SDE.state_lineages l WHERE l.lineage_name = :source_lineage_name AND l.lineage_id <= :source_state_id) AND SDE_STATE_ID = 0) UNION ALL SELECT a.SHAPE ,a.OBJECTID,a.SE_ANNO_CAD_DATA FROM OWNER1.A10130 a,SDE.state_lineages SL WHERE (a.OBJECTID, a.SDE_STATE_ID) NOT IN (SELECT /*+ HASH_AJ */ SDE_DELETES_ROW_ID,SDE_STATE_ID FROM OWNER1.D10130 WHERE DELETED_AT IN (SELECT l.lineage_id FROM SDE.state_lineages l WHERE l.lineage_name = :source_lineage_name AND l.lineage_id <= :source_state_id) AND SDE_STATE_ID > 0) AND a.SDE_STATE_ID = SL.lineage_id AND SL.lineage_name = :source_lineage_name AND SL.lineage_id <= :source_state_id ) V__10130 .
db_stream_prepare_stmt::db_sda_prepare_stmt: OCIStmtPrepare Error (0).
Dear experts,
I found that msg from folder "sde/sde_esri_sde.log". How do you read this error ? And what errors do i have based on the message ?
This is found after I got msg from arccatalog "The selected object failed to draw: FC: Underlying DBMS error[OWNER1.FC][STATE_ID=2461]"
Many thanks
