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

[Joaquín Marqués Alós]

Hi everyone,

I changed the order of the script "sakai_samigo.sql" Oracle
(/samigo-pack/src/sql/oracle/) and it seems that it creates all the
templates.

Before giving an error when creating a test because I could not find the
default template.

The sql script change has been to make the inserts of the templates at the
beginning of script (INSERT INTO SAM_ASSESSMENTBASE_T)

Another change I made was in
"samigo-app/src/java/org/sakaiproject/tool/assessment/ui/listener/author/AuthorAssessmentListener.java"

String templateId = author.getAssessmentTemplateId();
if (templateId == null){
   templateId = AssessmentTemplateFacade.DEFAULTTEMPLATE.toString();
}

Adding:

String templateId = author.getAssessmentTemplateId(); // return "", not null
if (templateId == null || templateId == ""){
   templateId = AssessmentTemplateFacade.DEFAULTTEMPLATE.toString();
}

With these changes do not fail, but I don't know if it will be a solution.

Regards, Joaquín.


2010/10/12 Jaques Smith <jaques at psybergate.co.za>

>  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.
>
>  --
>
> [image: cid:image001.jpg at 01C9F98A.71C74E60] <http://www.samoo.es/>
>
>   <http://www.samoo.es/>
>
> *Miguel Carro Pellicer*
>
> *Technical Manager - Director técnico*
>
> miguel.carro at samoo.es
>
> +34 - 96 393 74 33 ext. 32
>
> 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.
>
>
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101014/c4a0a350/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3022 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101014/c4a0a350/attachment.jpe