SBX - Search With Button

SBX - Forum Post Title

Moving VIEWS between enviroments

Microsoft Dynamics AX Forum

Vkunchakuri asked a question on 13 Jun 2019 7:53 AM

Question Status

Verified

HI All,

I had to add a field in ProjPostTrans view and a couple of other related views. This view is used in ProjPostedTransactionListPage(Project posted transactions). This works in Development environment. I have put all my objects in a model and moved the model to TEST environment. 

Now in TEST env, The fields are shown in UI but I cannot synchronize the views. It gives me the below errors

Cannot execute a data definition language command on  ().
The SQL database has issued an error.

SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'PERSONNELNUMBER'. 

This is the newly added field.

Reply
Verified Answer

Please check that the underlying table has field PersonnelNumber and that the table is synchronized.

Reply
Vkunchakuri responded on 13 Jun 2019 2:04 PM

Thanks Nikolas, Yes Ive checked that. Somehow, strangely it is resolved by itself. COmpiled,generated CIl,restarted AOS, after that tried to sync and the error got resolved.

Reply
Verified Answer

Please check that the underlying table has field PersonnelNumber and that the table is synchronized.

Reply

SBX - Two Col Forum

SBX - Migrated JS