Delete Change Log Entries

amphysvena
amphysvena Member Posts: 113
edited 2008-07-23 in NAV/Navision Classic Client
Hi,
We're planning to delete the change log entries data, & we're now using report 510 - Change Log - Delete
The problem is, every time we run the report, it will than show error message after a period of time. The error message is:

The following ODBC error occurred:
Error: [Miscrosoft][ODBC SQL Server Driver]Unspecified error occurred on SQL Server. Connection may have been terminated by the server.
State ID: HY000

Even if we only delete 1 day data, it still shows the error.
How to fix this?
Can I just delete it manually? Open the table, filter then delete the data?
Thx

Comments

  • Tomas
    Tomas Member Posts: 420
    Yes, you can delete them from the Change Log Entry table.
    Tomas,
    Dynamics NAV Enthusiast
  • amphysvena
    amphysvena Member Posts: 113
    Ok, I'll delete the data from table. Wonder if there is any side effect.
    But, i'm still curious, why the error appear?
    greatly thanks for the reply
  • bergoulle
    bergoulle Member Posts: 23
    amphysvena wrote:
    Ok, I'll delete the data from table. Wonder if there is any side effect.
    But, i'm still curious, why the error appear?
    greatly thanks for the reply

    May be the transaction log file.
    You could be running out of space where the transaction log file is locate on your disk or
    you might have a limitation size on this file.
  • amphysvena
    amphysvena Member Posts: 113
    I have limited access to the server. But I guess the drive C is out of space. So the error occurred. Anyway, I already delete the change log manually.
    Thanks for all the replies.

Categories