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 create chocolatey connectors



  • When trying to create a connector for a chocolatey feed, when saving the system outputs an ASP.NET error page with the following information:
    Exception Details: System.Data.SqlClient.SqlException: 547´16´0´Connectors_CreateOrUpdateConnector´39´The INSERT statement conflicted with the CHECK constraint "CK__Connectors__FeedType". The conflict occurred in database "ProGet", table "dbo.Connectors", column 'FeedType_Name'.

    [SqlException (0x80131904): 547´16´0´Connectors_CreateOrUpdateConnector´39´The INSERT statement conflicted with the CHECK constraint "CK__Connectors__FeedType". The conflict occurred in database "ProGet", table "dbo.Connectors", column 'FeedType_Name'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action´1 wrapCloseInAction) +388 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +752 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4493 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +117 System.Data.SqlClient.SqlDataReader.get_MetaData() +126 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +522 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +3101 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource´1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +536 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +104 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +267 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +167 Inedo.Data.DatabaseContext.ExecuteInternal(String storedProcName, GenericDbParameter[] parameters) +206 Inedo.Data.DatabaseContext.ExecuteNonQuery(String storedProcName, GenericDbParameter[] parameters) +36 Inedo.ProGet.Data.Context.Connectors_CreateOrUpdateConnector(String FeedType_Name, String Connector_Name, String Connector_Url, String Filter_Csv, String User_Name, Byte[] Password_Bytes, Nullable´1 Timeout_Period, Nullable´1 Connector_Id) +750 Inedo.ProGet.WebApplication.Pages.Connectors.<>c__DisplayClass13_0.<CreateChildControls>b__1(Object s, EventArgs e) +746 Inedo.Web.PageFree.<>c__DisplayClass58_1.<ProcessPostBack>b__1(ControlCollection col) +166 Inedo.Web.PageFree.<>c__DisplayClass58_1.<ProcessPostBack>b__1(ControlCollection col) +193 Inedo.Web.PageFree.SimplePageBase.ProcessRequest(HttpContext context) +246 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +712 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +169

    Product: ProGet
    Version: 4.0.5



  • This has since been resolved in v4.0.7.



  • Thanks!! Works like a charm



Inedo Website HomeSupport HomeCode of ConductForums GuideDocumentation