{"id":3187,"date":"2012-10-10T09:55:29","date_gmt":"2012-10-10T13:55:29","guid":{"rendered":"https:\/\/pitss.org\/us\/2012\/10\/10\/reports-builder-11gr2-crashes-when-viewing-data-model\/"},"modified":"2017-05-16T08:23:56","modified_gmt":"2017-05-16T12:23:56","slug":"reports-builder-11gr2-crashes-when-viewing-data-model","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2012\/10\/10\/reports-builder-11gr2-crashes-when-viewing-data-model\/","title":{"rendered":"Reports Builder 11gR2 crashes when viewing Data Model"},"content":{"rendered":"

Although Reports Builder 11gR2 is supported on 64-bit Windows machines, there is a bug within Reports Builder 11gR2 64-bit where if you try to access \u201cData Models\u201d for any report in Reports Builder, Reports Builder will crash (Windows error that generates is: \u201cReport Builder has stopped working. Windows can check online for a solution to the problem.\u201d). <\/em>To work around this, you will need to do the following:<\/p>\n

    \n
  1. Go to %ORACLE_INSTANCE%\\config\\FRComponent\\frcommon\\TOOLS\\admin (%DOMAIN_HOME%\\config\\fmwconfig\\components\\ReportsToolsComponent\\reptools1\\tools\\admin in 12c)<\/li>\n
  2. Make a backup of cauprefs.ora<\/li>\n
  3. Edit cauprefs.ora in a text editor\n
      \n
    • Find the following lines:\n
        \n
      • Reports.PluggableDataSourceFactories =
        \n(“oracle.reports.plugin.datasource.xmlpds.XMLDataSourceFactory”,
        \n“oracle.reports.plugin.datasource.jdbcpds.JDBCDataSourceFactory”,
        \n“oracle.reports.plugin.datasource.textpds.TextDataSourceFactory”)<\/li>\n<\/ul>\n<\/li>\n
      • Replace the value to: Reports.PluggableDataSourceFactories = ()<\/li>\n<\/ul>\n<\/li>\n
      • Save the file and try running Reports Builder again.<\/li>\n<\/ol>\n

        NOTE: If you happen to use Pluggable Data Sources (PDS) in your reports, the workaround will not work.<\/b><\/p>\n

        UPDATE: This error also occurs in the latest release of Oracle Forms & Reports 11gR2 (11.1.2.2) and 12c.<\/strong>
        \nReference: See Oracle Support note 1395965.1 for more information.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

        Although Reports Builder 11gR2 is supported on 64-bit Windows machines, there is a bug within Reports Builder 11gR2 64-bit where if you try to access \u201cData Models\u201d for any report in Reports Builder, Reports Builder will crash (Windows error that generates is: \u201cReport Builder has stopped working. Windows can check online for a solution to […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[26,36,14,10],"tags":[16,89,25,12,3,37,24],"class_list":["post-3187","post","type-post","status-publish","format-standard","hentry","category-development","category-reports","category-resolve-issues","category-windows","tag-11gr2","tag-12c","tag-customer-support-request","tag-error","tag-faq","tag-reports","tag-windows"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=3187"}],"version-history":[{"count":3,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3187\/revisions"}],"predecessor-version":[{"id":8528,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3187\/revisions\/8528"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=3187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=3187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=3187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}