You’re offline. This is a read only version of the page.
Good day Community
Recently updated to SPk5 GP10, only upgrade my production company, did not test the upgrade. But now when creating or adding companies Fabikam data, GP10 displays an error when in the stored procedure 'Create_Requester_Procs_cursor'. Now remove the automated solution 'Clear_Companies' some companies that had registered. But I can not create new ones.
The error is as follows:
"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”
I appreciate your support and comments, greetings
*This post is locked for comments
Hello Francisco,
My client run the script but the error message persists when creating companies. He had no problem in carrying the results of the script were:
'The eConnect_Out_Setup Table has been updated for ILSA'
'The eConnect_Out_Setup Table has been updated for TWO'
Thanks in advanced
Que tal Francisco,
Mi cliente ya ejecuto el script pero persiste el mensaje de error al crear las compañias. Al parecer no tuvo problemas en la ejecucion, los resultados del script fueron:
'The eConnect_Out_Setup Table has been updated for ILSA'
'The eConnect_Out_Setup Table has been updated for TWO'
Gracias por tu ayuda y seguimiento
Hello Mr. Francisco Zurita
Make a backup of your company that generated this error and run the following script, please let us know if this fix your issue
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (