Insert link table row failed - Sitefinity - General Discussions

All Replies

Posted by Community Admin on 09-Jul-2013 00:00

Good day,

We are currently having a problem when we try to upload images or documents. We are running Sitefinity 5.1 on Windows Server 2003.

Here is some of the error log created

Message: HandlingInstanceID: f4806cf6-1a22-4e70-bcc5-02cd2f3a01c0
An exception of type 'Telerik.OpenAccess.Exceptions.DuplicateKeyException' occurred and was caught.
---------------------------------------------------------------------------------------------------
07/09/2013 09:06:16
Type : Telerik.OpenAccess.Exceptions.DuplicateKeyException, Telerik.OpenAccess, Version=2012.2.628.2, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342
Message : Insert link table row failed: Telerik.OpenAccess.RT.sql.SQLException: Violation of PRIMARY KEY constraint 'pk_sf_lbrrs_sf_prmssns_nhrtnc_'. Cannot insert duplicate key in object 'dbo.sf_lbrrs_sf_prmssns_nhrtnc_map'.
The statement has been terminated.
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeUpdate()
   at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeUpdate()
   at OpenAccessRuntime.Relational.metadata.RelationalLinkCollectionField.insertOrderedLinkTableRows(OID oid, Int32[] insertedIndexes, Object _insertedValues, PreparedStatement psins, Boolean batch, String sql)
Field: System.Collections.Generic.IList`1[[Telerik.Sitefinity.Security.Model.PermissionsInheritanceMap, Telerik.Sitefinity.Model, Version=5.1.3210.0, Culture=neutral, PublicKeyToken=b28c218413bdf563]] Telerik.Sitefinity.Libraries.Model.Library.permissionChildren
Instance: GenericOID@ddc3e3d8 Album content_id=4ba7ad46-f29b-4e65-be17-9bf7ce5ba1fb
Link table value[sequence 0]: NewObjectOID@3 classIndex = 88 id = 3 realOID = GenericOID@ffff022b PermissionsInheritanceMap sf_prmssons_inheritance_map_id=555
INSERT INTO [sf_lbrrs_sf_prmssns_nhrtnc_map]([content_id], [seq], [sf_prmssons_inheritance_map_id]) VALUES (?, ?, ?)
(set event logging to all to see parameter values)
Source : Unity_ILEmit_DynamicClasses
Help link :
InnerExceptions : System.Exception[]
FailedObject :
BackendError : Telerik.OpenAccess.RT.sql.SQLException: Violation of PRIMARY KEY constraint 'pk_sf_lbrrs_sf_prmssns_nhrtnc_'. Cannot insert duplicate key in object 'dbo.sf_lbrrs_sf_prmssns_nhrtnc_map'.
The statement has been terminated.

Ok, after doing some comparisons between one project that is working and this one for the one that is working the table dbo.sf_libraries has a field voa_version where the project that is not working does not have that particular field in that particular table. The field voa_version has relationships with 3 other libraires so thinking this may be the problem - any ideas?

Thanks,

Rob

This thread is closed