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
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.
answered 28 Oct '14, 05:45