Switching From Interested Party Synchronization V1 to V2

  1. Copy the most recent STP winsolvenz FLOW Connector from \\kastpdat04\pde_auslieferungen\InputManagement\ to the application server.
  2. Stop winsolvenz.p4 server (STP Server 8005).
  3. Stop STP winsolvenz.p4 FLOW Connector.
  4. Create a backup of the winsolvenz.p4 database (you can find its name in C:\Program Files (x86)\STP AG\STP Server\STP.RemotingServer.exe.config).
  5. Create backup of C:\Program Files (x86)\STP AG\STP Server\STP.RemotingServer.exe.config.
  6. Ensure that the following setting is set to false in STP.RemotingServer.exe.config to disable the deprecated synchronization job: <add key="RefreshBeteiligtenCacheJobSettings_IsEnabled" value="false" />.
  7. Add one of the following configuration snippets just before the </appSettings> block in STP.RemotingServer.exe.config, based on the SQL Server version:
  • For SQL2014 or lower \\kastpdat04\pde_auslieferungen\InputManagement\winsolvenzFlow Connector\winsolvenz.p4 10.13.130.2\STP.RemotingServer.exe (Auszug) - for_SQL_2014_or_lower.config
  • For SQL2016 or higher \\kastpdat04\pde_auslieferungen\InputManagement\winsolvenzFlow Connector\winsolvenz.p4 10.13.130.2\STP.RemotingServer.exe (Auszug) - for_SQL_2016_or_higher.config
  1. Start winsolvenz.p4 server (STP Server 8005). It may take some time to populate the tblAlleBeteiligtenCache2 table with interested party data.
  2. Delete the following file: C:\ProgramData\STP AG\winsolvenz.FLOW.Connector\syncInterestedPartiesToFlowJobSettings.json. This file stores details of the last successful synchronization and will be recreated when the connector runs again.
  3. Create a backup of the configuration file: C:\Program Files (x86)\STP AG\STP winsolvenz.p4 FLOW Connector\appsettings.json.
  4. Install the latest version of STP winsolvenz.p4 FLOW Connector.
  5. After installation, update the connection string placeholder in appsettings.json:
"ConnectionStrings": {
    "winsolvenz": "Server=<myServerAddress>;Database=<myDataBase>;User Id=<myUsername>;Password=<myPassword>;"
}

NOTES:

  • The correct settings can be found in STP.RemotingServer.exe.config.
  • If using a SQL Server instance (server), replace the single \ with \\ to avoid setup failures.
  • If SQL Server uses a self-signed certificate or one from an untrusted CA, append: TrustServerCertificate=True; to the connection string to prevent connection issues.
  1. Check the logs of the winsolvenz.p4 server in C:\ProgramData\STP AG\WzServer and wait for confirmation that the tblAlleBeteiligtenCache2 refresh job has completed.
  2. Restart the STP winsolvenz.p4 FLOW Connector.

Related to