Inedo Community Forums Forums
    • Recent
    • Tags
    • Popular
    • Login

    Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

    If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

    Proget Error

    Scheduled Pinned Locked Moved Support
    serviceproget
    11 Posts 1 Posters 44 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • ? This user is from outside of this forum
      Guest
      last edited by

      This usually means that the connection to the SQL Server instance was lost. If SQL Server is on a different server, was that server rebooted for updates perhaps?

      1 Reply Last reply Reply Quote 0
      • ? This user is from outside of this forum
        Guest
        last edited by

        we checked the db server and server db server was online all the time.

        I checked the Windows EventLog today and found 100 and more error msg like this:

        `Event code: 3005
        Event message: An unhandled exception has occurred.
        Event time: 4/14/2014 5:22:10 PM
        Event time (UTC): 4/14/2014 3:22:10 PM
        Event ID: b4c2513f2d09490f8fea20543dc7f0d7
        Event sequence: 37
        Event occurrence: 36
        Event detail code: 0

        Application information:
        Application domain: /LM/W3SVC/2/ROOT-1-130419415313981407
        Trust level: Full
        Application Virtual Path: /
        Application Path: C:\Program Files\ProGet\WebApp\
        Machine name: TESTNGETFRA01

        Process information:
        Process ID: 5720
        Process name: w3wp.exe
        Account name: INTERN\SA_ProGet

        Exception information:
        Exception type: SqlException
        Exception message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
        at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TrySetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
        at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
        at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
        at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
        at Inedo.Data.DatabaseFactory.Inedo.Data.IDatabaseExecuter.ExecuteDataSet(String storedProcName, String[] tableNames, DbParameter[] parameters)
        at Inedo.ProGet.Data.StoredProcedures.Dashboards_GetDashboardInfo.Execute()
        at Inedo.ProGet.WebApplication.Pages.RootPage.CreateChildControls()
        at System.Web.UI.Control.EnsureChildControls()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

        The wait operation timed out

        Request information:
        Request URL: https://nuget.test-dev.net:443/
        Request path: /
        User host address: 192.168.xxx.xxx
        User: admintl
        Is authenticated: True
        Authentication Type:
        Thread account name: INTERN\SA_ProGet

        Thread information:
        Thread ID: 32
        Thread account name: INTERN\SA_ProGet
        Is impersonating: False
        Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TrySetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
        at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
        at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
        at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
        at Inedo.Data.DatabaseFactory.Inedo.Data.IDatabaseExecuter.ExecuteDataSet(String storedProcName, String[] tableNames, DbParameter[] parameters)
        at Inedo.ProGet.Data.StoredProcedures.Dashboards_GetDashboardInfo.Execute()
        at Inedo.ProGet.WebApplication.Pages.RootPage.CreateChildControls()
        at System.Web.UI.Control.EnsureChildControls()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

        Custom event details: `

        1 Reply Last reply Reply Quote 0
        • ? This user is from outside of this forum
          Guest
          last edited by

          Hi guy
          we found out that something on Proget Startpage needs more than 30sec to load.
          Pls check this and make a option to disable the

          • "Latest News from Inedo",
          • "Proget Help & Support",
          • "Local feeds" and
          • "Lastest Local Packages"´

          ProGet Loading time:
          ProGet Loading time

          1 Reply Last reply Reply Quote 0
          • ? This user is from outside of this forum
            Guest
            last edited by

            Thanks for the info. It seems that our RSS feed was returning far more data than it was supposed to, and it also is not being cached client-side as much as it is supposed to be. We've just updated inedo.com to return much less data - this should greatly reduce the loading time you see. We'll fix the caching issue in the next ProGet release.

            1 Reply Last reply Reply Quote 0
            • ? This user is from outside of this forum
              Guest
              last edited by

              Hi guys,
              we updated ProGet to version 3.0.2 and the problem with the Timeouts still there.
              pls fix it or you have any workaround for us?

              1 Reply Last reply Reply Quote 0
              • ? This user is from outside of this forum
                Guest
                last edited by

                This is slightly odd. Can you try running the query

                EXEC [Dashboards_GetDashboardInfo] 10

                against the ProGet database and see how long it takes on your installation? This query should be instant and should virtually never time out.

                There must be something else going on here. Are you certain that the connection strings to ProGet's SQL database are pointing at the database server, named instance, and database name that you believe it to be?

                1 Reply Last reply Reply Quote 0
                • ? This user is from outside of this forum
                  Guest
                  last edited by

                  Hi your statment runs 5min it is very slow.

                  We changed the stored procedures "Dashboards_GetDashboardInfo"

                  This query:

                  `SELECT *
  FROM [Packages_Extended]
 WHERE [Project_Indicator] = 'N'

                  ORDER BY [Published_Date] DESC`

                  to this:

                  `SELECT TOP 0 *
  FROM [Packages_Extended]
 WHERE [Project_Indicator] = 'N'

                  ORDER BY [Published_Date] DESC`

                  now we get now no timeouts and no errors

                  1 Reply Last reply Reply Quote 0
                  • ? This user is from outside of this forum
                    Guest
                    last edited by

                    Thank you for the analysis. Curious, how many packages do you have total across all feeds, and what sort of database server is this running on (version, hardware or VM specs)? Even though the publish date is unindexed (though it will be in the next version ;)), it seems odd that it would take 5 minutes unless there are hundreds of thousands of packages or more.

                    1 Reply Last reply Reply Quote 0
                    • ? This user is from outside of this forum
                      Guest
                      last edited by

                      We have 6328 packages in all feeds.

                      On the database server runs an windows 2008 with an MSSQL Server 2008.

                      1 Reply Last reply Reply Quote 0
                      • ? This user is from outside of this forum
                        Guest
                        last edited by

                        For completeness, v3.0.3 was just published which adds an index to Publish_Date and the dashboard query now returns virtually instantly tested against 100,000+ packages in the database.

                        1 Reply Last reply Reply Quote 0

                        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                        With your input, this post could be even better 💗

                        Register Login
                        • 1 / 1
                        • First post
                          Last post
                        Inedo Website Home • Support Home • Code of Conduct • Forums Guide • Documentation