+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / Insert link table row failed

Insert link table row failed

1 posts, 0 answered
  1. Rob
    Rob avatar
    70 posts
    Registered:
    08 Nov 2011
    09 Jul 2013
    Link to this post

    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

1 posts, 0 answered