Documents cannot be uploaded

Problem

When accessing the Attribute Editor in WebOffice via the following URL

https://<servername>/GEONISserverUI/AttributeEditor/indexWebOffice.aspx?datasource=was_sde&project=was_sde&table=u_was_punkt&querylayerid=u_was_punkt&id=1271

it is not possible to create a new document entry.
The problem occurs regardless of whether a file is uploaded or not – even just creating the document record alone fails.

The following error message appears in the GEONIS Server Log:

Object could not be saved. Error: Transaction could not be executed
Value cannot be null. Parameter name: relatedDataid

No further detailed information is visible in the server log.

Cause

Analysis of the error message shows that a mandatory value (relatedDataid) cannot be set during the save operation.

The cause is an inconsistent data type in the reference field of the document table:

• The reference field u_was_punkt_ref in the table WAS_DOKUMENT is not defined as GUID
• However, the Attribute Editor expects a GUID data type for document-related links to correctly establish the relationship between object and document
• As a result, relatedDataid remains internally null, which causes the transaction to abort

It is also noticeable that other reference fields in the database are currently defined as text, which deviates from the expected GEONIS data model.

Solution

The problem can be fixed by correctly adjusting the reference field:

1. In the table WAS_DOKUMENT, change the field type of
   u_was_punkt_ref to GUID
2. Perform schema change in the SDE (or FGDB for testing purposes)
3. If necessary:
   • Reload or check the FRM (form)
   • Clear caches / restart service
4. Then test again whether:
   • a document without a file
   • and a document with a file can be created successfully

After changing the field type to GUID, the relatedDataid should be set correctly and the save operation in the Attribute Editor should work again.