Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-29902

476843Feb 7 2006 — edited Mar 4 2006

I am still working through a problem with spatial indexing. I have successfully recreated my spatial index with the min max parameters and the srid value correctly now I can see that data correctly in my arcmap, autodesk map and oem spatial viewers. However when viewed in Autodesk Mapguide (6.5.5.7) I get the message>
autodesk mapguide server error: 529-16202
Unable to retrieve data for layer "New Layer". The query posed to data source "Oraclpcora1" failed to execute. Oracle Call Interface(OCI) error with text- ORA-29902: error in executing ODCIIndexStart() routine SQL Statement: SELECT OBJECTID, SHAPE FROM PCLIMITS

Other posts I have found online indicate several different possibilities for the problem. ESRI says it is a transform problem that was fixed in 9.0, Oracle says a text problem (281372.1) or Bug 4092060, However it says only confirmed affecting 10.1.0.4 (I'm on 10.1.0.3). Autodesk says it is an 8.1.7 problem that they addressed in the data extension (old Info).
Can anyone help

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 31 2006

Added on Feb 7 2006

#database-key-features, #spatial

35 comments

12,745 views