This is a migrated thread and some comments may be shown as answers.

ERROR AT THE TIME OF EXPORT DATA

1 Answer 20 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Hugo Nickerson
Top achievements
Rank 1
Hugo Nickerson asked on 28 Mar 2011, 02:21 PM
I'm making a system that takes data from the database and export pro excel. But that has hours of this error and can no longer export. Can anyone help me?

See end of this message for details on invoking
debugging just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

   em Sistema.bll.clnRelatorio.relatoriosEmpresas(String numgEmprsas)
   em Sistema.frmImportacao.relatorios(List`1 numg_Empresas, String empresa)
   em Sistema.frmPesquisa.btnImportar_Click(Object sender, EventArgs e)
   em System.Windows.Forms.Control.OnClick(EventArgs e)
   em Telerik.WinControls.RadControl.OnClick(EventArgs e)
   em Telerik.WinControls.UI.RadButton.ButtonElement_Click(Object sender, EventArgs e)
   em Telerik.WinControls.RadItem.OnClick(EventArgs e)
   em Telerik.WinControls.UI.RadButtonItem.OnClick(EventArgs e)
   em Telerik.WinControls.RadItem.DoClick(EventArgs e)
   em Telerik.WinControls.RadItem.RaiseBubbleEvent(RadElement sender, RoutedEventArgs args)
   em Telerik.WinControls.RadElement.RaiseRoutedEvent(RadElement sender, RoutedEventArgs args)
   em Telerik.WinControls.RadItem.RaiseBubbleEvent(RadElement sender, RoutedEventArgs args)
   em Telerik.WinControls.RadElement.RaiseRoutedEvent(RadElement sender, RoutedEventArgs args)
   em Telerik.WinControls.RadElement.DoMouseUp(MouseEventArgs e)
   em Telerik.WinControls.ComponentInputBehavior.OnMouseUp(MouseEventArgs e)
   em Telerik.WinControls.RadControl.OnMouseUp(MouseEventArgs e)
   em System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   em System.Windows.Forms.Control.WndProc(Message& m)
   em System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   em Telerik.WinControls.RadControl.WndProc(Message& m)
   em System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   em System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   em System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Conjuntos de Módulos (Assemblies) Carregados **************
mscorlib
    Versão do Conjunto de Módulos (Assembly): 2.0.0.0
    Versão do Win32: 2.0.50727.4062 (QFE.050727-4000)
    Base de Código: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
mscorlib.resources
    Versão do Conjunto de Módulos (Assembly): 2.0.0.0
    Versão do Win32: 2.0.50727.4062 (QFE.050727-4000)
    Base de Código: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Sistema
    Versão do Conjunto de Módulos (Assembly): 2010.2.713.0
    Versão do Win32: 2010.2.713.0
    Base de Código: file:///C:/Program%20Files/AUD_EFD/AUD_EFD/Sistema.exe
----------------------------------------
System.Windows.Forms
    Versão do Conjunto de Módulos (Assembly): 2.0.0.0
    Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
    Base de Código: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Versão do Conjunto de Módulos (Assembly): 2.0.0.0
    Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
    Base de Código: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Versão do Conjunto de Módulos (Assembly): 2.0.0.0
    Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
    Base de Código: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Telerik.WinControls.UI
    Versão do Conjunto de Módulos (Assembly): 2010.2.10.713
    Versão do Win32: 2010.2.10.0713
    Base de Código: file:///C:/Program%20Files/AUD_EFD/AUD_EFD/Telerik.WinControls.UI.DLL
----------------------------------------
Telerik.WinControls
    Versão do Conjunto de Módulos (Assembly): 2010.2.10.713
    Versão do Win32: 2010.2.10.0713
    Base de Código: file:///C:/Program%20Files/AUD_EFD/AUD_EFD/Telerik.WinControls.DLL
----------------------------------------
TelerikCommon
    Versão do Conjunto de Módulos (Assembly): 2010.2.10.713
    Versão do Win32: 2010.2.10.0713
    Base de Código: file:///C:/Program%20Files/AUD_EFD/AUD_EFD/TelerikCommon.DLL
----------------------------------------
System.Xml
    Versão do Conjunto de Módulos (Assembly): 2.0.0.0
    Versão do Win32: 2.0.50727.3074 (QFE.050727-3000)
    Base de Código: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
    Versão do Conjunto de Módulos (Assembly): 2.0.0.0
    Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
    Base de Código: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
ptauwmit
    Versão do Conjunto de Módulos (Assembly): 2010.2.10.713
    Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
    Base de Código: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms.resources
    Versão do Conjunto de Módulos (Assembly): 2.0.0.0
    Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
    Base de Código: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_pt-BR_b77a5c561934e089/System.Windows.Forms.resources.dll
----------------------------------------
System.Data
    Versão do Conjunto de Módulos (Assembly): 2.0.0.0
    Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
    Base de Código: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
    Versão do Conjunto de Módulos (Assembly): 2.0.0.0
    Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
    Base de Código: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
    Versão do Conjunto de Módulos (Assembly): 2.0.0.0
    Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
    Base de Código: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
ExportExcel
    Versão do Conjunto de Módulos (Assembly): 1.0.0.0
    Versão do Win32: 1.0.0.0
    Base de Código: file:///C:/Program%20Files/AUD_EFD/AUD_EFD/ExportExcel.DLL
----------------------------------------
System.Data.resources
    Versão do Conjunto de Módulos (Assembly): 2.0.0.0
    Versão do Win32: 2.0.50727.3053 (netfxsp.050727-3000)
    Base de Código: file:///C:/Windows/assembly/GAC_MSIL/System.Data.resources/2.0.0.0_pt-BR_b77a5c561934e089/System.Data.resources.dll
----------------------------------------

************** JIT Debugging **************
To enable debugging just-in-time (JIT), the. config this
application or computer (machine.config) must have the value
jitDebugging defined in section system.windows.forms.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
     <system.windows.forms jitDebugging="true" />
</ configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

 

1 Answer, 1 is accepted

Sort by
0
Richard Slade
Top achievements
Rank 2
answered on 28 Mar 2011, 02:27 PM
Hello,

The error that you have posted is not related to Telerik. It looks as though you need to refactor the amount of data you are exporting and perhaps increase the command/connection tmeout properties of your SQL Connection /SQL Command Objects.

Regards,
Richard
Tags
General Discussions
Asked by
Hugo Nickerson
Top achievements
Rank 1
Answers by
Richard Slade
Top achievements
Rank 2
Share this question
or