Notifications
Announcements
No record found.
*This post is locked for comments
Hello,
I would look in the Windows Application Event Log on the machine that is trying to do a synchronize and see if you can determine what error SQL is throwing out to you. I would think that would give you a better idea as to what error SQL is generating, and a resolution to your issue.
Best Regards,
Bill Thompson
Dynamics AX/Dynamics Sure Step - Online Support Engineer
============================================================
When responding to posts, please 'Reply to Group' via your newsreader so that
others may learn and benefit from your issue.
This posting is provided 'AS IS' with no warranties, and confers no rights.
Hi,
Bil Thompson,
Thanks for the reply .
In the event viewer the error description is as bellow....
1). Before stopping the replication jobs in job activity monitor. Event viewer error description as below:
Object Server 01:
[Microsoft][SQL Native Client][SQL Server]Cannot rename the table because it is published for replication.
SP_RENAME '"DBO".ADDRESSSTATE.FIELD3','NEW','COLUMN'
session 3 (Admin)
2) After stopping the replication jobs in job activity monitor. Event viewer error description as below:
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'NEW'.
SELECT A.NAME,A.STATEID,A.COUNTRYREGIONID,A.INTRASTATCODE,A.TIMEZONE,A.FIELD1,A.FIELD2,A.NEW,A.RECVERSION,A.RECID FROM ADDRESSSTATE A WHERE (DATAAREAID=?)
I tried with other different column names, the data type and column name is valid. but it is throwing the same error.
what will be the problem? how to resolve it ?
But the user, whose is logged in AX and trying to add a new field is having the full rights to SQL Server.
He is having sysadmin & db_owner rights.
Regards
Prasad.
Hi Prasad,
Have you find the solution? I am facing the same issue.
If you get an error because of replication, then you need to stop it in order for AX to be able to carry out the changes to the SQL table structure as per above.
If you have issues with column names, then please check your SQLDictionary table with the tabId field = your tables' Table id and see if the fields are matching in there with your AOT.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Priya_K 4
Martin Dráb 4 Most Valuable Professional
Ali Zaidi 2
