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

problems logging into OpenClinica 2.0 after upgrade

Hi,
We are having problems logging into the new version. The login page comes up properly but when I log in I get this page. If I try to click on the Login Page link I just keep getting this screen below. I've inserted my log file output below the screen shot. Any help would be greatly appreciated.
Thanks,
Tiffany
Emacs!
Feb 7, 2007 12:53:56 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Feb 7, 2007 12:53:56 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1002 ms
Feb 7, 2007 12:53:56 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Feb 7, 2007 12:53:56 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.0.28
Feb 7, 2007 12:53:56 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Feb 7, 2007 12:53:56 PM org.apache.catalina.core.StandardHost getDeployer
INFO: Create Host deployer for direct deployment ( non-jmx )
Feb 7, 2007 12:53:56 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\tomcat5\conf\Catalina\localhost\admin.xml
Feb 7, 2007 12:53:57 PM org.apache.struts.util.PropertyMessageResources
INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
Feb 7, 2007 12:53:57 PM org.apache.struts.util.PropertyMessageResources
INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
Feb 7, 2007 12:53:58 PM org.apache.struts.util.PropertyMessageResources
INFO: Initializing, config='org.apache.webapp.admin.ApplicationResources', returnNull=true
Feb 7, 2007 12:53:59 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\tomcat5\conf\Catalina\localhost\balancer.xml
Feb 7, 2007 12:53:59 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\tomcat5\conf\Catalina\localhost\manager.xml
Feb 7, 2007 12:53:59 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Processing Context configuration file URL file:C:\tomcat5\conf\Catalina\localhost\OpenClinica.xml
Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
INFO: WARNING: Security role name data used in an without being defined in a
Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
INFO: WARNING: Security role name dba used in an without being defined in a
Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
INFO: WARNING: Security role name coordinator used in an without being defined in a
Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
INFO: WARNING: Security role name director used in an without being defined in a
Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
INFO: WARNING: Security role name investigator used in an without being defined in a
Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
INFO: WARNING: Security role name ra used in an without being defined in a
Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
INFO: WARNING: Security role name guest used in an without being defined in a
Feb 7, 2007 12:54:00 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Installing web application at context path /jsp-examples from URL file:C:\tomcat5\webapps\jsp-examples
Feb 7, 2007 12:54:00 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Installing web application at context path from URL file:C:\tomcat5\webapps\ROOT
Feb 7, 2007 12:54:00 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Installing web application at context path /servlets-examples from URL file:C:\tomcat5\webapps\servlets-examples
Feb 7, 2007 12:54:00 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Installing web application at context path /tomcat-docs from URL file:C:\tomcat5\webapps\tomcat-docs
Feb 7, 2007 12:54:00 PM org.apache.catalina.core.StandardHostDeployer install
INFO: Installing web application at context path /webdav from URL file:C:\tomcat5\webapps\webdav
Feb 7, 2007 12:54:00 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Feb 7, 2007 12:54:01 PM org.apache.jk.common.ChannelSocket init
INFO: JK2: ajp13 listening on /0.0.0.0:8009
Feb 7, 2007 12:54:01 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/15 config=C:\tomcat5\conf\jk2.properties
Feb 7, 2007 12:54:01 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 4935 ms
Feb 7, 2007 12:54:15 PM org.akaza.openclinica.core.SessionManager setupDataSource
INFO: looking up postgres...
Feb 7, 2007 12:54:15 PM org.akaza.openclinica.dao.core.EntityDAO select
WARNING: Exeception while executing dynamic query, GenericDAO.select: select * from user_account where user_name=?:message: Cannot create JDBC driver of class '' for connect URL 'null'
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at org.akaza.openclinica.dao.core.EntityDAO.select(Unknown Source)
at org.akaza.openclinica.dao.login.UserAccountDAO.findByUserName(Unknown Source)
at org.akaza.openclinica.core.SessionManager.(Unknown Source)
at org.akaza.openclinica.control.core.SecureController.process(Unknown Source)
at org.akaza.openclinica.control.core.SecureController.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.NullPointerException
at org.postgresql.Driver.parseURL(Driver.java:302)
at org.postgresql.Driver.acceptsURL(Driver.java:170)
at java.sql.DriverManager.getDriver(DriverManager.java:232)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
... 34 more
Feb 7, 2007 12:54:15 PM org.akaza.openclinica.control.core.SecureController process
INFO: user bean from SessionManager:
Tiffany Elliott
Programmer Analyst
Department of Psychiatry
Yale School of Medicine
(203) 932-5711 x 4527

Comments

  • Would you please send me your OpenClinica.xml in CATALINA_HOME\ conf\Catalina\localhost directory?

    If you still kept your previous OpenClinica.xml which used for your previous OpenClinica, it could be helpful if you send it to me too.


    Thanks,
    Yufang
    Sent: Wednesday, February 07, 2007 1:25 PM
    To: [email protected]
    Subject: [Users] problems logging into OpenClinica 2.0 after upgrade

    Hi,
    We are having problems logging into the new version. The login page comes up properly but when I log in I get this page. If I try to click on the Login Page link I just keep getting this screen below. I've inserted my log file output below the screen shot. Any help would be greatly appreciated.
    Thanks,
    Tiffany
    Emacs!
    Feb 7, 2007 12:53:56 PM org.apache.coyote.http11.Http11Protocol init
    INFO: Initializing Coyote HTTP/1.1 on http-8080
    Feb 7, 2007 12:53:56 PM org.apache.catalina.startup.Catalina load
    INFO: Initialization processed in 1002 ms
    Feb 7, 2007 12:53:56 PM org.apache.catalina.core.StandardService start
    INFO: Starting service Catalina
    Feb 7, 2007 12:53:56 PM org.apache.catalina.core.StandardEngine start
    INFO: Starting Servlet Engine: Apache Tomcat/5.0.28
    Feb 7, 2007 12:53:56 PM org.apache.catalina.core.StandardHost start
    INFO: XML validation disabled
    Feb 7, 2007 12:53:56 PM org.apache.catalina.core.StandardHost getDeployer
    INFO: Create Host deployer for direct deployment ( non-jmx )
    Feb 7, 2007 12:53:56 PM org.apache.catalina.core.StandardHostDeployer install
    INFO: Processing Context configuration file URL file:C:\tomcat5\conf\Catalina\localhost\admin.xml
    Feb 7, 2007 12:53:57 PM org.apache.struts.util.PropertyMessageResources
    INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
    Feb 7, 2007 12:53:57 PM org.apache.struts.util.PropertyMessageResources
    INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
    Feb 7, 2007 12:53:58 PM org.apache.struts.util.PropertyMessageResources
    INFO: Initializing, config='org.apache.webapp.admin.ApplicationResources', returnNull=true
    Feb 7, 2007 12:53:59 PM org.apache.catalina.core.StandardHostDeployer install
    INFO: Processing Context configuration file URL file:C:\tomcat5\conf\Catalina\localhost\balancer.xml
    Feb 7, 2007 12:53:59 PM org.apache.catalina.core.StandardHostDeployer install
    INFO: Processing Context configuration file URL file:C:\tomcat5\conf\Catalina\localhost\manager.xml
    Feb 7, 2007 12:53:59 PM org.apache.catalina.core.StandardHostDeployer install
    INFO: Processing Context configuration file URL file:C:\tomcat5\conf\Catalina\localhost\OpenClinica.xml
    Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
    INFO: WARNING: Security role name data used in an without being defined in a
    Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
    INFO: WARNING: Security role name dba used in an without being defined in a
    Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
    INFO: WARNING: Security role name coordinator used in an without being defined in a
    Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
    INFO: WARNING: Security role name director used in an without being defined in a
    Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
    INFO: WARNING: Security role name investigator used in an without being defined in a
    Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
    INFO: WARNING: Security role name ra used in an without being defined in a
    Feb 7, 2007 12:53:59 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
    INFO: WARNING: Security role name guest used in an without being defined in a
    Feb 7, 2007 12:54:00 PM org.apache.catalina.core.StandardHostDeployer install
    INFO: Installing web application at context path /jsp-examples from URL file:C:\tomcat5\webapps\jsp-examples
    Feb 7, 2007 12:54:00 PM org.apache.catalina.core.StandardHostDeployer install
    INFO: Installing web application at context path from URL file:C:\tomcat5\webapps\ROOT
    Feb 7, 2007 12:54:00 PM org.apache.catalina.core.StandardHostDeployer install
    INFO: Installing web application at context path /servlets-examples from URL file:C:\tomcat5\webapps\servlets-examples
    Feb 7, 2007 12:54:00 PM org.apache.catalina.core.StandardHostDeployer install
    INFO: Installing web application at context path /tomcat-docs from URL file:C:\tomcat5\webapps\tomcat-docs
    Feb 7, 2007 12:54:00 PM org.apache.catalina.core.StandardHostDeployer install
    INFO: Installing web application at context path /webdav from URL file:C:\tomcat5\webapps\webdav
    Feb 7, 2007 12:54:00 PM org.apache.coyote.http11.Http11Protocol start
    INFO: Starting Coyote HTTP/1.1 on http-8080
    Feb 7, 2007 12:54:01 PM org.apache.jk.common.ChannelSocket init
    INFO: JK2: ajp13 listening on /0.0.0.0:8009
    Feb 7, 2007 12:54:01 PM org.apache.jk.server.JkMain start
    INFO: Jk running ID=0 time=0/15 config=C:\tomcat5\conf\jk2.properties
    Feb 7, 2007 12:54:01 PM org.apache.catalina.startup.Catalina start
    INFO: Server startup in 4935 ms
    Feb 7, 2007 12:54:15 PM org.akaza.openclinica.core.SessionManager setupDataSource
    INFO: looking up postgres...
    Feb 7, 2007 12:54:15 PM org.akaza.openclinica.dao.core.EntityDAO select
    WARNING: Exeception while executing dynamic query, GenericDAO.select: select * from user_account where user_name=?:message: Cannot create JDBC driver of class '' for connect URL 'null'
    org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
    at org.akaza.openclinica.dao.core.EntityDAO.select(Unknown Source)
    at org.akaza.openclinica.dao.login.UserAccountDAO.findByUserName(Unknown Source)
    at org.akaza.openclinica.core.SessionManager.(Unknown Source)
    at org.akaza.openclinica.control.core.SecureController.process(Unknown Source)
    at org.akaza.openclinica.control.core.SecureController.doGet(Unknown Source)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
    at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
    at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: java.lang.NullPointerException
    at org.postgresql.Driver.parseURL(Driver.java:302)
    at org.postgresql.Driver.acceptsURL(Driver.java:170)
    at java.sql.DriverManager.getDriver(DriverManager.java:232)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
    ... 34 more
    Feb 7, 2007 12:54:15 PM org.akaza.openclinica.control.core.SecureController process
    INFO: user bean from SessionManager:
    Tiffany Elliott
    Programmer Analyst
    Department of Psychiatry
    Yale School of Medicine
    (203) 932-5711 x 4527
  • guoweiguowei Posts: 50
    Hi,
    I have a question to discuss with OpenClinica 2.0. When you login to
    submit data, no matter whether a subject is new or existed, clicking
    Entry Data or Continue Entry Data in Actions always makes top main
    menu gray. No matter what role is assigned to a user, when MainMenu is
    gray, full MainMenu(all buttons) was showed in gray. If there are many
    CRFs associated in the study to input data form by form, you have to
    click Back on the top of tool bar same times to go back to the page
    where the mainMenu is active. Does it work as this as design for
    purpose? or Is it a bug? In some case, user may only input data for a
    couple of CRFs then returns back to mainMenu; if user can click one
    button to go back to MainMenu, that would be much better and friendly
    than they have to click Back several times to get MainMenu with active
    status for further operation now. Is there any one can explain this and
    make it work as we expected?
    The age calculation as I asked last time, it should be a dynamic
    number, which means it should calculate by Current date - birth of
    date. Our users here asked me this question. The explanation from
    userGroup couldn't be accepted by them because enrollment date - BOD is
    static which can't tell user what age of a subject is now, at the time
    they are looking data. What do you think? The current definition has any
    special meaning or usage?
    When do you plan to put filter function back to Extract data?
    Thanks,
    Wei
This discussion has been closed.