This error occurs when inserting rows into a table which has dependant materialized view in SQLA12 db (see attached image for full details).

Any ideas on why this is happening? This happens on 1 or 2 databases, the rest (90+) is working great. This is databases which started out as ASA5.5 db's once upon a time. Otherwise, everything works as it should.

We've also installed the lastest EBF for SQL Anywhere 12 (4142), but the error still occurs.

Regards,

Bjarne Anker Maritech Systems AS Norway

asked 14 Nov '14, 07:51

Bjarne%20Anker's gravatar image

Bjarne Anker
420141529
accept rate: 0%

According to CR number 756681 (fixed in 12.0.1.4071), I would have thought this bug should have been fixed in your EBF. - FWIW, 4142 is not the latest one for 12.0.1.

(14 Nov '14, 08:05) Volker Barth

Hi Volker.

I noticed now that 4142 is not the latest EBF, but this error should be fixed also in 4142. Anyways, the error occurs when running simple INSERT or UPDATE statement from PowerBuilder embedded sql against a table with dependency to a materialized view. The line-view has a join against another materialized view. Also, there are some triggers on one of the tables, if that has anything to do with the case?

Regards,

Bjarne Anker

(17 Nov '14, 02:22) Bjarne Anker
Replies hidden

I'm just another customer so I can't tell that...

Does the description of the cited CR fit your situation?

  • An INSERT, UPDATE, or DELETE statement triggered the change of an immediate materialized view.
  • The problem only happened when the very first INSERT, UPDATE, or DELETE of the table in a connection was executed in a nested block, for example a trigger or procedure.

As Jeff seems to have asked for more details on your similar quesion on SCN, that's probably the way to go:)

(17 Nov '14, 03:13) Volker Barth

I will take a look. Do you have any more details about the issue? Is the insert executed from the client or from stored procedure? Does it happen at random times? first time the insert is executed? Does the view cover one or more tables?

(17 Nov '14, 15:02) Elmi Eflov
Be the first one to answer this question!
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:

×406
×26
×15

question asked: 14 Nov '14, 07:51

question was seen: 320 times

last updated: 17 Nov '14, 15:02