Skip to Main Content

DevOps, CI/CD and Automation

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!

Report Builder has stopped working 12c 12.2.1.4

Sarah QAMay 12 2020 — edited May 15 2020

hi all,

I have issue with report builder, Its not opening its showing the following error

Report Builder has stopped working

check online for a solution.....

Sarah

Comments

alwu-Oracle
Hi,

Have you tried the same query on 11.2 database?

One thing I'd like to point out is your query has a bit too many patterns. Behind the scene, we use table joins to implement the sparql query you send in. The number of joins is linear to the number of patterns you have. Keep in mind that such a big query is tricky to optimize.

Is it possible to simplify your query?

Thanks,

Zhe Wu
617912
Hi alwu,

Thanks for your reply. Our ontology design and our query requirements demand queries with large patterns. Generally, we want to retrieve 10 to 20 properties of any given class. I am assuming it is a common requirement, to retrieve that many number of properties, is it not? In any case, is there any way we can model our queries to perform better? Any performance guidelines etc..?

Thanks,
Rajesh.
alwu-Oracle
Hi,

It is not that common to have queries with so many patterns :) However, without knowing details of your applications, I would not say you did something wrong. When a query has so many patterns, join orders and types of joins are critical for performance.

It is a good idea to 1) gather statistics, 2) set a realistic performance target, 3) check execution plan of slow running queries, understand why it is slow, and 4) tune the query (by either changing pattern order, or by adding hints. Please refer to http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28397/sdo_rdf_newfeat.htm for adding hints to SEM_MATCH).

Cheers,

Zhe Wu
1 - 3

Post Details

Added on May 12 2020
9 comments
1,501 views