Sometimes Oracle Reports Builder crashes in Windows environment. Especially when you are working on Apps upgrade (11i–> R12) project and retrofitting Reports from 6i to 10G. You,
- Open report builder 10g
- Connect to database
- Open a custom report
- Report builder goes in not responding stage and after sometime crashes giving below error message.
Reports Builder stopped working. Windows is checking for a solution to the problem…
What went wrong? You repeat above steps, still same issue. Why So? What is the issue? How to resolve it?
There could be many reasons but most probably it happens due to dependency issue. When you open reports builder, it checks dependent objects in the database. If it does not find it crashes.
Follow below steps to resolve Crashing issue.
Method 1: Use original reports builder version
Open reports builder 6i and connect to 11i database.Here you need to identify all custom objects which report is using from your database and the pll file. Create those object in R12. Now you can open report builder 10g and connect to r12 and open report.
e.g if your old report is calling a package from a database. Create only package spec in R12 database and then you can easily open that report in 10G version.
What if you do not have old report builder version? Here is the workaround,
Method 2: Use Notepad++ to identify object
Oracle RDF is a binary file. The code is not in readable format, but it does show package, table name in a readable format.
Open rdf in NOTEPADD+ and identify all the custom object which report is using and follow steps mentioned in method 1 to resolve the issue.
e.g below rdf shows package name/query in notepad++.
I hope above method will help you to solve reports builder stopped working issue or report builder crash issue.
Please let me know if you faced a similar issue and how you resolved.