Database Integration

Upload Firewall: Duplicate Key Error

Block uploads when multiple polylines share the same room Text ID.

What is the upload firewall: duplicate key error?

The upload firewall stops a drawing from linking when two polylines carry the same room Text ID. Because the room ID is the key that maps geometry to a database record, the duplicate is reported with both locations and must be resolved before the link can proceed.

The problem it prevents

Two rooms sharing an ID means two geometries competing for one database record. Whichever loses is either overwritten or dropped, and the failure is silent: the upload appears to succeed while a real room quietly stops existing in reporting.

How it works

  • Room text identifiers are tested for uniqueness across the space layer before commit.
  • Duplicates block the upload rather than being resolved by arbitrary precedence.
  • Both conflicting locations are reported with click-to-zoom navigation.
  • The link proceeds only once every identifier is unique.

What you get

Prevents database conflicts where two rooms attempt to map to a single primary key.

More in Database Integration

See the drawing engine on your own plans

Send us a floor plan and we will show these tools running against your building during a short walkthrough.

Request a demo