none
Error: Profiler cannot Save the result trace to a table

    Question

  • I use profiler to replay a trace  and save the replay result as a trace file. I open the result trace file, when i try to save the trace file to a table. profiler report a error message:

    Failed to save table SQLPOD069-05.traceresult_oledb.test

    Multiple-step OLE DB operation generated errors, Check each OLE DB status value, if available. No work was done.

    what's the meaning of this kind of error message? How to fix it?

    THX

    Monday, February 09, 2009 9:05 AM

Answers

  • Hi Jet,

    It works in my machine to save a replay result file as table.

    For the issue you mentioned, I guess the result file you are using is not the final result file, but a result file from one replay client. Before the result trace files are merged into the final one, they have an extra column in it (which is used for merging, and doesn't exist in the final merged result), and that may cause your saving_as_table fail.

    If this is the reason, please use the final merged result file.

    Thanks,
    Elton
    Elton
    • Marked as answer by Jet Li - MSFT Monday, February 16, 2009 1:52 AM
    Tuesday, February 10, 2009 6:29 AM