SEOW Scripted Campaign - Operation Detachment v2.0

A meeting place for people running SEOW campaigns and people who want to participate in SEOW campaigns.

Moderator: SEOW Developers

gec100
Posts: 78
Joined: Fri 06 May 2011 4:55 am
Location: Zagreb, Croatia
Contact:

Post by gec100 »

checked. there is exactly 260 OD-ZZZZ records in the ObjMissionData table

so that shows we have a problem. where should i check for problems?

i have teamviewer if u'd like to connect and i've made a backup of the database so it's not a prob if u delete something.
IV/JG7_4Shades
Posts: 2211
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

Post by IV/JG7_4Shades »

Add the following line to DCSEngine-ODv2.php after the
include 'MP-Connection.php';
line:

$DEBUG=1;

That will generate debugging info that we can get to grips with.
IV/JG7_4Shades
SEOW Developer

Image
gec100
Posts: 78
Joined: Fri 06 May 2011 4:55 am
Location: Zagreb, Croatia
Contact:

Post by gec100 »

done! what next?
gec100
Posts: 78
Joined: Fri 06 May 2011 4:55 am
Location: Zagreb, Croatia
Contact:

Post by gec100 »

here is what i've got:

SEDCS::frmMain.isExecuteWebService: 5 Unable to connect to the remote server
Description : Unable to connect to the remote server

Code: Select all

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Runtime.InteropServices.ExternalException (0x800401D0): Requested Clipboard operation did not succeed.
   at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy, Int32 retryTimes, Int32 retryDelay)
   at System.Windows.Forms.Clipboard.SetText(String text, TextDataFormat format)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
SEOW-DCS-V3.3.9
    Assembly Version: 3.3.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files/Scorched%20Earth%20Online%20War%20System%20(x64h)/SEOW-DCS-V3.3.9.exe
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Interop.ADODB
    Assembly Version: 2.8.0.0
    Win32 Version: 2.8.0.0
    CodeBase: file:///C:/Program%20Files/Scorched%20Earth%20Online%20War%20System%20(x64h)/Interop.ADODB.DLL
----------------------------------------
System.Web
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_64/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
IV/JG7_4Shades
Posts: 2211
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

Post by IV/JG7_4Shades »

OK, so you have a DCS exception. I have never seen this before, so maybe you have the wrong URL in the Web Script box of the DCS?

Do you see any other DCS errors?

Cheers,
4Shades
IV/JG7_4Shades
SEOW Developer

Image
gec100
Posts: 78
Joined: Fri 06 May 2011 4:55 am
Location: Zagreb, Croatia
Contact:

Post by gec100 »

no. this is the only error that i get and it is always there on building new mission.
IV/JG7_4Shades
Posts: 2211
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

Post by IV/JG7_4Shades »

OK, well this is preventing your Operation Detachment from working properly.

Please tell me your .NET Framework version number and your MyODBC version number. Also, make sure that the DCSEngine-ODv2.php has no special user permissions that may prevent the DCS connecting to it.

Cheers,
4Shades
IV/JG7_4Shades
SEOW Developer

Image
gec100
Posts: 78
Joined: Fri 06 May 2011 4:55 am
Location: Zagreb, Croatia
Contact:

Post by gec100 »

Morning Shades.

.NET is 4.0.30319 and ODBC is 3.51.28

No special permissions are set for DCSEngine-ODv2.php

does the address needs to be outside web address or it can be file path?

ok. i think i found a problem. i'm not able to access DCSEngine-ODv2.php from the server (SDCS is on the same mashine as the web server). probably some routing or ISP firewall problem.

Need to find other way to connect to it. probably using localhost. but as i have several redirections using hosts file, not sure how to do this.
IV/JG7_4Shades
Posts: 2211
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

Post by IV/JG7_4Shades »

You might be able to use the localhost address...
Another alternative is to use a remote DCS to run your campaign.

Cheers,
4S
IV/JG7_4Shades
SEOW Developer

Image
gec100
Posts: 78
Joined: Fri 06 May 2011 4:55 am
Location: Zagreb, Croatia
Contact:

Post by gec100 »

i've added a new entry to my hosts file pointing gec.servebeer.com to my local address and i think it should work now. i was able to open DCSEngine-ODv2.php from the browser on the server.

hope that solves the problem

will see if the game will correct it self or will have to start from the beginning
gec100
Posts: 78
Joined: Fri 06 May 2011 4:55 am
Location: Zagreb, Croatia
Contact:

Post by gec100 »

here is what i get now from Debug:

Code: Select all

SEDCS::Web Service completed with the following response ... 
<span class='debug'><b>Host Architecture</b> WINNT<p></span><span class='debug'><b>SEDCS Version</b> SE_3.3.9<p></span><span class='debug'><b>Host</b> 4Shades<p></span><span class='debug'><b>Theatre</b> Operation Detachment<p></span><span class='debug'><b>Sector</b> IwoJima (Iwo Jima)<p></span><span class='debug'><b>Cycle Status</b> Analyzed<p></span><span class='debug'><b>Sequence</b> 194502191200<p></span><span class='debug'><b>Duration</b> 104<p></span><span class='debug'><b>Mission Folder</b> C:\HSFX5\Missions\Net\coop\SEOW<p></span><span class='debug'><b>Exception</b> <p></span>Latest mission = SE-Operation Detachment-194502191200.mis<br><br>IJN steamer: -70163, 61970.6, 1, 5.700000286, 194502191300<br><br>IJN steamer: GroupMissionData SQL INSERT INTO GroupMissionData(Obj_Group,Strength,Default_Ord,Default_Ord_Verbose,Default_Fuel,AIonly,Mission_Nbr,Briefing) VALUES ('IJN00',1,'default','default',100,0,'194502191300','Title: Naval Mission Continuation, 19 Feb 1945/n');<br><br>IJN steamer: NewWaypoints SQL 1INSERT INTO NewWaypoints(Mission_Nbr,Unit_Group,Way_Nbr,Way_ETA,Way_Type,Way_Y_Axis,Way_X_Axis,Way_Alt,Way_Speed,Terrain,Orientation,Delay,Reached,Target,Tgt_Way) VALUES ('194502191300','IJN00',0,'7:00','','61970.6','-70163',0,'5.700000286',0,405,0,0,'',0);<br><br>IJN steamer: NewWaypoints SQL 2INSERT INTO NewWaypoints(Mission_Nbr,Unit_Group,Way_Nbr,Way_ETA,Way_Type,Way_Y_Axis,Way_X_Axis,Way_Alt,Way_Speed,Terrain,Orientation,Delay,Reached,Target,Tgt_Way) VALUES ('194502191300','IJN00',1,'8:00','','9520','4040',0,'5.700000286',0,405,0,0,'',0);<br><br>IJN air attack: current targets SQL SELECT * FROM NewWaypoints WHERE Mission_Nbr='194502191300' AND LEFT(Unit_Group,2)='IJ' AND LEFT(Target,3)='USN'<br>Array
(
    [0] => USN75
    [1] => USN80
    [2] => USN78
    [3] => USN61
    [4] => USN83
    [5] => USN10
    [6] => USN73
    [7] => USN02
    [8] => USN77
    [9] => USN09
    [10] => USN08
    [11] => USN70
    [12] => USN14
    [13] => USN04
    [14] => USN76
    [15] => USN06
    [16] => USN67
    [17] => USN00
    [18] => USN15
    [19] => USN03
    [20] => USN66
    [21] => USN82
    [22] => USN12
    [23] => USN11
    [24] => USN13
    [25] => USN62
    [26] => UN63
    [27] => USN81
    [28] => USN72
    [29] => USN71
    [30] => USN07
    [31] => USN79
    [32] => USN65
    [33] => USN01
    [34] => USN69
    [35] => USN84
    [36] => USN74
    [37] => USN68
    [38] => USN05
    [39] => USN64
)
<br>Looking for floating ship USN61 with SQL SELECT * FROM ObjMissionData WHERE Mission_Name='SE-Operation Detachment-194502191200.mis' AND Obj_Group_Name='USN61' AND Quantity>0;<br><br>IJN air attack: IJN_H_701z03, USN62, USN61, -17810.1, -5182.74<br><br>IJN Ohka air attack: prior waypoint SQL UPDATE NewWaypoints SET Way_X_Axis=-30588.1, Way_Y_Axis=-658.74 WHERE Mission_Nbr='194502191300' AND Unit_Group='IJN_H_701z03' AND Way_Nbr=3;<br><br>IJN Ohka air attack: gattack waypoint SQL UPDATE NewWaypoints SET Target='USN61', Way_X_Axis=-24121.1, Way_Y_Axis=664.26 WHERE Mission_Nbr='194502191300' AND Unit_Group='IJN_H_701z03' AND Target='USN62'<br>Array
(
    [0] => USN13
    [1] => USN05
    [2] => USN66
    [3] => USN76
    [4] => USN62
    [5] => USN12
    [6] => USN84
    [7] => USN01
    [8] => USN06
    [9] => USN73
    [10] => USN71
    [11] => USN11
    [12] => USN82
    [13] => USN74
    [14] => USN65
    [15] => USN78
    [16] => USN03
    [17] => USN81
    [18] => USN08
    [19] => USN04
    [20] => USN07
    [21] => USN79
    [22] => USN83
    [23] => USN10
    [24] => USN69
    [25] => USN80
    [26] => USN72
    [27] => USN15
    [28] => USN77
    [29] => USN68
    [30] => USN67
    [31] => USN02
    [32] => USN61
    [33] => USN09
    [34] => USN75
    [35] => UN63
    [36] => USN14
    [37] => USN70
    [38] => USN64
    [39] => USN00
)
<br>Looking for floating ship USN76 with SQL SELECT * FROM ObjMissionData WHERE Mission_Name='SE-Operation Detachment-194502191200.mis' AND Obj_Group_Name='USN76' AND Quantity>0;<br><br>IJN air attack: IJN_H_701z10, USN63, USN76, 21307, -15515.7<br><br>IJN conventional air attack: NewWaypoints SQL UPDATE NewWaypoints SET Target='USN76', Way_X_Axis=16154, Way_Y_Axis=-15128.7 WHERE Mission_Nbr='194502191300' AND Unit_Group='IJN_H_701z10' AND Target='USN63'<br>Array
(
    [0] => USN83
    [1] => USN01
    [2] => USN71
    [3] => USN82
    [4] => USN64
    [5] => USN77
    [6] => USN68
    [7] => USN78
    [8] => USN74
    [9] => USN80
    [10] => USN72
    [11] => USN70
    [12] => USN04
    [13] => USN08
    [14] => USN09
    [15] => USN14
    [16] => USN03
    [17] => USN79
    [18] => USN11
    [19] => USN00
    [20] => USN67
    [21] => USN06
    [22] => USN84
    [23] => USN65
    [24] => USN15
    [25] => USN02
    [26] => USN76
    [27] => USN75
    [28] => USN12
    [29] => USN05
    [30] => USN10
    [31] => USN69
    [32] => USN13
    [33] => USN66
    [34] => USN62
    [35] => USN07
    [36] => USN81
    [37] => UN63
    [38] => USN61
    [39] => USN73
)
<br>Looking for floating ship USN82 with SQL SELECT * FROM ObjMissionData WHERE Mission_Name='SE-Operation Detachment-194502191200.mis' AND Obj_Group_Name='USN82' AND Quantity>0;<br><br>IJN air attack: IJN_H_703z00, USN61, USN82, 22807, -15515.7<br><br>IJN Ohka air attack: prior waypoint SQL UPDATE NewWaypoints SET Way_X_Axis=9619, Way_Y_Axis=-9089.7 WHERE Mission_Nbr='194502191300' AND Unit_Group='IJN_H_703z00' AND Way_Nbr=3;<br><br>IJN Ohka air attack: gattack waypoint SQL UPDATE NewWaypoints SET Target='USN82', Way_X_Axis=14778, Way_Y_Axis=-10480.7 WHERE Mission_Nbr='194502191300' AND Unit_Group='IJN_H_703z00' AND Target='USN61'<br>Array
(
    [0] => USN83
    [1] => USN80
    [2] => USN76
    [3] => USN78
    [4] => USN07
    [5] => USN74
    [6] => USN62
    [7] => USN81
    [8] => USN03
    [9] => USN13
    [10] => USN06
    [11] => USN66
    [12] => USN82
    [13] => USN04
    [14] => USN73
    [15] => USN69
    [16] => USN77
    [17] => USN68
    [18] => USN10
    [19] => USN70
    [20] => USN75
    [21] => USN05
    [22] => UN63
    [23] => USN15
    [24] => USN09
    [25] => USN72
    [26] => USN61
    [27] => USN12
    [28] => USN71
    [29] => USN14
    [30] => USN65
    [31] => USN02
    [32] => USN00
    [33] => USN11
    [34] => USN08
    [35] => USN01
    [36] => USN79
    [37] => USN67
    [38] => USN64
    [39] => USN84
)
<br>Looking for floating ship USN78 with SQL SELECT * FROM ObjMissionData WHERE Mission_Name='SE-Operation Detachment-194502191200.mis' AND Obj_Group_Name='USN78' AND Quantity>0;<br><br>IJN air attack: IJN_H_703z02, USN59, USN78, 21307, -18015.7<br><br>IJN Ohka air attack: prior waypoint SQL UPDATE NewWaypoints SET Way_X_Axis=8409, Way_Y_Axis=-14988.7 WHERE Mission_Nbr='194502191300' AND Unit_Group='IJN_H_703z02' AND Way_Nbr=3;<br><br>IJN Ohka air attack: gattack waypoint SQL UPDATE NewWaypoints SET Target='USN78', Way_X_Axis=14791, Way_Y_Axis=-12653.7 WHERE Mission_Nbr='194502191300' AND Unit_Group='IJN_H_703z02' AND Target='USN59'<br>Array
(
    [0] => USN82
    [1] => USN71
    [2] => USN07
    [3] => USN15
    [4] => USN01
    [5] => USN69
    [6] => USN05
    [7] => USN68
    [8] => USN03
    [9] => USN75
    [10] => USN81
    [11] => USN64
    [12] => USN13
    [13] => USN77
    [14] => USN02
    [15] => USN08
    [16] => USN83
    [17] => USN84
    [18] => USN14
    [19] => USN79
    [20] => USN67
    [21] => USN00
    [22] => USN09
    [23] => USN66
    [24] => USN72
    [25] => USN73
    [26] => USN12
    [27] => USN76
    [28] => USN04
    [29] => USN10
    [30] => UN63
    [31] => USN62
    [32] => USN11
    [33] => USN65
    [34] => USN06
    [35] => USN61
    [36] => USN70
    [37] => USN74
    [38] => USN80
    [39] => USN78
)
<br>Looking for floating ship USN15 with SQL SELECT * FROM ObjMissionData WHERE Mission_Name='SE-Operation Detachment-194502191200.mis' AND Obj_Group_Name='USN15' AND Quantity>0;<br><br>IJN air attack: IJN_H_703z10, USN64, USN15, 7836.84, -542.6<br><br>IJN Ohka air attack: prior waypoint SQL UPDATE NewWaypoints SET Way_X_Axis=-5681.16, Way_Y_Axis=7616.4 WHERE Mission_Nbr='194502191300' AND Unit_Group='IJN_H_703z10' AND Way_Nbr=3;<br><br>IJN Ohka air attack: gattack waypoint SQL UPDATE NewWaypoints SET Target='USN15', Way_X_Axis=1726.84, Way_Y_Axis=4503.4 WHERE Mission_Nbr='194502191300' AND Unit_Group='IJN_H_703z10' AND Target='USN64'<br>DCSEngine (Operation Detachment) v2.0 :: OOB management complete for sequence number 194502191200. IJN steamer continuing course to Iwo Jima. IJN air attacks initiated.
IV/JG7_4Shades
Posts: 2211
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

Post by IV/JG7_4Shades »

Yes, looking healthy now! :)

Turn off DEBUG and keep playing, or start OD again.

Cheers,
4S
IV/JG7_4Shades
SEOW Developer

Image
gec100
Posts: 78
Joined: Fri 06 May 2011 4:55 am
Location: Zagreb, Croatia
Contact:

Post by gec100 »

thx for the help!
Zoi
Posts: 268
Joined: Fri 14 Jan 2011 3:20 pm

Post by Zoi »

I installed the campaign but was wondering if there was any reason to set up the script on the remote host if I'm transferring the database to my local host to work with DCS.
IV/JG7_4Shades
Posts: 2211
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

Post by IV/JG7_4Shades »

No need, just set up the web script to point to the OD-DCSEngine.php script on your local MP (which itself should be set up to use the Iwo Jima OD database locally).

The important thing is that the OD script is to be executed by the DCS at the end of each Analyze cycle.

Cheers,
4S
IV/JG7_4Shades
SEOW Developer

Image
Post Reply