Using Rename inside a server stored procedure when multiple users use it at the same time,  I receive errors like:

An error occurred with the statement at line X and column Y (File manager error (Access denied to the file  ... path ... \eiid.DBTbl ))

The SP looks like this :
...
EXECUTE IMMEDIATE 'RENAME TABLE "eiida" TO "eiid"';
...

and both eiida and eiid are temporary tables.

Is it a bug?

Timoscov,

<< Using Rename inside a server stored procedure when multiple users use it
at the same time,  I receive errors like:

An error occurred with the statement at line X and column Y (File manager
error (Access denied to the file  ... path ... \eiid.DBTbl ))

The SP looks like this :
..
EXECUTE IMMEDIATE 'RENAME TABLE "eiida" TO "eiid"';
..

and both eiida and eiid are temporary tables. >>

How did you create the tables, with CREATE TABLE, or CREATE TEMPORARY TABLE
?

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:
How did you create the tables, with CREATE TABLE, or CREATE TEMPORARY TABLE ?

I don't know if it matters, but i will be very specific:

- tables are created by "CALL NewTable('eiida');",  where NewTable is defined as:

PROCEDURE "NewTable" ( IN ANAME VARCHAR )
BEGIN
EXECUTE IMMEDIATE 'CREATE TEMPORARY TABLE "'+ANAME+'"
(
ID INTEGER,
CONSTRAINT "dupaid" PRIMARY KEY ("ID")
)
DESCRIPTION '''+CAST(CURRENT_TIMESTAMP AS VARCHAR)+'''';
END

Also the rename is inside a while loop:

WHILE NRNOD > 0 DO
  CALL NouTabel('eiida');
 ........ more SQL.....
  EXECUTE IMMEDIATE 'DROP TABLE "eiid"';
  EXECUTE IMMEDIATE 'RENAME TABLE "eiida" TO "eiid"';
END WHILE;

Timoscov,

<<- tables are created by "CALL NewTable('eiida');",  where NewTable is
defined as: >>

Thanks, that's what I needed.  I'll check it out and see what the issue is.

--
Tim Young
Elevate Software
www.elevatesoft.com

<<Thanks, that's what I needed.  I'll check it out and see what the issue is.  >>

Any news ? I hope for the good ones, as I have no wish to rewrite all the rename code, in order to avoid the bug.

Timoscov,

<< Any news ? >>

My apologies - this one got lost in the shuffle.

<< I hope for the good ones, as I have no wish to rewrite all the rename
code, in order to avoid the bug. >>

I suspect that the issue is this:

http://www.elevatesoft.com/incident?action=viewrep&category=edb&release=2.03&incident=3173

It doesn't always manifest itself as an AV.

If you're using the latest 2.03 Build 13, then the issue is probably with
anti-virus software interfering with the creation of the temporary tables.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

I'm using 2.03 Build 12,  and I've just tested the issue with no anti-virus software on the server, with the same result.

Could you please take another look at the error.

Timoscov Razvan wrote:

I'm using 2.03 Build 12,  and I've just tested the issue with no anti-virus software on the server, with the same result.

Could you please take another look at the error. Do not forget that this error does occur only with several remote sessions using the SP at the same time.

Timoscov,

<< Could you please take another look at the error. Do not forget that this
error does occur only with several remote sessions using the SP at the same
time. >>

Sorry about that - I completely missed that you were trying to rename
temporary tables.  This actually is a bug - EDB doesn't expect anyone to try
to rename temporary tables, so it doesn't handle it properly.

A fix will be available in the next build, but that's at least a couple of
weeks away right now.

--
Tim Young
Elevate Software
www.elevatesoft.com