SSIS CDC state User::CDC_State is not well structured

This post shows one of the possibilities to resolve the error “SSIS CDC state User::CDC_State is not well structured”.

This full error as below. This happen in your CDC Source normally.

I[Shipper CDC Records [20]] Error: System.Exception: Value ILUPDATE/CE/0x00000031000001D80001/IR/Ox00000031000001650002//TS/2018-03-15T11:40:15.3532021/ of CDC state User::CDC_State is not well structured. Structure must be – logicalName(required)/[CS//] (optional)[CE/cce-lsn>/](optional)[IRcir-start>/cir-end>/](optional)/[TS/timestamp/](optional) [ER/cerror-message>/](optional). at Attunity.SqlServer.CDCSrc.CdcSourceComponent.PrimeOutput(Int32 outputs, Int32[] outputlDs, PipelineBuffer[] buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput (IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputlDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)

If you go to check your CDC_State table you likely to see the state started with.

ILUPDATE

You need your CDC state start with

ILEND…

Most likely you do not have a CDC Control Task set CDC control operation to Mark initial load end .

稿源:Chanmingman's Blog (源链) | 关于 | 阅读提示

本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » 后端存储 » SSIS CDC state User::CDC_State is not well structured

喜欢 (0)or分享给?

专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录