I'm not given to long explanations, I'll cut right to the chase:
In order to replace the missing stored procedures, navigate to
C:Program Files (x86)\Microsoft Dynamics\eConnect 14.0\Custom Procedures\Requester
Run every stored procedure in this folder, it will replace all the missing lines in eConnect_out_setup.
Then, run this code:
set nocount on
declare @NAME varchar(100)
declare @TEXT varchar(8000)
declare @a int
declare @t varchar(1)
declare taCreateRequesterProcs insensitive cursor for
select DOCTYPE
from eConnect_Out_Setup (nolock)
where MAIN = 1
and DOCTYPE not like '%GetList'
open taCreateRequesterProcs
while 1 = 1
begin
fetch next from taCreateRequesterProcs into @NAME
if @@fetch_status <> 0 begin
break
end
set @a = 0
while @a < 3 begin
set @t = @a
select @TEXT = 'if exists (select 1 from information_schema.routines where routine_name = ' + quotename('tarequester' + @name + @t,char(39)) + ' ) drop procedure taRequester' + @NAME + @t
print @text
exec (@TEXT)
--this is the money line. This sproc will create the 'taRequester' procs that we're missing
select @TEXT = 'exec eConnectOutCreate '+ @NAME + ', ' + @t
print @text
exec (@TEXT)
set @a = @a + 1
end
end
close taCreateRequesterProcs
deallocate taCreateRequesterProcs
As a side note, when I started my demo db had 332 taRequester procs and when the code above finished I had 475. Not all the lines in eConnect_out_setup had three taRequester procs. I don't know the logic there... so I created them all. Didn't seem to hurt.