Hi Everyone,
Has anyone heard about any issue during the company upgrade process with the not too famous error message "The stored procedure SynchronizeTableData() of form duSQLAccountSynch : 27 Pass Through SQL returned the following results: DBMS:50000, MS Dynamics GP: 0"
It seems to affect the GP dictionnary 0 and arise on the table APR_DIA40200... which doesn't exist. However there is a table APR_DIA40200_T that seems to be a TEMP Table just created by the upgrade process... Enabling the SQL DEX log in the DEX.ini reveals some other interesting details :
/* Date: 07/09/2012 Time: 13:34:28
stmt(22752888):*/
/*Begin_APR_DIA40200_T*/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[APR_DIA40200_T]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[APR_DIA40200_T]
CREATE TABLE [dbo].[APR_DIA40200_T](
[SRCECODE] [char](7) NOT NULL,
[SRCDSCR] [char](51) NOT NULL,
[DEX_ROW_ID] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PKAPR_DIA40200_T] PRIMARY KEY NONCLUSTERED
(
[SRCECODE]
) ON [PRIMARY]
) ON [PRIMARY]
setuser
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[dbo].[APR_DIA40200_T].[SRCECODE]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[dbo].[APR_DIA40200_T].[SRCDSCR]'
setuser
GRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[APR_DIA40200_T] TO [DYNGRP]
/*End_APR_DIA40200_T*/
Furthermore, when the script tries to read some data input from a temp file, it fails to insert into the APR_DIA40200 table that does not exist in my case...
/* Date: 07/09/2012 Time: 13:34:28
SQLSTATE:(00000) Native Err:(15511) status(0):*/
SWSTATUS DUMP*/
/* Date: 07/09/2012 Time: 13:34:28
stmt(22752888):*/
BULK INSERT [FTW]..[APR_DIA40200_T] FROM 'C:\Program Files\Microsoft Dynamics\GP2010\DATA\Temp\APR_DIA40200.out' WITH (CODEPAGE = 'ACP', KEEPNULLS, FIELDTERMINATOR = '||', ROWTERMINATOR = '#EOR#\n')
/* Date: 07/09/2012 Time: 13:34:28
stmt(22752888):*/
exec duAN_SynchronizeTable 'APR_DIA40200','APR_DIA40200_T','D'
/*
/* Date: 07/09/2012 Time: 13:34:28
SQLSTATE:(01000) Native Err:(50000) stmt(22752888):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table specified not found*/
/*
/* Date: 07/09/2012 Time: 13:34:28
SQLSTATE:(00000) Native Err:(50000) stmt(22752888):*/
*/
Any hints ?
