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.