OC throws Exception if user opens viewstudy

[/app/rest/oc/se_randomizations?studyoid=S_SITESTAT_4442&instanceurl=http://localhost:8080/OpenClinica-web/rest2/openrosa/S_SITESTAT_4442] is not a valid HTTP URL
java.lang.IllegalArgumentException: [/app/rest/oc/se_randomizations?studyoid=S_SITESTAT_4442&instanceurl=http://localhost:8080/OpenClinica-web/rest2/openrosa/S_SITESTAT_4442] is not a valid HTTP URL
at org.springframework.web.util.UriUtils.encodeHttpUrl(UriUtils.java:245)
at org.springframework.web.client.RestTemplate$HttpUrlTemplate.encodeUri(RestTemplate.java:651)
at org.springframework.web.util.UriTemplate.expand(UriTemplate.java:140)
at org.springframework.web.client.RestTemplate.execute(RestTemplate.java:400)
at org.springframework.web.client.RestTemplate.getForObject(RestTemplate.java:199)
at org.akaza.openclinica.service.pmanage.RandomizationRegistrar.getRandomizationDTOObject(RandomizationRegistrar.java:52)
at org.akaza.openclinica.service.pmanage.RandomizationRegistrar.getCachedRandomizationDTOObject(RandomizationRegistrar.java:79)
at org.akaza.openclinica.control.admin.ViewStudyServlet.processRequest(ViewStudyServlet.java:83)
at org.akaza.openclinica.control.core.SecureController.process(SecureController.java:588)
at org.akaza.openclinica.control.core.SecureController.doGet(SecureController.java:634)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.akaza.openclinica.control.core.OCServletFilter.doFilter(OCServletFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.oauth2.provider.OAuth2ProtectedResourceFilter.doFilter(OAuth2ProtectedResourceFilter.java:55)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
at org.springframework.security.oauth2.provider.verification.VerificationCodeFilter.doFilter(VerificationCodeFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.oauth2.provider.OAuth2ExceptionHandlerFilter.doFilter(OAuth2ExceptionHandlerFilter.java:36)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:109)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.oauth2.provider.verification.BasicUserApprovalFilter.doFilter(BasicUserApprovalFilter.java:41)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.planetj.servlet.filter.compression.CompressingFilter.doFilter(CompressingFilter.java:217)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.akaza.openclinica.web.filter.LocaleFilter.doFilter(LocaleFilter.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1136)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)

Apache Tomcat 9.0.58.0
Ubuntu 20.4.3 LTS
OpenJDK 1.8.0_312
Postgresql 12.6
OpenClinica 3.16
localhost.2022-03-07.log
catalina.2022-03-07.log
openclinica-db.log

I used the installation guide and only changed the changeLogsCreateTables.xml to allow postgresql 12 by changing the check-sql tag

Hello,

I am currently using OpenClinica Version 3.7 to build a study for clinical data collection,
My CRF template (excel workbook) has several sections for 1) Inclusion Criteria, 2) Demographics 3) Blood Test 4) Diagnostic Procedures etc.
I collect the "Date of Visit" data field in the Demographics section and also, "Date of Test", "Date of Procedure", "Date of prescription" data fields throughout all other sections of the CRF.

I would like to know if there is any way I can compare these date fields against the date of visit to validate that both dates are within 12 months of each other.
Further, the "Date of Visit" field is in the "DD-MMM-YYYY" format whereas, all other date fields are in the partial date; "MMM-YYYY" or "YYYY" format.

I am not sure how JavaScript/J query can be utilised to solve my issue.
Any and all advice/suggestions/help is appreciated.

Thank you!!

Best,
Neva

Hi there

Editing a completed marked CRF with administrative editing doesn't show the header correctely if it contains html code.
I suppose that escapeXml="false" is missing in the corrisponding c:out tag.
regards,
Veruska

Status of site/study not visible at ChangeStudy view

especially datamanager and monitors need to see study/site state at ChangeStudy view.

otherwise they have to change into every site to see if they have to work with.

The wiki for installation only goes up to 3.10 and does not include newer JDK / Postgres and CentOS, OC 3.11. It is probably not a good idea to install a patient data repository on a platform where security updates may be no longer available as well as the software being updated - such as the instructions to modify /etc/init.d

Hi,

I'm running the OC version 3.11 and just got an issue as i said in the issue title.

After i remove a user role from this page (/ListStudyUser), that row disappear and never show a button for restore the user role.

I think i need to go to the page (/AssignUserToStudy) to reassign it, but it said that the role is invalid (the select box for select user role didn't show).

I did some debug and figure out this:

1. When do a restore you set the SUR object a status of DELETE (id = 5). (line 84, org.akaza.openclinica.control.managestudy.RemoveStudyUserRoleServlet)
2. But when do listing user role in page (/ListStudyUser), you use the query: findAllUsersByStudy, that defined in file (properties/useraccount_dao.xml), this query have a condition: sur.status_id=1 => this mean you never get any removed user role.

Hope you fix it soon.

Thanks for reading.
Sinzii Rosy

I have SSL_ERROR_UNSUPPORTED_VERSION when try to download documentation from https://docs.openclinica.com/downloads.
Update version of SSL/TLS, please.

I've check the Maven and JDK version and met some problem.
Result of Command: mvn clean install -Dmaven.test.skip=true
[WARNING] The POM for oracle.ojdbc14:ojdbc14:jar:10g is missing, no dependency information available
[WARNING] The POM for org.jmesa:jmesa:jar:2.4.2-oc is missing, no dependency information available
[WARNING] The POM for org.akaza.openclinica.odm:openclinica-odm:jar:2.2 is missing, no dependency information available
[WARNING] The POM for log4jdbc:log4jdbc4:jar:1.2 is missing, no dependency information available

For technical support and configuration questions, post your question/problem to https://forums.openclinica.com

Please submit any bugs/feature requests to https://jira.openclinica.com (free registration required).

If you are contributing code, submit a pull request to this repository and please create a corresponding ticket at https://jira.openclinica.com (free registration required). This will ensure the OpenClinica Development team sees your request/submission and is able to act on it quickly.

Thank You!

When i start the tomcat server in the tomcat7-stedrr its show me the next error and can't deploy the openclinica project
2017-09-15 10:44:35 Commons Daemon procrun stderr initialized
sep 15, 2017 11:44:36 AM org.apache.catalina.core.AprLifecycleListener init
Información: La biblioteca nativa de Apache Tomcat basada en ARP que permite un rendimiento óptimo en entornos de desarrollo no ha sido hallada en java.library.path: C:\Program Files\Apache Software Foundation\Tomcat 7.0\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\Windows Live\Shared;C:\xampp\php;C:\ProgramData\ComposerSetup\bin;C:\Windows\system32\config\systemprofile.dnx\bin;C:\Program Files\Microsoft DNX\Dnvm;C:\Windows\system32\config\systemprofile\AppData\Local\Microsoft\WindowsApps;.
sep 15, 2017 11:44:37 AM org.apache.catalina.startup.HostConfig deployDirectory
Información: Despliegue del directorio C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\docs de la aplicación web
sep 15, 2017 11:44:37 AM org.apache.catalina.startup.HostConfig deployDirectory
Información: Despliegue del directorio C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\manager de la aplicación web
sep 15, 2017 11:44:37 AM org.apache.catalina.startup.HostConfig deployDirectory
Información: Despliegue del directorio C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\OpenClinica de la aplicación web
sep 15, 2017 11:44:41 AM org.apache.catalina.loader.WebappClassLoader validateJarFile
Información: validateJarFile(C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\OpenClinica\WEB-INF\lib\servlet-api-2.3.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class
sep 15, 2017 11:44:59 AM org.apache.catalina.startup.TaglibUriRule body
Información: TLD skipped. URI: http://code.google.com/p/jmesa is already defined
sep 15, 2017 11:45:24 AM org.apache.catalina.core.StandardContext startInternal
Grave: Error listenerStart
sep 15, 2017 11:45:24 AM org.apache.catalina.core.StandardContext startInternal
Grave: Falló en arranque del Contexto [/OpenClinica] debido a errores previos
sep 15, 2017 11:45:24 AM org.apache.catalina.startup.HostConfig deployDirectory
Información: Despliegue del directorio C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\ROOT de la aplicación web
sep 15, 2017 11:45:24 AM org.apache.coyote.AbstractProtocol start
Información: Starting ProtocolHandler ["http-bio-8080"]
sep 15, 2017 11:45:24 AM org.apache.coyote.AbstractProtocol start
Información: Starting ProtocolHandler ["ajp-bio-8009"]
sep 15, 2017 11:45:24 AM org.apache.catalina.startup.Catalina start
Información: Server startup in 47199 ms
towireCapableBeanFactory.java:394)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1413)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:353)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:983)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:879)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:626)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:407)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(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.contextInitialized(OCContextLoaderListener.java:38)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1229)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Hello everyone,

I am having an issue upgrading OpenClinica-3.13 to a newer version. After completing all of the upgrade steps and trying to deploy it with Tomcat, the deployment fails with the following error:

SEVERE [main] org.apache.catalina.core.StandardContext.listenerStart Exception sending context initialized event to listener instance of class [org.akaza.openclinica.dao.core.OCContextLoaderListener] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/akaza/openclinica/applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set migration/3.14/2017-06-05-OC-7394.xml::2017-06-05-7394-1::sdibona: Reason: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE event_crf ADD CONSTRAINT uniq_study_event_crf_version_study_subject UNIQUE (study_event_id, crf_version_id, study_subject_id): Caused By: Error executing SQL ALTER TABLE event_crf ADD CONSTRAINT uniq_study_event_crf_version_study_subject UNIQUE (study_event_id, crf_version_id, study_subject_id): Caused By: ERROR: could not create unique index "uniq_study_event_crf_version_study_subject" Detail: Key (study_event_id, crf_version_id, study_subject_id)=(59977, 8175, 5910) is duplicated.

I found a script for removing duplicates (OpenClinica-x.x/conf/database/PostgreSQL/upgrade/Duplicate_Delete_v5.sql), but it only works with a different table and doesn't solve my issue. There are 149 duplicates in my database, and I am unsure if manual deletion is a good idea since there are references to this table in the database.
Does anyone faced with such an issue? Unfortunately, searching doesn't provide me any relevant information.

authenticating using /pages/accounts/login doesn't increase lock_counter in user_account-table.

this means you have unlimited attempts to break a password even with "Lockout Configuration" enabled.

I have installed the latest version of OC Community. And while I can logon to the application and do what's needed, every page is takes awhile to load. My logs are capturing some Severe error messages, but I can't seem to figure out the issue. Any help appreciated.

Thanks,
SG
catalina.2022-04-29.log.txt
localhost.2022-04-29.log.txt
tomcat9-stderr.2022-04-29.log.txt
tomcat9-stdout.2022-04-29.log.txt

on repeating events you only see status of first event.

suggestion:
show status of the event with lowest status
show status icon at event numbers (next to "Add another occurrence" )

I want to intall the latest openclinical softeware on my computer, but it failed when I start the application. I just did it followed by the install guide, I've already installed java(jdk 1.7), tomcat(7.0) and postgresql(9.1.x) successfully. And the tomcat can work well with deploy other .war file.
I read the logs in localhost.log, it writes:

Exception sending context destroyed event to listener instance of class org.akaza.openclinica.control.OCServletContextListener
org.springframework.beans.factory.BeanDefinitionStoreException: Invalid bean definition with name 'schedulerFactoryBean' defined in class path resource [org/akaza/openclinica/applicationContext-core-scheduler.xml]: Could not resolve placeholder 'org.quartz.jobStore.class'……

anyone who has met this problem before? Who can help me to solve this? Thanks!!!!!!

Hello,

Made LDAP work on my instance sort of... if a user has a UTF8 character in their path I get
]; nested exception is javax.naming.NameNotFoundException: [LDAP: error code 32 - 0000208D: NameErr: DSID-03100238, problem 2001 (NO_OBJECT), data 0, best match of:
And if the persons name does not contain a UTF 8 charset (ąččęėįšųū) I can add the user.

Is there a way to work around this maybe something in the search query can be tweaked or maybe there is setting somewhere where I could force UTF 8 encoding on the connection between LDAP?

The following code throws an IllegalArgumentException (tested on 3.9.1 and 3.12.2):

When uploading a rule referencing _CURRENT_DATE on an installation with a non-UTC timezone the call OpenClinicaVariableNode.calculateVariable triggers an IllegalArgumentException. On line 201 null is received for ssZoneId.

    private String calculateVariable() {
        if (number.equals("_CURRENT_DATE")) {
            String ssZoneId= getExpressionService().getSSZoneId();         // evaluates to `null`
            String serverZoneId =TimeZone.getDefault().getID();
            return getExpressionService().getSSDate(ssZoneId,serverZoneId).get("ssDate");
        }
        return null;
    }

Within ExpressionService.getSSDate null is replaced by TimeZone.getDefault().getID(), which is then fed into Joda's DateTimeZone.forID(ssZoneId).

    public HashMap<String, String> getSSDate(String ssZoneId, String serverZoneId) {
        HashMap<String, String> map = new HashMap<String, String>();
        if (ssZoneId == null || ssZoneId.equals(""))
            ssZoneId = TimeZone.getDefault().getID();

        DateTimeZone ssZone = DateTimeZone.forID(ssZoneId);
        DateMidnight dm = new DateMidnight(ssZone);
        DateTimeFormatter fmt = ISODateTimeFormat.date();
        map.put("ssDate", fmt.print(dm));
        
        map.put("serverZoneId", serverZoneId);
        DateTimeZone serverZone = DateTimeZone.forID(serverZoneId);
        DateMidnight serverDate = new DateMidnight(serverZone);
        map.put("serverDate", fmt.print(serverDate));
        return map;
    }

From the Javadocs for said DateTimeZone.forID():

Short ids, as accepted by TimeZone, are not accepted.

This is where an IllegalArgumentException is triggered.

On servers with timezone set to UTC Java's TimeZone returns the string UTC, which is understood by Joda's DateTimeZone.

Workaround

Start Tomcat with -Duser.timezone=UTC and force Java to assume UTC timezone. This, of course, has impact on the date handling and might lead to unexpected results.

Hi,
I'm trying to install last version of openclinica 3.16 on centos7 with Apache Tomcat/7.0.99 Postgresql 9.6 and openjdk 11.0.13
From start to Tomcat console manager I obtain
"FAIL - Application at context path [/OpenClinica] could not be started"
From address http://54.xxx.xxxx.xxxx:8080/OpenClinica/
I obtain
"HTTP Status 404 – Not Found"
"Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists."

How could I fix it?
Regards

After keenly following on the set procedure at http://docs.openclinica.com/3.1/technical-documents/developing-openclinica it seem to be way outdated.
I tried the set up using Eclipse Mars.2, Maven 3.0 and Spring 4.5 (Unable to set Spring 3.7 since MyLyn installed is more recent).

While above was successfully, on importing OC3.14, seems some of the plugins are missing from https://openclinica.jfrog.io/openclinica/libs-release/ repository and the import progress stalls at 39%.

Assistance on the environment setup used to develop OC3.14 or OC3.15 will be appreciated or pointer to more recent development environment guide will be appreciated.

Thanks in advance.

After i download the project 3.10.1 into my computer,i import the project into my eclipse .but i find the CrfEndpoint.java and StudySubjectEndpoint.java build error .Because it can not find these class.

import org.openclinica.ws.crf.v1.CreateCrfResponse; import org.openclinica.ws.crf.v1.CrfType; import org.openclinica.ws.crf.v1.ObjectFactory;

import org.openclinica.ws.beans.EventType; import org.openclinica.ws.beans.EventsType; import org.openclinica.ws.beans.GenderType; import org.openclinica.ws.beans.ListStudySubjectsInStudyType; import org.openclinica.ws.beans.StudyRefType; import org.openclinica.ws.beans.StudySubjectWithEventsType; import org.openclinica.ws.beans.StudySubjectsType; import org.openclinica.ws.beans.SubjectType; import org.openclinica.ws.studysubject.v1.ListAllByStudyResponse;

How should i do?

The Central Repository can't find this dependency
<dependency> <groupId>org.springframework.security.oauth</groupId> <artifactId>spring-security-oauth</artifactId> <version>1.0.0.M2</version> </dependency>

I Changed to

<dependency> <groupId>org.codehaus.spring-security-oauth</groupId> <artifactId>spring-security-oauth</artifactId> <version>3.19.SS3</version> </dependency>

We are trying to extract a dataset in OpenClinica (on Docker Linux) hosted on AWS Linux machine logging in as root. It says, the dataset extract is running and an email is expected. However, usually after a while we can download from same page but we don’t see an entry or email. What I observed was once I click extract dataset it is getting logged out. We tried creating dataset in several formats but the issue remains the same. We have recently migrated from Windows to Docker Linux containers. Could this be causing ?

Interestingly, this is happening across all studies but working on one study. The following is the relevant part of the logs. Any help is appreciated. Is there any other way to extract data ?

 09/16 22:04:49 [] FTP INFO   o.a.o.j.OpenClinicaStdSchedulerFactory:1179 - Using default implementation for ThreadExecutor 
 09/16 22:04:49 [] FTP INFO   o.a.o.j.OpenClinicaStdSchedulerFactory:1324 - Quartz scheduler 'schedulerFactoryBean' initialized from an externally provided properties instance. 
 09/16 22:04:49 [] FTP INFO   o.a.o.j.OpenClinicaStdSchedulerFactory:1328 - Quartz scheduler version: 1.8.6 
 09/16 22:04:49 [] FTP INFO   o.a.o.j.OpenClinicaSchedulerFactoryBean:650 - Starting Quartz Scheduler now 
 09/16 22:06:08 [] FTP INFO  root o.a.o.c.e.ExportDatasetServlet:513 - action is blank 
 09/16 22:06:08 [] FTP INFO  root o.a.o.c.e.ExportDatasetServlet:515 - just set dataset to request 
 09/16 22:06:08 [] FTP WARN  root o.a.o.c.e.ExportDatasetServlet:546 -  
 09/16 22:06:08 [] FTP WARN  root o.a.o.c.e.ExportDatasetServlet:547 - file list length: 0 
 09/16 22:06:08 [] FTP WARN  root o.a.o.c.e.ExportDatasetServlet:588 - just set file list to request, sending to page 
 09/16 22:06:27 [/usr/local/tomcat/webapps/OpenClinica/] FTP INFO   o.a.o.j.XsltTransformJob:114 - Job XsltTriggers.260_TAB_TEST_Full_Extract_2021_2021-09-16-220627882.tsv1631829987886 started. 
 09/16 22:06:28 [/usr/local/tomcat/webapps/OpenClinica/] AUTHPRIV INFO   o.a.o.d.h.RuleSetRuleDao:63 - EntityRuleSet3 
 09/16 22:06:28 [/usr/local/tomcat/webapps/OpenClinica/] AUTHPRIV INFO   o.a.o.d.h.RuleSetRuleDao:64 - null 
 09/16 22:06:28 [/usr/local/tomcat/webapps/OpenClinica/] AUTHPRIV INFO   o.a.o.d.h.RuleSetRuleDao:65 - hit count0 
 09/16 22:06:40 [/usr/local/tomcat/webapps/OpenClinica/] FTP INFO   o.a.o.s.BulkEmailSenderService:42 - Executing now...0 taskScheduler-2 0 
 09/16 22:06:40 [/usr/local/tomcat/webapps/OpenClinica/] FTP INFO   o.a.o.s.BulkEmailSenderService:46 - Nothing left to do getting out... 
 09/16 22:07:41 [/usr/local/tomcat/webapps/OpenClinica/] FTP INFO   o.a.o.j.OpenClinicaStdSchedulerFactory:1179 - Using default implementation for ThreadExecutor 
 09/16 22:07:41 [/usr/local/tomcat/webapps/OpenClinica/] FTP INFO   o.a.o.j.OpenClinicaStdSchedulerFactory:1324 - Quartz scheduler 'schedulerFactoryBean' initialized from an externally provided properties instance. 
 09/16 22:07:41 [/usr/local/tomcat/webapps/OpenClinica/] FTP INFO   o.a.o.j.OpenClinicaStdSchedulerFactory:1328 - Quartz scheduler version: 1.8.6 
 09/16 22:07:41 [/usr/local/tomcat/webapps/OpenClinica/] FTP INFO   o.a.o.j.OpenClinicaSchedulerFactoryBean:650 - Starting Quartz Scheduler now 
 09/16 22:07:41 [/usr/local/tomcat/webapps/OpenClinica/] FTP INFO   o.a.o.s.BulkEmailSenderService:42 - Executing now...0 taskScheduler-1 0 
 09/16 22:07:41 [/usr/local/tomcat/webapps/OpenClinica/] FTP INFO   o.a.o.s.BulkEmailSenderService:46 - Nothing left to do getting out... 
 09/16 22:08:10 [] FTP INFO   o.a.o.j.OpenClinicaStdSchedulerFactory:1179 - Using default implementation for ThreadExecutor 
 09/16 22:08:10 [] FTP INFO   o.a.o.j.OpenClinicaStdSchedulerFactory:1324 - Quartz scheduler 'schedulerFactoryBean' initialized from an externally provided properties instance. 
 09/16 22:08:10 [] FTP INFO   o.a.o.j.OpenClinicaStdSchedulerFactory:1328 - Quartz scheduler version: 1.8.6 
 09/16 22:08:11 [] FTP INFO   o.a.o.j.OpenClinicaSchedulerFactoryBean:650 - Starting Quartz Scheduler now 
 09/16 22:09:41 [/usr/local/tomcat/webapps/OpenClinica/] FTP INFO   o.a.o.s.BulkEmailSenderService:42 - Executing now...0 taskScheduler-2 0 
 09/16 22:09:41 [/usr/local/tomcat/webapps/OpenClinica/] FTP INFO   o.a.o.s.BulkEmailSenderService:46 - Nothing left to do getting out... 
 09/16 22:11:41 [/usr/local/tomcat/webapps/OpenClinica/] FTP INFO   o.a.o.s.BulkEmailSenderService:42 - Executing now...0 taskScheduler-3 0 
 09/16 22:11:41 [/usr/local/tomcat/webapps/OpenClinica/] FTP INFO   o.a.o.s.BulkEmailSenderService:46 - Nothing left to do getting out... 
 09/16 22:13:27 [] FTP INFO  root o.a.o.c.e.ExportDatasetServlet:513 - action is blank 
 09/16 22:13:27 [] FTP INFO  root o.a.o.c.e.ExportDatasetServlet:515 - just set dataset to request 
 09/16 22:13:27 [] FTP WARN  root o.a.o.c.e.ExportDatasetServlet:546 -  
 09/16 22:13:27 [] FTP WARN  root o.a.o.c.e.ExportDatasetServlet:547 - file list length: 0 
 09/16 22:13:27 [] FTP WARN  root o.a.o.c.e.ExportDatasetServlet:588 - just set file list to request, sending to page 

I'm having issues installing the latest version of OC 4.0.1, especially with Auth0 authentication.

• Error from Auth0 logs: Missing required parameter: response_type
• OC then redirects me to /error each time

I think my Auth0 configuration is wonky (my fault). Any advice on how to proceed?

' in LEFT_ITEM_TEXT or RIGHT_ITEM_TEXT is saved into the database as ' ' and javascript like onmouseover="Tip('Our own information here')" is saved as onmouseover="Tip(''Our own information here'')" (' is saved twice and function won't work)

I import master version and find some classes in package org.openclinica.ns.odm_ext_v130.v31 like OCodmComplexTypeDefinitionFormLayoutRef are missing after add ocdom project. How can I find these? Thanks.

build 27-Apr-2017 15:37:00 [INFO] -------------------------------------------------------------
build 27-Apr-2017 15:37:00 [ERROR] COMPILATION ERROR :
build 27-Apr-2017 15:37:00 [INFO] -------------------------------------------------------------
build 27-Apr-2017 15:37:00 [ERROR] /opt/bamboo/xml-data/build-dir/OP-OCT-JOB1/core/src/main/java/org/akaza/openclinica/service/crfdata/XformMetaDataService.java:[69,43] cannot find symbol
build 27-Apr-2017 15:37:00 symbol: class OCodmComplexTypeDefinitionFormLayoutDef
build 27-Apr-2017 15:37:00 location: package org.openclinica.ns.odm_ext_v130.v31
build 27-Apr-2017 15:37:00 [ERROR] /opt/bamboo/xml-data/build-dir/OP-OCT-JOB1/core/src/main/java/org/akaza/openclinica/service/crfdata/ExecuteIndividualCrfObject.java:[9,43] cannot find symbol
build 27-Apr-2017 15:37:00 symbol: class OCodmComplexTypeDefinitionFormLayoutDef
build 27-Apr-2017 15:37:00 location: package org.openclinica.ns.odm_ext_v130.v31
build 27-Apr-2017 15:37:00 [ERROR] /opt/bamboo/xml-data/build-dir/OP-OCT-JOB1/core/src/main/java/org/akaza/openclinica/service/crfdata/ExecuteIndividualCrfObject.java:[14,17] cannot find symbol
build 27-Apr-2017 15:37:00 symbol: class OCodmComplexTypeDefinitionFormLayoutDef
build 27-Apr-2017 15:37:00 location: class org.akaza.openclinica.service.crfdata.ExecuteIndividualCrfObject
build 27-Apr-2017 15:37:00 [ERROR] /opt/bamboo/xml-data/build-dir/OP-OCT-JOB1/core/src/main/java/org/akaza/openclinica/service/crfdata/ExecuteIndividualCrfObject.java:[23,53] cannot find symbol
build 27-Apr-2017 15:37:00 symbol: class OCodmComplexTypeDefinitionFormLayoutDef
build 27-Apr-2017 15:37:00 location: class org.akaza.openclinica.service.crfdata.ExecuteIndividualCrfObject
build 27-Apr-2017 15:37:00 [ERROR] /opt/bamboo/xml-data/build-dir/OP-OCT-JOB1/core/src/main/java/org/akaza/openclinica/service/EDCTagDTO.java:[6,43] cannot find symbol
build 27-Apr-2017 15:37:00 symbol: class OCodmComplexTypeDefinitionConfigurationParameters
build 27-Apr-2017 15:37:00 location: package org.openclinica.ns.odm_ext_v130.v31
build 27-Apr-2017 15:37:00 [ERROR] /opt/bamboo/xml-data/build-dir/OP-OCT-JOB1/core/src/main/java/org/akaza/openclinica/service/EDCTagDTO.java:[11,13] cannot find symbol
build 27-Apr-2017 15:37:00 symbol: class OCodmComplexTypeDefinitionConfigurationParameters
build 27-Apr-2017 15:37:00 location: class org.akaza.openclinica.service.EDCTagDTO
build 27-Apr-2017 15:37:00 [ERROR] /opt/bamboo/xml-data/build-dir/OP-OCT-JOB1/core/src/main/java/org/akaza/openclinica/service/EDCTagDTO.java:[45,12] cannot find symbol
build 27-Apr-2017 15:37:00 symbol: class OCodmComplexTypeDefinitionConfigurationParameters
build 27-Apr-2017 15:37:00 location: class org.akaza.openclinica.service.EDCTagDTO
build 27-Apr-2017 15:37:00 [ERROR] /opt/bamboo/xml-data/build-dir/OP-OCT-JOB1/core/src/main/java/org/akaza/openclinica/service/EDCTagDTO.java:[49,25] cannot find symbol
build 27-Apr-2017 15:37:00 symbol: class OCodmComplexTypeDefinitionConfigurationParameters
build 27-Apr-2017 15:37:00 location: class org.akaza.openclinica.service.EDCTagDTO
build 27-Apr-2017 15:37:00 [ERROR] /opt/bamboo/xml-data/build-dir/OP-OCT-JOB1/core/src/main/java/org/akaza/openclinica/service/EventDefinitionCrfDTO.java:[11,43] cannot find symbol
build 27-Apr-2017 15:37:00 symbol: class OCodmComplexTypeDefinitionConfigurationParameters
build 27-Apr-2017 15:37:00 location: package org.openclinica.ns.odm_ext_v130.v31

Hi folks,

I'm trying to get the soap request to work with the most current version, but without success.

Request:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v1="http://openclinica.org/ws/study/v1">
  <soapenv:Header>
    <wsse:Security soapenv:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
      <wsse:UsernameToken wsu:Id="UsernameToken-27777511" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
        <wsse:Username>root</wsse:Username>
        <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">a3adf26e70b8d8ab53da3d36b159ccb341d014e6</wsse:Password>
      </wsse:UsernameToken>
    </wsse:Security>
  </soapenv:Header>
  <soapenv:Body>
    <v1:listAllRequest/>
  </soapenv:Body>
</soapenv:Envelope>

Response:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
   <SOAP-ENV:Header/>
   <SOAP-ENV:Body>
      <SOAP-ENV:Fault>
         <faultcode>SOAP-ENV:Client</faultcode>
         <faultstring xml:lang="en">com.sun.xml.wss.impl.WssSoapFaultException: Authentication of Username Password Token Failed; nested exception is com.sun.xml.wss.XWSSecurityException: com.sun.xml.wss.impl.WssSoapFaultException: Authentication of Username Password Token Failed</faultstring>
      </SOAP-ENV:Fault>
   </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Thanks for your help.
/Jens

comma is automatically escaped with \ when used in RESPONSE_VALUES_OR_CALCULATIONS column of uploaded ecrf xls file.
This causes functions like func: ((weight/pow(height,2))*10000) to stop working and requires manual correction in database (replacement of \, with ,)

I have installed openclinica per instruction but it give me that error when i want to start on apche tomcat

After discarting my initial plan of deploying OC 3.14 due to its lack of support for PostgreSQL 9.6 I am trying to deploy latest OC version (4.7.6). Compilation went well, but I noticed the architecture of the app has changed.

Installation documentation is outdated and refers to all modules in 3.x. Could somebody provide me some guidance on how to launch the application using Tomcat 7.

Help would be really appreaciated. Thanks a lot.

1. I see you are using an older version of JMesa.. one that is not available anywhere except your own repo.. 2.4.2-oc.. 2. the extension "-oc" makes me think its not only old but a customized version of this. Care to share the source code for it?

As I could see in the official documentation the suggested method of getting values of DOM element in OpenClinica is using "children", "sibilings" and "parents" jquery methods:

http://en.wikibooks.org/wiki/OpenClinica_User_Manual/VarsFromHeader#How_does_it_work.3F

Are you planning in further versions identify DOM elements in a proper way? This method is prone to suffer several bugs or getting incorrect values if someone alters the field structure.

I needed to find out is it possible to extract data directly from Open clinica to R or stata without necessarily logging into Open clinica or choose a file extension. I have seen its possible with other database platform such redcap because of its API features. Is Open clinica possible?

Please let me know
thanks

What are the limits of this program?

There a some problems with the OpenClinica installation guides. There are some links that aren't useful anymore.

For example:
https://openclinica.app.box.com/oc-downloads/1/2186651363

Does the OpenClinica offer custom language?

Are there any thoughts about opening a branch for OC3.x supporting more recent JDKs?

JDK7 and JDK8 are already outdated and not recommended for production use

see warning at https://www.oracle.com/java/technologies/javase/javase7-archive-downloads.html
and https://www.oracle.com/java/technologies/javase/javase8u211-later-archive-downloads.html

most recent JDK with LTS ist JDK 17
next JDK with LTS will be JDK 21 issue planned for September 2023

OpenClinica is failing to download real number / integer for my study this include age, weight, height, Blood pressure and vital signs. I am not sure where the problem is... Kindly help.

It looks like code cleanup has not been completed yet.
OpenClinica-web: Compilation failure
build 13-Jun-2016 13:47:55 [ERROR] /mnt/sdc/bamboo/xml-data/build-dir/OC-OCC-JOB1/web/src/main/java/org/akaza/openclinica/controller/ReportController.java:[5,51] error: package org.akaza.openclinica.controller.healthcheck does not exist

Can't compile branch 3.14-pom

seems like repo http://dev.openclinica.com/artifactory/libs-snapshot/ is not accessible.

download of http://dev.openclinica.com/artifactory/libs-snapshot/log4jdbc/log4jdbc4/1.2/log4jdbc4-1.2.pom fails.

Additional Info:

got following repsonse while browsing the Repo-URL:
HTTP 502

Proxy Error

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET /artifactory/libs-snapshot/.

Reason: Error reading from remote server

Apache/2.2.17 (Ubuntu) Server at dev.openclinica.com Port 443

Output by calling Maven:

[3.14-pom]$ mvn clean compile
[INFO] Scanning for projects...
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Build Order:
[INFO]
[INFO] OpenClinica
[INFO] OpenClinica Core
[INFO] OpenClinica Web Application
[INFO] OpenClinica Web Services
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building OpenClinica 3.14-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] --- maven-clean-plugin:2.5:clean (default-clean) @ OpenClinica ---
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building OpenClinica Core 3.14-SNAPSHOT
[INFO] ------------------------------------------------------------------------
Downloading: http://dev.openclinica.com/artifactory/libs-snapshot/log4jdbc/log4jdbc4/1.2/log4jdbc4-1.2.pom
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] OpenClinica ........................................ SUCCESS [ 0.271 s]
[INFO] OpenClinica Core ................................... FAILURE [ 3.311 s]
[INFO] OpenClinica Web Application ........................ SKIPPED
[INFO] OpenClinica Web Services ........................... SKIPPED
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 3.898 s
[INFO] Finished at: 2017-10-16T13:29:23+02:00
[INFO] Final Memory: 13M/308M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal on project OpenClinica-core: Could not resolve dependencies for project org.akaza.openclinica:OpenClinica-core:jar:3.14-SNAPSHOT: Failed to collect dependencies at log4jdbc:log4jdbc4:jar:1.2: Failed to read artifact descriptor for log4jdbc:log4jdbc4:jar:1.2: Could not transfer artifact log4jdbc:log4jdbc4:pom:1.2 from/to snapshots (http://dev.openclinica.com/artifactory/libs-snapshot): sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR] mvn -rf :OpenClinica-core

As of januari 12, 2016 Microsoft has officially dropped support for any versions of Internet Explorer older than the last released version (11).

OpenClinica currently tells IE to render the page in IE8 compatibility mode, effectively forcing the page to be rendered by a non-supported version of Internet Explorer. This should be adjusted to the more common "IE=Edge" compatibility mode which will allow Internet Explorer to always use the latest available rendering engine.

Hi there,

I'm running OC v3.11.

As i wrote in the issue title, when open the page RemoveStudyEvent, i suppose it is: RemoveStudyEvent?action=confirm&id=1&studySubId=1

This page have 3 weird bugs: (http://prntscr.com/d8aenu)

1. The Study Setup menu item disappear
2. My current study is The JUNO Diabetes Study (JUNO) but is automatically changed to Site A?? (What's going on here?)
3. The menu item View Study does not work, it redirect to the menu page with this messages:

You don't have correct permission in your current Study. Change your current Study or contact your administrator.

I checked this on your demo site (https://demo.eclinicalhosting.com/OpenClinica/RemoveStudyEvent?action=confirm&id=1&studySubId=1), and it have the same result.

I think may be there was some mistakes when you detect the current Study on this page.
Please review this bug and fix it soon.

Thanks for reading.

When you have studies with many sites the dropdown view is sometimes to short to view correspionding study.

suggestion:
show study as prefix of site in dropdown lists

When using the previously provided PostgreSQL 9.x patch things mostly work, except for a regular expression validation filter.

After many tests the most illustrative was using the patched version against both PostgreSQL 8.4 and 9.x in two separate tests.

8.4 results in:

select DISTINCT regexp from item_form_metadata;
regexp: /[0-1]\d:[0-5]\d|2[0-3]:[0-5]\d/

9.x results in:

select DISTINCT regexp from item_form_metadata;
regexp: /[0-1]\d:[0-5]\d|2[0-3]:[0-5]\d/

It looks like in the case of PostgreSQL 9.x the string may be escaped twice, thus breaking any intended use of a single \ escape.

For example, in 9.x versions the above regexp will allow a 'time' of 1\d:4\d through, instead of a time of 12:34.

Unfortunately I've not had success in tracking down the lifecycle of the regexp field; as this string occurs in far too many locations. Similarly searching for 'replace' lead me to a 'StringUtil.escapeSingleQuote' function, which might be incorrectly used to incompletely escape SQL field values, as well as a stripQuotes function within SpreadSheetTableRepeating.

It may also be good to glance at http://stackoverflow.com/questions/4954002/how-to-escape-user-supplied-parameters-with-a-sql-query depending upon how much OpenClinica talks directly to the JDBC instead of through frameworks that abstract away security pitfalls.

Hi,

how to change the RSS Feed from default in OpenClinica Community version 3.1.4, in data.properties?

Thank you very much,

Silke.