Duplicate Key Value (Error 23505)

SMART Community Forum
1

Hi All -

This error appeared while I was grooming data. If I understand correctly, there’s a row of data somewhere that I edited that clashes with a row in the CA as it sits on Connect. Is there a way to use the SQL object identifier below to see which patrol the error is associated with? I’d like to learn what change I made triggered the error. I do the same procedures with hundreds of patrols monthly and haven’t seen this one before.

In case it’s relevant:

  • We are in our first weeks of using SMART 8.1. When reviewing and editing many patrols in succession, the cache has been filling a lot faster than it was when we used 7.5.6 requiring system restarts.
  • I’ve cleaned up the queue in Connect per another post with a similar (albeit not identical) error.

Screenshot 2026-01-06 222433
Screenshot 2026-01-06 222433549×275 15.4 KB

2

Hi Becky,

Sorry for the delay in the response.

It seems SMART Desktop is trying to apply changes downloaded from SMART Connect, but it hits a database uniqueness constraint on the patrol table. SMART is trying to insert a patrol that already exists locally, with the same internal key.

It might be hard to use the object identifier as the error doesn’t seem to be giving us the patrol ID.

Is the problem still persisting?

Depending on the volume of patrol data coming in and if this is causing issues you may want to test out how things run when you turn off the automatic data processing option (new to SMART 8) in the Connect settings configuration.

Cheers,

Alex