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  |  

The best choice for your web site host, email hosting, and domain registration.
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Active Modules -- Active Forums for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
 


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
1731 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
1731 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.

 


Live Visitor Tracking & Live Chat For DotNetNuke
Track your visitors in real time and add live chat for sales & support. Free Trial.
www.whoson.com
SINA101
WANT A SPECial sIte iN TAIWAN?
sina101.com
Web Development and Strategy Firm
The Risdall Interactive Agency s websites, strategies, branding, & promotion in digital space.
www.Risdall.net/

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