Correct Missing VSA_VP/NP_REF and from/toHaltungspunktRef

Problem

• The export log shows the error messages "The attribute VSA_VP_REF is mandatory." and "The attribute VSA_NP_REF is mandatory."
• A resulting XTF is written, but it is missing the attributes "vonHaltungspunktRef", "nachHaltungspunktRef", and "AbwassernetzelementRef".

Cause

When starting an INTERLIS export from GEONIS, a pre-process is automatically started first, which prepares the GEONIS data for export into the INTERLIS model, see Preprocessing for INTERLIS Export. Among other things, the holding points are created in the table AWK_VSA_HALTUNGSPUNKT and these are referenced in the columns VSA_VP_REF and VSA_NP_REF of the attribute table of the holding. 

If these reference fields are not filled, and thus the holding point references are not exported into the XTF, this is usually due to certain data errors that prevent a successful pre-process. 

Workflow

The relevant database must be manually checked and corrected for the following possible sources of errors:

• The attribute tables of holding (T) and channel (B) must contain the same number of objects. Unequal numbers can be corrected with this workflow: Workflow: Recreate Channel Surface - Updated!. Likewise for standard shaft (T) and standard shaft (B): Workflow: Recreate Shaft (Surface) - Updated!.
• Holdings must not have zero geometries (LAENGE = 0).
• Connection objects must not link to themselves (KNOTEN_REF = own GlobalID). Incorrect references can be removed in the attribute mask of the connection objects using the button "Remove link to object".
• Connection points must be recorded at the beginning of the holding, not at the end. 

There may be other individual linking errors causing the issue. The support team will be happy to assist you here.