This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Violation of PRIMARY KEY constraint

Hello developers,

I hope you are doing well,

I encounter a problem when I try to drag and drop directly a file in the m-files desktop, also when I try to create a document from m-files (before the metadata are shown).

Error message : 

Parents
  • Hi!

    This has to do with a duplicate key in the database's Objecttor table, check if you have any integration so that when you create an object it is added to this table, it is probably adding a primary key that already exists in the table.


  • I am just going to also highlight - for wider visibility - that integrations should never interact directly with the database, even just to read data.

    The only supported way to create integrations is via the APIs.  If you need to read significant volumes of data then the Reporting Module is also a supported methodology.

Reply
  • I am just going to also highlight - for wider visibility - that integrations should never interact directly with the database, even just to read data.

    The only supported way to create integrations is via the APIs.  If you need to read significant volumes of data then the Reporting Module is also a supported methodology.

Children
No Data