Icon View Incident Report

Minor Minor
Reported By: Roy Lambert
Reported On: 11/15/2014
For: Version 2.18 Build 1
# 4127 Tables with Names Containing One or More Trailing Spaces Can Experience File Manager Errors

I received the following error message:

ElevateDB Error #600 File manager error (Cannot rename the file E:\Cluster DEV\System\Data\OPTIMUS451249521995034Info4.EDBTbl to E:\Cluster DEV\System\Data\Contacts .EDBTbl (OS Error: Cannot create a file when that file already exists.
))

I think the problem was related to the trailing space on the table name (I don't know how that got there - must be wandering fingers) at least when I removed it it worked.

Used the EDBManager built in facilities to alter a table, dropped several columns, committed that- no problem.

Altered the table again altered a column name & type, tried to save the changes and received the error.

Exited EDBManager, checked no work files left around, tried again - same problem.

I copied the code to sql and tried executing it a few times just to see what happened to the file name and it incremented from Info1 to Info4.

Removed the space from the table name, tried again and it worked

Tried adding the space back onto the table name but things still work hence information only.


Comments Comments and Workarounds
ElevateDB now trims all trailing spaces from any identifier name, in order to prevent such issues.


Resolution Resolution
Fixed Problem on 11/18/2014 in version 2.18 build 2


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image