Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 issues
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
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