FIX: ????? ??? ??? ????? ??????? MDX ?? SQL Server 2005 Analysis Services: "??? ??? ????? occurred (??? 'pffilestore.cpp' ? ????? 3267 ? ?????? 'PFFileStore::HandleDataPageFault')"???: # 50000754 (??????? ?????? SQL)
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????. ???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????: - ???????? ???? ??? ??????? ?? ???? ???? ????????? ??????? ??? ??? ?????
- ????????? ??????? ????? ???? ????????? ???????
- ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ??????? ??????
- ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
- ?? ??? ??? ??? ????? ??? ??????? ??????? ??? ????? ???? ??????? ??????
- ??????? ??????? ?? ???? ????????? ???????
??? ????? ??????? ??????? ?????? ??????? (MDX) ?? Microsoft SQL Server 2005 Analysis Services ????? ????? ????? ???????: ????? ?????????...
??? ?????: ??? ??? ????? occurred (??? 'pffilestore.cpp' ? ????? 3267 ? ?????? 'PFFileStore::HandleDataPageFault').
????? ??????? ??? ???? ??????? ????? ??? ??????? ??? ????? ??????? ??????? ??? ???: with member [Customer].[Postal Code].[Test] as null
select generate([Customer].[Postal Code].[03064], generate([Customer].[Postal Code].[Test], [Customer].[City].currentmember)) on 0
from [Adventure Works]
???? ??? ??????? ??? ????? ????? ??? ??? ????? ?? ??? ????? ??? ??? ??? ??? ?? ??????? ??????. ??????? ??? ??? ????? ??????? ???? ?? ??? ??? ?????. ??? ???? ?? ??? ?? ????? ????? ???????? ??? ??????? ??? ????? ?????. ????? ????? ????? ????? SQL Server ?? ????? ????? ??? ????? ?? ????? ????? ? ???? ??? ??? ????? ????? ???? ??? ?????. ????? ????? ???? ????? ?? Microsoft. ???? ????? ??? ?? ?? ??????? ??????? ?? ??? ???????. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????. ?? ??? ????? ???????? ?????? ??? ??? ??????? ??????. ?????? ??? ?? ??? ????? ??? ??????? ??????? ???? ????????? ??? ??????? ?????? ?? ????? ???????? ???? ????? ??? ??? ??????? ??????. ?? ???? ????? ??????? ?????? ???? ??? "???? ????? ??????? ????" ???? ????? ????? ??????? ??? ???. ??? ?? ???? ??? ?????? ???? Microsoft ???? ??????? ?????? ?????? ??? ??????? ??????. ?????? ???? ?????? ?????? ?? ?? ?? ???? ?????? ??? ??????? ??????? ???????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ????? ????? ?????? ????? Microsoft ???? ??????? ?????? ?????? ????? ?? ?????? ??? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????: ?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ??? ???? ?? ????? ????? ???? ???? ?????. ????????? ????????- Microsoft SQL Server 2005 ?????? ????? ?????? Service Pack 1 (SP1) - ???????? ??? ????? ??????? ?????? SQL Server 2005 ?????? ????? ?????? SP1.
- Microsoft SQL Server 2005 ?????? ????? ?????? Service Pack 2 (SP2) - ???????? ??? ????? ??????? ?????? SQL Server 2005 ?????? ????? ?????? SP2.
?????? ??? ???? ?? ????????? ??? ????? ?????? ??? ??? ?????? ?? SQL Server 2005 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft: 913089
(http://support.microsoft.com/kb/913089/
)
????? ?????? ??? ???? ???? ???? ?? SQL Server 2005 ????? ????? ???????????? ???? ??? ????? ????? ???? ????????? ??? ????? ??? ??????? ??????. ????? ??? ??????? ?????? ????? ?? ?? ????? ????? ???? "????? ???????". ??? ??? ?????? ???? HTTP ?????? ???? ??? ?? ????? ????? ??????? ?????? ?? Microsoft (IIS) ?? ?? ?????? ????? IIS ??? ?????? ???????. ??? ??? ?????? "????? ?????" ????? ????? ??? ????? ???? ?????? SQL Server. ??? ????? ???? ?????? SQL Server ???? ????? ?????? Msmdredir.dll ???? ?????? SQL Server ????? ????? ??? ??????? ??????. ??????? ????????? ??? ???? ????? ?????. ??????? ??? ??????? ??????????? ??? ??????? ?????? ??? ??????? ???????? ?????? ???????? ???? ???? ??? ??????? ???. ?? ?? ????? ??? ??? ??????? ?????? ???? ??????? ???? ??? ?? ???? ???? ?????? ???? ????? ?????? ????? ????. ????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????". SQL Server 2005 ?????? ??????? ??????SQL Server 2005 Analysis Services ? ??????? ?? ???? ??? ??????????? ??? ?????? | ??? ????? | ????? ????? | ??? ????? | ????? | ????? | ?????? ??????? |
|---|
| Microsoft.analysisservices.adomdclient.dll | 9.0.2223.0 | 546,160 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.analysisservices.deploymentengine.dll | 9.0.2223.0 | 140,656 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.analysisservices.dll | 9.0.2223.0 | 1,217,904 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.datawarehouse.dll | 9.0.2223.0 | 1,279,344 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.sqlserver.mgdsqldumper.dll | 2005.90.2223.0 | 78,192 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.sqlserver.sqlenum.dll | 9.0.2223.0 | 910,704 | ?? ?????? ???? | 11: 47 | x 86 | | Msadomdx.dll | 9.0.2223.0 | 495,472 | ?? ?????? ???? | 11: 47 | x 86 | | Msasxpress.dll | 9.0.2223.0 | 24,944 | ?? ?????? ???? | 11: 47 | x 86 | | Msmdlocal.dll | 9.0.2223.0 | 15,646,064 | ?? ?????? ???? | 11: 47 | x 86 | | Msmdpump.dll | 9.0.2223.0 | 3,986,288 | ?? ?????? ???? | 11: 47 | x 86 | | Msmdredir.dll | 9.0.2223.0 | 3,993,968 | ?? ?????? ???? | 11: 47 | x 86 | | Msmdsrv.exe | 9.0.2223.0 | 14,627,696 | ?? ?????? ???? | 11: 47 | x 86 | | Msmgdsrv.dll | 9.0.2223.0 | 6,000,496 | ?? ?????? ???? | 11: 47 | x 86 | | Msolap90.dll | 9.0.2223.0 | 4,265,328 | ?? ?????? ???? | 11: 47 | x 86 | | Msolui90.dll | 9.0.2223.0 | 275,312 | ?? ?????? ???? | 11: 47 | x 86 |
SQL Server 2005 Analysis Services ? ????? 64-???? ??? ??????????? ??? ?????? | ??? ????? | ????? ????? | ??? ????? | ????? | ????? | ?????? ??????? |
|---|
| Microsoft.analysisservices.adomdclient.dll | 9.0.2223.0 | 546,160 | ?? ?????? ???? | 23: 51 | x 86 | | Microsoft.analysisservices.adomdclient.dll | 9.0.2223.0 | 546,160 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.analysisservices.deploymentengine.dll | 9.0.2223.0 | 140,656 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.analysisservices.dll | 9.0.2223.0 | 1,217,904 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.datawarehouse.dll | 9.0.2223.0 | 1,279,344 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.sqlserver.mgdsqldumper.dll | 2005.90.2223.0 | 94,064 | ?? ?????? ???? | 23: 51 | x 64 | | Microsoft.sqlserver.mgdsqldumper.dll | 2005.90.2223.0 | 78,192 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.sqlserver.sqlenum.dll | 9.0.2223.0 | 877,936 | ?? ?????? ???? | 23: 51 | x 86 | | Msadomdx.dll | 9.0.2223.0 | 495,472 | ?? ?????? ???? | 11: 47 | x 86 | | Msasxpress.dll | 9.0.2223.0 | 30,064 | ?? ?????? ???? | 23: 51 | x 64 | | Msasxpress.dll | 9.0.2223.0 | 24,944 | ?? ?????? ???? | 11: 47 | x 86 | | Msmdlocal.dll | 9.0.2223.0 | 31,520,112 | ?? ?????? ???? | 23: 51 | x 64 | | Msmdlocal.dll | 9.0.2223.0 | 15,646,064 | ?? ?????? ???? | 11: 47 | x 86 | | Msmdpump.dll | 9.0.2223.0 | 5,163,376 | ?? ?????? ???? | 23: 51 | x 64 | | Msmdredir.dll | 9.0.2223.0 | 3,993,968 | ?? ?????? ???? | 11: 47 | x 86 | | Msmdsrv.exe | 9.0.2223.0 | 30,915,952 | ?? ?????? ???? | 23: 51 | x 64 | | Msmgdsrv.dll | 9.0.2223.0 | 9,604,976 | ?? ?????? ???? | 23: 51 | x 64 | | Msmgdsrv.dll | 9.0.2223.0 | 6,000,496 | ?? ?????? ???? | 11: 47 | x 86 | | Msolap90.dll | 9.0.2223.0 | 5,828,976 | ?? ?????? ???? | 23: 51 | x 64 | | Msolap90.dll | 9.0.2223.0 | 4,265,328 | ?? ?????? ???? | 11: 47 | x 86 | | Msolui90.dll | 9.0.2223.0 | 323,440 | ?? ?????? ???? | 23: 51 | x 64 | | Msolui90.dll | 9.0.2223.0 | 275,312 | ?? ?????? ???? | 11: 47 | x 86 |
SQL Server 2005 Analysis Services ? ??????? ????? Itanium?? ??? ??????????? ??? ?????? | ??? ????? | ????? ????? | ??? ????? | ????? | ????? | ?????? ??????? |
|---|
| Microsoft.analysisservices.adomdclient.dll | 9.0.2223.0 | 546,160 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.analysisservices.adomdclient.dll | 9.0.2223.0 | 546,160 | ?? ?????? ???? | 01: 56 | x 86 | | Microsoft.analysisservices.deploymentengine.dll | 9.0.2223.0 | 140,656 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.analysisservices.dll | 9.0.2223.0 | 1,217,904 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.datawarehouse.dll | 9.0.2223.0 | 1,279,344 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.sqlserver.mgdsqldumper.dll | 2005.90.2223.0 | 78,192 | ?? ?????? ???? | 11: 47 | x 86 | | Microsoft.sqlserver.mgdsqldumper.dll | 2005.90.2223.0 | 165,744 | ?? ?????? ???? | 01: 56 | IA-64 | | Microsoft.sqlserver.sqlenum.dll | 9.0.2223.0 | 877,936 | ?? ?????? ???? | 01: 56 | x 86 | | Msadomdx.dll | 9.0.2223.0 | 495,472 | ?? ?????? ???? | 11: 47 | x 86 | | Msasxpress.dll | 9.0.2223.0 | 24,944 | ?? ?????? ???? | 11: 47 | x 86 | | Msasxpress.dll | 9.0.2223.0 | 57,712 | ?? ?????? ???? | 01: 56 | IA-64 | | Msmdlocal.dll | 9.0.2223.0 | 15,646,064 | ?? ?????? ???? | 11: 47 | x 86 | | Msmdlocal.dll | 9.0.2223.0 | 48,718,704 | ?? ?????? ???? | 01: 56 | IA-64 | | Msmdpump.dll | 9.0.2223.0 | 6,733,680 | ?? ?????? ???? | 01: 56 | IA-64 | | Msmdredir.dll | 9.0.2223.0 | 6,249,328 | ?? ?????? ???? | 01: 56 | IA-64 | | Msmdsrv.exe | 9.0.2223.0 | 47,717,232 | ?? ?????? ???? | 01: 56 | IA-64 | | Msmgdsrv.dll | 9.0.2223.0 | 6,000,496 | ?? ?????? ???? | 11: 47 | x 86 | | Msmgdsrv.dll | 9.0.2223.0 | 13,056,880 | ?? ?????? ???? | 01: 56 | IA-64 | | Msolap90.dll | 9.0.2223.0 | 4,265,328 | ?? ?????? ???? | 11: 47 | x 86 | | Msolap90.dll | 9.0.2223.0 | 7,886,192 | ?? ?????? ???? | 01: 56 | IA-64 | | Msolui90.dll | 9.0.2223.0 | 275,312 | ?? ?????? ???? | 11: 47 | x 86 | | Msolui90.dll | 9.0.2223.0 | 473,456 | ?? ?????? ???? | 01: 56 | IA-64 |
??????? ?????? ??????? ??? SQL Server 2005 ?????? ????? ?????? SP2SQL Server 2005 Analysis Services ? ??????? ?? ???? ??? ??????????? ??? ?????? | ??? ????? | ????? ????? | ??? ????? | ????? | ????? | ?????? ??????? |
|---|
| Microsoft.datawarehouse.dll | 9.0.3166.0 | 1,279,344 | 28 ????? ???? | ??: 53 | x 86 | | Msmdlocal.dll | 9.0.3166.0 | 15,943,536 | 28 ????? ???? | ??: 53 | x 86 | | Msmdspdm.dll | 9.0.3166.0 | 202,096 | 28 ????? ???? | ??: 53 | x 86 | | Msmdsrv.exe | 9.0.3166.0 | 14,911,344 | 28 ????? ???? | ??: 53 | x 86 | | Msmgdsrv.dll | 9.0.3166.0 | 6,045,552 | 28 ????? ???? | ??: 53 | x 86 | | Msolap90.dll | 9.0.3166.0 | 4,299,120 | 28 ????? ???? | ??: 53 | x 86 |
?? ??? ??????????? ??? ?????? | ??? ????? | ????? ????? | ??? ????? | ????? | ????? | ?????? ??????? |
|---|
| Microsoft.datawarehouse.dll | 9.0.3166.0 | 1,279,344 | 28 ????? ???? | ??: 53 | x 86 | | Msmdlocal.dll | 9.0.3166.0 | 30,833,008 | 28 ????? ???? | 16: 12 | x 64 | | Msmdlocal.dll | 9.0.3166.0 | 15,943,536 | 28 ????? ???? | ??: 53 | x 86 | | Msmdspdm.dll | 9.0.3166.0 | 202,096 | 28 ????? ???? | 16: 12 | x 86 | | Msmdsrv.exe | 9.0.3166.0 | 30,160,752 | 28 ????? ???? | 16: 12 | x 64 | | Msmgdsrv.dll | 9.0.3166.0 | 9,126,256 | 28 ????? ???? | 16: 12 | x 64 | | Msmgdsrv.dll | 9.0.3166.0 | 6,045,552 | 28 ????? ???? | ??: 53 | x 86 | | Msolap90.dll | 9.0.3166.0 | 5,849,456 | 28 ????? ???? | 16: 12 | x 64 | | Msolap90.dll | 9.0.3166.0 | 4,299,120 | 28 ????? ???? | ??: 53 | x 86 |
?? ??? ??????????? ??? ?????? | ??? ????? | ????? ????? | ??? ????? | ????? | ????? | ?????? ??????? |
|---|
| Microsoft.datawarehouse.dll | 9.0.3166.0 | 1,279,344 | 28 ????? ???? | ??: 53 | x 86 | | Msmdlocal.dll | 9.0.3166.0 | 49,887,088 | 28 ????? ???? | 10: 09 | IA-64 | | Msmdlocal.dll | 9.0.3166.0 | 15,943,536 | 28 ????? ???? | ??: 53 | x 86 | | Msmdspdm.dll | 9.0.3166.0 | 202,096 | 28 ????? ???? | 10: 09 | x 86 | | Msmdsrv.exe | 9.0.3166.0 | 48,838,000 | 28 ????? ???? | 10: 09 | IA-64 | | Msmgdsrv.dll | 9.0.3166.0 | 13,169,008 | 28 ????? ???? | 10: 09 | IA-64 | | Msmgdsrv.dll | 9.0.3166.0 | 6,045,552 | 28 ????? ???? | ??: 53 | x 86 | | Msolap90.dll | 9.0.3166.0 | 7,908,720 | 28 ????? ???? | 10: 09 | IA-64 | | Msolap90.dll | 9.0.3166.0 | 4,299,120 | 28 ????? ???? | ??: 53 | x 86 |
???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???". ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft: 824684
(http://support.microsoft.com/kb/824684/
)
??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft ???? ???????: 932610 - ????? ??? ??????: 23/????/1428 - ??????: 1.4 ????? ???- Microsoft SQL Server 2005 Analysis Services
| kbmt kbautohotfix kbsql2005as kbhotfixserver kbqfe kbpubtypekc KB932610 KbMtar |
????? ???????: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ?????? ???? ??? ????? ??????? ?????? ?????????? 932610
(http://support.microsoft.com/kb/932610/en-us/
)
| |
???? ??? ??????
