We have a customer getting '0.0' is not a valid timestamp error.  We've tracked it down to a few corrupted records in the LogEvents table.  What options do I have to repair the table or delete the offending records?  Trying to delete through EDB Manager tells me I'm trying to update a read-only cursor.

Alan


If you're talking about the built in LogEvents table then, as far as I know, there are no facilities for editing it - its purely a system maintained file.

What you can do is delete it totally. However, I'd recommend taking a copy first and sending to Tim because since its a system maintained file it shouldn't have invalid entries

The file to delete is EDBConfig.EDBLog

You'll need everyone off the system first, and any server shut down.

If its not the system LogEvents table then we need more info.

Roy Lambert

Thanks Roy.  Deleting EDBConfig.EDBLog took care of it.