Hi Amit,
Thanks for ur reply.
As you said i delete the records from 'SQLDictionary' table from Ax4.0, doing
this DBUpgrade tool run sucessfully.
After installation of Ax2009 pointing to the updated database, while strating
services of AOS it tells to delete some tables stating tables already exsis in
the database.
e.g.
1. Syssrstablespermission
2. Sysoccconfiguration
3. Domaininfo
4. sql parameters.
Kindly share your views.
Regards,
Nitin
________________________________
From: Amit Jain <amitjain...@yahoo.com>
To: development-axapta@yahoogroups.com
Sent: Tuesday, September 15, 2009 7:08:55 PM
Subject: Re: [development-axapta] DB Upgrade Tool Error
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_ j...@yahoo. com> wrote:
From: nitinmathur_ jpr <nitinmathur_ j...@yahoo. com>
Subject: [development- axapta] DB Upgrade Tool Error
To: development- axa...@yahoogrou ps.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]
[Non-text portions of this message have been removed]
