'Table '#TEMP_<number>' errors

Classic Servoy
1

Hi

I get following errors and have great difficulties to debug them. I think they have something to do when applying table filters, but can’t track them down to where the errors appears, some sort of a moving target.

Fehler in Beziehung
 > com.servoy.j2db.dataprocessing.DataException: SQL Anywhere Error -141: Table '#TEMP_3344222350' not found
Fehler in Beziehung
 > com.servoy.j2db.dataprocessing.DataException: SQL Anywhere Error -141: Table '#TEMP_3344222353' not found

Any idea how to get a step further or where the problem could be?

Regards,

Java 1.6.0_29
OS X 10.7.2

2

Robert,

When a smart client reconnects to the server it checks to see if temp tables it has been using are still there.
It does that with a query on that table and if the table was cleaned up already, you get a (harmeless) sql exception.

I think that is what us happening here

Rob

3

Hi Rob

The thing is that it always appears by loading the same form. And the time we load the Form does not matters. We use table filters in this case and if we don’t apply them it works fine! So why does this error occurs always at the same forms?

Regards, Stef

4

Ah, I mixed things up with another error message.

This is typically what may happen if you use databaseManager.getQL() in cases that the sql uses a temporary table.

See viewtopic.php?f=8&t=13009

Rob

5

But we dont use databaseManager.getSQL() in the whole project.

When is this message normaly triggerd.

Regards, Stef

6

Can you show some more of the stack trace from the server log file?

Rob

7

I attached a txt file with the StackTrace of the error log. I hope this helps.

Regards, Stef

temp_ERROR.txt (9.3 KB)