Question Re: SQLCode - 1: Table '_^_^_22072007....._^_^_' not found in Technology Q&A

SQLCode - 1: Table '_^_^_22072007....._^_^_' not found

Former Member — Fri, 14 Nov 2014 07:51:03 GMT

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

Re: SQLCode - 1: Table '_^_^_22072007....._^_^_' not found

VolkerBarth — Fri, 14 Nov 2014 08:05:38 GMT

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.

Re: SQLCode - 1: Table '_^_^_22072007....._^_^_' not found

Former Member — Mon, 17 Nov 2014 02:22:28 GMT

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

Re: SQLCode - 1: Table '_^_^_22072007....._^_^_' not found

VolkerBarth — Mon, 17 Nov 2014 03:13:07 GMT

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:)

Re: SQLCode - 1: Table '_^_^_22072007....._^_^_' not found

Former Member — Mon, 17 Nov 2014 15:02:49 GMT

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?