Skip to main content
15-Moonstone
November 28, 2019
Question

FileTransferSubsystem: Violation of PRIMARY KEY constraint 'file_transfer_job_pkey'

  • November 28, 2019
  • 8 replies
  • 2099 views

Hi,

 

There are many Thingworx SQL errors in ApplicationLog

 

2019-11-28 03:14:18.840-0600 [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: System] [S: ] [T: FileTransfer-3] [message: Violation of PRIMARY KEY constraint 'file_transfer_job_pkey'. Cannot insert duplicate key in object 'twschema.file_transfer_job'. The duplicate key value is (08ec7aa0-1844-4ac7-bd31-71d8271f30d3).]
2019-11-28 03:14:18.840-0600 [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: System] [S: ] [T: FileTransfer-18] [message: Violation of PRIMARY KEY constraint 'file_transfer_job_pkey'. Cannot insert duplicate key in object 'twschema.file_transfer_job'. The duplicate key value is (5de4e265-4319-439d-bc24-ffeeb9f89da6).]
2019-11-28 03:14:18.840-0600 [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: System] [S: ] [T: FileTransfer-17] [message: Violation of PRIMARY KEY constraint 'file_transfer_job_pkey'. Cannot insert duplicate key in object 'twschema.file_transfer_job'. The duplicate key value is (5c29b673-2e49-4765-a7a1-d90b816cbed5).]
2019-11-28 03:14:18.840-0600 [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: System] [S: ] [T: FileTransfer-19] [message: Violation of PRIMARY KEY constraint 'file_transfer_job_pkey'. Cannot insert duplicate key in object 'twschema.file_transfer_job'. The duplicate key value is (5e185fa1-e32f-4eee-aba0-05a96dfb6cb9).]
2019-11-28 03:14:18.840-0600 [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: System] [S: ] [T: FileTransfer-6] [message: Violation of PRIMARY KEY constraint 'file_transfer_job_pkey'. Cannot insert duplicate key in object 'twschema.file_transfer_job'. The duplicate key value is (0f5aaab0-c4f5-4bad-979d-cfed8adbb79b).]
2019-11-28 03:14:18.841-0600 [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: System] [S: ] [T: FileTransfer-11] [message: Violation of PRIMARY KEY constraint 'file_transfer_job_pkey'. Cannot insert duplicate key in object 'twschema.file_transfer_job'. The duplicate key value is (302415f0-6952-4ac3-9e8f-0b1539e4d827).]
2019-11-28 03:14:18.841-0600 [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: System] [S: ] [T: FileTransfer-16] [message: Violation of PRIMARY KEY constraint 'file_transfer_job_pkey'. Cannot insert duplicate key in object 'twschema.file_transfer_job'. The duplicate key value is (46568797-2530-4871-a58a-d433adaefda7).]
2019-11-28 03:14:18.841-0600 [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: System] [S: ] [T: FileTransfer-12] [message: Violation of PRIMARY KEY constraint 'file_transfer_job_pkey'. Cannot insert duplicate key in object 'twschema.file_transfer_job'. The duplicate key value is (3144532e-3719-4e69-a8d8-5e8d53524ac6).]
2019-11-28 03:14:18.841-0600 [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: System] [S: ] [T: FileTransfer-9] [message: Violation of PRIMARY KEY constraint 'file_transfer_job_pkey'. Cannot insert duplicate key in object 'twschema.file_transfer_job'. The duplicate key value is (2afb1d28-cade-4d38-b069-56492732036b).]
2019-11-28 03:14:18.841-0600 [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: System] [S: ] [T: FileTransfer-22] [message: Violation of PRIMARY KEY constraint 'file_transfer_job_pkey'. Cannot insert duplicate key in object 'twschema.file_transfer_job'. The duplicate key value is (75adabd6-0235-472b-b533-6c478fd70858).]
2019-11-28 03:14:18.841-0600 [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: System] [S: ] [T: FileTransfer-15] [message: Violation of PRIMARY KEY constraint 'file_transfer_job_pkey'. Cannot insert duplicate key in object 'twschema.file_transfer_job'. The duplicate key value is (45695124-b951-4668-98a7-91fd9212071b).]

 

I wonder what are causing these errors.

 

My Bests,

Hung Tran

 

 

8 replies

raluca_edu
17-Peridot
November 29, 2019

Hi,

 

This seems that system is trying to insert duplicate id in table file_transfer_job of your MSSQL database.

Please look in the table file_transfer_job and see if there are really existing id like :

08ec7aa0-1844-4ac7-bd31-71d8271f30d3
5de4e265-4319-439d-bc24-ffeeb9f89da6

 ....

Please check your services/tasks that are uploading files and see what is wrong and why these duplicates are sent to the database.

 

Hope it helps,

Raluca Edu

 

htran-2115-MoonstoneAuthor
15-Moonstone
November 29, 2019

Hi Raluca Edu,

 

I understood what the error means, however that's Thingworx code and the table file_transfer_job is a thingworx table, we do not have any code related. I do believe that is a logical bug in FileTransferSubsystem. I don't feel that I can do anything on my side.

 

My Bests,

Hung Tran

raluca_edu
17-Peridot
November 29, 2019

Hi,

 

But when these errors are happening? You are not running/executing anything? Or transferring files? Or an Edge/Remote thing that is transferring files?

 

When you notice this error? Do you have any reproducible steps to try internally?

 

Thank you,

Raluca Edu