Windows Login Table crashes NAV

corocoric
corocoric Member Posts: 5
edited 2009-10-22 in NAV/Navision Classic Client
Hi ever1,

I have this wierd problem. I managed to insert some wierd value into the Windows Login table, field SID, value: "a"

Now whatever I try to do with this record NAV crashes, I tried to delete, change field to valid SID value, delete whole table, change the field proporties, change with a report etc.. After the restart of the client, it is recovering the DB.

We use: NAV 5.0 SP1
Native DB

pls help :)

Comments

  • corocoric
    corocoric Member Posts: 5
    Crashes also in Cronus 5.0 SP1 :((
  • matttrax
    matttrax Member Posts: 2,309
    Try taking a backup, but don't include the "Data Common to All Companies". Restoring that should give you a database without any logins in it.

    Of course there may be some side effects if you've changed tables to not be company specific. You'll definitely want to go through your data to validate it and test functionality.

    Perhaps someone else can add to this as I deal almost exclusively with SQL.
    Matt Traxinger - ArcherPoint
  • corocoric
    corocoric Member Posts: 5
    This is a shared table of course :( and I cannot make it data per company before its emptyyy :)
  • kapamarou
    kapamarou Member Posts: 1,152
    IF you are a developer:

    Take a copy of your database.
    On the new copy:

    Create a new blank form. Declare rec1 as Record, Windows Login.

    Go to onopen trigger.

    Write:

    rec1.SETRANGE(ID,'a');
    IF rec1.FINDFIRST THEN
    rec1.DELETE;

    Hit Ctrl-R to run temporarily the form.

    Test thoroughly your "Test" database to see if everything is ok...
  • matttrax
    matttrax Member Posts: 2,309
    corocoric wrote:
    This is a shared table of course :( and I cannot make it data per company before its emptyyy :)

    You don't need to change the table definition. You should be able to take a backup, but exclude the table by unchecking the "Include Data Common to All Companies" checkbox on the backup form (Tools --> Backup).
    Matt Traxinger - ArcherPoint
  • corocoric
    corocoric Member Posts: 5
    @kapamarou: I tried this but it still crashes, it looks like this is embedded inside the client or somewhere else.. Under SQL, i can delete rows without problems..

    @matttrax: after restore the data is still there..

    for time sake, im just gone put my backup back on..maybe it should be reported to Microsoft?

Categories