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.
Please check that the underlying table has field PersonnelNumber and that the table is synchronized.
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.
Business Applications communities