MP down

[=gRiJ=Petr]

Hi,

Everything was fine with the planner until just an few hours ago. Suddenly the MP doesn't want to load the requested map. It stops at:

Commander Administrator, please wait. We are gathering the latest intelligence from Administration HQ ...

And there is DONE with exclamation mark in the bottom left corner.
Details of the error are:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2)
Timestamp: Tue, 29 Jun 2010 21:35:01 UTC


Message: Expected '}'
Line: 12395
Char: 3
Code: 0
URI: http://petr.servegame.org/seow/mp4/Scripts/MP-Head.js


Message: 'NCurrentMissions' is undefined
Line: 34
Char: 10
Code: 0
URI: http://petr.servegame.org/seow/mp4/Scripts/MP-Body.js

AND:
Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2)
Timestamp: Tue, 29 Jun 2010 21:35:20 UTC


Message: Expected '}'
Line: 12395
Char: 3
Code: 0
URI: http://petr.servegame.org/seow/mp4/Scripts/MP-Head.js


Message: 'NCurrentMissions' is undefined
Line: 34
Char: 10
Code: 0
URI: http://petr.servegame.org/seow/mp4/Scripts/MP-Body.js

Anyone?
Thanks!
Cheers,
Petr

[IV/JG7_4Shades]

Hi Petr

Probably someone added a pilot report or a flight plan with a strange character in the text. Open Pilot_Reports table and look for quote characters, brackets etc. Also look at briefings in the latest GroupMissionData records.

Cheers,
4S

[=gRiJ=Petr]

Hi Shades,

The Pilot_recon_reports table is empty.
In the groupmission table I deleted all briefings I could find. There were no briefings for the current mission 16h hours. Some were there for previous mission and the text is Polish. I deleted that but no result.

Thanks!
Cheers,
Petr

[IV/JG7_4Shades]

Hmm. Well someone did something to the DB (directly or via the MP) that has caused the error. THat's all I can offer at the moment, I'm sorry.

Cheers,
4S

[=gRiJ=Petr]

No problem, I have a working backup from just after the last analyze.Will restore and we'll start over. I'll keep a copy of the problem DB so you can analyze afterwards if you want to.

Thanks! Enjoy Europe!
Cheers,
Petr

[=gRiJ=Petr]

After the restore last time everything went well.

Now, a mission later the same error

Just took a backup and then deleted everything in the groupmission table but to no effect.

HELP! Mission is tonight!

[=gRiJ=Petr]

Hi Shades,

I found the problem but have no idea of the cause.
I got the MP back by deleting the last mission planned in the Objectmissiondata and the newwaypoints tables.
It was a mission which ended in a Withdraw, so I deleted the entry for that mission in the Withdrawels table as well.

After that, MP works again.
No clue what caused it though. No brief or anything. I do have a backup of the DB with the problem in case you want to debug...

Cheers,
Petr