Toad World® Forums

Toad for SQL Server Beta 6.7.0.135 - GPF when select tab profiling


#1

Last BETA of TOAD 6.7 .

I connect to a SQL Server 2008 R2 DB and write a valid SQL select statement.

After this I select tab profiling and I obtain an error message/GPF.

I attach a screenshot for detail :

error_profiling.png

Best regards,

Sergio


#2

Hi Sergio,

Sorry I can’t reproduce this issue. Would you please provide the script? Thank you so much.

Best Regards,

Kelly


#3

Hi Kelly,

many thank’s for your support.

This is the script :

SELECT CL.codice_cliente, CL.ragione_sociale, CL.descrizione_ridotta, CL.indirizzo,

CL.cap, CL.localita, CL.provincia, CL.codice_fiscale,

CL.partita_iva, CL.telefono, CL.fax1, CL.fax2,

CL.persona_tecnica, CL.persona_commerciale, CL.persona_amministrativa, CL.telefono_tecnica,

CL.telefono_commerciale, CL.telefono_amministrativa, CL.tipo_fattura, CL.banca_appoggio,

CL.codice_pagamento, CL.codice_agente, CL.provvigione_agente, CL.codice_zona,

CL.codice_categoria, CL.persona_fisica, CL.esposizione, CL.fido,

CL.attivo, CL.codice_abi, CL.codice_cab, CL.sede_amministrativa_indirizzo,

CL.sede_amministrativa_cap, CL.sede_amministrativa_localita, CL.sede_amministrativa_provincia, CL.stato_cliente,

CL.valuta, CL.riferimento, CL.codice_iban, CL.codice_bic,

CL.trasporto_cura, CL.codice_corriere, CL.porto, CL.ragione_sociale_spedizione,

CL.cap_spedizione, CL.indirizzo_spedizione, CL.listino, CL.spedizione_fattura,

CL.numero_copie_fattura, CL.giorni_scadenza_gennaio, CL.giorni_scadenza_settembre, CL.indirizzo_sede_secondaria,

CL.priorita, CL.certificato_conformita, CL.codice_cin, CL.stato_estero,

CL.riferimento_infineon, CL.flag_solo_web, CL.classe

FROM CLIENTI CL

I stay tune for your consideration,

Best regards,

Sergio


#4

Hi Sergio,

Thank you so much for your helping.

Do you get the same error when you select other tables?

Would you please provide the table create script?

Best Regards,

Kelly


#5

Hi Kelly,

No.

This is the script of the table :

/****** Object: Table [dbo].[CLIENTI] Script Date: 07/14/2015 14:53:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CLIENTI](

[codice_cliente] [int] NOT NULL,

[ragione_sociale] nvarchar NULL,

[descrizione_ridotta] nvarchar NULL,

[indirizzo] nvarchar NULL,

[cap] nvarchar NULL,

[localita] nvarchar NULL,

[provincia] nvarchar NULL,

[codice_fiscale] nvarchar NULL,

[partita_iva] nvarchar NULL,

[telefono] nvarchar NULL,

[fax1] nvarchar NULL,

[fax2] nvarchar NULL,

[persona_tecnica] nvarchar NULL,

[persona_commerciale] nvarchar NULL,

[persona_amministrativa] nvarchar NULL,

[telefono_tecnica] nvarchar NULL,

[telefono_commerciale] nvarchar NULL,

[telefono_amministrativa] nvarchar NULL,

[tipo_fattura] nvarchar NULL,

[banca_appoggio] nvarchar NULL,

[codice_pagamento] [int] NULL,

[codice_agente] [int] NULL,

[provvigione_agente] [money] NULL,

[codice_zona] [int] NULL,

[codice_categoria] [int] NULL,

[persona_fisica] nvarchar NULL,

[esposizione] [money] NULL,

[fido] [money] NULL,

[attivo] nvarchar NULL,

[codice_abi] nvarchar NULL,

[codice_cab] nvarchar NULL,

[sede_amministrativa_indirizzo] nvarchar NULL,

[sede_amministrativa_cap] nvarchar NULL,

[sede_amministrativa_localita] nvarchar NULL,

[sede_amministrativa_provincia] nvarchar NULL,

[stato_cliente] nvarchar NULL,

[valuta] nvarchar NULL,

[riferimento] nvarchar NULL,

[codice_iban] nvarchar NULL,

[codice_bic] nvarchar NULL,

[trasporto_cura] [int] NULL,

[codice_corriere] nvarchar NULL,

[porto] [int] NULL,

[ragione_sociale_spedizione] nvarchar NULL,

[cap_spedizione] nvarchar NULL,

[indirizzo_spedizione] nvarchar NULL,

[listino] [int] NULL,

[spedizione_fattura] nvarchar NULL,

[numero_copie_fattura] [int] NULL,

[giorni_scadenza_gennaio] [int] NULL,

[giorni_scadenza_settembre] [int] NULL,

[indirizzo_sede_secondaria] nvarchar NULL,

[priorita] [int] NULL,

[certificato_conformita] nvarchar NULL,

[codice_cin] nvarchar NULL,

[stato_estero] [int] NULL,

[riferimento_infineon] nvarchar NULL,

[flag_solo_web] [int] NULL,

[classe] [decimal](18, 10) NULL,

CONSTRAINT [PK_CLIENTI] PRIMARY KEY CLUSTERED

(

[codice_cliente] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

ALTER TABLE [dbo].[CLIENTI] WITH CHECK ADD CONSTRAINT [FK_CLIENTI_AREE_MERCATO] FOREIGN KEY([codice_zona])

REFERENCES [dbo].[AREE_MERCATO] ([codice])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

ALTER TABLE [dbo].[CLIENTI] CHECK CONSTRAINT [FK_CLIENTI_AREE_MERCATO]

GO

ALTER TABLE [dbo].[CLIENTI] WITH CHECK ADD CONSTRAINT [FK_CLIENTI_CATEGORIE] FOREIGN KEY([codice_categoria])

REFERENCES [dbo].[CATEGORIE] ([codice])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

ALTER TABLE [dbo].[CLIENTI] CHECK CONSTRAINT [FK_CLIENTI_CATEGORIE]

GO

ALTER TABLE [dbo].[CLIENTI] WITH CHECK ADD CONSTRAINT [FK_CLIENTI_CODICI_PAGAMENTO] FOREIGN KEY([codice_pagamento])

REFERENCES [dbo].[CODICI_PAGAMENTO] ([codice])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

ALTER TABLE [dbo].[CLIENTI] CHECK CONSTRAINT [FK_CLIENTI_CODICI_PAGAMENTO]

GO

ALTER TABLE [dbo].[CLIENTI] WITH CHECK ADD CONSTRAINT [FK_CLIENTI_CORRIERI] FOREIGN KEY([codice_corriere])

REFERENCES [dbo].[CORRIERI] ([codice])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

ALTER TABLE [dbo].[CLIENTI] CHECK CONSTRAINT [FK_CLIENTI_CORRIERI]

GO

ALTER TABLE [dbo].[CLIENTI] WITH NOCHECK ADD CONSTRAINT [FK_CLIENTI_DOSSIER_NOTE_CLIENTI] FOREIGN KEY([codice_cliente])

REFERENCES [dbo].[DOSSIER_NOTE_CLIENTI] ([codice_cliente])

NOT FOR REPLICATION

GO

ALTER TABLE [dbo].[CLIENTI] NOCHECK CONSTRAINT [FK_CLIENTI_DOSSIER_NOTE_CLIENTI]

GO

ALTER TABLE [dbo].[CLIENTI] WITH CHECK ADD CONSTRAINT [FK_CLIENTI_FORNITORI] FOREIGN KEY([codice_agente])

REFERENCES [dbo].[FORNITORI] ([codice])

GO

ALTER TABLE [dbo].[CLIENTI] CHECK CONSTRAINT [FK_CLIENTI_FORNITORI]

GO

ALTER TABLE [dbo].[CLIENTI] WITH CHECK ADD CONSTRAINT [FK_CLIENTI_PORTI] FOREIGN KEY([porto])

REFERENCES [dbo].[PORTI] ([porto])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

ALTER TABLE [dbo].[CLIENTI] CHECK CONSTRAINT [FK_CLIENTI_PORTI]

GO

ALTER TABLE [dbo].[CLIENTI] WITH CHECK ADD CONSTRAINT [FK_CLIENTI_SPEDIZIONE_FATTURA] FOREIGN KEY([spedizione_fattura])

REFERENCES [dbo].[SPEDIZIONE_FATTURA] ([spedizione_fattura])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

ALTER TABLE [dbo].[CLIENTI] CHECK CONSTRAINT [FK_CLIENTI_SPEDIZIONE_FATTURA]

GO

ALTER TABLE [dbo].[CLIENTI] WITH CHECK ADD CONSTRAINT [FK_CLIENTI_STATI_CLIENTE] FOREIGN KEY([stato_cliente])

REFERENCES [dbo].[STATI_CLIENTE] ([stato])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

ALTER TABLE [dbo].[CLIENTI] CHECK CONSTRAINT [FK_CLIENTI_STATI_CLIENTE]

GO

ALTER TABLE [dbo].[CLIENTI] WITH CHECK ADD CONSTRAINT [FK_CLIENTI_TIPI_FATTURA] FOREIGN KEY([tipo_fattura])

REFERENCES [dbo].[TIPI_FATTURA] ([tipo_fattura])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

ALTER TABLE [dbo].[CLIENTI] CHECK CONSTRAINT [FK_CLIENTI_TIPI_FATTURA]

GO

ALTER TABLE [dbo].[CLIENTI] WITH CHECK ADD CONSTRAINT [FK_CLIENTI_TRASPORTI_CURA] FOREIGN KEY([trasporto_cura])

REFERENCES [dbo].[TRASPORTI_CURA] ([trasporto_cura])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

ALTER TABLE [dbo].[CLIENTI] CHECK CONSTRAINT [FK_CLIENTI_TRASPORTI_CURA]

GO

ALTER TABLE [dbo].[CLIENTI] WITH CHECK ADD CONSTRAINT [FK_CLIENTI_VALUTE] FOREIGN KEY([valuta])

REFERENCES [dbo].[VALUTE] ([valuta])

ON UPDATE CASCADE

ON DELETE CASCADE

GO

ALTER TABLE [dbo].[CLIENTI] CHECK CONSTRAINT [FK_CLIENTI_VALUTE]

GO

Database is Microsoft SQL Server 2008 R2 Advanced Express Edition with last service pack.

I stay tune for your answer,

Best regards,

Sergio


#6

Last beta version of TOAD 6.7.0.194.

The problem is still present.

I attach a screenshot for details :

toad_67_Error.png

Best regards,

Sergio


#7

Last beta version of TOAD 6.7.0.282.

The problem is still present.

toad_error.png

Best regards,

Sergio


#8

Last Beta version of TOAD 6.7.0.376.

The problem is still present.

0636.toad_error.jpeg

Best regards,

Sergio


#9

Hi Sergio,

We are failed to reproduce this issue.

I can only see the table script of CLIENTI but there are still many tables which referenced by it.

Could you please provide a completely scripts for us including the tables which referenced by table CLENTI?

I will try again.

Thanks,

Cathy.


#10

Hi Cathy,

many thank’s for your reply.

In attach a file rar with all the tables - clienti and all foreign key of clienti.

Please, inform me if you can reproduce the problem.

If not, send me your private e-mail. I empty all tables of the DB and send to you a backup of it.

I stay tune for your answer,

Best regards,

Sergio
toad_cathy.rar (2.07 KB)


#11

Hi Sergio,

Thanks for your reply, I’ve created the tables with your scripts successful and select the same statements as yours but still failed to get the exception.

I ‘ve send E-mail to our developer who owner this modules and I hope he could check it out.

When I get update from him I will let you know that if you need to provide more details to me.

My private E-mail Address is : Cathy.Liu@quest.com , you can contact me anytime.

Thanks,

Cathy.


#12

Hi Cathy,

I send to you a private e-mail.

I stay tune for your reply.

Best regards,

Sergio


#13

Hi Cathy

I send to your private e-mail backup of the DB with datas and ExceptionTrace.Log file.

I stay tune for your answer,

Best regards,

Sergio


#14

Hi Sergio,

With your backup file I reproduce the exception.

I’ve create TSS-1205 for it and we will fix it as soon as possible.

I will update to you when it is fixed.

Thank you very much.

Best regards,

Cathy.


#15

Hi Cathy,

good news.

I stay tune for your update as soon as possibile.

Best regards,

Sergio


#16

Hi Sergio,

It has been fixed in the latest beta which is 6.7.0.37 ,

You could verified it nowJ

Thanks,

Cathy.


#17

Hi Cathy,

I test the problem with last new beta version 6.7.0.37.

Now the problem was solved. I verify and confirm it.

Best regards,

Sergio


#18

That’s great, ThanksJ

Cathy.