Page 1 of 1

Failure connection during analysing

Posted: Sat 24 May 2008 8:46 am
by 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?

Posted: Sat 24 May 2008 9:42 am
by 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

Posted: Sat 24 May 2008 9:44 am
by PA-Dore
Thanks too much 4Shades !!
4shades' Compagny: The best and quickiest after-sale in the World :lol:

Posted: Wed 09 Jul 2008 2:39 pm
by 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...

Posted: Wed 09 Jul 2008 9:19 pm
by 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

Posted: Thu 10 Jul 2008 4:30 am
by PA-Dore
In MissionData table I have only:
Mission Name
Duration
Mis_Time
Host
Theatre
Map
Mis_Nbr
Mis_Date
Mis_Commencement