More in this section

Forums / Bugs & Issues / Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 issues

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 issues

3 posts, 0 answered
  1. mkavici
    mkavici avatar
    22 posts
    Registered:
    07 Nov 2007
    13 Dec 2011
    Link to this post
    Hi,
    I have created a project with Sitefinity 4.3 and Oracle XE 10g (works fine) and exported the database to my database server, Oracle 11g Enterprise Edition Release 11.2.0.2.0. 

    Now I'm experiencing such problems while uploading multiple images;

    Insert link table row failed: Telerik.OpenAccess.RT.sql.SQLException: ORA-00001: unique constraint violated (DSIWEB.pk_sf_lbrrs_sf_prmssns_nhrtnc_)
     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=4.3.1885.0, Culture=neutral, PublicKeyToken=b28c218413bdf563]] Telerik.Sitefinity.Libraries.Model.Library.permissionChildren
    Instance: GenericOID@17931709 Album content_id=9cbb53fe-b628-44d6-a26f-3dfbc7afce2f
    Link table value[sequence 6]: NewObjectOID@51 classIndex = 75 id = 6 realOID = GenericOID@201 PermissionsInheritanceMap sf_prmssns_inhrtnc_mp_id=438
    INSERT INTO "sf_lbrrs_sf_prmssns_inhrtnc_mp"("content_id", "seq", "sf_prmssns_inhrtnc_mp_id") VALUES (?, ?, ?)
    (set event logging to all to see parameter values)

    Best regards
  2. Stanislav Velikov
    Stanislav Velikov avatar
    1113 posts
    Registered:
    18 Sep 2017
    16 Dec 2011
    Link to this post
    Hello,

    I haven`t tested with Oracle 11.2.0.2.0 since our Oracle server is running 11.2.0.1.0 and image uploading is working with this version (11.2.0.1.0). What I can suggest is to test with a backup of the project to run it on Oracle 11.2.0.1.0 and if you experience the error there there should ba a problem with the project and if possible send me the project files and a backup of the database so I can investigate the issue at my end. 
     
    Kind regards,
    Stanislav Velikov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. mkavici
    mkavici avatar
    22 posts
    Registered:
    07 Nov 2007
    16 Dec 2011
    Link to this post
    Hi,
    Thank you for the response.
    We have solved the problem. Oracle export/import tool was causing the problem.
    I have started  with a clean project with Oracle 11.2.0.2.0 and everything is fine for now.
    Kind Regards
3 posts, 0 answered