[mapguide-users] Ora error when displaying layer from view

[marius.360]

Hi All

I have created a layer that reads from an oracle view with a geometry
column. This view has an entry in the USER_SDO_GEOM_METADATA, as well as a
primary key. It is a point layer that displays perfectly in Mapguide 6.5,
but when I turn the layer on in mapguide opensource, it doesn't display and
the following error is logged in the error logs: 

<2009-02-16T14:09:43> 		192.168.0.55	Anonymous
 Error: Failed to stylize layer: NEURON_PROP
        An exception occurred in FDO component.
        ORA-00923: FROM keyword not found where expected
 StackTrace:
  - MgMappingUtil.StylizeLayers line 786 file
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\mapping\MappingUtil.cpp
Failed to stylize layer: NEURON_PROP
An exception occurred in FDO component.
ORA-00923: FROM keyword not found where expected

I do not know where the ORA-00923 error occurs, because the view compiles
without problems, as well as displays in mapguide 6.5 so the view seems to
be fine.

I am using Oracle 10g R2 and Mapguide Opensource 2.0.2 on windows server
2003, with KingOra v0_8_5. 

Does anyone have an idea as to where this error comes from?

Kind Regards,

Marius
-- 
View this message in context: http://n2.nabble.com/Ora-error-when-displaying-layer-from-view-tp2334574p2334574.html
Sent from the MapGuide Users mailing list archive at Nabble.com.