Got a question for us?

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()

Hi,

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

Best regards,