Great Plains Dynamics 2011 year end update… error!

Posted on December 22, 2011 by Andrew Denner

Train Wreck, Steam Locomotives

This week we ran the GP updates for the end of year that also happened to have SP 5 included in the roll-up. The install finished successfully, however after running the GP Utilities we came up with the following errors when upgrading our company. The solution was that the CRM integrator was still running and needed to be forced to quit.  After that all the problems went away!
The following SQL statement produced an error:
set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedCustomerKey1′
The following SQL statement produced an error:
set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedPriceLevelKey1′ in the database.
The following SQL statement produced an error:
set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedSalespersonKey1′ in the database.
The following SQL statement produced an error:
set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSCustomer1′ in the database.
The following SQL statement produced an error:
set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSPriceLevel1′ in the database.
The following SQL statement produced an error:
set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSSalesperson1′ in the database.
Upgrade of database: SG failed! Microsoft Dynamics GP Utilities will now shutdown.

The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedCustomerKey1′
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedPriceLevelKey1′ in the database.
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedSalespersonKey1′ in the database.
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSCustomer1′ in the database.
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSPriceLevel1′ in the database.
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSSalesperson1′ in the database.
Upgrade of database: NN failed! Microsoft Dynamics GP Utilities will now shutdown.

About Andrew Denner

Andrew is the owner of Denner Consulting LLC, a web design and computer consulting company. In his spare time he enjoys writing here, spending time with his new wife at their home in Polk City and tinkering with various computer things.
This entry was posted in tech. Bookmark the permalink.

Comments are closed.