Korriger: "Invoke-sqlcmd" cmdlet utfører-setningen for en spørring flere ganger hvis det oppstår en feil i SQL Server-2014 eller 2016

Bug #: 9503260 (sqlbuvsts01)
Feil #: 59255 (innhold idé)
Feil #: 57752 (innhold idé)

Symptomer

Du kan bruke cmdleten Start-sqlcmd for å utføre en spørring-setning i en forekomst av SQL Server-2014 eller 2016. Imidlertid Hvis kjøring av mislykkes på grunn av en feil, utføres spørringssetningen flere ganger.

Løsning

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

Kumulativ oppdatering 5 for SQL Server 2016 RTM

Samleoppdatering 2 for SQL Server 2016 SP1

Kumulativ oppdatering 4 for SQL Server 2014 Service Pack 2

 

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-2016

Nyeste kumulative oppdateringen for SQL Server-2014

Status

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

 

Kallstakk


0:000 > k

# Underordnet-SP RetAddr samtale område

00 000000df '2484dc58 00007ffa' 6ea92817Microsoft_SqlServer_Management_PSSnapins! Microsoft.SqlServer.Management.PowerShell.ExecutionProcessor.ExecuteBatch(System.String)

Advarsel: Kan ikke bekrefte kontrollsum-formicrosoft.sqlserver.batchparser.ni.dll

01 000000df '2484dc60 00007ffa' 7f22a226Microsoft_SqlServer_Management_PSSnapins! Microsoft.SqlServer.Management.PowerShell.ExecutionProcessor.ProcessBatch (System.String,Int32) + 0x77

02 000000df '2484dcc0 00007ffa' cd5f21femicrosoft_sqlserver_batchparser_ni! < modul >. BatchParser.ThunkCommandExecuter.ProcessBatch (BatchParser.ThunkCommandExecuter*,UInt16*, Int32) + 0x56

03 000000df '2484dd10 00007ffa' 6e04e92a clr! UMThunkStub + 0x6e

04 000000df '2484dda0 00007ffa' 7f223ab4microsoft_sqlserver_batchparser_ni! DomainNeutralILStubClass.IL_STUB_PInvoke (Int32 IntPtr, UInt16 *) + 0x7a

05 000000df '2484de50 00007ffa' 7f22268emicrosoft_sqlserver_batchparser_ni! < modul >. BatchParser.ExecutionContext.ProcessWhatsLeftInBatch (BatchParser.ExecutionContext*) + 0x84

06 000000df '2484def0 00007ffa' 7f232ca8microsoft_sqlserver_batchparser_ni! < modul >. BatchParser.BatchParserInternal.Parse (BatchParser.BatchParserInternal*,BatchParser.ParserState*, boolsk) + 0xce

07 000000df '2484e020 00007ffa' 6ea92634microsoft_sqlserver_batchparser_ni! ManagedBatchParser.Parser.Parse () + 0x38

08 000000df '2484e280 00007ffa' 6e04ac76Microsoft_SqlServer_Management_PSSnapins! Microsoft.SqlServer.Management.PowerShell.ExecutionProcessor.ExecuteTSql (System.String) + 0xf4

Advarsel: Kan ikke bekrefte kontrollsum-forsystem.management.automation.ni.dll

09 000000df '2484e2e0 00007ffa' 90eaa8c0Microsoft_SqlServer_Management_PSSnapins! Microsoft.SqlServer.Management.PowerShell.GetScriptCommand.ProcessRecord () + 0x2b6

0a 000000df`2484e330 00007ffa`90e85879system_management_automation_ni!System.Management.Automation.CommandProcessor.ProcessRecord()+0x360

0b 000000df`2484e3c0 00007ffa`91955cdesystem_management_automation_ni!System.Management.Automation.CommandProcessorBase.DoExecute()+0x59

0c 000000df`2484e400 00007ffa`90e42010system_management_automation_ni!System.Management.Automation.Internal.PipelineProcessor.SynchronousExecuteEnumerate(System.Object)+0x15e

0d 000000df '2484e490 00007ffa' 90ea70e6 system_management_automation_ni! System.Management.Automation.PipelineOps.InvokePipeline(System.Object,Boolean, System.Management.Automation.CommandParameterInternal,System.Management.Automation.Language.CommandBaseAst,System.Management.Automation.CommandRedirection,System.Management.Automation.Language.FunctionContext)+0x340

0e 000000df`2484e520 00007ffa`90e8838bsystem_management_automation_ni!System.Management.Automation.Interpreter.ActionCallInstruction`6,,,,,].Run(System.Management.Automation.Interpreter.InterpretedFrame)+0x1b6

0f 000000df`2484e5d0 00007ffa`90e8838bsystem_management_automation_ni!System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(System.Management.Automation.Interpreter.InterpretedFrame)+0xdb

10 000000df '2484e660 00007ffa' 90e88251system_management_automation_ni! System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run (System.Management.Automation.Interpreter.InterpretedFrame) + 0xdb

11 000000df '2484e6f0 00007ffa' 90e790a7 system_management_automation_ni! System.Management.Automation.Interpreter.Interpreter.Run (System.Management.Automation.Interpreter.InterpretedFrame) + 0x31

12 000000df '2484e740 00007ffa' 90e865c1system_management_automation_ni! System.Management.Automation.Interpreter.LightLambda.RunVoid1](System.__Canon) + 0xf7

13 000000df '2484e7b0 00007ffa' 90e860absystem_management_automation_ni! System.Management.Automation.DlrScriptCommandProcessor.RunClause (System.Action'1 < System.Management.Automation.Language.FunctionContext > System.Object, System.Object)+0x3c1

14 000000df'2484e850 (00007ffa'90e85de5system_management_automation_ni!System.Management.Automation.DlrScriptCommandProcessor.Complete) + 0x1bb

15 000000df'2484e8d0 (00007ffa'90e85a70system_management_automation_ni!System.Management.Automation.CommandProcessorBase.DoComplete) + 0x105

16 000000df '2484e940 00007ffa' 91955cecsystem_management_automation_ni! System.Management.Automation.Internal.PipelineProcessor.DoCompleteCore (System.Management.Automation.CommandProcessorBase) + 0xb0

17-tommers 000000df '2484e9c0 00007ffa' 90e6afa7system_management_automation_ni! System.Management.Automation.Internal.PipelineProcessor.SynchronousExecuteEnumerate (System.Object) + 0x16c

18 000000df '2484ea50 00007ffa' 90e6a42bsystem_management_automation_ni! System.Management.Automation.Runspaces.LocalPipeline.InvokeHelper () + 0x667

19 000000df '2484eb20 00007ffa' 90db3561system_management_automation_ni! System.Management.Automation.Runspaces.LocalPipeline.InvokeThreadProc () + 0x1db

1a 000000df`2484eb90 00007ffa`bca4674e system_management_automation_ni!System.Management.Automation.Runspaces.PipelineThread.WorkerProc()+0x31

1b 000000df`2484ebc0 00007ffa`bca465e7mscorlib_ni!System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext,System.Threading.ContextCallback, System.Object, Boolean)+0x15e

1c 000000df`2484ec90 00007ffa`bca465a2mscorlib_ni!System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext,System.Threading.ContextCallback, System.Object, Boolean)+0x17

1d 000000df`2484ecc0 00007ffa`bca4d1f2mscorlib_ni!System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext,System.Threading.ContextCallback, System.Object)+0x52

1e 000000df`2484ed10 00007ffa`cd5f6a53mscorlib_ni!System.Threading.ThreadHelper.ThreadStart()+0x52

1f 000000df`2484ed50 00007ffa`cd5f6913clr!CallDescrWorkerInternal+0x83

20 000000df '2484ed90 00007ffa' cd5f7165clr! CallDescrWorkerWithHandler + 0x4e

21 000000df '2484edd0 00007ffa' cd6d4739clr! MethodDescCallSite::CallTargetWorker + 0xf8

22 (innebygd funksjon)-------clr! MethodDescCallSite::Call + 0xA

23 000000df '2484eed0 00007ffa' cd5f7819clr! ThreadNative::KickOffThread_Worker + 0x109

24 000000df '2484f130 00007ffa' cd5f7794clr! ManagedThreadBase_DispatchInner + 0x39

25 000000df '2484f170 00007ffa' cd5f76d2clr! ManagedThreadBase_DispatchMiddle + 0x6c

26 000000df '2484f270 00007ffa' cd5f7853clr! ManagedThreadBase_DispatchOuter + 0x75

27 000000df '2484f300 00007ffa' cd6d461bclr! ManagedThreadBase_FullTransitionWithAD + 0x2f

28 (innebygd funksjon)-------clr! ManagedThreadBase::KickOff + 0x20

29 000000df '2484f360 00007ffa' cd6002cfclr! ThreadNative::KickOffThread + 0xdb

2a 000000df`2484f430 00007ffa`d8608364clr!Thread::intermediateThreadProc+0x86

2b 000000df`2484faf0 00007ffa`d8f65e91 kernel32!BaseThreadInitThunk+0x14

2c 000000df`2484fb20 00000000`00000000ntdll!RtlUserThreadStart+0x21

Referanser

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

 

LAG: v-fmeng
Forfatter:
Tekstforfatter: v-thomr
Teknisk redaktør: matteot; yqsu; v-fmeng; sqlprev; daleche
Redaktør: v-rhowar

 

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.

×