Page 2 of 3

Posted: Wed 04 Jan 2012 9:09 am
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.

Posted: Wed 04 Jan 2012 9:26 am
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.

Posted: Wed 04 Jan 2012 9:29 am
by gec100
done! what next?

Posted: Wed 04 Jan 2012 9:46 am
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.

Posted: Wed 04 Jan 2012 10:55 am
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

Posted: Wed 04 Jan 2012 1:29 pm
by gec100
no. this is the only error that i get and it is always there on building new mission.

Posted: Wed 04 Jan 2012 10:11 pm
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

Posted: Thu 05 Jan 2012 3:17 am
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.

Posted: Thu 05 Jan 2012 3:58 am
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

Posted: Thu 05 Jan 2012 4:06 am
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

Posted: Thu 05 Jan 2012 4:30 am
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.

Posted: Thu 05 Jan 2012 4:58 am
by IV/JG7_4Shades
Yes, looking healthy now! :)

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

Cheers,
4S

Posted: Thu 05 Jan 2012 10:26 am
by gec100
thx for the help!

Posted: Tue 31 Jan 2012 8:34 am
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.

Posted: Tue 31 Jan 2012 8:43 am
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