Could it be as simple as permissions on the view?
-----Original message----- From: Zac Spitzer zac.spit...@gmail.com Date: Tue, 07 Sep 2010 23:39:30 -0700 To: MapGuide Users Mail List mapguide-users@lists.osgeo.org Subject: Re: [mapguide-users] View on Oracle Express > also remember that mapguide caches the schema info, > so once you have accessed a schema, mapguide won't read the > schema until that cache expires... so no changes will show up > > you can flush the cache by simply opening and saving the feature > source defintion > > z > > On Wed, Sep 8, 2010 at 2:30 PM, VOLZ Mark (FN) <mark.v...@ergon.com.au> wrote: > > Francesco, > > > > That all seems very strange (that it is working on tables but not > > views). Are you changing the geometry in anyway in your views? i.e. are > > you using any of cs_transform, aggr, sdo functions/procedures, custom > > packages/functions/procedures, etc? certain ones will null and void your > > index. > > > > Are the entries in your user_sdo_geom_metadata for your views exactly > > the same as the ones for the tables i.e. you haven't changed accuracies > > or x & y column names. > > > > Have your tried running a sdo_relate query on your view, shown below (it > > will test the above questions)? > > Select * > > >From xe.view v > > Where sdo_relate (v.geomtry_column, > > sdo_geometry(2003,8311,null,sdo_elem_info_array(1,1003,3),sdo_ordinate_a > > rray(145.683622,-16.88905,145.6925,-16.880274)), 'mask=ANYINTERACT') = > > 'TRUE'; > > > > Unless you are in Australia that code shouldn't return any records but > > it will test that your view supports spatial queries (its actually a > > snippet of sql that Mapguide sent to our database about 5 minutes ago). > > > > Have you tried materialized view? > > > > How did you add the primary key to the view? Did you use a statement > > similar to this after creating the view;? > > ALTER VIEW XE.VIEW ADD ( > > CONSTRAINT VIEW_PK > > PRIMARY KEY > > (column_name) DISABLE); > > > > > > Sorry if I am asking you to check simple things but I had similar > > problems getting my oracle setup going so I'm just running through all > > the different problems I ran into using views in XE and mapguide. > > > > Mark. > > > > -----Original Message----- > > From: mapguide-users-boun...@lists.osgeo.org > > [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Francesco > > Sozzi > > Sent: Tuesday, 7 September 2010 5:42 PM > > To: MapGuide Users Mail List > > Subject: Re: [mapguide-users] View on Oracle Express > > > > Hi Mark, > > > > Thanks for answer. > > > > I confirm primary key and spatial index for both tables and views. > > On Oracle Express I manage small data. Tablespaces are smaller that > > 100MB. > > I tried to drop and recreate all keys and spatial index. Oracle did the > > job with no warnings or errors, so I am sure all index are ok. > > > > For the moment my workaround is to create side tables with the content > > of views, a sort of snapshots on views I need to publish data. With > > these tables (populated with data from views) MG works as expected. > > Please note that I need views (or these "side" tables) to show joined > > data in the property panel. > > > > Best regard > > > > Francesco > > > > > > ----- Original Message ----- > > From: "VOLZ Mark (FN)" <mark.v...@ergon.com.au> > > To: "MapGuide Users Mail List" <mapguide-users@lists.osgeo.org> > > Sent: Monday, September 06, 2010 8:00 PM > > Subject: RE: [mapguide-users] View on Oracle Express > > > > > > Francesco, > > > > Can you confirm that the geometry columns (in the underlying table(s)) > > you > > are trying to use in the views have a spatial index built on them? > > > > The second thing to look at is the size of the database. A spatial index > > > > takes up table space so if you have a data set of about 4.5gb and then > > try > > and build a spatial index it will fail due to the size restriction on > > XE. > > This may be why the imported schema works in Standard/enterprise but not > > in > > XE. > > > > Mapguide always sends a spatial query when querying the data from oracle > > > > (which will fail if you don't have a spatial index), Autocad map doesn't > > > > always do this. > > > > Mark > > > > > > > > -----Original Message----- > > From: mapguide-users-boun...@lists.osgeo.org > > [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Zac Spitzer > > Sent: Tuesday, 7 September 2010 11:27 AM > > To: MapGuide Users Mail List > > Subject: Re: [mapguide-users] View on Oracle Express > > > > have you tried the latest king oracle provider? > > > > http://www.sl-king.com/fdooracle/ > > > > Also it's always helpful to state versions of the various software > > > > z > > > > On Mon, Sep 6, 2010 at 10:38 PM, Francesco Sozzi <fso...@intercad.ch> > > wrote: > >> Hi All, > >> > >> I have an Oracle schema with views to render on Mapguide Open Source. > >> If I load this schema on an Oracle Standard or Enterprise, views are > >> rendered. > >> If I load on Mapguide from express, they are not rendered (I can > >> render the table with geometry field, but not the view). > >> > >> All views are in USER_SDO_GEOM_METADATA and all views have primary > > keys. > >> I can load and render on Autodesk Map from Oracle Express without > >> problems. > >> From Maestro I can see them in the list, if I try to create a layer, > >> but they are not rendered at all. > >> > >> Any idea or suggstions?.... > >> > >> Best regards > >> > >> Francesco > >> > >> __________ Information from ESET NOD32 Antivirus, version of virus > >> signature database 5426 (20100906) __________ > >> > >> The message was checked by ESET NOD32 Antivirus. > >> > >> http://www.eset.com > >> > >> _______________________________________________ > >> mapguide-users mailing list > >> mapguide-users@lists.osgeo.org > >> http://lists.osgeo.org/mailman/listinfo/mapguide-users > >> > >> > > > > > > > > -- > > Zac Spitzer > > Solution Architect / Director > > Ennoble Consultancy Australia > > http://www.ennoble.com.au > > http://zacster.blogspot.com > > +61 405 847 168 > > _______________________________________________ > > mapguide-users mailing list > > mapguide-users@lists.osgeo.org > > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > To report this email as spam, please forward to s...@mailcontrol.com > > --------------------------------------------------------------------- > > > > > > ************************************************************************ > > * > > This e-mail (including any attachments) may contain confidential or > > privileged information and is intended for the sole use of the person(s) > > to > > whom it is addressed. If you are not the intended recipient, or the > > person > > responsible for delivering this message to the intended recipient, > > please > > notify the sender of the message or send an e-mail to > > mailto:help.d...@ergon.com.au immediately, and delete all copies. Any > > unauthorised review, use, alteration, disclosure or distribution of this > > e-mail by an unintended recipient is prohibited. Ergon Energy accepts no > > responsibility for the content of any e-mail sent by an employee which > > is of > > a personal nature. > > > > Ergon Energy Corporation Limited ABN 50 087 646 062 > > ************************************************************************ > > * > > _______________________________________________ > > mapguide-users mailing list > > mapguide-users@lists.osgeo.org > > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > > > __________ Information from ESET NOD32 Antivirus, version of virus > > signature > > database 5429 (20100906) __________ > > > > The message was checked by ESET NOD32 Antivirus. > > > > http://www.eset.com > > > > > > > > > > __________ Information from ESET NOD32 Antivirus, version of virus > > signature database 5429 (20100906) __________ > > > > The message was checked by ESET NOD32 Antivirus. > > > > http://www.eset.com > > > > > > > > _______________________________________________ > > mapguide-users mailing list > > mapguide-users@lists.osgeo.org > > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > _______________________________________________ > > mapguide-users mailing list > > mapguide-users@lists.osgeo.org > > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > > > > > -- > Zac Spitzer > Solution Architect / Director > Ennoble Consultancy Australia > http://www.ennoble.com.au > http://zacster.blogspot.com > +61 405 847 168 > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users