Skip to Content
avatar image
Former Member

loadercli Schema Export: Order of Statements

We try to do an export/Import (from 7.6 to 7.8 in RECORDS format) with the loadercli Version 7.8.02.39 (same for 7.6er) and face one interesting difficulty:

When exporting the more complex parts of the catalog in the catalog0001 file (views, triggers, functions), the loader seems not to honour any required order of statements; that is if we for example have a view that needs a user-defined function for it's creation, the view is tried to be created before the function (much earlier in the file). Of course this does not work. The same seems to apply to functions and triggers depending on each other.

Of course we can manually reorder those things (and will 😊), but since this seems a little weird to me (loader completely ignoring such constraints) and I could not find anything in the documentation I would like to ask for any hints.

Thanks a lot,

urs

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 14, 2015 at 09:38 AM

    Thank you for reporting this bug. We will fix this via bug tracking id PTS1253606. If you want, I can send you a preliminary bug fix for testing (new loadercli executable) once it is available.

    Kind regards,
    Thorsten

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Thorsten Zielke

      Hi Thorsten,

      Sorry for the delay ... I still cannot provide a full test report right now, but at least it seems to run much smoother than 7.8.02.39. I could export/import a smaller test database with only one error in the catalog script (despite many of them before).

      Most funny the single error was a duplicate statement like:

        CREATE VIEW bla AS ...

        CREATE VIEW bla AS ...

      I can of course provide more information on our DB, but not here in the open forum.

      I will continue to run a bigger test as well.

      Regards,

      Urs