Failure connection during analysing

[PA-Dore]

First scuse my english language

I had a problem during analysing a mission, my connection failed. I was unable to close DCS. I reboot my computer and reopen DCS. The mission was still in "Build next mission" but on line I saw the pilot's result correctly.
I clic again on "Analyse last mission". I had 1 or 2 errors messages but analysing seemed correct ( Mission appears like analysed).
In statistics, pilot's results appears now (of course) 2 times:
Mission results
Is it possible to correct directly in database?

[IV/JG7_4Shades]

Hi Dore,

You need to edit ActionData, PilotScores, PilotMissionData, PilotMissionDisposition, ObjMissionDisposition tables for mission 'SE-Crimee-194108020900.mis' and remove any duplicate records. Keep a backup of the tables so you can restore things if you make an error.

Cheers,
4Shades

[PA-Dore]

Thanks too much 4Shades !!
4shades' Compagny: The best and quickiest after-sale in the World

[PA-Dore]

Sorry to disturb you again for this problem:
I checked ActionData, PilotScores, PilotMissionData, PilotMissionDisposition, ObjMissionDisposition tables.
All data were OK.
I think only the statistics tool took twice the data.
For example:
One pilot shot down 3 planes in this mission
- In Pilot_Scores table we have 3 Enemy_Aircraft --> OK
1640 Fire_Bullets
- In Statistics we have 6 planes and 1640 bullets.

When I analysed twice the mission, I think only the statistics tool added 3+3 planes....

I don't know how to proceed to correct...

[IV/JG7_4Shades]

Hi Dore,

Check MissionData table for a duplicate entry. You might also check ObjMissionData, but I doubt there would be duplicates there.

Cheers,
4Shades

[PA-Dore]

In MissionData table I have only:
Mission Name
Duration
Mis_Time
Host
Theatre
Map
Mis_Nbr
Mis_Date
Mis_Commencement