Forum Stats

  • 3,757,491 Users
  • 2,251,236 Discussions


Data modeler export to reporting schema issue

Rob Naastepad
Rob Naastepad Member Posts: 3

Hello All,

When I try and export a model to a reporting schema I get the following error:

2014-07-03 16:25:54,947 [Thread-27] ERROR ReportsHandler - Error Exporting to Reporting Schema:


  at oracle.dbtools.crest.exports.reports.RSFKeys.export(

  at oracle.dbtools.crest.exports.reports.RSRelationalModel.export(

  at oracle.dbtools.crest.exports.reports.ReportsHandler.export(

  at oracle.dbtools.crest.swingui.ControllerApplication$ExportToReportsSchema$

Anyone who knows how te get around this error and be able to export normally?

Thanks in advance for your time!




  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,348 Employee

    Hi Rob,

    you have a bad foreign key without referred (Remote) table. You can use search functionality in advanced mode, object type foreign key (for your relational model) and add property (as search property) 'remote Table" or "Key object". Leave the text field empty and press "find" button.

    If you get something in result then try to find it in the browser and to delete those bad foreign keys.

    You also can use scripting to find those foreign keys as explained here

    You have 2 scripts there - 1) to report bad FKs, 2) to remove bad FKs

    How did you get there?


This discussion has been closed.