WSUS delete statement

-

hi all,

i running wsus 3.0 sp2 server on windows storage server 2003 sp2 64bit, database housed on sql 2005 standard sp3.
one of pc's reporting wsus server has been decommisioned , need delete console, receive following error in application log, sql server , running serving couple of other applications / databases. please advise.

verify sql server running on wsus server. if problem persists, try restarting sql.

 

system.data.sqlclient.sqlexception -- delete statement conflicted reference constraint "fk__tbexpande__targe__7fb5f314". conflict occurred in database "susdb", table "dbo.tbexpandedtargetintargetgroup", column 'targetid'.

the statement has been terminated.

source

.net sqlclient data provider

stack trace:

at microsoft.updateservices.ui.snapin.dialogs.progressdialog.oncompleted(object sender, asynccompletedeventargs e)



thanks lawrence, added computer original group again , deleting worked time.

actually, might have found , remediated actual issue @ point. if computer not removed group assignment in database originally, , left record behind in table showing group membership still existed, , delete operation did not attempt remove group membership, result in foreign key constraint violation of type saw.

placing computer in group re-validated orphaned record , allowed delete occur.

either way, though, -yes- bug. either group removal failed, or request delete computer should not getting trapped fk constraint.
lawrence garvin, m.s., mcitp:ea, mcdba
principal/cto, onsite technology solutions, houston, texas
microsoft mvp - software distribution (2005-2009)
mvp profile: http://mvp.support.microsoft.com/profile/lawrence.garvin
blog: http://onsitechsolutions.spaces.live.com


Windows Server  >  WSUS



Comments

Post a Comment

Popular posts from this blog

Motherboard replacement

-
running windows 10 technical preview, need replace motherboard can run the  sysprep  command restoring pc ? or there easier  or more preferred way ? thanks if replace motherboard within same family of chipsets (i.e. intel > intel or amd > amd), should okay restarting pc twice. carey frisch Windows 10 Insider Preview  >  Windows 10 Insider Preview General
Read more

Cannot create Full Text Search catalog after upgrading to V12 - Database is not fully started up or it is not in an ONLINE state

-
in order access new full text search capiblities of sql azure, upgraded our azure sql v12. (a day later), when try create new catalog: create fulltext catalog mycatalog default i following message: msg 9972, level 16, state 100, line 1 database not started or not in online state. try full-text ddl command again after database started , becomes online. hi scott, apologies inconvenience caused you. known issue on service side , fix going included in next update. specific case mitigated, should able use full-text search syntax now. thanks, mihaela Microsoft Azure  >  Azure SQL Database
Read more

Remote Desktop App - Error 0x207 or 0x607

-
hi all, i manage windows 2012 r2 network, including connection broker, session hosts , remote apps virtual servers.  i've used remote desktop app on own android phone, no issues @ - connects published gateway url , can login , access network. we looking move business onto nokia handsets ms operating system (currently on blackberry), not able connect via remote desktop app on nokia lumia handset. setup, per android config , brings remote apps , remote desktop screen, know can connect.  when select remote desktop, shows following process: initiating remote connection securing remote connection certificate can't verified - choose connect it digitally signed cert (digicert sha2), pc name different physical connection broker name (inherited domain name old gov project - can't publish publicly) initiating establishing securing connection error have been 0x207 getting 0x607 a bit baffled, work on android (and ipad @ home using app). assume ms use d...
Read more