ReTrace utility not importing the trace file

• Divine Flame

  SSCoach

  Points: 15943

  More actions

  August 1, 2013 at 9:28 am

  #278164

  Hi Friends,

  I am trying to analyze a trace file using ReTrace utility. However, it is not able to import the trace file to database.

  Errors reported by the tool are given below:

  ----------------------------

  Error running query: IF NOT EXISTS (SELECT * FROM TraceStats)

  INSERT INTO TraceStats VALUES (null, null, null, null);

  UPDATE TraceStats SET StartTime = @StartTime WHERE StartTime IS NULL OR StartTime > @StartTime;

  UPDATE TraceStats SET EndTime = @EndTime WHERE EndTime IS NULL OR EndTime < @EndTime;

  UPDATE TraceStats SET StartSequence = @StartSequence WHERE StartSequence IS NULL OR StartSequence < @StartSequence;

  UPDATE TraceStats SET EndSequence = @EndSequence WHERE EndSequence IS NULL OR EndSequence < @EndSequence;

  ----------------------------

  Error importing trace file MyTraceFile.trc.

  Exception: System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

  Any help is appreciated :-).

  ---

  Sujeet Singh

• Sean Smith

  SSCertifiable

  Points: 5941

  More actions

  August 6, 2013 at 9:59 am

  #1639004

  Sounds like it's trying to import a date value which is not within a valid range. Unfortunately I don't really know the tool so it's hard to say.