Tags: basemap, basemaps, create, database, library, load, map, mapbuilder, mdsyssdo-3gl, mysql, ora-06553, oracle, pls-907, preview, sql, styles, themes, time, unit, zoom
ORA-06553: PLS-907: cannot load library unit MDSYS.SDO-3GL
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)
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?
Oracle AS 10.1.3.3
Thanks in advance
Leave a comment...
- 9 Comments
- Hi Joyce, a few questions to start:
1) What is the database version that you are using?
2) I assume you are using your own tables. Did you try the mvdemo sample that comes with MapViewer kit? Does the MDSYS.SDO_3GL library error also happens when you try to zoom in or out?
3) Which command did you use to start MapBuilder? When previewing data, if you do not define the center and size in version 10.1.3.1, the full extent is retrieved and depending on the amount of data you may get out of memory error. With the new preview 11g posted today on OTN, if your basemap has theme scales assigned, the scales will be used even if you do not define the center and size, and in this case data out of the scale ranges will not be retrieved.
Joao#1; Sat, 23 Feb 2008 19:16:00 GMT
- Hi Joao,
Thank you for your quick reply.
1, My DB version is 10gR2
2, all the tables are spatial tables, I've tried mvdemo sample on my workstation and everything is perfect. I haven't try on RHEL 4 (I will try later).
3, The following is the command that I started Oracle MapBuilder
cd C:\Program Files\Java\jdk1.5.0_05\bin
java -jar c:\OracleMapBuilder\mapbuilder.jar -cache 1024M
4, I just tried to custom the Spatial Data Cache, set max_cache_size= 1024, still got the same error.
we can not use any preview version for the Oracle products. But I will try to define the center and size to see what will happen.
I prefer to see map can display on MapViewer.
Joyce#2; Sat, 23 Feb 2008 19:16:00 GMT
- Hi Joyce,
For (2) try the mvdemo just to be sure that your are able to perform zoom in and zoom out as these operations will use the spatial filter.
For (3) the -cache option defines the internal MapBuilder geometry cache. It is not the memory assigned to your java application. Try the following (you can add your cache option if you want):
java -jar -Xmx1024M c:\OracleMapBuilder\mapbuilder.jar
Joao#3; Sat, 23 Feb 2008 19:17:00 GMT
- Hi Joao,
I have 2 connections in my MapBuilder.
1, One connect to my workstation DB which has mvdemo sample.
2, The other one connect to the remote DB which installed on RHEL4 (This one doesn't have mvdemo) .
I perform zoom in and out very well in mvdemo sample, but in the second one, it always got the errors.
I tired your (3) advise, and I don't have outofmemory error any more. I still got the same error message.
Joyce#4; Sat, 23 Feb 2008 19:19:00 GMT
if possible load the mvdemo on RHEL4, so you can confirm that it also runs there. If you get the same error with mvdemo, there may be something with Spatial installation on RHEL4.
Joao#5; Sat, 23 Feb 2008 19:20:00 GMT
- Hi Joao,
Now I installed mvdemo sample on RHEL 4, and all the behaviors are the same as I described before.
BTW, one concern about install mvdemo sample,
grant connect, resource, create view to mvdemo identified by mvdemo is not enough. I added create any view to mvdemo user and I also selected admin option for these privileges.
Thanks#6; Sat, 23 Feb 2008 19:21:00 GMT
- First confirm that the database query works. The error message is a db error.
So connect to the db on the rhel4 m/c using sql*plus.
Perform a query (cut and paste from the mapbuilder or mapviewer logs after modifying the coordinate info) in sql*plus.
Does that work?#7; Sat, 23 Feb 2008 19:22:00 GMT
- Hi Jayant,
I run the following sql query:
SELECT ROWID, GEOMETRY, 'C.LAKES', null, 'null', -1
'querytype=WINDOW') = 'TRUE'
I have the same error messages
What's the next steps?
Message was edited by:
xpp#8; Sat, 23 Feb 2008 19:23:00 GMT
- Now, it works, but I don't know what I did correct the problem.
I only run the following sql.
and return TRUE.
Then I run the preview sql again, I got the results.
Does anybody know why? Does it make sense?
Joyce#9; Sat, 23 Feb 2008 19:24:00 GMT