web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Need Urgent Help in Sa...
Microsoft Dynamics AX (Archived)

Need Urgent Help in Salesline table Synchronization

(0) ShareShare
ReportReport
Posted on by Azwar Alam 2,985

Hello

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 ?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi,

    Please add that field again print to salesline and then try restarting the AOS see if this is gana work.

    Regards,

    Yousef Shawareb

  • Community Member Profile Picture
    Community Member on at

    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.

    -ABdul

  • Rakesh Darge Profile Picture
    Rakesh Darge on at

    Hi,

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans