Index creation in views disabled in Update 2?

(0) Share

Report

Posted on by Community Member

Hi everybody,

we got Update 2 installed on our environments last week and since then we're not able to create indexes in views. Doesn't matter if we're extending or the view is new, the option isn't there anymore:

Also when building the solution we get this warning:

"ViewWithIndexes: Path: [AxView/DimAttributeCounterparty]:You have added an index to a view, but AX7 views do not support indexing: No index will be added to the view in SQL server. We suggest removing the index."

We haven't found any mention to this in the Update 2 notes nor anywhere on the internet. I just can't believe nobody has had this issue after applying update 2, specially when indexes are used in views when creating new Dimensions (DimAttribute pattern). I'm starting to think that our environments haven't been correctly patched/updated or there's some setup error.

Has anybody else faced this issue?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

DevinS on at

Like (0)

Report
Copy link

Link copied!

Have you found a resolution to this issue? We are facing the same issue in our solution.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

We´re still waiting for our Partner´s response, they told us they had asked Microsoft about this but still haven´t heard back from them. That was more than a month ago so I'm not really hoping on any news, and they´re quite a big partner, one with badges and such...

If you´re stuck at Update2 I´d recommend just adding the indexes manually editing the XML file for each view. We´ve done it like this for new Dimensions and it´s doing the trick. So, stop the AOS, open Notepad (or your preferred text editor) as an administrator, edit and save the file and start the AOS. After restarting Visual Studio you´ll see the changes in the AOT. Regarding the warning message: just ignore it. The standard views for Dimensions still have the indexes there so I guess it´ll come back after we apply Update 3.

Was this reply helpful? Yes No
Martin Dráb 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The warning means that these indexes exist only in metadata; they're never synchronized to database. This applied to Platform Update 3 as well.

Was this reply helpful? Yes No