Share
ReportI am doing a test upgrade of GP10 to GP2015 for a customer. The installation is being done on a new server. I backed up the GP 10 databases and restored them to SQL Server 2012 on the new server. Changed the DB compatibility level etc. per the transferring GP to a new server doc. Ran dbcc checkdb and dbcc updateusage against the databases. Upgraded from GP10 to GP2013 R2 with no problems. Backed up the databases and proceeded to start the upgrade to GP2015. During the upgrade of the DYNAMICS db in the Load Required Data section, I received the following error -
The stored procedure SynchronizeTableData() of form duSQLAccountSynch: 27Pass Through SQL returned the following results: DBMS: 2601, Microsoft Dynamics GP: 0
The table name showing above the progress bar is ASIEXP86.
I find the following in the dexsql log -
----- Start DEXSQL Log -----
/* Date: 06/17/2015 Time: 12:31:18
stmt(14532056):*/
BULK INSERT [DYNAMICS]..[ASIEXP86_T] FROM 'C:\Program Files (x86)\Microsoft Dynamics\GP2015\DATA\Temp\ASIEXP86.out' WITH (CODEPAGE = 'ACP', KEEPNULLS, FIELDTERMINATOR = '||', ROWTERMINATOR = '#EOR#\n')
/* Date: 06/17/2015 Time: 12:31:18
stmt(14532056):*/
exec duAN_SynchronizeTable 'ASIEXP86','ASIEXP86_T','D'
/*
/* Date: 06/17/2015 Time: 12:31:20
SQLSTATE:(23000) Native Err:(2601) stmt(14532056):*/
[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.ASIEXP86' with unique index 'AK2ASIEXP86'. The duplicate key value is (0, 1, 0, 0, , , */
/*
/* Date: 06/17/2015 Time: 12:31:20
SQLSTATE:(01000) Native Err:(3621) stmt(14532056):*/
[Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.*/
/*
/* Date: 06/17/2015 Time: 12:31:20
SQLSTATE:(00000) Native Err:(3621) stmt(14532056):*/
*/
/*
/* Date: 06/17/2015 Time: 12:31:20
SQLSTATE:(00000) Native Err:(3621) status(54):*/
SWSTATUS DUMP*/
/* Date: 06/17/2015 Time: 12:42:48
stmt(14532056):*/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duAN_SynchronizeTable]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN drop procedure [dbo].[duAN_SynchronizeTable] END if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duAN_GetTempAndDestColumnInfo]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN drop procedure [dbo].[duAN_GetTempAndDestColumnInfo] END if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duAN_GetAccountNumberColumnCandidates]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN drop procedure [dbo].[duAN_GetAccountNumberColumnCandidates] END if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duAN_AccountFieldValue]') and xtype in (N'FN',N'IF',N'TF')) BEGIN drop function [dbo].[duAN_AccountFieldValue] END if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duAN_AcctSegTrim]') and xtype in (N'FN',N'IF',N'TF')) BEGIN drop function [dbo].[duAN_AcctSegTrim] END if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duAN_Create_duInserts]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN drop procedure [dbo].[duAN_Create_duInserts] END if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duAN_GenerateInsertStatement]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN drop procedure [dbo].[duAN_GenerateInsertStatement] END if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duAN_Execute_duInsertStatement]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN drop procedure [dbo].[duAN_Execute_duInsertStatement] END if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duAN_GenerateInsert_1]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN drop procedure [dbo].[duAN_GenerateInsert_1] END if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duAN_GenerateInsert_2]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN drop procedure [dbo].[duAN_GenerateInsert_2] END if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duCreate_duTempPrimarKeyColumnTable]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN drop procedure [dbo].[duCreate_duTempPrimarKeyColumnTable] END if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duGetTablePrimaryKeyColumns]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN drop procedure [dbo].[duGetTablePrimaryKeyColumns] END if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duAN_GenerateJoin]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN drop procedure [dbo].[duAN_GenerateJoin] END if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[duDeleteMatchingRecords]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) BEGIN drop procedure [dbo].[duDeleteMatchingRecords] END
/* Date: 06/17/2015 Time: 12:42:51
stmt(14514584):*/
{CALL ..zDP_duLCKF_1(NULL,NULL,NULL,NULL)}
/*
/* Date: 06/17/2015 Time: 12:42:51
SQLSTATE:(37000) Native Err:(2812) stmt(14514584):*/
[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'zDP_duLCKF_1'.*/
/*
/* Date: 06/17/2015 Time: 12:42:51
SQLSTATE:(00000) Native Err:(2812) stmt(14514584):*/
*/
/*
/* Date: 06/17/2015 Time: 12:42:51
SQLSTATE:(00000) Native Err:(2812) status(58):*/
SWSTATUS DUMP*/
/* Date: 06/17/2015 Time: 12:42:51
stmt(14514584):*/
SELECT TOP 25 companyID,INTERID,duWorkstationID,DEX_ROW_ID FROM duLCK ORDER BY companyID ASC ,INTERID ASC
/*
/* Date: 06/17/2015 Time: 12:42:51
SQLSTATE:(S0002) Native Err:(208) stmt(14514584):*/
[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'duLCK'.*/
/*
/* Date: 06/17/2015 Time: 12:42:51
SQLSTATE:(00000) Native Err:(208) stmt(14514584):*/
*/
/*
/* Date: 06/17/2015 Time: 12:42:51
SQLSTATE:(00000) Native Err:(208) status(56):*/
SWSTATUS DUMP*/
/* Date: 06/17/2015 Time: 12:42:51
stmt(14514584):*/
delete from tempdb..DEX_SESSION where session_id = 7
----- End DEXSQL Log -----
Looks like it is trying to insert a duplicate record into ASIEXP86.
The customer has eight or so third party add-ons which I did not upgrading for GP2013. I will do that when I have GP2015 installed.
Any help is appreciated.
Thanks,
Bill
*This post is locked for comments
All responses (
Answers (
12,931
