ERROR AT THE TIME OF EXPORT DATA

2 posts, 0 answers
  1. Hugo Nickerson
    Hugo  Nickerson avatar
    1 posts
    Member since:
    May 2010

    Posted 28 Mar 2011 Link to this post

    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.

     

  2. Richard Slade
    Richard Slade avatar
    3000 posts
    Member since:
    May 2009

    Posted 28 Mar 2011 Link to this post

    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
  3. UI for WinForms is Visual Studio 2017 Ready
Back to Top