Dynamics Community Forum Thread Details

GP Hot fix upgrade

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?

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)