Toad World® Forums

Problem with Log Reader of TOAD 5.8.0.833


#1

Last beta version of TOAD 5.8.
I create a test DB in full recovery mode.
This DB contains only one table with about 1500 records.
I open editor and execute a delete statement to delete one record. I delete record with field codice = 11537.
At this point I open your Log Reader and I try to undo my delete/transaction.
In attach a script of the table ANAGRAFICA_ARTICOLI. The script is CREATE_TABLE.SQL .
All is OK.
I found the correct transaction with delete statement and I try to undo it with log reader wizard.
At the end of the wizard, I obtain an error when log Reader execute the script generated.
See my JPG in attach for details.

Have you some idea about this ?

Best regards.

Sergio Bertolotti

create_table.sql (1.02 KB)

errore_log_reader.jpeg


#2

I found the problem.
The error in insert statement was generate by the value of field [ULTMOD].

The correct value is N’20111206 12:47:18:000’.
The wrong value is N’20111206 12.47.18.000’.

If I change the value in the insert with the correct value all is OK.

I stay tune for your consideration about this…

Best regards.

Sergio Bertolotti


#3

At the endof the story I found my problem.
In attach sdcreenshot of regional settings of my notebook.
As you can see hour formatr is H.mm.ss.
I change this to HH:mm:ss and now it’s OK.

I never change this value/parameter on my system.
I use Microsoft Vista Business with service pack 2 plus last windows update in italian language and I don’t know why this parameter is set on H.mm.ss .

I hope tis can be helpfull for you.

I stay tune for your consederation about this.

Best regards.

Sergio Bertolotti
regional_settings.jpeg


#4

Last beta version of TOAD SS 6.0.0.123.

The problem is still present.

The correct value is N’20111206 12:47:18.000’.
The wrong value is N’20111206 12.47.18.000’.

If I change the value in the insert with the correct value all is OK.

I stay tune for your answer.

Best regards.

Sergio Bertolotti