Forum Stats

  • 3,757,491 Users
  • 2,251,236 Discussions
  • 7,869,842 Comments

Discussions

Data modeler 4.0.2.840 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:

java.lang.NullPointerException

  at oracle.dbtools.crest.exports.reports.RSFKeys.export(RSFKeys.java:45)

  at oracle.dbtools.crest.exports.reports.RSRelationalModel.export(RSRelationalModel.java:37)

  at oracle.dbtools.crest.exports.reports.ReportsHandler.export(ReportsHandler.java:123)

  at oracle.dbtools.crest.swingui.ControllerApplication$ExportToReportsSchema$1.run(ControllerApplication.java:2056)

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

Thanks in advance for your time!

Regards,

Rob

Answers

  • 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?

    Philip

This discussion has been closed.