Trying to configure database connection from the application server

Hi,

We are migrating our application servers  to Windows 2019 from Windows 2012.

The database server remains the same.

So what we did is we installed the outsystems platform server on the new Windows 2019 server. Then we opened the configuration Tool and did the configuration for the database.


However on clicking apply and exit or Grant Permissions or Create/Upgrade Session Database,

we are getting the following error:


System.NullReferenceException: Object reference not set to an instance of an object.


In more details :


See the end of this message for details on invoking 

just-in-time (JIT) debugging instead of this dialog box.


************** Exception Text **************

System.NullReferenceException: Object reference not set to an instance of an object.

   at OutSystems.HubEdition.ConfigurationTool.IISUtils.#KUb()

   at OutSystems.HubEdition.ConfigurationTool.IISUtils.#Zsc()

   at #mnc.#hvc.#yqc(EnvironmentConfiguration config)

   at OutSystems.HubEdition.ConfigurationTool.ConfigurationFrmCode.#dpc()

   at #mnc.#hvc.#Luc(Object sender, EventArgs e)

   at #mnc.#hvc.#8uc(Object sender, EventArgs e)

   at System.Windows.Forms.MenuItem.OnClick(EventArgs e)

   at System.Windows.Forms.MenuItem.MenuItemData.Execute()

   at System.Windows.Forms.Command.Invoke()

   at System.Windows.Forms.Control.WmCommand(Message& m)

   at System.Windows.Forms.Control.WndProc(Message& m)

   at System.Windows.Forms.Form.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.7.3640.0 built by: NET472REL1LAST_C

    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll

----------------------------------------

ConfigurationTool

    Assembly Version: 10.0.1102.0

    Win32 Version: 10.0.1102.0

    CodeBase: file:///D:/Program%20Files/OutSystems/Platform%20Server/ConfigurationTool.exe

----------------------------------------

OutSystems.RuntimeCommon

    Assembly Version: 10.0.1102.0

    Win32 Version: 10.0.1102.0

    CodeBase: file:///D:/Program%20Files/OutSystems/Platform%20Server/OutSystems.RuntimeCommon.DLL

----------------------------------------

System

    Assembly Version: 4.0.0.0

    Win32 Version: 4.7.3640.0 built by: NET472REL1LAST_C

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

System.Configuration

    Assembly Version: 4.0.0.0

    Win32 Version: 4.7.3630.0 built by: NET472REL1LAST_B

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

----------------------------------------

System.Core

    Assembly Version: 4.0.0.0

    Win32 Version: 4.7.3640.0 built by: NET472REL1LAST_C

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

----------------------------------------

System.Xml

    Assembly Version: 4.0.0.0

    Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

----------------------------------------

OutSystems.HubEdition.RuntimePlatform

    Assembly Version: 10.0.1102.0

    Win32 Version: 10.0.1102.0

    CodeBase: file:///D:/Program%20Files/OutSystems/Platform%20Server/OutSystems.HubEdition.RuntimePlatform.DLL

----------------------------------------

System.Windows.Forms

    Assembly Version: 4.0.0.0

    Win32 Version: 4.7.3580.0 built by: NET472REL1LAST_C

    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.7.3190.0 built by: NET472REL1LAST_C

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

----------------------------------------

OutSystems.HubEdition.DatabaseAbstractionLayer

    Assembly Version: 10.0.1102.0

    Win32 Version: 10.0.1102.0

    CodeBase: file:///D:/Program%20Files/OutSystems/Platform%20Server/OutSystems.HubEdition.DatabaseAbstractionLayer.DLL

----------------------------------------

SCInstaller

    Assembly Version: 10.0.1102.0

    Win32 Version: 10.0.1102.0

    CodeBase: file:///D:/Program%20Files/OutSystems/Platform%20Server/SCInstaller.EXE

----------------------------------------

System.Web

    Assembly Version: 4.0.0.0

    Win32 Version: 4.7.3650.0 built by: NET472REL1LAST_B

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_64/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll

----------------------------------------

OutSystems.HubEdition.iDB2DatabaseProvider

    Assembly Version: 10.0.1102.0

    Win32 Version: 10.0.1102.0

    CodeBase: file:///D:/Program%20Files/OutSystems/Platform%20Server/plugins/database/OutSystems.HubEdition.iDB2DatabaseProvider.dll

----------------------------------------

OutSystems.HubEdition.MySQLDatabaseProvider

    Assembly Version: 10.0.1102.0

    Win32 Version: 10.0.1102.0

    CodeBase: file:///D:/Program%20Files/OutSystems/Platform%20Server/plugins/database/OutSystems.HubEdition.MySQLDatabaseProvider.dll

----------------------------------------

OutSystems.HubEdition.OracleDatabaseProvider

    Assembly Version: 10.0.1102.0

    Win32 Version: 10.0.1102.0

    CodeBase: file:///D:/Program%20Files/OutSystems/Platform%20Server/plugins/database/OutSystems.HubEdition.OracleDatabaseProvider.dll

----------------------------------------

OutSystems.HubEdition.SQLServerDatabaseProvider

    Assembly Version: 10.0.1102.0

    Win32 Version: 10.0.1102.0

    CodeBase: file:///D:/Program%20Files/OutSystems/Platform%20Server/plugins/database/OutSystems.HubEdition.SQLServerDatabaseProvider.dll

----------------------------------------

System.Data

    Assembly Version: 4.0.0.0

    Win32 Version: 4.7.3630.0 built by: NET472REL1LAST_B

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll

----------------------------------------

System.Xml.Linq

    Assembly Version: 4.0.0.0

    Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll

----------------------------------------

OutSystems.HubEdition.ServerCommon

    Assembly Version: 10.0.1102.0

    Win32 Version: 10.0.1102.0

    CodeBase: file:///D:/Program%20Files/OutSystems/Platform%20Server/OutSystems.HubEdition.ServerCommon.DLL

----------------------------------------

OutSystems.Activation

    Assembly Version: 10.0.1102.0

    Win32 Version: 10.0.1102.0

    CodeBase: file:///D:/Program%20Files/OutSystems/Platform%20Server/OutSystems.Activation.DLL

----------------------------------------

MySql.Data

    Assembly Version: 6.8.3.0

    Win32 Version: 6.8.3.0

    CodeBase: file:///D:/Program%20Files/OutSystems/Platform%20Server/plugins/database/MySql.Data.DLL

----------------------------------------

System.Transactions

    Assembly Version: 4.0.0.0

    Win32 Version: 4.7.3260.0 built by: NET472REL1LAST_C

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_64/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll

----------------------------------------

System.EnterpriseServices

    Assembly Version: 4.0.0.0

    Win32 Version: 4.7.3190.0 built by: NET472REL1LAST_C

    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_64/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.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.





Hi Nishit,

Since you are still on OutSystems 10, you should check with OutSystems Support if your current Platform Server version is supported to run on Windows Server 2019.

Be sure to include the ConfigurationTool.log file (which by default is located on C:\Windows\Temp\) after you reproduce the error. This may be useful to them to analyze what is causing the error.

Regards,

Nordin

2020-09-24 09:50:55.9830 [5048] [Info] ***** Starting log *****

2020-09-24 09:50:55.9918 [5048] [Debug] parsed_arguments, {"silent_mode"=False,"auto_mode"=False,"upgrade_mode"=False,"quick_switch_mode"=False,"sc_install_mode"=False,"rebuild_session"=False,"check_msmq"=False,"fix_machine_name_mode"=False,"generate_templates"=False,"regenerate_templates"=False,"reset_internal_network"=False,"upload_license="False,"license_file_path"="","sandbox_key"="","dbaadmin_login"="","dbaadmin_password"=False,"sessiondba_adminlogin"="","sessiondba_adminpassword"=False,"integrated_auth_admin_userpassword"=False,"set_platform_server_admin_password"=False,"get_serial"=False,}

2020-09-24 09:50:56.2896 [5048] [Debug] elevated_session_user, {"username":"CODE1\320104379","from_windows":True}

2020-09-24 09:50:56.2896 [5048] [Debug] elevated_admin_user, {"username":"CODE1\320104379","from_windows":True}

2020-09-24 09:50:56.7172 [5048] [Debug] IsLoopbackAddress - hostnameOrIp: fe80::6478:fbbd:157d:79c - internalAddress: 127.0.0.1 result: False

2020-09-24 09:50:56.7172 [5048] [Debug] IsLoopbackAddress - hostnameOrIp: 10.47.57.92 - internalAddress: 127.0.0.1 result: False

2020-09-24 09:50:56.7172 [5048] [Debug] IsLoopbackAddress - hostnameOrIp: ::1 - internalAddress: 127.0.0.1 result: True

2020-09-24 09:50:56.7172 [5048] [Debug] IsLoopbackAddress - hostnameOrIp: 127.0.0.1 - internalAddress: 127.0.0.1 result: True

2020-09-24 09:50:56.9537 [5048] [Debug] Trying to get some initial state for the Platform Server Admin user's GUI password fields from the database.

ConfigurationTool.exe Error: 0 : Unable to connect to any of the specified MySQL hosts.

ConfigurationTool.exe Error: 0 : Unable to connect to any of the specified MySQL hosts.

ConfigurationTool.exe Error: 0 : Unable to connect to any of the specified MySQL hosts.

ConfigurationTool.exe Error: 0 : Unable to connect to any of the specified MySQL hosts.

ConfigurationTool.exe Error: 0 : Unable to connect to any of the specified MySQL hosts.

2020-09-24 09:51:11.3053 [5048] [Debug] Failed to retrieve initial state for the Platform Server Admin user's password fields from the database. This may happen if the database does not yet exist, in which case this message is safe to ignore.


Hi Nishit Sadual,

First of all, and to get compatibility out of the way, these are the system requirements (and compatibility list) for OutSystems 10. Windows Server 2019 is not supported as per the document (which doesn't necessarily mean it won't work).

From this log, it seems the new installation has either a misconfigured database connection or there's some something restricting connectivity to the MySQL database (a firewall misconfigured somewhere?).

Hope this helps!