[Building Sakai] Problem with Samigo and Oracle 11g Release 2

[Jaques Smith]

Hi Miguel,

We had a problem where the indexes was created as unique. So check that the FK6A6F29F5694216CC index on sam_assessevaluation_t is NOT UNIQUE.

Cheers,
Jaques

From: Miguel Carro Pellicer [mailto:farreri.sakai at gmail.com]
Sent: 11 October 2010 12:11 PM
To: sakai-dev at collab.sakaiproject.org
Subject: [Building Sakai] Problem with Samigo and Oracle 11g Release 2

Hi subscribers.

Has anyone tested Samigo using Oracle 11g Release 2??

I installed a fresh Sakai configuring this database, when creating tables Samigo throws this error:

2010-10-11 12:05:11,328  WARN Thread-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): error code: 2291 sql:  INSERT INTO SAM_ASSESSEVALUATION_T ("ASSESSMENTID" , "EVALUATIONCOMPONENTS" ,"SCORINGTYPE" ,"NUMERICMODELID" , "FIXEDTOTALSCORE" ,"GRADEAVAILABLE" ,"ISSTUDENTIDPUBLIC" , "ANONYMOUSGRADING" ,"AUTOSCORING" ,"TOGRADEBOOK" ) VALUES (1 ,'' ,1 ,'' , NULL , NULL , NULL ,1 , NULL ,2  ) binds:
java.sql.SQLIntegrityConstraintViolationException: ORA-02291: restricción de integridad (TESTING.FK6A6F29F5694216CC) violada - clave principal no encontrada

This ORA responds to a constraint violation, the same tomcat worked 100% in Oracle 10g and MySQL.

Thanks in advance, Miguel.

--
[cid:image001.jpg at 01CB69EA.BA0A1DC0]<http://www.samoo.es/>
 <http://www.samoo.es/>
Miguel Carro Pellicer
Technical Manager - Director técnico
miguel.carro at samoo.es<mailto:miguel.carro at samoo.es>
+34 - 96 393 74 33 ext. 32
www.samoo.es<http://www.samoo.es>

Este  correo  y  sus archivos asociados son privados y confidenciales y va dirigido  exclusivamente  a su destinatario. Si recibe este correo sin ser el  destinatario del mismo, le rogamos proceda a su eliminación y lo ponga en  conocimiento del emisor. La difusión por cualquier medio del contenido de  este  correo podría ser sancionada conforme a lo previsto en las leyes españolas, Ley Orgánica 15/1999 de Protección de Datos de Carácter Personal.  No  se autoriza la utilización con fines comerciales o para su incorporación a ficheros automatizados de las direcciones del emisor o del destinatario."

This mail and its attached files are confidential and are only and exclusively intended to their addressee. In case you may receive this mail not being its addressee, we beg you to let us know the error by reply and to proceed to destroy it. The circulation by any mean of this mail could be penalised in accordance with the Spanish legislation. Is not allowed the use of both, the transmitter and the addressee's, address with a commercial aim, or in order to be incorporated to automated data process or to any kind of files.

P Antes de imprimir este correo electrónico piense bien si es necesario hacerlo. El medioambiente es cosa de todos.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101012/be945234/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3022 bytes
Desc: image001.jpg
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101012/be945234/attachment.jpg