Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 9 of 9 total |
Rename problem |
Thu, Apr 8 2010 6:11 AM | Permanent Link |
TDR | 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? |
Thu, Apr 8 2010 7:01 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Apr 9 2010 4:33 AM | Permanent Link |
TDR | "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; |
Fri, Apr 9 2010 3:23 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Mon, May 3 2010 8:43 AM | Permanent Link |
TDR | <<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. |
Mon, May 3 2010 1:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, May 4 2010 8:49 AM | Permanent Link |
TDR | "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. |
Tue, May 4 2010 9:49 AM | Permanent Link |
TDR | 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. |
Tue, May 4 2010 1:45 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |