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/<cs-lsn>/] (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.

Advertisements
Posted in .Net, Cloud, Community, Computers and Internet | Tagged , , , | Leave a comment

Find the files created or modified on this week in Windows 10

This is quick tip on how to the files created or modified on this week in Windows 10.

Open Windows Explorer, click on the Search textbox, click on Date modified, click on This week.

Posted in Cloud, Community, Computers and Internet, Operating System | Tagged , | Leave a comment

Microsoft Paint vs Paint 3D

This is one of the features that I found in Paint 3D but not in Paint.

In Paint Zoom is nightmare.


You cannot zoom to the percentage you want.

In Paint 3D you can zoom to the percentage you like.

Posted in Cloud, Community, Computers and Internet | Tagged , , , | Leave a comment

C# Find the last Day of Week of the month

This blog gives the complete code of finding the Last Day of Week of the Month for example, Thursday, Saturday, and so.

The idea of this post from forum, https://stackoverflow.com/questions/24245523/getting-the-first-and-last-day-of-a-month-using-a-given-datetime-object, is good but it only has the code snippet. I bet they are half or more than half of the reader after reading it, and yet to know how to code. Again what is var there in the post?

To complete shows in the code below. You will get actually the day.

static void Main(string[] args)

{

  DateTime dte = GetLastDayOfMonth();

  Console.WriteLine(“The last day of this moeth is {0}”, dte.DayOfWeek);

}

public static DateTime GetLastDayOfMonth()

{

  DateTime date = DateTime.Now;

  DateTime firstDayOfMonth = new DateTime(date.Year, date.Month, 1);

  var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1);

  return lastDayOfMonth;

}

Posted in .Net, Community, Computers and Internet | Tagged , | Leave a comment

SSMS Insufficient memory to continue the execution of the program

This blog provides one of the ways to resolve the error “Cannot execute script: Insufficient memory to continue the execution of the program” when you are using SQL Server Management Studio.

Both of my SQL Server 2014 and SQL Server 2016 Management Studio error.

SQL Server 2014 Management Studio shows Insufficient memory to continue the execution of the program.

SQL Server 2016 Management Studio shows System.OutOfMemoryException.


There is no way to resolve this in SQL Server Management Studio.

You need to start your command prompt to run the command like below.

SQLCMD -d <database-name> -i filename.sql

Posted in .Net, Cloud, Community, Computers and Internet, Servers | Tagged , , | Leave a comment

Windows Server search file contents grey

This post shows you one of the possibilities to enable the Files contents search in Windows Server. As you can see from the below picture the File contents is grey.


Go to Server Manager in Windows Server. Click Add Roles and features.


Select Windows Search Service in Add Roles and Features Wizard.


Restart your server. Go to Windows Explorer. Select View, Options, check the Always search file names and contents.


You should be able to search contents now.

Posted in .Net, Community, Computers and Internet, Operating System | Tagged , | Leave a comment

Control Internet bandwidth for Windows 10 update

In the past Windows 10 will take up whatever bandwidth you have for Windows 10. In version 1709 you can set how much bandwidth you want to allocate for Windows 10 update. This blog post shows you how to control the internet bandwidth for Windows 10 update.

1. Click Start.

2. Just type Settings after you click Start button. Click on Settings.

3. Click Update & Security.

4. Click on “Advanced options (link)” in “Settings”.

5. Scroll down. Click on “Delivery Optimization (link)” in “Settings”

6. Click on “Advanced options (link)” in “Settings”.

You can now set the bandwidth.

Not too sure when will Microsoft change the location of bandwidth setting or even remove it. In 1709 this is the way.

Posted in .Net, Community, Computers and Internet, Operating System | Tagged , | Leave a comment