SQL Server losts Data

Doode
Doode Member Posts: 6
edited 2005-03-22 in NAV/Navision Classic Client
Hi Forum,

we have got some problems with our SQL-Server Testing System.

3 Navision Developers working simultaneous on several Customer Testing Databases. The Problem ist that sometimes the SQL Server losts the changes they made i.e. a Developer reported that he makes changes at some objects in 3 tables last morning (7:30am). 2 hours later ALL changes were lost. 8-[

This happens very unregular (one time all 2 days)

How could it be???

Here´s the configuration:

- SQL Server 2000 standard installation on Windows Server 2003 Standard
- Navision Client 4.0 for SQL Server

Thanks for your help

Comments

  • kine
    kine Member Posts: 12,562
    Mainly it is report or codeunit? Problems are hidden in the objects cache... you open databse, use some objects... they are in your object cache... some other change the object, you change object from your cache, save and you overwrite others changes... may be that is why you lost your changes... or someone export the object into text, make some changes and import it back - but between someone make some changes in the same object... :-) you must coordinate the changes, if more developers are working on same database...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Doode
    Doode Member Posts: 6
    @kine

    thx for your reply

    when the changes were lost only 1 Developer used the SQL Server.

    concurrent use could not cause the problem :(

    I dont have any ideas... :-k
  • ara3n
    ara3n Member Posts: 9,258
    He might have two instances of the report open. Saved the first one he worked on. Then saved the one is wasn't working on.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Sorcerer
    Sorcerer Member Posts: 107
    is the server time the same as the time on the clients?
  • Doode
    Doode Member Posts: 6
    @ara3n

    unfortunately only 1 instance were open when he made the changes... :(

    @sorcerer

    the server and client time is exactly the same - i proved it
  • PaddyMullaney
    PaddyMullaney Member Posts: 59
    Have you set all object cache to 0 on all the clients to specifically elimintae this posssibility?
  • Doode
    Doode Member Posts: 6
    our Navision Developer himself had the idea to deactivate the object-cache on the concerning workstations -> no improvement

    i dont think its a client problem :-k
  • Doode
    Doode Member Posts: 6
    it happened again:

    here is the report of our developer:

    - made the changes

    - only 1 client were open

    - the object that was changed was only opened once

    - the object was correct saved and compiled

    - immediately after saving i did some successful tests

    - no other user used or changed the object

    - i worked on the same computer

    - between development and test the client stay opened

    After 45 minutes all changes were lost..... :(

    can anyone help :?:
  • ara3n
    ara3n Member Posts: 9,258
    I've been developing on SQL with several developers for the last 2 years at same time on same server. on windows 2000, windows 2003. Never seen this problem. My guess the developer is either lying, or he is overwritting.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Sorcerer
    Sorcerer Member Posts: 107
    no, we had this problem too.
    but not on sql but native database.

    it didn't happen every day but some times in amonth...

    but i dont know what exactly caused this bug...
    up to now i thought it was a diferent time between
    server / client...

Categories