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!

    Unable to Edit Existing Deployment Scripts on a Project

    Scheduled Pinned Locked Moved Support
    deploymentsdeploymentproget
    2 Posts 1 Posters 8 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

      I can add pre- and post-deployment scripts to a project template, but whenever I try to modify one (e.g., change the value of one of the parameters), I get an exception. The workaround is to delete the script from the project template and re-add it with the new parameter values.

      Server Error in '/' Application.
      
      515`16`2`DeploymentSteps_CreateOrUpdateStep`48`Cannot insert the value NULL into column 'Script_Id', table 'ProGet.dbo.DeploymentSteps'; column does not allow nulls. UPDATE fails.
      
      Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
      
      Exception Details: System.Data.SqlClient.SqlException: 515`16`2`DeploymentSteps_CreateOrUpdateStep`48`Cannot insert the value NULL into column 'Script_Id', table 'ProGet.dbo.DeploymentSteps'; column does not allow nulls. UPDATE fails.
      
      Source Error: 
      
      An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
      
      Stack Trace: 
      
      
      [SqlException (0x80131904): 515`16`2`DeploymentSteps_CreateOrUpdateStep`48`Cannot insert the value NULL into column 'Script_Id', table 'ProGet.dbo.DeploymentSteps'; column does not allow nulls. UPDATE fails.]
         System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +392
         System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +815
         System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4515
         System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6738737
         System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +6741487
         System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +586
         System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +751
         System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +290
         Inedo.Data.DatabaseFactory.Inedo.Data.IDatabaseExecuter.ExecuteNonQuery(String storedProcName, DbParameter[] parameters) +268
         Inedo.ProGet.WebApplication.Pages.Projects.DeployablePackages.<>c__DisplayClasse.<CreateChildControls>b__a(Object s, EventArgs e) +480
         Inedo.Web.Controls.ButtonLinks.PostBackButtonLink.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +206
         System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804
      
      Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18446
      

      Product: ProGet
      Version: 3.1.0

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

        Thank you for the report - this will be fixed in the maintenance release coming out today (v3.1.1)

        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