Dynamics Community Forum Thread Details

I’m trying to apply SP 5 to Dynamics GP 10.

The client PC is: Windows 7 Pro 64bit

SQL Server 2005 version 9.0.5000

Using SQL Server 2005 Native Client ODBC (32 bit)

The current GP version is: 10.00.1276

I’m applying SP 5 to get to version: 10.00.1868 using MicrosoftDynamicsGP-KB2769061-v10-ENU.exe

Only GL, AP and Safe Pay are being used.

The update runs fine on the DYNAMICS database but fails on the COMPANY database when trying to install the SVC_MailProcessLOG stored procedure. Although immediately after the failure, I tried to install this stored procedure on the Company database (using the scrips below) and it installs fine. I receive two error messages (below). I also enabled DEXLOG and extracted the failure part of the log and pasted it below as well. Any ideas?

First Error Message:

The following SQL statement produced an error:

CREATE procedure SVC_MailProcessLOG @msg_id varchar(64) as declare @subject varchar(255) declare @status int declare @originator varchar(255) declare @cc_list varchar(255) declare @query varchar(255) declare @custname varchar(60) declare @password varchar(255) declare @CUSTOMER varchar(255) declare @PASSWORD2 varchar(255) declare @KEYWORD2 varchar(255) declare @SERIAL varchar(255) declare @DESCR varchar(255) declare @EQUIPID integer declare @CUSTREF varchar(255) declare @CALLNBR varchar(255) declare @EMAIL varchar(255) declare @CONTACTe varchar(255) declare @PHONEe varchar(20) declare @separator varchar(3) declare @dbuse varchar(30) declare @filename varchar(255) declare @filepath varchar(255) declare @TempFile varchar(255) declare @result int declare @pathSep int declare @CommandLine varchar(255) declare @contact varchar(30) declare @phone varchar(14) declare @addressid varchar(15) declare @svcdesc varchar(60) declare @noteindex int declare @date datetime declare @time datetime declare @address1 varchar(31) declare @address2 varchar(31) declare @city varchar(31) declare @statecd varchar(5) declare @zip varchar(11) declare @Err integer print 'PROCESS LOG' select @separator=CHAR(9) select @dbuse = DB_NAME() set ANSI_PADDING ON exec @status = master..xp_readmail @msg_id=@msg_id, @originator=@originator output, @cc_list=@cc_list output, @subject=@subject output, @message=@query output, @peek='true', @suppress_attach='false', @attachments=@TempFile output exec @status = SVC_Mail_parse_for_keywords @query, @CUSTOMER out, @PASSWORD2 out, @KEYWORD2 out, @SERIAL out, @DESCR out, @CUSTREF out, @EMAIL out, @CONTACTe out, @PHONEe out select @svcdesc = substring(@DESCR,1,60) select @custname=CUSTNAME, @contact=CNTCPRSN, @phone=PHONE1, @addressid=ADRSCODE, @password=USERDEF2 from RM00101 where CUSTNMBR = @CUSTOMER select @CONTACTe = isnull(@CONTACTe,@contact) select @PHONEe = isnull(@PHONEe,@phone) if @CUSTOMER is null or @custname is null begin exec SVC_SendMail @originator, 'Invalid Customer', 'The customer you entered is not valid.' return end if @password <> @PASSWORD2 or @password is null or @PASSWORD2 is null begin exec SVC_SendMail @originator, 'Invalid Password', 'The password you entered is not valid.' return end if @EMAIL is null begin exec SVC_SendMail @originator, 'Empty E-Mail Adddress', 'You MUST supply an e-mail address. Use EMAIL:xxxxx@yyyy.' return end if @SERIAL is not NULL select @date = CONVERT(char(10),GETDATE(),102) + ' 00:00:00' select @time = '01/01/1900 ' + CONVERT(char(5),GETDATE(),108) select @EQUIPID=EQUIPID from SVC00300 where SVC00300.SERLNMBR = @SERIAL and SVC00300.CUSTNMBR = @CUSTOMER exec @status = SVC_ISC_Add_Call @custnmbr=@CUSTOMER, @svcdescr = @svcdesc, @pordnmbr=@CUSTREF, @equipid=@EQUIPID, @rqstdate=@date, @rqsttime=@time, @txtfield=value, @CONTNBR = '', @callnbr=@CALLNBR out, @Serial=@SERIAL, @Err=0 select @noteindex = NOTEINDX from SVC00200 where CALLNBR = @CALLNBR and SRVRECTYPE = 2 exec SVC_UpdateTextObject @noteindex OUTPUT, @date,@time,@DESCR update SVC00200 set CNTCPRSN = @CONTACTe, PHONE1 = @PHONEe where CALLNBR = @CALLNBR and SRVRECTYPE = 2 select @subject = 'Service Call Number ' + @CALLNBR + 'Logged For ' + @custname + ' - ' + @addressid + ' : ' + @CONTACTe + ' Phone: ' + @PHONEe select @pathSep = CHARINDEX('\',REVERSE(@TempFile)) select @filepath = Reverse(SUBSTRING(REVERSE(@TempFile),@pathSep,255)) select @pathSep = CHARINDEX('.',REVERSE(@TempFile)) select @filename = Reverse(SUBSTRING(REVERSE(@TempFile),1,@pathSep)) select @CommandLine = 'ren ' + @TempFile + ' ' + RTRIM(@CALLNBR) + @filename EXEC @result = master..xp_cmdshell @CommandLine exec @status = master..xp_sendmail @recipients=@EMAIL, @copy_recipients=@cc_list, @message='A new Service Call has been logged per your request', @subject=@subject, @separator=@separator, @width=256, @no_output='false', @echo_error='true', @dbuse=@dbuse

Second Error Message

ERROR [Microsoft][SQL Native Client]TCP Provider: The specified network name is no longer available.

Here is the last part of the DEXLOG when it fails:

/* Date: 03/10/2017 Time: 22:46:47
stmt(12965632):*/
SET QUOTED_IDENTIFIER ON

/* Date: 03/10/2017 Time: 22:46:47
stmt(12965632):*/
SET ANSI_NULLS ON

/* Date: 03/10/2017 Time: 22:46:47
stmt(12965632):*/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SVC_MailProcessLOG]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SVC_MailProcessLOG]

/* Date: 03/10/2017 Time: 22:46:47
stmt(12965632):*/
CREATE procedure SVC_MailProcessLOG @msg_id varchar(64) as declare @subject varchar(255) declare @status int declare @originator varchar(255) declare @cc_list varchar(255) declare @query varchar(255) declare @custname varchar(60) declare @password varchar(255) declare @CUSTOMER varchar(255) declare @PASSWORD2 varchar(255) declare @KEYWORD2 varchar(255) declare @SERIAL varchar(255) declare @DESCR varchar(255) declare @EQUIPID integer declare @CUSTREF varchar(255) declare @CALLNBR varchar(255) declare @EMAIL varchar(255) declare @CONTACTe varchar(255) declare @PHONEe varchar(20) declare @separator varchar(3) declare @dbuse varchar(30) declare @filename varchar(255) declare @filepath varchar(255) declare @TempFile varchar(255) declare @result int declare @pathSep int declare @CommandLine varchar(255) declare @contact varchar(30) declare @phone varchar(14) declare @addressid varchar(15) declare @svcdesc varchar(60) declare @noteindex int declare @date datetime declare @time datetime declare @address1 varchar(31) declare @address2 varchar(31) declare @city varchar(31) declare @statecd varchar(5) declare @zip varchar(11) declare @Err integer print 'PROCESS LOG' select @separator=CHAR(9) select @dbuse = DB_NAME() set ANSI_PADDING ON exec @status = master..xp_readmail @msg_id=@msg_id, @originator=@originator output, @cc_list=@cc_list output, @subject=@subject output, @message=@query output, @peek='true',   @suppress_attach='false', @attachments=@TempFile output exec @status = SVC_Mail_parse_for_keywords @query,   @CUSTOMER out,   @PASSWORD2 out,   @KEYWORD2 out,   @SERIAL out,   @DESCR out,   @CUSTREF out, @EMAIL out, @CONTACTe out, @PHONEe out select @svcdesc = substring(@DESCR,1,60) select @custname=CUSTNAME,   @contact=CNTCPRSN, @phone=PHONE1, @addressid=ADRSCODE, @password=USERDEF2 from RM00101 where CUSTNMBR = @CUSTOMER select @CONTACTe = isnull(@CONTACTe,@contact) select @PHONEe = isnull(@PHONEe,@phone) if @CUSTOMER is null or @custname is null begin exec SVC_SendMail @originator, 'Invalid Customer', 'The customer you entered is not valid.' return end if @password <> @PASSWORD2 or @password is null or @PASSWORD2 is null begin exec SVC_SendMail @originator, 'Invalid Password', 'The password you entered is not valid.' return end if @EMAIL is null begin exec SVC_SendMail @originator, 'Empty E-Mail Adddress', 'You MUST supply an e-mail address. Use EMAIL:xxxxx@yyyy.' return end if @SERIAL is not NULL select @date = CONVERT(char(10),GETDATE(),102) + ' 00:00:00' select @time = '01/01/1900 ' + CONVERT(char(5),GETDATE(),108) select @EQUIPID=EQUIPID   from SVC00300   where SVC00300.SERLNMBR = @SERIAL and SVC00300.CUSTNMBR = @CUSTOMER exec @status = SVC_ISC_Add_Call   @custnmbr=@CUSTOMER, @svcdescr = @svcdesc, @pordnmbr=@CUSTREF, @equipid=@EQUIPID, @rqstdate=@date, @rqsttime=@time, @txtfield=value, @CONTNBR = '', @callnbr=@CALLNBR out, @Serial=@SERIAL, @Err=0   select @noteindex = NOTEINDX from SVC00200 where CALLNBR = @CALLNBR and SRVRECTYPE = 2 exec SVC_UpdateTextObject @noteindex OUTPUT, @date,@time,@DESCR update SVC00200 set CNTCPRSN = @CONTACTe, PHONE1 = @PHONEe where CALLNBR = @CALLNBR and SRVRECTYPE = 2 select @subject = 'Service Call Number ' + @CALLNBR + 'Logged For ' + @custname + ' - ' + @addressid + ' : ' + @CONTACTe + ' Phone: ' + @PHONEe select @pathSep = CHARINDEX('\',REVERSE(@TempFile)) select @filepath = Reverse(SUBSTRING(REVERSE(@TempFile),@pathSep,255)) select @pathSep = CHARINDEX('.',REVERSE(@TempFile)) select @filename = Reverse(SUBSTRING(REVERSE(@TempFile),1,@pathSep)) select @CommandLine = 'ren ' + @TempFile + ' ' + RTRIM(@CALLNBR) + @filename EXEC @result = master..xp_cmdshell @CommandLine exec @status = master..xp_sendmail @recipients=@EMAIL, @copy_recipients=@cc_list, @message='A new Service Call has been logged per your request', @subject=@subject, @separator=@separator, @width=256, @no_output='false', @echo_error='true', @dbuse=@dbuse
/*
/* Date: 03/10/2017 Time: 22:47:07
SQLSTATE:(08S01) Native Err:(64) stmt(12965632):*/
[Microsoft][SQL Native Client]TCP Provider: The specified network name is no longer available.
*/
/*
/* Date: 03/10/2017 Time: 22:47:07
SQLSTATE:(08S01) Native Err:(64) stmt(12965632):*/
[Microsoft][SQL Native Client]Communication link failure*/
/*
/* Date: 03/10/2017 Time: 22:47:07
SQLSTATE:(00000) Native Err:(64) stmt(12965632):*/
*/
/*
/* Date: 03/10/2017 Time: 22:47:07
SQLSTATE:(00000) Native Err:(64) status(12):*/
SWSTATUS DUMP*/

/* Date: 03/10/2017 Time: 22:48:25
stmt(84130976):*/
{CALL DYNAMICS.dbo.zDP_SY02100F_1(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)}

/* Date: 03/10/2017 Time: 22:48:25
stmt(84130976):*/
{ CALL DYNAMICS.dbo.zDP_SY02100SS_1 ( 0, 0, 7, 0 ) }

/* Date: 03/10/2017 Time: 22:48:25
stmt(84130976):*/
{ CALL DYNAMICS.dbo.zDP_SY02100SS_1 ( 0, 0, 9, 0 ) }

/* Date: 03/10/2017 Time: 22:48:25
stmt(84130976):*/
{ CALL DYNAMICS.dbo.zDP_SY02100SS_1 ( 0, 0, 11, 0 ) }

/* Date: 03/10/2017 Time: 22:48:25
stmt(84130976):*/
{ CALL DYNAMICS.dbo.zDP_SY02100SS_1 ( 0, 0, 1000, 0 ) }

/* Date: 03/10/2017 Time: 22:48:25
stmt(84130976):*/
{ CALL DYNAMICS.dbo.zDP_SY02100SS_1 ( 0, 0, 15, 0 ) }

/* Date: 03/10/2017 Time: 22:48:25
stmt(84130976):*/
{CALL DYNAMICS.dbo.zDP_SY02100N_1(25,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)}
/*
/* Date: 03/10/2017 Time: 22:48:25
SQLSTATE:(08S01) Native Err:(0) stmt(12965632):*/
[Microsoft][SQL Native Client]Communication link failure*/
/*
/* Date: 03/10/2017 Time: 22:48:25
SQLSTATE:(00000) Native Err:(0) stmt(12965632):*/
*/
/*
/* Date: 03/10/2017 Time: 22:48:25
SQLSTATE:(00000) Native Err:(0) status(12):*/
SWSTATUS DUMP*/

/* Date: 03/10/2017 Time: 22:48:25
stmt(84133400):*/
{ CALL DYNAMICS.dbo.zDP_SY01700SS_1 ( 0, 36058 ) }

/* Date: 03/10/2017 Time: 22:48:25
stmt(84133400):*/
{ CALL DYNAMICS.dbo.zDP_SY01700SS_1 ( 0, 36058 ) }
/*
/* Date: 03/10/2017 Time: 22:48:25
SQLSTATE:(01000) Native Err:(5701) stmt(0):*/
[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.*/
/*
/* Date: 03/10/2017 Time: 22:48:25
SQLSTATE:(01000) Native Err:(5703) stmt(0):*/
[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.*/
/*
/* Date: 03/10/2017 Time: 22:48:25
SQLSTATE:(00000) Native Err:(5703) stmt(0):*/
*/
/*
/* Date: 03/10/2017 Time: 22:48:25
SQLSTATE:(00000) Native Err:(5703) status(0):*/
SWSTATUS DUMP*/

/* Date: 03/10/2017 Time: 22:48:25
stmt(84130168):*/
BEGIN SET DATEFORMAT ymd
SET NOCOUNT ON
SET CURSOR_CLOSE_ON_COMMIT OFF
SET ANSI_NULLS OFF
SET ANSI_WARNINGS OFF
SET ANSI_NULL_DFLT_ON ON
SET ANSI_PADDING OFF
SET NUMERIC_ROUNDABORT OFF
END

/* Date: 03/10/2017 Time: 22:48:25
stmt(84132592):*/
sp_helpsrvrolemember sysadmin

/* Date: 03/10/2017 Time: 23:03:35
stmt(84130976):*/
{CALL DYNAMICS.dbo.zDP_duLCKF_1(NULL,NULL,NULL,NULL)}
/*
/* Date: 03/10/2017 Time: 23:03:35
SQLSTATE:(37000) Native Err:(2812) stmt(84130976):*/
[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'DYNAMICS.dbo.zDP_duLCKF_1'.*/
/*
/* Date: 03/10/2017 Time: 23:03:35
SQLSTATE:(00000) Native Err:(2812) stmt(84130976):*/
*/
/*
/* Date: 03/10/2017 Time: 23:03:35
SQLSTATE:(00000) Native Err:(2812) status(58):*/
SWSTATUS DUMP*/

/* Date: 03/10/2017 Time: 23:03:35
stmt(84130976):*/
SELECT TOP 25 companyID,INTERID,duWorkstationID,DEX_ROW_ID FROM DYNAMICS.dbo.duLCK ORDER BY companyID ASC ,INTERID ASC

/* Date: 03/10/2017 Time: 23:03:35
stmt(84132592):*/
delete from tempdb..DEX_SESSION where session_id = 1

Community site session details

GP 10 SP 5 Erro The following SQL statement produced an error:

Helpful resources

News and Announcements

Quick Links

Jainam Kothari – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates