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.
