SQL Server losts Data

Doode

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

kine

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...

Doode

@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

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.

Sorcerer

is the server time the same as the time on the clients?

Doode

@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

Have you set all object cache to 0 on all the clients to specifically elimintae this posssibility?

Doode

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

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

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.

Sorcerer

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...