Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06502

Ram KrishnaOct 6 2009 — edited Oct 7 2009
I get the following exception when I run a sparql query with the new Jena adaptor. I see the same error when I run the sem_match equivalent of the query :

Error message:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 776
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 222
ORA-06512: at line 1

The query finally returns the results- albeit after a long time. The same query used to work fine with the old version of the Jena adaptor.

The query looks like this..
PREFIX cis:<http://cisoft.usc.edu/iam/DomainModel#> PREFIX owl:<http://cisoft.usc.edu/iam/Metadata.owl#> PREFIX owl2:<http://www.owl-ontologies.com/unnamed.owl#> PREFIX sm:<http://www.w3.org/2002/07/owl#> PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT DISTINCT ?CD ?Comments ?FilePath ?FileName ?PublishedOn ?PublishedByUser ?LastModifiedOn ?ModifiedByUser ?MaturityLevel ?VersionNumber ?RM ?rmi ?rmj ?rmk ?RMName ?rmno ?rmIsParameterized ?RMUUID ?RMType ?NumberOfActiveCells ?simStopDate ?simStartDate ?noEquil ?noFluidPropRegs ?noRockPropertyRegions ?WMS where { ?CD sm:sameAs <mdc:ccc:1253844487918:0>.?CD owl:CDMDIsMDOfRM ?RM . OPTIONAL { ?CD owl:filePath ?FilePath } . OPTIONAL { ?CD p1 ?FileName } . OPTIONAL { ?CD p2 ?LastModifiedOn } . OPTIONAL { ?CD owl:publishDate ?PublishedOn } . OPTIONAL { ?CD owl2:publishBy ?PublishedByUser } . OPTIONAL { ?CD owl:comments ?Comments } . OPTIONAL { ?CD owl:objectModifiedByUser ?ModifiedBy . ?ModifiedBy owl2:hasCAI ?ModifiedByUser } . OPTIONAL { ?RM cis:iDimensionCells ?rmi } . OPTIONAL { ?RM cis:jDimensionCells ?rmj } . OPTIONAL { ?RM cis:kDimensionCells ?rmk } . OPTIONAL { ?RM cis:name ?RMName } . OPTIONAL { ?RM cis:numberOfCells ?rmno } . OPTIONAL { ?RM cis:RMIsParameterized ?rmIsParameterized } . OPTIONAL { ?RM cis:UUID ?RMUUID } . OPTIONAL { ?RM cis:RMType ?RMType } .OPTIONAL { ?RM cis:numberOfActiveCells ?NumberOfActiveCells } . OPTIONAL { ?RM cis:simStopDate ?simStopDate } . OPTIONAL { ?RM cis:simStartDate ?simStartDate } . OPTIONAL {?RM cis:numberOfEquil ?noEquil } . OPTIONAL { ?RM cis:numberOfFluidPropertyRegions ?noFluidPropRegs } .OPTIONAL { ?RM cis:numberOfRockPropertyRegions ?noRockPropertyRegions } . OPTIONAL { ?RM cis:WMS ?WMS } . OPTIONAL { ?RM cis:maturityLevel ?MaturityLevel } OPTIONAL { ?CD owl:versionNumber ?VersionNumber } . }


Ram

Edited by: user652088 on Oct 6, 2009 8:46 PM

Comments

alwu-Oracle
What is your DB version and what version of Jena Adaptor are you using?

Thanks,

Zhe Wu
Ram Krishna
The oracle database is v11.1.0.7 and we are using the new Jena adaptor (rel 3) that we got from our metalink site.

ram
alwu-Oracle
Hi,

It seems that the new version of Jena Adaptor is doing the right job to convert the whole SPARQL into a single SEM_MATCH based query. Now the problem is that 11.1.0.7 database has this known server side bug (table function related) when the query is too big. You did not see this problem with Jena Adaptor v2 because ARQ breaks the query into many small pieces.

To fix this problem, there are a few choices:

1) upgrade to database 11.2, or
2) shorten your query, or
3) file a tar with Oracle support.

We are working on an optimization in Jena Adaptor to convert a SPARQL (with just a base BGP and a number of parallel OPTIONAL clauses) into a plain SQL. This may solve your problem even if you continue use 11.1.0.7.

Cheers,

Zhe Wu
1 person found this helpful
Ram Krishna
Thanks Zhe- that is helpful. We will use one of the workarounds before we switch to 11.2.

ram
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 4 2009
Added on Oct 6 2009
#database-key-features, #rdf-graph-property-graph
4 comments
3,107 views