[Building Sakai] Elluminate (Collaborate) - Unique Constraint Error

[Dan McCallum]

There's no database code in /contrib/unicon/elluminate (and definitely 
no code dealing w/ a table named ELL_SESSION_DATA).

Guessing you're probably running the tool Aaron linked to.

- Dan

On 05/16/2012 10:56 AM, Aaron Zeckoski wrote:
> I believe that tool is essentially deprecated ever since elluminate/BB
> took over and they now maintain it in house. I don't think it is open
> source but I can't get to the download without a BB account.
>
> http://www.blackboard.com/Platforms/Collaborate/Products/Integrations/Sakai-Collaborative-and-Learning-Environment.aspx
>
> That said, if you want, I can make that change to the code, however, I
> think I am suppose to recommend that you use the one maintained by the
> vendor.
> -AZ
>
>
> On Wed, May 16, 2012 at 1:42 PM, Paul Dagnall<pdagnall1 at udayton.edu>  wrote:
>> Sam
>> Thanks a million! I believe you are right.
>>
>> I don't think there is much active development on this integration tool.
>> Here's the code:
>> https://source.sakaiproject.org/contrib/unicon/elluminate/
>>
>> Again, thank you!
>>
>>
>> Paul Dagnall
>> Application Developer&  Administrator
>> University of Dayton
>>
>>
>> On Wed, May 16, 2012 at 11:45 AM, Sam Ottenhoff<ottenhoff at longsight.com>
>> wrote:
>>>
>>> My guess is that the developers of this tool incorrectly use the Hibernate
>>> sequence generator called "increment" despite it being non-cluster-safe:
>>>
>>>     http://docs.jboss.org/hibernate/orm/3.3/reference/en/html/mapping.html
>>>
>>> Look in the Hibernate definition files (end in .hbm.xml) and look for:
>>>
>>>    <generator class="increment"/>
>>>
>>> That is bad and won't work for anyone that runs more than one Sakai server
>>> (everyone).
>>>
>>> Use "native" instead and your database will generate sequences correctly:
>>>
>>>    <generator class="native"/>
>>>
>>> Do the developers of this integration maintain the integration as open
>>> source?
>>>
>>> --Sam
>>>
>>> On Wed, May 16, 2012 at 11:36 AM, Paul Dagnall<pdagnall1 at udayton.edu>
>>> wrote:
>>>>
>>>> Hi
>>>> We're getting a bizarre error using the Elluminate (now Blackboard
>>>> Collaborate) synchronous integration. The problem is, all works fine on app
>>>> server Sakai2 but I get "ORA-00001: unique constraint" when I do the same
>>>> thing on Sakai1. This error tells me that it's trying to insert a record
>>>> with a duplicate primary key. The code is identical on both servers.
>>>>
>>>> Using Sakai2 (the one that works) I can create records and I see the ID
>>>> column in ELL_SESSION_DATA table increment by 1 appropriately. Updates work
>>>> fine. It just seems to be inserts from Sakai1 only that cause the conflict.
>>>>
>>>> It gets stranger. On a whim I decided to redeploy the tool and bounce
>>>> tomcat. Afterward everything was fine on both servers for a time, but later
>>>> the problem resurfaced but it switched servers. The problem is only
>>>> happening on the other one now. Grrrr!
>>>>
>>>> We're new to using multiple app servers. Other tools are fine. Am I
>>>> missing something? Could there be a sequence missing? Have you ever heard of
>>>> a sequencing conflict like this occurring with multiple app servers
>>>> connected to the same database?
>>>>
>>>> Thanks!
>>>>
>>>> Paul Dagnall
>>>> Application Developer&  Administrator
>>>> University of Dayton
>>>>
>>>>
>>>> _______________________________________________
>>>> 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"
>>>
>>>
>>
>>
>> _______________________________________________
>> 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"
>
>
>