Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
SSRS and SSAS Integration
I have added a field with the name Print in salesline table then i deleted it from AOT but when i m going to synchronize table it is giving me error "cannot execute a data definition language command on sql database has issue an error". Then i deleted this field from sql server in salesline table and after that when i am going to synchronize it again it gives me the same error then i goto Eventviewer and in EventViewer it is giving me the error "Incorrect syntax near the keyword Print.The statement was Alter Table salesline drop column print".
because there is no field with the name Print in salesline table in sql server and it seems that salesline table executing Alter statement somewhere from configuration and i dnt know how to modify configuration.
Anyone have any idea about this ?
Please add that field again print to salesline and then try restarting the AOS see if this is gana work.
This an issue with AX you can not use print named field in AX because this is a system field and it generates an issue in the select statement.
It seems that Ax meta data table has the reference of salesline 'print' field.
AX metadata is stored into the table called 'sqldictionary ' which you will get it into the system node i.e. \System Documentation\Tables\SqlDictionary. or from a SQL Server.
You need to search it for table id '359' (salesline) into the field of tabid from Sql dictionary table.
If you find the record for a 'print' field then delete the record and synchronize the Data dictionary.
Please keep in mind that when you delete delete the record from this table the values which was stored against this field will be vanish/purge.
Hope this should resolve your issue.
-- Rakesh Darge
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13