loadercli Schema Export: Order of Statements

[urs_schuerer]

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

[thorsten_zielke · Accepted solution]

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

[urs_schuerer · Accepted solution]

Thanks a lot Thorsten for taking care about this, sorry for my slow responding and yes, it would be great to receive such a fixed binary,

Kind regards,

Urs

[thorsten_zielke · Accepted solution]

Hi,

we have the "Loader"-fix ready, but I forgot to ask you which OS version you are using. Please let me know and I will send you a link for e.g. Linux x86_64 (or even Linux ppc or Linux ia64).

Thorsten

[urs_schuerer · Accepted solution]

Hi Thorsten,

Great. We already did our migration to 7.8 on Saturday (had to - sorry), but will be happy to test that and yes we are on Linux x86_64 (sorry for not mentioning).

I don't like to sound too greedy, but we seem to have discovered some other little loader problems that we needed to circumvent:

• Sequences and their GRANTs seem to be missing from the Export (which was important for us)
• GRANTs on FUNCTIONs (grant execute on ...) seem to be missing from the Export

By the way one more novice question: I could not find a system table holding those execute rights on functions like 'FUNCTIONPRIVILEGES'. Where are these kept?

Best Regards,

Urs

[thorsten_zielke · Accepted solution]

Hi Urs,

here is the download link for the new Loader version (will be part of 7.8.02.42):

https://mdocs.sap.com/mcm/public/v1/open?shr=oO9m5zi9CSK9KRLFs7-ZLx6JPicX9cEW4b7lydSDAgQ&obj=Skv3bbR...

In response to your questions:

1. Sequences should not be missing from the Export. Can you double check with the new Loader version?

2. Grants on functions are indeed missing - we will to bug fix this, but it might take some time...

3. And indeed the system table holding the execute rights on FUNCTIONPRIVILEGES is also missing - it seems this feature was not fully implemented - we will also address this problem and fix it.

Regards,
Thorsten

[urs_schuerer · Accepted solution]

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