Using SQLA 11.0.1.2376

Situation: - Client database contains FKs with cascading deletes. - Oracle consolidated contains same FKs, but not with cascading delete clause. - error occurred during ML sync when deleting a row with child rows.

My Initial Assumption: - When I issue a delete on a parent row, the cascading delete option causes deletes to be issued for each child row. - these deletes will be in the transaction logs, and thus used by MobiLink. - ML orders the upload data stream by examining FK definitions to insure referential integrity will be maintained. - Therefore, the upload stream will issue child deletes on the consolidated database before the parent row. - MobiLink will have done all the work for me and life will be good.

But the error tells me my Initial Assumption must be faulty. I am asking 2 questions: 1. Where did my Initial Assumption get off track? 2. If I merely add “ON DELETE CASCADE” to the FKs on the consolidated, will that eliminate the error?

Thanks.

asked 08 Jul '10, 20:08

Bill%20Aumen's gravatar image

Bill Aumen
2.0k314573
accept rate: 16%

edited 09 Jul '10, 13:06

Volker%20Barth's gravatar image

Volker Barth
30.6k304455662


Bill,

to your first question:

Trigger-generated actions are not contained in the updload stream by default. This can be changed by the SendTriggers extended option. Note that all RI actions (except RESTRICT), i.e. CASCADE, SET NULL and SET DEFAULT, are implemented by system triggers.

You may also check the similar question will-a-publication-upload-trigger-generated-data-to-mobilink.

To your second question: I guess this should work but I do not know the Oracle implementation. I remember having had some trouble with cascading deletes and ML used between SQL Anywhere and MS SQL Server, though. In that case, SendTriggers might be the easier solution...

permanent link

answered 09 Jul '10, 12:30

Volker%20Barth's gravatar image

Volker Barth
30.6k304455662
accept rate: 32%

edited 09 Jul '10, 13:06

Thanks Volker. This is good to know (RI via system triggers).

(09 Jul '10, 14:01) Bill Aumen
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×295
×60
×27

question asked: 08 Jul '10, 20:08

question was seen: 1,361 times

last updated: 23 Jul '10, 13:23