Question Re: Error using materialized view in Technology Q&A

Error using materialized view

Former Member — Thu, 09 Jan 2014 06:27:43 GMT

I've create and enabled some materialized view with immediate refresh. Materialized view reference a table filled by trigger. When I use my app I receive this error:

Error code -141
SQLSTATE = S0002
[Sybase][ODBC Driver][SQL Anywhere]Table not found '_^_^_22072007_^_^_1962_^_^_22072007_^_^_'

Obviously that table description it's not a real table. I use ASA 16.0.0 build 1691

Thanks in advance

Re: Error using materialized view

Former Member — Thu, 09 Jan 2014 10:22:41 GMT

Can you post the schema for your tables, the materialized view and the trigger?

Re: Error using materialized view

Former Member — Thu, 09 Jan 2014 10:50:36 GMT

Here I attach my schema, I hope it's helpful because it contains several objects. Tables involved are:

dba.riga_documento which triggers t_riga_documento_ai that writes in dba.riga_doc_magazzino.

Materialized view select on dba.riga_doc_magazzino.

A particular it's that the trigger t_riga_documento_ai, in some circumstances, updates another record of dba.riga_documento ( the same starting table ) causing updates on dba.riga_doc_magazzino.

I think this is the case causing the error code

Re: Error using materialized view

VolkerBarth — Thu, 09 Jan 2014 17:14:10 GMT

Hm, I can't find your attachment...

Re: Error using materialized view

Former Member — Fri, 10 Jan 2014 02:30:35 GMT

Sorry, I'm trying again but upload doesn't work. After I've selected the file, i wait some second for the upload and then I don't see the file I've previously selected. My reload.sql file is 11 MB and I've splitted in 8 smaller files, but I can't attach the smaller one

Re: Error using materialized view

Former Member — Fri, 10 Jan 2014 03:14:34 GMT

I think you have to have a certain number of "points/credits" to be able to upload an attachment

Re: Error using materialized view

MCMartin — Fri, 10 Jan 2014 03:31:40 GMT

I think 100 should be enough...

Re: Error using materialized view

VolkerBarth — Fri, 10 Jan 2014 13:38:17 GMT

I don't think I would be interested in reading a 11 MB SQL script here - can't you extract some essential parts?

Re: Error using materialized view

VolkerBarth — Sat, 11 Jan 2014 06:28:29 GMT

At least 100 points are what the FAQ does tell:)