WSUS 2 migration to WSUS 3 redfoxert[ at ]gmail.com 6/8/2007 4:55:55 AM Hello, Here we are trying to move from WSUS 2 to WSUS 3. We have installed a new server with WSUS 3 and everything is running fine. Now we are trying to migrate the Approvals from WSUS 2 to WSUS 3 by means of the Sample API and Tools kit provided by Microsoft. All Exports are fine, importing Computer Groups, Configuration and Computers is working fine as well but as soon as we try to import the Approvals, something goes wrong. The tool aborts with an error : This is the error in the end: WsusMigration failed with the below exception! System.InvalidOperationException: Deleting this type of Deployment is not allowed. ---> System.Data.SqlClient.SqlException: Deleting this type of Deployment is not allowed. at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnectio­ ns(SqlException e) at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteCommandNoResult­ () at Microsoft.UpdateServices.Internal.NoResultSPHandler.ExecuteStoredProcedure(­ DBConnection connection) at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler, Int32 queryTimeoutInSeconds) at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler) at Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPNoResult(String spName, DBParameterCollection args) at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPD­ eleteDeployment(Guid id) --- End of inner exception stack trace --- at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPD­ eleteDeployment(Guid id) at Microsoft.UpdateServices.Internal.BaseApi.UpdateApproval.Delete() at Microsoft.WsusMigrationTools.ImportServerStatus.ProcessEndElement(XmlTextRe­ ader reader) at Microsoft.WsusMigrationTools.ImportServerStatus.ImportData(XmlTextReader reader) at Microsoft.WsusMigrationTools.WsusMigrationTool.Main(String[] args) Now we've tried to pin down which update this could be but we're very much at a loss here. Any directions on where to look would be greatly appreciated.

RE: WSUS 2 migration to WSUS 3 Kiv 6/8/2007 12:37:02 PM A much easier way would be to perform an in place upgrade from 2 to 3 on the old server and then export to media all the authorisations and then import them to the new server. 1 thing I would say is if you decide to do this then perform a manual update of the wsus2 database to SQL2005 Express SP1 BEFORE performing the upgrade as when I was doing testing on the in place upgrade it failed everytime until I upgraded the database first then it went through with no problems at all. Hope this helps Kiv "redfoxert[ at ]gmail.com" wrote: [Quoted Text] > Hello, > > Here we are trying to move from WSUS 2 to WSUS 3. We have installed a > new server with WSUS 3 and everything is running fine. > > Now we are trying to migrate the Approvals from WSUS 2 to WSUS 3 by > means of the Sample API and Tools kit provided by Microsoft. > > All Exports are fine, importing Computer Groups, Configuration and > Computers is working fine as well but as soon as we try to import the > Approvals, something goes wrong. > > The tool aborts with an error : > > This is the error in the end: > > > > WsusMigration failed with the below exception! > System.InvalidOperationException: Deleting this type of Deployment is > not allowed. ---> System.Data.SqlClient.SqlException: Deleting this > type of Deployment is not allowed. > at > Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnectio­ > ns(SqlException > e) > at > Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteCommandNoResult­ > () > at > Microsoft.UpdateServices.Internal.NoResultSPHandler.ExecuteStoredProcedure(­ > DBConnection > connection) > at > Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String > spName, DBParameterCollection args, IExecuteSPHandler handler, Int32 > queryTimeoutInSeconds) > at > Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String > spName, DBParameterCollection args, IExecuteSPHandler handler) > at > Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPNoResult(String > spName, DBParameterCollection args) > at > Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPD­ > eleteDeployment(Guid > id) > --- End of inner exception stack trace --- > at > Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPD­ > eleteDeployment(Guid > id) > at > Microsoft.UpdateServices.Internal.BaseApi.UpdateApproval.Delete() > at > Microsoft.WsusMigrationTools.ImportServerStatus.ProcessEndElement(XmlTextRe­ > ader > reader) > at > Microsoft.WsusMigrationTools.ImportServerStatus.ImportData(XmlTextReader > reader) > at Microsoft.WsusMigrationTools.WsusMigrationTool.Main(String[] > args) > > > Now we've tried to pin down which update this could be but we're very > much at a loss here. Any directions on where to look would be greatly > appreciated. > >

Re: WSUS 2 migration to WSUS 3 "Lawrence Garvin \(MVP\)" <onsitech[ at ]community.nospam> 6/8/2007 10:42:38 PM <redfoxert[ at ]gmail.com> wrote in message news:1181278555.988607.58560[ at ]i13g2000prf.googlegroups.com... Here we are trying to move from WSUS 2 to WSUS 3. We have installed a new server with WSUS 3 and everything is running fine. Now we are trying to migrate the Approvals from WSUS 2 to WSUS 3 by means of the Sample API and Tools kit provided by Microsoft. All Exports are fine, importing Computer Groups, Configuration and Computers is working fine as well but as soon as we try to import the Approvals, something goes wrong. Imagine that... an unsupported tool, written expressly for WSUS v2, doesn't seem to work when executed against a WSUS v3 database. :-) The *best* solution to this desired objective, in my opinion is to: [a] Backup the existing WSUS2 server. [b] Install WSUS 2.0 on the new server. [c] Restore the backup to the new server. [d] Upgrade in-place on the new server from WSUS 2 to WSUS 3. No "migration" of approvals needed. It's certainly a =simpler= solution! -- Lawrence Garvin, M.S., MCTS, MCP Independent WSUS Evangelist MVP-Software Distribution (2005-2007) https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E Everything you need for WSUS is at http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx And, almost everything else is at http://wsusinfo.onsitechsolutions.com .....

Re: WSUS 2 migration to WSUS 3 redfoxert <redfoxert[ at ]gmail.com> 6/9/2007 2:27:23 PM On 9 jun, 00:42, "Lawrence Garvin \(MVP\)" <onsit...[ at ]community.nospam> wrote: [Quoted Text] > <redfox...[ at ]gmail.com> wrote in message > > news:1181278555.988607.58560[ at ]i13g2000prf.googlegroups.com... > > Here we are trying to move from WSUS 2 to WSUS 3. We have installed a > new server with WSUS 3 and everything is running fine. > > Now we are trying to migrate the Approvals from WSUS 2 to WSUS 3 by > means of the Sample API and Tools kit provided by Microsoft. > > All Exports are fine, importing Computer Groups, Configuration and > Computers is working fine as well but as soon as we try to import the > Approvals, something goes wrong. > > Imagine that... an unsupported tool, written expressly for WSUS v2, > doesn't seem to work when executed against a WSUS v3 database. :-) > > The *best* solution to this desired objective, in my opinion is to: > [a] Backup the existing WSUS2 server. > [b] Install WSUS 2.0 on the new server. > [c] Restore the backup to the new server. > [d] Upgrade in-place on the new server from WSUS 2 to WSUS 3. > > No "migration" of approvals needed. > > It's certainly a =simpler= solution! > > -- > Lawrence Garvin, M.S., MCTS, MCP > Independent WSUS Evangelist > MVP-Software Distribution (2005-2007)https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D09... > > Everything you need for WSUS is athttp://technet2.microsoft.com/windowsserver/en/technologies/featured/... > > And, almost everything else is athttp://wsusinfo.onsitechsolutions.com > .... Funny ... cause in http://groups.google.nl/group/microsoft.public.windows.server.update_services/browse_thread/thread/97d75bf52788a292/4fd9e157855cf279?lnk=gst&q=WSUS2&rnum=10&hl=nl#4fd9e157855cf279 the Microsoft poster actually says they support importing Approvals from WSUS2 to WSUS3 ... And the tool is listed in the WSUS3 downloads, so .... would it be wrong to assume the tool would also work on WSUS3 ? Apparently it is .... I'm gonna try with your suggestions tho, might actually be easier indeed.