I've run into a problem that I just cannot figure out how to solve.
Trying to do an Ax 2.5 to 3.0 upgrade.
During the sync step, I get erros on the indexes of 21 tables stating
that the index object already exists. But, if I go into SQL
enterprise manager, right click on the table, choose table designer
and look at the indexes & keys it shows nothing!
If I look at the same tables via SQL enterprise manager in a working
ax 3.0 database, I can see the indexes & keys. I can also delete an
index, resync and the index gets recreated.
I have no idea how to solve this problem with the database I'm trying
to upgrade.
Can anyone help?
Here's an example of the error messages I get in the infolog...
Error Synchronize Cannot execute a data definition language
command on ().
The SQL database has issued an error.
Info Synchronize SQL error description: [Microsoft][ODBC SQL
Server Driver][SQL Server]There is already an object
named 'I_025SCRAPTYPEIDX' in the database.
Info Synchronize SQL statement: ALTER TABLE DEL_BOMSCRAP ADD
CONSTRAINT I_025SCRAPTYPEIDX PRIMARY KEY CLUSTERED
(DATAAREAID,SCRAPTYPEID)
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
