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

asked 09 Jan '14, 06:27

Giorgio%20Papagno's gravatar image

Giorgio Papagno
3062410
accept rate: 20%

edited 11 Jan '14, 08:00

Graeme%20Perrow's gravatar image

Graeme Perrow
8.7k374111

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

(09 Jan '14, 10:22) Jason Hinspe...

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

(09 Jan '14, 10:50) Giorgio Papagno
Replies hidden

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

(09 Jan '14, 17:14) Volker Barth

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

permanent link

answered 10 Jan '14, 02:30

Giorgio%20Papagno's gravatar image

Giorgio Papagno
3062410
accept rate: 20%

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

(10 Jan '14, 03:14) M G
Replies hidden

I think 100 should be enough...

(10 Jan '14, 03:31) Martin
1

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

(10 Jan '14, 13:38) Volker Barth

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

(11 Jan '14, 06:28) Volker Barth
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:

×206
×15

question asked: 09 Jan '14, 06:27

question was seen: 564 times

last updated: 11 Jan '14, 08:00