Aricie
The DNN Expert for your web project
DNN Community Forums

Changing titles: Cannot insert duplicate key in object 'dbo.FupUrlMapping'.

Sort:
You are not authorized to post a reply.
Author
Messages


rsiera











New Member



Posts:




New Member



    Hi,

    When changing titles via DNN Article the following errors happen:

    Logging in on the websites was not possible.

    Restart of SQL server made everythign working again.

    This is a big issue.

    InnerException: Following Query raised an exception: Query: INSERT INTO [dbo].[FupUrlMapping] ([FriendlyUrl], [RealUrl], [CreatedDate]) VALUES (@FriendlyUrl, @RealUrl, @CreatedDate) Parameter: @FriendlyUrl : String. Length: 255. Precision: 0. Scale: 0. Direction: Input. Value: "http://www.jongerengids.be/large/admin/artikel-admin/article-edit/dnnarticle/ItemID/124/rtab/176.aspx". Parameter: @RealUrl : String. Length: 255. Precision: 0. Scale: 0. Direction: Input. Value: "http://www.jongerengids.be/large/Default.aspx?tabid=181&ItemID=124&moduleid=481&rtab=176". Parameter: @CreatedDate : DateTime. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 27/05/2011 13:49:06.
    FileName:
    FileLineNumber: 0
    FileColumnNumber: 0
    Method: System.Data.SqlClient.SqlConnection.OnError
    StackTrace:
    Message: System.ApplicationException: Following Query raised an exception: Query: INSERT INTO [dbo].[FupUrlMapping] ([FriendlyUrl], [RealUrl], [CreatedDate]) VALUES (@FriendlyUrl, @RealUrl, @CreatedDate) Parameter: @FriendlyUrl : String. Length: 255. Precision: 0. Scale: 0. Direction: Input. Value: "http://www.jongerengids.be/large/admin/artikel-admin/article-edit/dnnarticle/ItemID/124/rtab/176.aspx". Parameter: @RealUrl : String. Length: 255. Precision: 0. Scale: 0. Direction: Input. Value: "http://www.jongerengids.be/large/Default.aspx?tabid=181&ItemID=124&moduleid=481&rtab=176". Parameter: @CreatedDate : DateTime. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 27/05/2011 13:49:06. ---> SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException: An exception was caught during the execution of an action query: Violation of PRIMARY KEY constraint 'PK_FUPURLMAPPING'. Cannot insert duplicate key in object 'dbo.FupUrlMapping'. The statement has been terminated.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_FUPURLMAPPING'. Cannot insert duplicate key in object 'dbo.FupUrlMapping'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute() --- End of inner exception stack trace --- at SD.LLBLGen.Pro.ORMSupportClasses.UnitOfWork2.Commit(IDataAccessAdapter adapterToUse, Boolean autoCommit) at Aricie.DNN.Services.Url.FriendlyUrl.Data.FupPersistenceJob.Commit(DataAccessAdapterBase objAdapter) at Aricie.DNN.Services.Url.FriendlyUrl.Data.DataProvider.CommitToDB() --- End of inner exception stack trace ---

    InnerException: Object reference not set to an instance of an object.
    FileName:
    FileLineNumber: 0
    FileColumnNumber: 0
    Method: System.Data.SqlClient.SqlInternalConnectionTds.get_IsLockedForBulkCopy
    StackTrace:
    Message: System.NullReferenceException: Object reference not set to an instance of an object. at System.Data.SqlClient.SqlInternalConnectionTds.get_IsLockedForBulkCopy() at System.Data.SqlClient.SqlInternalTransaction.Rollback() at System.Data.SqlClient.SqlTransaction.Rollback() at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.Rollback() at SD.LLBLGen.Pro.ORMSupportClasses.UnitOfWork2.Commit(IDataAccessAdapter adapterToUse, Boolean autoCommit) at Aricie.DNN.Services.Url.FriendlyUrl.Data.FupPersistenceJob.Commit(DataAccessAdapterBase objAdapter) at Aricie.DNN.Services.Url.FriendlyUrl.Data.DataProvider.CommitToDB()

     

     

     



    Deleted User











    New Member



    Posts:




    New Member



      Hi,

      We are looking about your issue. You'll get a feedback ASAP.

      Best regards,



      Deleted User











      New Member



      Posts:




      New Member



        Hi,

        We're working on a new version of Aricie.FriendlierUrlProvider. We should release it during this week.

        Best regards,



        Deleted User











        New Member



        Posts:




        New Member



          Hi,

          the new version of Aricie.FriendlierUrlProvider has been released on our website. You can find it in the download section.

          Best Regards,

          You are not authorized to post a reply.