The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

We have a program that runs continuously and at 1am, fires off a stored procedure and then starts processing accounts that have changed during the day.

However, the last night it has recorded 24,281 errors of the same thing per account: [Sybase][ODBC Driver][SQL Anywhere]Table '^^22072007^^_1114^^_22072007^^' not found.

I don't have a table of this name - does anyone have any ideas?!

asked 28 Oct '14, 04:56

da69plc's gravatar image

da69plc
36347
accept rate: 0%


Which version and ebf are you using ? The same happened to me with trigger on table involved in materialized view This error was solved with latest EBF OF SQL Anywhere 16.

From readme of latest ebf:

Build #1829 - Engineering Case #756681

In rare cases, the server could have returned an error like: "Table '^^22072007^^_759^^_22072007^^' not found" for an internal temporary table if 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. In this case subsequent DML operations on the table may then have returned the above error. This has been fixed.

permanent link

answered 28 Oct '14, 05:45

Giorgio%20Papagno's gravatar image

Giorgio Papagno
3062410
accept rate: 20%

Unfortunately, I am using v11.0.1 EBF 2661 (x64) - am I knackered then?

Is it something that has changed that is causing this now? (the stored procedure has recently been extended to perform some more UPDATES!)

Thanks.

(28 Oct '14, 05:50) da69plc
Replies hidden

I have read 11.0.1 docs until the latest ebf 3158 but the problem seems unresolved. The error happened to me when a trigger update on table causes an update on a differente record of the same table and the table was involved in a materialized view. Release 11.0.1 it's not supported for bug fixes, I think you have to migrate or change something in your procedure.

Good luck

(28 Oct '14, 05:59) Giorgio Papagno

Thanks for that - I'll change the stored procedure short-term.

Long-term - do you know of any "breaking changes" between 11.0.1 and latest 16?

(28 Oct '14, 06:12) da69plc
1

I migrate from 11.0.1 to 16 with no problem. Our db consists on more than 1.000 tables, complex triggers, views and more then 300 store procedure. We don't use many of new features but after one year in production we have no problem. Pay attention in new features when you create a new database because many new features are about security and permissions.

(28 Oct '14, 06:20) Giorgio Papagno

FWIW, according to the CR note this bug has been fixed in v16.0.0.1829 and v12.0.1.4071, so it's available in the 12.0.1 version as well - that may present a "smaller upgrade path".

@da69plc: Do you use immediate materialized views at all?

Note that you should be able to run your v11 database unchanged on a v12.0.1/v16 database engine to test whether that error will still appear...

(28 Oct '14, 07:09) Volker Barth

Yes - there are 6 materialized views defined in the schema....

I removed all lines from the stored procedure that is called before the main overnight process loop (leaving just an empty procedure) and moved them into an event (at midnight) and the errors still happened so I am changing the order of the CALL's from within the event to see if this will fix it...

(29 Oct '14, 12:08) da69plc
1

Adding an UPDATE statement before the first CALL fixed the problem.

Thanks for your help guys.

(30 Oct '14, 10:49) da69plc
Replies hidden

Glad to hear that - it's great that those CR notes contain work-arounds, isn't it? (Who would have thought that only the initial DML statement would cause such an error, and only when contained within a code block...?)

(30 Oct '14, 11:07) Volker Barth
showing 4 of 8 show all flat view
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:

×122
×79

question asked: 28 Oct '14, 04:56

question was seen: 1,083 times

last updated: 30 Oct '14, 11:07