En essayant de générer une dimension contenant environ 30 millions de membres, j’ai eu l’erreur suivante :
File system error: A FileStore error from WriteFile occurred. Physical file: ….
En cherchant sur le forum Analysis Services du MSDN, j’ai trouvé le post d’un utilisateur (Sally J.) avec le même problème sur une dimension de plus de 10 millions de membres, il a contacté le support Microsoft, et voila sa conclusion
I had this problem many times, until I found a totally unrelated article pertaining to a 4 GB limitation for the .asstore file in MOLAP dimensions.
I talked to Microsoft, and they investigated and found that the limitation does exist. If it happens again, I would suggest browsing the data folder where the database exists and opening the failing dimension folder. If you see that the dimension file with a .asstore extension, or any other one that is over 4 GB, you have found your problem.There is nothing short of doing a full process on the dimension (which the Microsoft guy suggested, and I had to yell at him (in a nice way)) when it hits the limit. If you MUST Process Update and you cannot use ProcessAdd on your dimension, I would suggest breaking the dimension in a linear fashion into several dimensions (column by column), or finding a new way to build the dimension where it will not grow exponentially. A Process Update appends string data to the file, and that is why it gets so large. I would also suggest taking a look at the AS dimension and see if there are any character columns you can cut down in size.
Pas de commentaire reçu(s)
Laisser une réponse