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
High-Res Visual Tile Generator
Direct-to-platform CAD upload that generates high-resolution tiles for the web interface.
Read moreLevel 1 Linking & Floors Scale Audit
Measure gross area via the Floors template and run a scale sanity check.
Read moreColour-Coded Audit States
Legend colour coding: grey for a perfect match, purple for recalculated spaces.
Read moreUnidentified Space Flag
Flag closed polylines on the space layer with no room text identifier.
Read moreRoom Split Record Provisioning
Detect split polylines with new text IDs and automatically provision new database records.
Read moreMicro-Audit Zoom & Navigation
Single click highlights the database row; double click zooms the camera to the space.
Read moreDownstream CAFM Sync & Automation
Committed links instantly publish updated plans for occupant requests and automated PDF printing.
Read moreSee 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