Upgrading 03.01.13 to 14 gives the same sort of error as described in this thread and pasted below:
http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/54/threadid/202259/scope/posts/Default.aspx
I can get into the db and look, but how exactly can I determine which items are "orphan records"?
Thanks for any advice on this. I've restored to backup in the meantime.
| StartJob |
Start Sql execution: 03.01.14.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_grmRepositoryAttributeValues_grmRepositoryAttributes". The conflict occurred in database "wonderwebs", table "dbo.grmRepositoryAttributes", column 'ItemID'. 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.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /* =====================================================================*/ ALTER TABLE dbo.[grmRepositoryAttributeValues] ADD CONSTRAINT [FK_grmRepositoryAttributeValues_grmRepositoryAttributes] FOREIGN KEY ([AttributeID]) REFERENCES dbo.[grmRepositoryAttributes] ([ItemID]) |
Update: Following the advice in the other post referenced above, I'm looking in the db at grmRepositoryAttributeValues and there is one record present. It has ItemID=1, AttributeID=2 and ValueName=green. There is nothing in the grmRepositoryAttributes table.
There is no option to delete the record. Can someone please advise me on how to 'clean' this data as Steve has suggested in the other post?
Rob