Skip to content

fix(teams): XLS inject import creates duplicate contextual teams (no trimming), and contextual team delete fails with HTTP 500 #7558

Description

@fruitcakej

Description

Two distinct defects surfaced from the same XLS inject import workflow. They are reported together because they reproduce together, but they are separate bugs.

Bug 1: XLS inject import does not trim team names, creating duplicate contextual teams.
The importer splits the teams cell on , but does not trim white-space or trailing new-lines before matching against existing teams. Each white-space variant of a team name spawns a separate contextual team. The trailing characters are invisible in the UI, so users see what appears to be the same team listed two or three times.

Bug 2: Deleting a contextual team returns HTTP 500 "Internal Server Error".
Deleting a freshly created duplicate team results in a status 500 error

{"timestamp":"2026-08-21T16:20:14.968+00:00", "status":500, "error":"Internal Server Error", "path":"/api/tenants/2cffad3a-0001-4078-b0e2-ef74274022c3/teams/8e7616da-bfbb-4c84-810b-addb5502ec68"}

Combined with Bug 1, users cannot clean up the duplicate teams the import created.

Environment

OpenAEV version: 3.260821.0. Also observed on 3.260818.1 (SaaS).

Reproducible steps

Steps to create the smallest reproducible scenario:

  1. Scenario visible here : https://testing.obas.staging.filigran.io/2cffad3a-0001-4078-b0e2-ef74274022c3/admin/scenarios/c3447c91-20cf-4be8-a665-05baa182ec64

Expected output

Trimming to happen to avoid duplicate team names

Additional information

Customer original ticket with their XLS - OAEV1-106
Testing XLS file attached (with carriage return in cell C3)
Testing XLS mapper titled : 'Test Jamie' in above linked platform

Image

Test.xlsx

Metadata

Metadata

Labels

bugType: something isn't working (fix:).

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions