Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

telerik -- supercharge your DNN websites
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
WebHostForAsp.net
 


  Sponsors  

Meet Our Sponsors

eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Repository Modu...  03.01.14.17762 upgrade error
Previous Previous
 
Next Next
New Post 7/4/2008 8:09 AM
User is offline ROBAX
1848 posts
5th Ranked


03.01.14.17762 upgrade error 
Modified By ROBAX  on 7/4/2008 8:48:38 PM)

 

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

 
New Post 7/4/2008 5:57 PM
User is offline ROBAX
1848 posts
5th Ranked


Re: 03.01.14.17762 upgrade error 

Ok, I got it sorted. the host-supplied SQL management tool did not let me delete that particular record (even though it normally does), but Ms management studio express did. The isntall went fine after that.

I'm a little suspicious about the orphaned data. I don't recall ever creating a 'green' attribute... nor any attribute for that matter.

Rob

 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Repository Modu...  03.01.14.17762 upgrade error
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Icthus Technologies
Building Faith on the Internet
www.icthustech.com
Efficion Consulting
A premier DotNetNuke consulting firm providing complete DNN services including: custom module development, skinning and design, installation and integration services.
www.efficionconsulting.com
DotNetNuke Training by Engage Software
Specializing in customized training, architecture and module solutions for large scale implementations lead by DNN Core Team Member Christopher Hammond.
engagesoftware.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP