Hi,
We are currently using gp 10.0 hotfix version 10.00.1757 and planning to upgrade to gp 2013 .After research I came to know that my gp 10.0 needs to be upgraded to any version higher than 10.00.1779 before upgrading to gp 2013.I am in the process to upgrade the service pack to 10.00.1868 and the one of the company database upgrade is failing and shows below two errors?
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 Native Client][SQL Server]Cannot find the object 'taRequesterPayables_Posted_Transaction_ApplyOp', because it does not exist or you do not have permission
I am upgrading using 'sa' access and I have all the permissions and I applied the below script
declare @dbname char(5), @statement char(1500)
declare eConnect_Out_Setup_Fix cursor for
select INTERID from DYNAMICS..SY01500 where INTERID in (select name from master..sysdatabases)
set nocount on
open eConnect_Out_Setup_Fix
fetch next from eConnect_Out_Setup_Fix into @dbname
while (@@fetch_status <> -1) begin
set @statement='
if exists (select * from ' + rtrim(@dbname) + '.dbo.sysobjects where id = object_id(''dbo.eConnect_Out_Setup'') and OBJECTPROPERTY(id,''IsUserTable'') = 1)
update ' + rtrim(@dbname) + '.dbo.eConnect_Out_Setup set DATACNT = 72 where DOCTYPE = ''ModifiedItem''
print ''The eConnect_Out_Setup table has been updated for '+ rtrim(@dbname) + ''''
exec (@statement)
fetch next from eConnect_Out_Setup_Fix into @dbname
end
deallocate eConnect_Out_Setup_Fix
set nocount off
which did not help me.
Can any one tell me how can I proceed further?
Can I downgrade directly to 10.0.1779 if so how can I do that?
