After restoring dynamics GP 10 db to Dynamics GP 2013 we are getting message the version of dynamics gp on the client does not match the version of dynamics gp on the sql server (GP 2013),Also when we are trying to login GP with 'sa' after restoring Database we are getting message "A get/change first operation on table 'SY_Users_MSTR' failed accessing sql data"
More Info : Number of results columns doesnt match table definition.
*This post is locked for comments
Richard
After successfully migrating dynamics and all companies to GP 2013 we are now in process of configuring the management report to migrate FRx reports. We are facing following issue in installing Data mart for GP . Can you provide your feedback here. I am logged in with domain user having local adming rights on server and running MR configuration console with this account .
3/11/2013 3:26:16 AM - Creating Windows user...
3/11/2013 3:26:16 AM - Assigning role...
3/11/2013 3:26:16 AM - Update complete.
3/11/2013 3:26:16 AM - Application service URI is http://XXX:4712/
3/11/2013 3:26:18 AM - Configuring Dynamics GP adapter with settings: Server: xxx\xxx_DYNAMICS_GP, Database: DYNAMICS, User name: sa
3/11/2013 3:26:18 AM - Configuring data mart adapter with settings: Server: xxx\xxx_DYNAMICS_GP, Database: DDM, User name: sa, Windows auth: False, Encrypt connection: False
3/11/2013 3:26:20 AM - System.ServiceModel.FaultException`1[Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.Connector.UnexpectedServiceError]: A service error has occurred. Please check your server error logs for details. (Fault Detail is equal to Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.Connector.UnexpectedServiceError).
3/11/2013 3:26:20 AM - Rolling back data mart database creation due to installation error. Connection information:
Create new database: True
Server name:xxx\xxx_DYNAMICS_GP
Database name: DDM
Integrated authentication: False
User name: sa
Encrypted connection: False
3/11/2013 3:26:20 AM - The data mart database was rolled back successfully.
3/11/2013 3:26:26 AM - System.ServiceModel.FaultException`1[Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.Connector.UnexpectedServiceError]: A service error has occurred. Please check your server error logs for details. (Fault Detail is equal to Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.Connector.UnexpectedServiceError).
Thank you Richard . We have resolved the issue for dynamics and one company by executing DBCC check DB and DBCC UPDATEUSAGE scritps. We are now upgrading all companies.
Try following the procedures outlined here. Apparently someone had a similar problems back in 2010 and posted what they tried to get beyond this. I would start by chaning the dex.ini line to synchronize=TRUE and try the upgrade again.
Richard
We have successfully upgraded the GP 10 to 10.0.1868 by following the recommended procedure. We have also moved the backups of upgrades db of Dynamics and all companies to GP 2013 server and restored them completely . Now ,when we are running GP utilities to upgrade databases , dynamics databases has been upgraded successfully at GP 2013 but during upgrading of company databases it is giving following error message .
Unhandled script exception:
Illegal address for field 'Account Number' in script 'initCompany'. Script terminated.
EXCEPTION_CLASS_SCRIPT_BAD_TYPE
SCRIPT_CMD_COMPONENT
That's exactly we are thinking to do i.e. create test environment and upgrade GP 10 to 10.00.1779 with sql 2008 and then use that upgraded version for migration on GP 2013. I will get back you after performing all this. Hopefully it will work.
Again, Thank you so much for your guidance.
No. Can you create a test environment for GP 10 and SQL 2008? You could copy your data to that image and upgrade GP to 10.00.1779 and then upgrade that copy to GP 2013. Otherwise, a GP 10 upgrade in production should not be that much of an effort for a small number of worksations and the server. If your server is a virtual server, you could back it up first and then apply GP 10.00.1779. If it works just continue, if not just restore the image.
OK .so we need to upgrade GP to 10.00.1779 first and then execute KB878449 steps from scratch ? do we have any other way to avoid change anything on GP 10 production ?
GP 10 has to be at least 10.00.1779 you said your GP 10 is 10.0.1061.
Richard
We have used the KB878449 to restore databases , we have now restored all the db of GP 10 along with dynamics db and ran all the mentioned required scripts in KB878449 document. For your reference i have pasted here log which we are getting while trying to update db using GP utilities.
exec duAN_SynchronizeTable 'DU000010','DU000010_T','D'
/* Date: 02/14/2013 Time: 7:19:32
stmt(8310608):*/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DU000010_T]') and OBJECTPROPERTY(id,N'IsUserTable') = 1) BEGIN drop table [dbo].[DU000010_T] END
/* Date: 02/14/2013 Time: 7:19:32
stmt(8310608):*/
/*Begin_HROD_T*/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[HROD_T]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[HROD_T]
CREATE TABLE [dbo].[HROD_T] (
[DEFAULTNUMBER_I] [smallint] NOT NULL ,
[TERMITEM_I] [char] (51) NOT NULL ,
[TERMATTRIBUTE_I] [smallint] NOT NULL ,
[TERMORDER_I] [smallint] NOT NULL ,
[ADDTODEFAULTITEMS_I] [tinyint] NOT NULL ,
[DEX_ROW_ID] [int] IDENTITY (1, 1) NOT NULL ,
CONSTRAINT [PKHROD_T] PRIMARY KEY CLUSTERED
(
[DEFAULTNUMBER_I],
[TERMORDER_I]
) ON [PRIMARY]
) ON [PRIMARY]
setuser
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[HROD_T].[ADDTODEFAULTITEMS_I]'
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[HROD_T].[DEFAULTNUMBER_I]'
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[HROD_T].[TERMATTRIBUTE_I]'
EXEC sp_bindefault N'[dbo].[GPS_CHAR]', N'[HROD_T].[TERMITEM_I]'
EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[HROD_T].[TERMORDER_I]'
setuser
GRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[HROD_T] TO [DYNGRP]
/*End_HROD_T*/
/*
/* Date: 02/14/2013 Time: 7:19:32
SQLSTATE:(01000) Native Err:(15511) stmt(8310608):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]Default bound to column.*/
/*
/* Date: 02/14/2013 Time: 7:19:32
SQLSTATE:(01000) Native Err:(15511) stmt(8310608):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]Default bound to column.*/
/*
/* Date: 02/14/2013 Time: 7:19:32
SQLSTATE:(01000) Native Err:(15511) stmt(8310608):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]Default bound to column.*/
/*
/* Date: 02/14/2013 Time: 7:19:32
SQLSTATE:(01000) Native Err:(15511) stmt(8310608):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]Default bound to column.*/
/*
/* Date: 02/14/2013 Time: 7:19:32
SQLSTATE:(01000) Native Err:(15511) stmt(8310608):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]Default bound to column.*/
/*
/* Date: 02/14/2013 Time: 7:19:32
SQLSTATE:(00000) Native Err:(15511) stmt(8310608):*/
*/
/*
/* Date: 02/14/2013 Time: 7:19:32
SQLSTATE:(00000) Native Err:(15511) status(0):*/
SWSTATUS DUMP*/
/* Date: 02/14/2013 Time: 7:19:32
stmt(8310608):*/
BULK INSERT [DYNAMICS]..[HROD_T] FROM 'C:\Program Files (x86)\Microsoft Dynamics\GP2013\DATA\Temp\HROD.out' WITH (CODEPAGE = 'ACP', KEEPNULLS, FIELDTERMINATOR = '||', ROWTERMINATOR = '#EOR#\n')
/* Date: 02/14/2013 Time: 7:19:32
stmt(8310608):*/
exec duAN_SynchronizeTable 'HROD','HROD_T','T'
/*
/* Date: 02/14/2013 Time: 7:19:32
SQLSTATE:(01000) Native Err:(50000) stmt(8310608):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table specified not found*/
Please follow instructions in KB878449. You will need to copy all of your company databases plus the DYNAMICS database and do a complete upgrade using GP Utilities.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
