You’re offline. This is a read only version of the page.
Hello All,
We have successfully upgraded to R3 and have now performed the CU8 update (with both binaries and application). During the Software update checklist, all steps were ok except that we got an error during synchronize database. It did not prevent the subsequent steps from completing fine.
The error is:
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot alter 'TRVSUBMITACCDISTRIBUTION' because it is not a table.
SQL statement: ALTER TABLE TRVSUBMITACCDISTRIBUTION DROP COLUMN PARTITION#3, PARTITION#2
Problems during SQL data dictionary synchronization.
Synchronize failed on 1 table(s)
Did anyone experience this error and how to get it resolved?
*This post is locked for comments
Bhaskar,
I believe you are correct. Now we just need to determine why is it a table in DEV and how to get it converted into a view.
Hello All,
this is strange indeed. the 'TrvSubmitAccDistribution' is a view in our TEST R3 environment yet it is a table in our DEV environment. It's confusing as to what object it is.
Can anyone advise?
It is view in AOT. It is consist of TrvSubmitAccountingDistribution query. This query having data source
1. AccountingDistribution
2.TrvExpTrans
3.TrvPayMethod
Please sync the above tables first and then go to view please check any unknown field is there or not and each field should have mapped with correct table.
Hi Boubacar,
Just find the table in DB and delete/drop the table, and re-sync.
I had the same problem twice and Microsoft's reply is it's rather a random issue and they were not able to provide a fix yet until they can reproduce it.
Please see the following and use the sql query to fix it
Hi,
It looks like that view is being handled as a table. Check this https://community.dynamics.com/ax/f/33/t/143042
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...
291,232
Super User 2024 Season 2
#2
Martin Dráb
230,064
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (