Trying to create a new table using the Create Table tool and I get the error: Message : FastTable (4302561)

Chatee ahora con Soporte

Obtener ayuda en vivo
Completar registro

Iniciar sesión

Solicitar precios

Comuníquese con Ventas

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

Trying to create a new table using the Create Table tool and I get the error: Message : FastTable
Descripción

When I use the Create Table tool to create a new table, I get the error below.
**********************************************************************
Exception Information
**********************************************************************
Exception: Quest.Toad.SqlServer.Trl.TrlHasEmptyResultSetException
Message : FastTable.Rows.Count = 0, FastTable.Columns.Count = 36 for: sqlserver://@ARAMARKDB01/DATABASE/CE_GeneralData/PROPERTIES
Stack Trace:
at Quest.Toad.SqlServer.Trl.BaseObjPropertiesTrl.getProperties()
at Quest.Toad.SqlServer.Trl.Databases.DatabasePropertiesTrl.get_Collation()
at Quest.Toad.SqlServer.Doe.Tables.TableProperties.GetCollationDefault()
at Quest.Toad.SqlServer.Doe.Tables.Columns.ColumnsControl.addRecord()
at Quest.Toad.SqlServer.Doe.Tables.Columns.ColumnsControl.ActivateControl(TableProperties tableProperties)
at Quest.Toad.SqlServer.Doe.Tables.TableEditForm.Initialize()
at Quest.Toad.Doe.BaseDoeForm.BaseDoeForm_Load(Object sender, EventArgs e)
at Quest.Toad.Doe.BaseDoeForm.PreShowInitialize()
at Quest.Toad.Doe.BaseDoeForm.Create(Object sender, ItemClickEventArgs e)
**********************************************************************
Support Bundle: Toad for SQL Server 5.5.0.1073 Professional Edition
7/11/2011 12:16:39 PM
**********************************************************************
Resolución

Reset or rename the Toad for SQL Server (TSS) user files folder. Here are the steps.

1) Fully exit Toad for SQL Server (TSS)

2) Go to:
XP: C:\Documents and Settings\<YOUR_USER>\Application Data\Quest Software\
Vista: C:\Users\<YOUR_USER>\AppData\Roaming\Quest Software\

3) Rename the “Toad for SQL Server 5.5” folder to “Toad for SQL Server 5.5 OLD”

4) Start TSS

5) When asked if you want to ‘migrate’ settings from previous versions, choose CANCEL
NOTE: If you are not asked to ‘migrate’ settings, please let me know as the process might have not gone through properly or your Toad user files folder is in a different location.

6) Connect to one database and exit TSS again to finalize all the settings

7) Start TSS again and re-test the issue

NOTE: If you would like to transfer back your Saved Connections in the TSS log-in screen, please see the steps below. Important: Re-test the issue first before performing these steps.

1) Fully exit TSS again

2) Go to the OLD “Toad for SQL Server 5.5 OLD” folder you renamed in Step 3 above

3) Perform a Copy on the “Connections.xml” file (make a backup of this file just in case of errors)

4) Go to the NEW “Toad for SQL Server 5.5” folder that was just created by TSS

5) Paste the “Connections.xml” file in there

6) Start TSS and you should now have your previous Saved Connections in the log-in screen

NOTE: try not to leave TSS running overnight or force close TSS as these can cause user files corruption or damage.

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Solicitar un artículo KB

Contenido recomendado

Producto(s):: Toad for SQL Server

Tema(s):: Technical Solutions

Historial del artículo:: Creado el: 7/16/2011
Última actualización: 5/7/2023

Buscar todos los artículos

Seleccione su producto:

Con el fin de ofrecerle un mejor servicio, complete el campo Motivo del chat:

Soluciones recomendadas para su problema

Trying to create a new table using the Create Table tool and I get the error: Message : FastTable (4302561)

Título

Descripción

Resolución

Leave a Comment