Icon View Incident Report

Minor Minor
Reported By: Michael Baytalsky
Reported On: 8/8/2007
For: Version 1.05 Build 1
# 2437 Long Database Names Cause Invalid Temporary Table Identifier Error with SQL Queries

The following SQL now returns the following error:

ElevateDB Error #406 Invalid temporary table identifier
'CONTEXT8441640DBA7199CBE2FD44229BFD73528DA0503B143'

The database name (randomly generated from GUID) is:
DBA7199CBE2FD44229BFD73528DA0503B143'

SELECT
  NAME, DESCRIPTION, VERSION, ENCRYPTED, INDEXPAGESIZE, BLOBBLOCKSIZE,
  MAXROWBUFFERSIZE, MAXINDEXBUFFERSIZE, MAXBLOBBUFFERSIZE
FROM INFORMATION.TABLES
ORDER BY NAME



Comments Comments and Workarounds
The workaround is to use a shorter database name or make sure that the query returns a sensitive result set that doesn't require a temporary table.


Resolution Resolution
Fixed Problem on 8/10/2007 in version 1.05 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 VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image