Synchronize database error after CU8 in AX 2012 R3

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (1)

Sort by

nunomaia 27 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

It looks like that view is being handled as a table. Check this https://community.dynamics.com/ax/f/33/t/143042

Was this reply helpful? Yes No
Suggested answer

Victor Tang 47 on at

Like (0)

Report
Copy link

Link copied!

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

community.dynamics.com/.../119471

Was this reply helpful? Yes No
Umesh Pandit 9,315 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi Boubacar,

Just find the table in DB and delete/drop the table, and re-sync.

Was this reply helpful? Yes No
Verified answer

5400 7,162 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No