could also look at the actual table structure in the database and
compare it to what Axapta thinks it should be. Could there be a problem
with the owner of the table (dbo vs. bmssa)? If you see more than one
owner, you may need to run a script to force all Axapta tables to have
the same owner (preferably dbo).
Jim Chwaszczewski
[EMAIL PROTECTED]
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED]
Sent: Thursday, May 11, 2006 10:59 AM
To: [email protected]
Subject: [development-axapta] Digest Number 1740
Message 2
From: "csmanohar2000" [EMAIL PROTECTED]
Date: Thu May 11, 2006 4:18am(PDT)
Subject: Synchronize Problem While Upgrading from 2.5 to 3.0 sp5 KR1
I am upgrading an installation from 2.5 to 3.0 SP5 KR1. I opened up
the old 2.5 database with my upgraded application which started the
upgrade checklist. While going thru the upgrade checklist, I have
completed all steps thru pre-synchronize data upgrade, the next step
being synchronize. One of he error messages I have received at the
end of synchronization is as follows.
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]Column name 'INVENTDIMID' does not exist in
the target table.
Info Synchronize SQL statement: CREATE INDEX I_019NUMIDX ON
BOMCALCTABLE
(DATAAREAID,ITEMID,INVENTDIMID,BOMID,ROUTEID,PRICECALCID)
Many tables from version 2.5 (eg 'BOMCALCTABLE' shown above) with the
field ConfigId have been modified in 3.0 as follows.
1. Rename the field ConfigId to DEL_ConfigId
2. Add field InventDimId.
>From what I know, synchronization step should take care of this by
updating undelying database table automatically to match table
definition in AOT. Instead of doing that, it complains it can't find
the field inventDimId while trying to create an index that includes
InventDimId.
Can you please help me understand what is happening here.
Thanks
--------------------------------------------------------
The content of this E-mail and any attached files is confidential, and may be subject
to certain privilege. This email is intended for the designated recipient(s) only.
If you have received this E-mail in error, please immediately contact the sender.
Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this email (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties.
WIPFLI LLP
Business experts. Right from the start.
--------------------------------------------------------
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
