hi Nitin,
Check if you have any external tables in SQL Server (tables which are not there
in AX but they are present in SQL Server AX database). If you have such tables,
please follow below mentioned steps:
1. Export data from those tables
2. Delete all those tables from SQL Server
3. run this tool and import these tables in new database.
Hope it works for you. In case it doesn't, do let me know.
Regards
Amit
--- On Tue, 15/9/09, nitinmathur_jpr <nitinmathur_...@yahoo.com> wrote:
From: nitinmathur_jpr <nitinmathur_...@yahoo.com>
Subject: [development-axapta] DB Upgrade Tool Error
To: development-axapta@yahoogroups.com
Date: Tuesday, 15 September, 2009, 3:58 PM
Hi,
I am trying to migrate from AX 4.0 SP1 to AX 2009 SP1 with indian localization.
After running the 'DBUpgrade Tool' shipped with Ax 2009 i am facing the problem.
------------ --------- --------- --------- --------- --------- -
OCC: Updating table SqlDictionary
Error while execution the following sql:DECLARE TABLES CURSOR FOR SELECT
DISTINCT TABLEID FROM [DynamicsAx2009Test ].[dbo].[ SQLDICTIONARY] DECLARE
@RECVERSIONNAME NVARCHAR(20) SET @RECVERSIONNAME = N'RECVERSION' DECLARE
@TABLEID INT OPEN TABLES FETCH TABLES INTO @TABLEID DECLARE @STATEMENT
NVARCHAR(2000) DECLARE @RECID INT WHILE (@@FETCH_STATUS =0) BEGIN SET @RECID =
0 SELECT @RECID = RECID FROM [DynamicsAx2009Test ].[dbo].[ SQLDICTIONARY] WHERE
TABLEID = @TABLEID AND FIELDID = 61450 IF @RECID = 0 BEGIN SELECT @RECID =
(CASE WHEN MAX(RECID) > 0 THEN MAX(RECID) ELSE 0 END) + 1 FROM
[DynamicsAx2009Test ].[dbo].[ SQLDICTIONARY] SET @STATEMENT = N'INSERT INTO
[DynamicsAx2009Test ].[dbo].[ SQLDICTIONARY] ' + N'(TABLEID,FIELDID,
ARRAY,NAME, SQLNAME,FIELDTYP E,STRSIZE, SHADOW,RIGHTJUST IFY,NULLABLE,
FLAGS,RECID, RECVERSION) VALUES ' + N'(' + CAST(@TABLEID AS NVARCHAR(10) ) +
N',61450,1,' '' + @RECVERSIONNAME + N''',''' + @RECVERSIONNAME + N''',1,0,0,0,
0,0,' +
CAST(@RECID AS NVARCHAR(10) ) + N',1)' EXECUTE SP_EXECUTESQL @STATEMENT END
FETCH TABLES INTO @TABLEID END CLOSE TABLES DEALLOCATE TABLES
SqlState 22003, NativeError 8115: [Microsoft][ ODBC SQL Server Driver][SQL
Server]Arithmetic overflow error converting expression to data type int.
SqlState 22003, NativeError 8115: [Microsoft][ ODBC SQL Server Driver][SQL
Server]Arithmetic overflow error converting expression to data type int.
SqlState 23000, NativeError 547: [Microsoft][ ODBC SQL Server Driver][SQL
Server]The INSERT statement conflicted with the CHECK constraint
"CK__SQLDICTIO_ _RECID__496B2A13 ". The conflict occurred in database
"DynamicsAx2009Test ", table "dbo.SQLDICTIONARY" , column 'RECID'.
SqlState 01000, NativeError 3621: [Microsoft][ ODBC SQL Server Driver][SQL
Server]The statement has been terminated.
------------ --------- --------- --------- --------- --------- -
Please help ASAP.
Thanks and Regards,
Nitn
Love Cricket? Check out live scores, photos, video highlights and more.
Click here http://cricket.yahoo.com
[Non-text portions of this message have been removed]
