Korriger: En uventet feil oppstår når et mål for XIR behandler for mange poster i SSAS 2016 eller 2017

Feil #: 10965956 (sqlbuvsts01)
Feil #: 10479291 (sqlbuvsts01)
Feil #: 69603 (innhold idé)
Feil #: 67450 (innhold idé)
Feil #: 66143 (innhold idé)

Symptomer

Anta at du oppretter et uttrykk for Data-analyse (DAX) mål ved hjelp av XIR-funksjonen i Microsoft SQL Server-2016 eller 2017 Analysis Services (SSAS). Når du åpner målet i Power pivottabellen i Excel-2016 eller strømmen BI-skrivebordet, og prøver å behandle for mange poster (for eksempel: mer enn 400 poster), kan du få en feilmelding som ligner på følgende:

Det oppstod et uventet unntak.

Løsning

Dette problemet er løst i følgende kumulative oppdateringer for SQL Server:

Samleoppdatering 1 for SQLServer 2017

Kumulativ oppdatering 8 for SQL Server 2016 RTM

Samleoppdatering 6 for SQL Server 2016 SP1

Hver nye kumulative oppdateringen for SQL Server inneholder alle hurtigreparasjonene og alle sikkerhetsreparasjoner som fulgte med den forrige kumulative oppdateringen. Sjekk ut de nyeste kumulative oppdateringene for SQL Server:

Nyeste kumulative oppdateringen for SQL Server-2017

Nyeste kumulative oppdateringen for SQL Server-2016

Status

Microsoft har bekreftet at dette er et problem i Microsoft-produktene som er oppført i delen "Gjelder for".
 

Kallstakk: 0:005> k # Child-SP          RetAddr           Call Site 00 (Inline Function) --------`-------- msmdsrv_7ff69adc0000!PFVectorBase<PFValue,PFVectorSupport::PFVectorValueNoResetManip>::Add  01 (Inline Function) --------`-------- msmdsrv_7ff69adc0000!PFVectorBase<PFValue,PFVectorSupport::PFVectorValueNoResetManip>::Add  02 00000047`2c77c660 00007ff6`9bb01a2a msmdsrv_7ff69adc0000!XLAggImpl_XNPV::AddRecordToVector+0x2a  03 00000047`2c77c6a0 00007ff6`9bb04f32 msmdsrv_7ff69adc0000!XLAggImpl_XNPV::Accumulate+0x3a  04 00000047`2c77c6d0 00007ff6`9bb03a3e msmdsrv_7ff69adc0000!XLAggEngine<XLAggImpl_XNPV,0>::AggregateImpl<0>+0xfc2  05 00000047`2c77c890 00007ff6`9bb07b98 msmdsrv_7ff69adc0000!XLAggEngine<XLAggImpl_XNPV,0>::Aggregate+0xe  06 00000047`2c77c8d0 00007ff6`9b9cfb47 msmdsrv_7ff69adc0000!XLScaLogOp_XIRR::MakeLookupPhyOp+0x348  07 00000047`2c77c9a0 00007ff6`9b9cfab1 msmdsrv_7ff69adc0000!XLScaLogOp::GetLookupPhyOpImpl+0x38  08 00000047`2c77ca10 00007ff6`9b9f62d8 msmdsrv_7ff69adc0000!XLScaLogOp::GetLookupPhyOp+0x32  09 00000047`2c77ca50 00007ff6`9b9cfb47 msmdsrv_7ff69adc0000!XLScaLogOp_ISERROR<tyBOOL,tyANY>::CreateLookupPhyOp+0x89  0a 00000047`2c77cab0 00007ff6`9b9d0bf6 msmdsrv_7ff69adc0000!XLScaLogOp::GetLookupPhyOpImpl+0x38  0b (Inline Function) --------`-------- msmdsrv_7ff69adc0000!XLScaLogOp::GetLookupPhyOp+0x1c  0c 00000047`2c77cb20 00007ff6`9b9d008f msmdsrv_7ff69adc0000!XLScaLogOp::BuildIterFromLookup<1,0>+0x146  0d 00000047`2c77cb90 00007ff6`9b9cfe38 msmdsrv_7ff69adc0000!XLScaLogOp::GetScaIterPhyOpImpl+0x1df  0e 00000047`2c77cc30 00007ff6`9bcd8635 msmdsrv_7ff69adc0000!XLScaLogOp::GetScaIterPhyOp+0x39  0f 00000047`2c77cc80 00007ff6`9bcd87e8 msmdsrv_7ff69adc0000!XLIterPhyOp_Cond::Init+0xc6  10 00000047`2c77cce0 00007ff6`9b9b0d8a msmdsrv_7ff69adc0000!XLRelLogOp_Cond::MakeIterPhyOp+0xd8  11 00000047`2c77cd60 00007ff6`9b9b0ce1 msmdsrv_7ff69adc0000!XLRelLogOp::GetIterPhyOpImpl+0x4b  12 00000047`2c77cdc0 00007ff6`9b9b2226 msmdsrv_7ff69adc0000!XLRelLogOp::GetIterPhyOp+0x32  13 00000047`2c77ce00 00007ff6`9bbd7a8d msmdsrv_7ff69adc0000!XLRelLogOp::GetIterPhyOp+0x77  14 00000047`2c77cec0 00007ff6`9ba3916d msmdsrv_7ff69adc0000!XLApplyIterBuilder<1,1,0>::Build+0x5fd  15 (Inline Function) --------`-------- msmdsrv_7ff69adc0000!XLApplyIterBuilder<0,1,0>::BuildIterPhyOp+0xa9  16 00000047`2c77d000 00007ff6`9b9d0bd2 msmdsrv_7ff69adc0000!XLHyperspace::BuildIterPhyOp+0xfd  17 00000047`2c77d080 00007ff6`9b9d008f msmdsrv_7ff69adc0000!XLScaLogOp::BuildIterFromLookup<1,0>+0x122  18 00000047`2c77d0f0 00007ff6`9b9cfe38 msmdsrv_7ff69adc0000!XLScaLogOp::GetScaIterPhyOpImpl+0x1df  19 00000047`2c77d190 00007ff6`9bcda372 msmdsrv_7ff69adc0000!XLScaLogOp::GetScaIterPhyOp+0x39  1a 00000047`2c77d1e0 00007ff6`9bcda4db msmdsrv_7ff69adc0000!XLScaLogOp_Cond::MakeBranchIterPhyOp+0xa3  1b 00000047`2c77d240 00007ff6`9b9cff7c msmdsrv_7ff69adc0000!XLScaLogOp_Cond::MakeScaIterPhyOp+0x11c  1c 00000047`2c77d2b0 00007ff6`9b9d7d4b msmdsrv_7ff69adc0000!XLScaLogOp::GetScaIterPhyOpImpl+0xcc  1d (Inline Function) --------`-------- msmdsrv_7ff69adc0000!XLScaLogOp::GetScaIterPhyOp+0x34  1e 00000047`2c77d350 00007ff6`9b9d7ad8 msmdsrv_7ff69adc0000!MDScaIterPhyOp_XL::Init+0x1fb  1f 00000047`2c77d3c0 00007ff6`9aebcce8 msmdsrv_7ff69adc0000!MDScaLogOp_XL::MakeIterPhyOp+0x1c8  20 00000047`2c77d430 00007ff6`9aebfefd msmdsrv_7ff69adc0000!MDLogOp<tyScalar>::GetIterPhyOp+0x36e  21 00000047`2c77d510 00007ff6`9aebfd68 msmdsrv_7ff69adc0000!MDCalcCoverItem::AggregateMerge+0x22a  22 00000047`2c77d610 00007ff6`9af213b6 msmdsrv_7ff69adc0000!MDCalcCover::RunExecPlan+0x5f9  23 00000047`2c77d810 00007ff6`9af2134e msmdsrv_7ff69adc0000!MDCalcCover::FinalizeCoverNonEmpty+0x8a  24 00000047`2c77d860 00007ff6`9aeaedaa msmdsrv_7ff69adc0000!MDNonEmptyCalc::ExecuteExpressNonEmpty+0x1d65  25 00000047`2c77dc00 00007ff6`9af2114a msmdsrv_7ff69adc0000!MDNonEmptyWrapper::ExecuteExpressNonEmpty+0x15b  26 00000047`2c77e310 00007ff6`9af210e5 msmdsrv_7ff69adc0000!MDSelect::ExecuteExpressNonEmpty+0x912  27 00000047`2c77e510 00007ff6`9ae22869 msmdsrv_7ff69adc0000!MDSelect::Execute+0x870  28 00000047`2c77e6a0 00007ff6`9ae37c36 msmdsrv_7ff69adc0000!PCDMLSelect::Execute+0x34c  29 00000047`2c77ea00 00007ff6`9ae372eb msmdsrv_7ff69adc0000!PCASTDMLRootNode::DispatchExecute+0x5680  2a 00000047`2c77f100 00007ff6`9ae36fad msmdsrv_7ff69adc0000!PCDMLStatement::Dispatch+0x821  2b 00000047`2c77f2a0 00007ff6`9ae368f2 msmdsrv_7ff69adc0000!PCXAExecute::Dispatch+0x144a  2c 00000047`2c77f560 00007ff6`9ae3a3bd msmdsrv_7ff69adc0000!PXSession::InternalExecuteCommand+0xc8b  2d 00000047`2c77f840 00007ff6`9ae3a4ab msmdsrv_7ff69adc0000!PCSession::ExecuteCommand+0x9d  2e 00000047`2c77f9c0 00007ff6`9ae3acbf msmdsrv_7ff69adc0000!PCClientRequestHolder::ExecuteRequest+0xc9  2f 00000047`2c77fa50 00007ff6`9adc97fd msmdsrv_7ff69adc0000!PCRequestHolder::ExecuteTask+0x165  30 00000047`2c77fbd0 00007ff6`9adc5212 msmdsrv_7ff69adc0000!PFThreadPool::ExecuteJob+0x25c  31 00000047`2c77fd00 00007ff6`9add69b0 msmdsrv_7ff69adc0000!PFThreadPool::WorkerMethod+0x2ca  32 00000047`2c77fe10 00007ff6`9add6965 msmdsrv_7ff69adc0000!PFParsingShortThreadPool::ThreadProc+0x21  33 00000047`2c77fe40 00007ffd`64b24f87 msmdsrv_7ff69adc0000!PFThreadPool::ThreadProcWrapperForPFThreadPool+0x25  34 00000047`2c77fe70 00007ffd`64b2512e msvcr120!_callthreadstartex+0x17  35 00000047`2c77fea0 00007ffd`74568364 msvcr120!_threadstartex+0x102  36 00000047`2c77fed0 00007ffd`749970d1 kernel32!BaseThreadInitThunk+0x14  37 00000047`2c77ff00 00000000`00000000 ntdll!RtlUserThreadStart+0x21

Referanser

Lær mer om terminologiensom Microsoft bruker til å beskrive oppdateringer av programvare.

LAG: v-fmeng
Author: 
Writer: v-madora
Teknisk redaktør: v-kaac; scottzho; hagotur; v-fmeng;
Redaktør: v-idsun

Trenger du mer hjelp?

Utvid ferdighetene dine
Utforsk opplæring
Vær først ute med de nye funksjonene
Bli med i Microsoft Insiders

Var denne informasjonen nyttig?

Takk for tilbakemeldingen!

Takk for tilbakemeldingen! Det høres ut som det kan være lurt å sette deg i kontakt med én av våre Office-kundestøtteagenter.

×