I'm trying to add t fields to the PurchLine Table but after compile i got the following error:
Cannot execute a data definition language command on ().
The SQL database has issued an error.
Problems during SQL data dictionary synchronization.
The operation failed.
Synchronize failed on 1 table(s)
This error happened when I was adding fields to the table and disconnect the system from the network.
Thanks for your help
If AX is trying to create a table which already exists in the database, most likely that means that your SQLDictionary table is out of sync with the AOT.
The easiest way to fix it would be to rename PURCHLINE table in the database, then run synchronization and let it create PURCHLINE table again, and then copy data from the renamed PURCHLINE table into the newly created PURCHLINE.
Hi
I add these flieds directly in AOT, besides just delete these fields from AOT, but I mark error when synchronizing,
I am checking the Server Application and the event log shome this message:
Object Server 01: The database reported (session 9 (amar)): [Microsoft][ODBC SQL Server Driver][SQL Server] there is already an object named 'PURCHLINE' in the database.. The SQL statement was: "CREATE TABLE "DBO".PURCHLINE
thanks by you help
How were you adding these fields? Directly in AOT or through xpo? I would first try recreating the fields in PurchLine and try another synch.
You can check Eventlog for more detail info. E.g sql script, tables, etc
Regards,
S.C.GAN
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,647
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (