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

Converse agora com nosso suporte

Obtenha ajuda em tempo real
Concluir registro

Entrar

Solicitar preços

Entre em contato com o setor de vendas

Voltar

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Título

Trying to create a new table using the Create Table tool and I get the error: Message : FastTable
Descrição

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
**********************************************************************
Resolução

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.

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Solicitar um artigo da base de conhecimento

Conteúdo recomendado

Produto(s):: Toad for SQL Server

Tópico(s):: Technical Solutions

Histórico do artigo:: Criado em: 7/16/2011
Última atualização em: 5/7/2023

Search All Articles

Selecione seu produto:

Para podermos atendê-lo melhor, informe o Propósito de seu chat:

Soluções recomendadas para seu problema

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

Título

Descrição

Resolução

Leave a Comment