SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED - State is not well structured

Опубликовано: 21 Февраль 2025
на канале: ramit girdhar
12,630
19

Error: 0x4002F304 at Data Flow Task 1, CDC Source [2]: "Value ILUPDATE/CE/0x00000026000001380001/IR/0x0000002500000ED00002//TS/2019-09-05T13:43:16.0600688/ of CDC state User::CDC_State is not well structured. Structure must be - logicalName(required)/[CS/cs-lsn/](optional)[CE/ce-lsn/](optional)[IRir-start/ir-end/](optional)/[TS/timestamp/](optional)[ER/error-message/](optional).".
Error: 0xC0047062 at Data Flow Task 1, CDC Source [2]: System.Exception: Value ILUPDATE/CE/0x00000026000001380001/IR/0x0000002500000ED00002//TS/2019-09-05T13:43:16.0600688/ of CDC state User::CDC_State is not well structured. Structure must be - logicalName(required)/[CS/cs-lsn/](optional)[CE/ce-lsn/](optional)[IRir-start/ir-end/](optional)/[TS/timestamp/](optional)[ER/error-message/](optional).
at Attunity.SqlServer.CDCSrc.CdcSourceComponent.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)
Error: 0xC0047038 at Data Flow Task 1, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on CDC Source returned error code 0x80131500. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.