Database Software

I used MapBuilder to create styles, themes and basemaps. When the first time I preview the basemap, it is ok.
Then I zoom in the preview map, I got the following errors:

ERROR [oracle.sdovis.theme.pgtp] *** Exception while querying theme: TOLL_HWY
ERROR [oracle.sdovis.theme.pgtp] java.sql.SQLException: ORA-29900: operator binding does not exist
ORA-06540: PL/SQL: compilation error
ORA-06553: PLS-907: cannot load library unit MDSYS.SDO_3GL (referenced by MDSYS.SDO_FILTER)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:623)
at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:295)
at oracle.sdovis.Theme.prepareData(Theme.java:174)
at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

And I also see the errors on the MapBuilder console:
Exception in thread "Thread-15" java.lang.OutOfMemoryError: Java heap space
Exception in thread "Thread-14" java.lang.OutOfMemoryError: Java heap space

The MapBuilder cache is 512MB. I may think my workstation doesn't have enough memory.


So I tried on MapViewer which is deployed on Oracle Application Server, and OracleAS was installed on RHEL 4.0

I created data source and map cache instance, I use Demo to display the basemap. I always got a blue background and empty map. Then I checked the logs, the same as above I mentioned.

I searched in metalink, I only saw the similar like this:
"ORA-06553: PLS-907: CANNOT LOAD LIBRARY UNIT" ON HIGH WORKLOAD
Bug No. 6087146


In my case, There is one basemap that included 12 tables (one table has 23*,*** records, others are hundreds). Other basemap does not include the large table.

Any ideas / helps?

BTY,
Oracle AS 10.1.3.3
MapViewer 10.1.3.1
MapBuilder 10.1.3.1

Thanks in advance

Joyce