openPDC installation failed on an Amazon EC2 Windows VM

GPA Products openPDC
1

Hi Ritchie and Stephen,

I encountered an error when I was trying to install openPDC v2.8.196 on an Amazon EC2 Windows virtual machine. The database I installed is PostgreSQL v13.2 (x64). The installation failed at the step of configuration setup with an error message given below.

Please shed lights on this issue.

Thank you!

The following information about the error was automatically captured:

• an event was written to the application log

• details were written to a text log at:

LogFile

Detailed error information follows:

Date and Time: 3/25/2021 2:46:49 AM

Machine Name: EC2AMAZ-MDFL5L2

Machine IP: fe80::ecca:eed1:d4df:145b%8

Machine OS: Microsoft Windows NT 6.2.9200.0

Application Domain: ConfigurationSetupUtility.exe

Assembly Codebase: C:/Program Files/openPDC/ConfigurationSetupUtility.exe

Assembly Full Name: ConfigurationSetupUtility, Version=2.8.196.0, Culture=neutral, PublicKeyToken=null

Assembly Version: 2.8.196.0

Assembly Build Date: 12/16/2020 12:13:40 AM

.Net Runtime Version: 4.0.30319.42000

Exception Source: Npgsql

Exception Type: System.NullReferenceException

Exception Message: Object reference not set to an instance of an object.

Exception Target Site: Cleanup

---- Stack Trace ----

Npgsql.NpgsqlConnector.Cleanup()

   ConfigurationSetupUtility.exe: N 00279

Npgsql.NpgsqlConnector.Open()

   ConfigurationSetupUtility.exe: N 01055

Npgsql.NpgsqlConnection.Open()

   ConfigurationSetupUtility.exe: N 00765

ConfigurationSetupUtility.PostgresSetup.ExecuteStatement(statement As String)

   ConfigurationSetupUtility.exe: N 00047

ConfigurationSetupUtility.Screens.SetupInProgressScreen.SetUpPostgresDatabase()

   ConfigurationSetupUtility.exe: N 00870
2

We are going to have to test this for you. Do you happen to know which version of PostgreSQL you are using?

3

Ritchie,

Thank you! The version of PostgreSQL is v13.2 (x64) for Windows

4

btw, are you going to test this installation on an Amazon EC2 Windows machine too? or just do it locally?

5

We will test locally first, just to see if we can replicate it easily - could be an easy fix…

6

Finally got a build that works well:
https://gridprotectionalliance.org/NightlyBuilds/openPDC/Beta/Synchrophasor.Installs.zip

The issue was an old version of the PostgreSQL .NET adapter that didn’t work with newer authentication methods.

Let me know how it goes…

Thanks,
Ritchie

7

Hi Ritchie,

Thanks for fixing it. It works like a charm. I may need to ask you more on STTP connections.