Why does the message "Access violation in module 'GeonisCentral.dll'" appear when editing attributes in the sewer system solution?

Problem

As soon as an attribute of a wastewater node is changed in GEONIS Sewer System, the following error message appears without saving the change:

Access violation at address 77670FD6 in module 'GeonisCentral.dll'. Read ad address 00000000.

This problem can occur in GEONIS Sewer System with the different wastewater nodes (SWS_SEWER_NODE).

Cause

Background information based on the example "Connection Point":

As soon as a connection Point is created, an entry is made in SWS_SEWER_NODE and at the same time an entry is made in SWS_CONNECTION_POINT with a referencing of the latter to the former via NODE_REF.

If this entry in SWS_CONNECTION_POINT is missing, the error message appears when editing attributes.

Possible solution / workaround (example connection point)

1. make a backup of the database.

2. delete all entries of SWS_CONNECTION_POINT.

Execute the rule "sew_cre_sws_sewer_node11_sws_connection_point" as validation.

Example of validations:

<?xml version="1.0" encoding="utf-8"?>
<verify version="2017.2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="..\..\..\..\xsd_2017\verify.xsd">
<taskgroup title="SWS_CONNECTION_POINT" name="SWS_CONNECTION_POINT" description="SWS_CONNECTION_POINT" display_order="1">
<verifytask title="Create entries in SWS_CONNECTION_POINT" name="ft_objectrelationtask_SWS_CONNECTION_POINT" taskid="ft_objectrelationtask" description="Create entries in SWS_CONNECTION_POINT" sessionrestart="500" targetclasstype="feature">
<taskparam paramid="tblname" value="SWS_SEWER_NODE" />
<taskparam paramid="rules" value="sew_cre_sws_sewer_node11_sws_connection_point" />
<exectime onbatch="true" onrequest="true" />
</verifytask>
</taskgroup>
</verify>