We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Couldn't Store Tigger - Ubuntu Install Issue

Hi Jamuna,
Looked in the two oc_qrtz tables. Neither had any triggers in the
initial install (which is consistent with the "couldn't store triggers"
message from the logfile). I'm dropping back and putting postgresql 8.4
on the box as the database and will re-run everything from that point.
Thanks to all for the suggestions and help to date.
Michael
Michael R. Zdanis
410.403.1161 (direct)
410.615.1112 (cell)
-----Original Message-----
[mailto:[email protected]] On Behalf Of
[email protected]
Sent: Friday, November 18, 2011 12:00 PM
To: [email protected]
Subject: Developers Digest, Vol 216, Issue 13
Send Developers mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://mailman.openclinica.com/listinfo/developers
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Developers digest..."
Today's Topics:
1. Re: Couldn't Store Trigger - Ubuntu Install Issue
(Jamuna Nyayapathi)
----------------------------------------------------------------------
Message: 1
Date: Fri, 18 Nov 2011 09:43:16 -0500
From: "Jamuna Nyayapathi"
To:
Subject: Re: [Developers] Couldn't Store Trigger - Ubuntu Install
Issue
Message-ID:

<[email protected]>
Content-Type: text/plain; charset="us-ascii"
Hi Sebastian,
In the table oc_qrtz_simple_triggers and also in oc_qrtz_triggers see if
there is a trigger called 'legacyJobTrigger' trigger_name created. If it
did, try deleting it off and try to restart the application and see if
that helps?
Thanks,
Jamuna
-----Original Message-----
[mailto:[email protected]] On Behalf Of Sebastian
Hilbert
Sent: Friday, November 18, 2011 9:36 AM
To: [email protected]
Subject: Re: [Developers] Couldn't Store Trigger - Ubuntu Install Issue
On Thursday, November 17, 2011 08:57:04 PM Michael Zdanis wrote:
Hi,
Just in case someone is wondering. It is possible to run Postgresql 8.4
and
9.x on the same system at the same time. Some Linux versions will
configure
this for you automatically. If you are running the with the instructions
provided by OC you would have to make sure different ports are assigned
for
each version in postgresql.conf
Regards,
Sebastian Hilbert
> > Hello,
> >
> >
> >
> > I am attempting to install OpenClinica-3.1.1-Community for evaluation
on
> > an Ubuntu 11.10 system that was built from bare iron for the purpose.
> > Ubunutu isn't wild about having tomcat and java installed per the OC
> > directions, so after a couple of attempts we allowed the main system
to
> > install and config PostgreSQL, and tomcat. Removed the pl/pgsql
> > extension from template1 (a default you can't get around with the base
> > install) and changed the addressing in datainfo.properties to point to
> > catalina.base rather than catalina.home since the OpenClinica files
sit
> > in /var/lib/tomcat6/webapps in this installation. On initial run,
> > OpenClinica hits the database, builds 101 tables, 72 sequences, 2
> > functions, 9 trigger functions, and 1 view and then bombs with a
series
> > of errors. An exemplar of the error in the localhost.yyyy-mm-dd.log
file
> > is shown below. At this point I'm a bit stuck. Any direction is
> > appreciated.
> >
> >
> >
> >
> >
> > Nov 16, 2011 4:29:09 PM org.apache.catalina.core.StandardContext
> > listenerStop
> >
> > SEVERE: Exception sending context destroyed event to listener instance
> > of class org.akaza.openclinica.control.OCServletContextListener
> >
> > org.springframework.beans.factory.BeanCreationException: Error
creating
> > bean with name 'schedulerFactoryBean' defined in URL
> >
[jar:file:/var/lib/tomcat6/webapps/OpenClinica/WEB-INF/lib/OpenClinica-c
> >
ore-3.1.1-Community.jar!/org/akaza/openclinica/applicationContext-core-s
> > cheduler.xml]: Invocation of init method failed; nested exception is
> > org.quartz.JobPersistenceException: Couldn't store trigger
> > 'legacyJobTrigger' for 'legacyJobDetail' job:invalid stream header:
> > BB656430 [See nested exception: java.io.StreamCorruptedException:
> > invalid stream header: BB656430]
> >
> > at
> >
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> > tory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
> >
> > at
> >
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> > tory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
> >
> > at
> >
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> > tory.createBean(AbstractAutowireCapableBeanFactory.java:456)
> >
> > at
> >
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObjec
> > t(AbstractBeanFactory.java:291)
> >
> > at
> >
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.g
> > etSingleton(DefaultSingletonBeanRegistry.java:222)
> >
> > at
> >
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(
> > AbstractBeanFactory.java:288)
> >
> > at
> >
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Ab
> > stractBeanFactory.java:190)
> >
> > at
> >
org.springframework.beans.factory.support.DefaultListableBeanFactory.pre
> > InstantiateSingletons(DefaultListableBeanFactory.java:563)
> >
> > at
> >
org.springframework.context.support.AbstractApplicationContext.finishBea
> > nFactoryInitialization(AbstractApplicationContext.java:895)
> >
> > at
> >
org.springframework.context.support.AbstractApplicationContext.refresh(A
> > bstractApplicationContext.java:425)
> >
> > at
> >
org.springframework.web.context.ContextLoader.createWebApplicationContex
> > t(ContextLoader.java:276)
> >
> > at
> >
org.springframework.web.context.ContextLoader.initWebApplicationContext(
> > ContextLoader.java:197)
> >
> > at
> >
org.springframework.web.context.ContextLoaderListener.contextInitialized
> > (ContextLoaderListener.java:47)
> >
> > at
> >
org.akaza.openclinica.dao.core.OCContextLoaderListener.contextInitialize
> > d(OCContextLoaderListener.java:22)
> >
> > at
> >
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.j
> > ava:4206)
> >
> > at
> >
org.apache.catalina.core.StandardContext.start(StandardContext.java:4705
> > )
> >
> > at
> >
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja
> > va:799)
> >
> > at
> >
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
> >
> > at
> > org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
> >
> > at
> > org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
> >
> > at
> > org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
> >
> > at
> > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
> >
> > at
> > org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
> >
> > at
> >
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:32
> > 4)
> >
> > at
> >
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu
> > pport.java:142)
> >
> > at
> > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
> >
> > at
> > org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
> >
> > at
> > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> >
> > at
> > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
> >
> > at
> >
org.apache.catalina.core.StandardService.start(StandardService.java:525)
> >
> > at
> > org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
> >
> > at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
> >
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >
> > at
> >
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
> > a:57)
> >
> > at
> >
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
> > Impl.java:43)
> >
> > at java.lang.reflect.Method.invoke(Method.java:616)
> >
> > at
org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
> >
> > at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
> >
> > Caused by: org.quartz.JobPersistenceException: Couldn't store trigger
> > 'legacyJobTrigger' for 'legacyJobDetail' job:invalid stream header:
> > BB656430 [See nested exception: java.io.StreamCorruptedException:
> > invalid stream header: BB656430]
> >
> > at
> >
org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSuppor
> > t.java:1245)
> >
> > at
> >
org.quartz.impl.jdbcjobstore.JobStoreSupport$5.execute(JobStoreSupport.j
> > ava:1151)
> >
> > at
> >
org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.
> > java:3691)
> >
> > at
> >
org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:
> > 242)
> >
> > at
> >
org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSuppo
> > rt.java:3687)
> >
> > at
> >
org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSuppor
> > t.java:1147)
> >
> > at
> > org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:829)
> >
> > at
org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:254)
> >
> > at
> >
org.springframework.scheduling.quartz.SchedulerAccessor.addTriggerToSche
> > duler(SchedulerAccessor.java:340)
> >
> > at
> >
org.springframework.scheduling.quartz.SchedulerAccessor.registerJobsAndT
> > riggers(SchedulerAccessor.java:271)
> >
> > at
> >
org.springframework.scheduling.quartz.SchedulerFactoryBean.afterProperti
> > esSet(SchedulerFactoryBean.java:513)
> >
> > at
> >
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> > tory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
> >
> > at
> >
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> > tory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
> >
> > ... 37 more
> >
> > Caused by: java.io.StreamCorruptedException: invalid stream header:
> > BB656430
> >
> > at
> > java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:800)
> >
> > at java.io.ObjectInputStream.(ObjectInputStream.java:297)
> >
> > at
> >
org.quartz.impl.jdbcjobstore.PostgreSQLDelegate.getObjectFromBlob(Postgr
> > eSQLDelegate.java:99)
> >
> > at
> >
org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectJobDetail(StdJDBCDele
> > gate.java:904)
> >
> > at
> >
org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSuppor
> > t.java:1201)
> >
> > ... 49 more
> >
> > Nov 16, 2011 4:29:09 PM org.apache.catalina.core.ApplicationContext
log
> >
> > INFO: Closing Spring root WebApplicationContext
> >
> >
> >
> > Best regards,
> >
> > Michael
> >
> >
> >
> >
> >
> > Michael R. Zdanis
> >
> > President
> >
> > Cetus Group, LLC
> >
> > 224 Schilling Circle, Ste. 240
> >
> > Hunt Valley, MD 21031
> >
> > 410.403.1161 (direct)
> >
> > 410.615.1112 (cell)
> >
> > 410.403.1159 (fax)
This discussion has been closed.