Mapviewer issues - can't render polygon
Date: Thu, 26 May 2016 10:30:48 -0600
Message-ID: <CAJzM94CZnBGFpDaCDNHB5VySBEk_0wdVWTWfem6Ep6v_Y+rSGQ_at_mail.gmail.com>
Just an FYI - I tried searching the oracle-l archives, but get an error page "Secure Connection Failed". Could be blocked on my side, as many websites are.
I am new to spatial and don't understand a lot about it yet. Kind of "trial by fire" going on so please bear with me.
Currently a 12c EE database with Oracle Spatial installed and valid Mapviwer 9iAS
We are in the process of upgrading our 11g databases to 12c. Mapviewer was working is working well with the 11g version. The development 11g database had so many invalid components and objects that we could not rectify (plus over 19k schemas we needed to remove but drop user cascade didn't work) we decided to create a new 12c database, ensuring the latest spatial patches were applied. We then used expdp/impdp to migrate the pertinent schemas from 11g to 12c. That's when Mapviewer stopped rendering polygons. It will work for points, but not polygons. We did find some data that was in the 11g MDSYS schema that was not in the 12c MDSYS schema. Inserting the missing data did not fix the problem. Could we be missing more data or the values are different for the same PK values? Not sure.
Is the combination of MV 9iAS and EE 12c a problem? Was it 12c or was it the way we migrated data? To test the "migration vs upgrade" theory, we created an 11g database on a sandbox. We verified that Mapviewer 9iAS would render polygons correctly. We then upgraded the test DB to 12c. Ran the Mapviewer verification again and polygons were rendered correctly.
Below is the error we get when trying to render the polygon in the migrated database. There is currently no one at the company who knows anything about Mapviewer other than how to use it. I can't seem to find a java guru either who can give us guidance. I have searched MOS and found nothing that helped. Googling did provide any answers either. It would be greatly appreciated if someone could point us in the right direction. I suggested installing the latest version of Mapviewer, but that was not met with any enthusiasm from the development team. The remaining database upgrades are on hold until we resolve this issue.
WARN [oracle.sdovis.theme.DGTP] java.lang.Exception: Corrupted element info array.
at oracle.sdovis.Unpickle81.getElemInfoArray(Unpickle81.java:542)
at oracle.sdovis.Unpickle81.unpickle(Unpickle81.java:426)
at oracle.sdovis.JSDOGeometry.loadFromDB(JSDOGeometry.java:419)
at
oracle.sdovis.theme.DynGeomThemeProducer.prepareData(DynGeomThemeProducer.java:395)
at oracle.sdovis.Theme.prepareData(Theme.java:174)
at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)
ERROR [oracle.sdovis.ltd] Message:null
Description: Nested exception is:
java.lang.Exception: Corrupted element info array.
java.lang.Exception: Corrupted element info array.
at oracle.sdovis.Unpickle81.getElemInfoArray(Unpickle81.java:542)
at oracle.sdovis.Unpickle81.unpickle(Unpickle81.java:426)
at oracle.sdovis.JSDOGeometry.loadFromDB(JSDOGeometry.java:419)
at
oracle.sdovis.theme.DynGeomThemeProducer.prepareData(DynGeomThemeProducer.java:395)
at oracle.sdovis.Theme.prepareData(Theme.java:174)
at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)
Thank you.
-- Sandy B. -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 26 2016 - 18:30:48 CEST