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

data export

Hello All,
ich have a question regarding data export:
Why get all item names after data export an additional new ending (_A1).
Thanks Judith
pharmtrace - imaging therapy
Dr. rer. nat. Judith Jaehnchen
Medical Sciences - Pharmtrace GmbH
Friedrichstr. 94, 10117 Berlin, Germany
Phone: +49 30 2096 4025, Fax: +49 30 2096 4029

Comments

  • Hello, Judith -

    The ending designates the CRF that the item is on. You can see the CRF designations in the Info pane on the left when you view the dataset as HTML. In addition to that, suffixes are appended to identify repeating occurrences of CRFs. Also, if there are ‘grouped’ items, another suffix will appear to identify the group, followed by the number of the item within the group.

    Best Regards,

    - Jeff

    Jeff Halperin
    Account Manager
    Akaza Research
    400 One Kendall Square
    Cambridge, MA 02139
    tel: 617.621.8585 x15
    fax: 617.621.0065
    [email protected]
    www.akazaresearch.com
    www.openclinica.org
    Open Source Platform for Clinical Research
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    Sent: Wednesday, September 17, 2008 9:44 AM
    To: [email protected]
    Subject: [Users] data export
    Hello All,
    ich have a question regarding data export:
    Why get all item names after data export an additional new ending (_A1).
    Thanks Judith
    pharmtrace - imaging therapy
    Dr. rer. nat. Judith Jaehnchen
    Medical Sciences - Pharmtrace GmbH
    Friedrichstr. 94, 10117 Berlin, Germany
    Phone: +49 30 2096 4025, Fax: +49 30 2096 4029
  • Am downloading data in openclinica using the tab-delimited text and
    Apache tomcat encounters an internal error. What could be the source
    of the problem.
    The following message is returned.
    HTTP Status 500 -
    --------------------------------------------------------------------------------
    type Exception report
    message
    description The server encountered an internal error () that prevented
    it from fulfilling this request.
    exception
    javax.servlet.ServletException: Servlet execution threw an exception
    com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
    com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
    org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
    org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
    org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp(SessionFixationProtectionFilter.java:67)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    root cause
    java.lang.OutOfMemoryError: Java heap space
    note The full stack trace of the root cause is available in the Apache
    Tomcat/5.5.27 logs.
    --------------------------------------------------------------------------------
    Apache Tomcat/5.5.27
    Regards,
    Naitala
  • Am downloading data in openclinica using the tab-delimited text and
    Apache tomcat encounters an internal error. What could be the source
    of the problem.
    The following message is returned.
    HTTP Status 500 -
    --------------------------------------------------------------------------------
    type Exception report
    message
    description The server encountered an internal error () that prevented
    it from fulfilling this request.
    exception
    javax.servlet.ServletException: Servlet execution threw an exception
    com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
    com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
    org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
    org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
    org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp(SessionFixationProtectionFilter.java:67)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    root cause
    java.lang.OutOfMemoryError: Java heap space
    note The full stack trace of the root cause is available in the Apache
    Tomcat/5.5.27 logs.
    --------------------------------------------------------------------------------
    Apache Tomcat/5.5.27
    Regards,
    Naitala
  • haenselhaensel Posts: 602 ✭✭✭
    Hi all
    I added a new FAQ section with a short note (without detailed instructions) for this problem[1] to the OpenClinica wikibook.
    Regards,
    Christian
    [1] http://en.wikibooks.org/wiki/OpenClinica_User_Manual/OutOfMemoryError
    Am 29.9.2010 09:43, schrieb Naitala Ronald:
    > Morning all
    >
    > Am downloading data in openclinica using the tab-delimited text and
    > Apache tomcat encounters an internal error. What could be the source
    > of the problem.
    >
    > The following message is returned.
    >
    > HTTP Status 500 -
    >
    > --------------------------------------------------------------------------------
    >
    > type Exception report
    >
    > message
    >
    > description The server encountered an internal error () that prevented
    > it from fulfilling this request.
    >
    > exception
    >
    > javax.servlet.ServletException: Servlet execution threw an exception
    > com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
    > com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
    > org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
    > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    > org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
    > org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
    > org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
    > org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    > org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp(SessionFixationProtectionFilter.java:67)
    > org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    > org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    > org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
    > org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    > org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    > org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    > org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    > org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    > org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    > org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    > org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    > org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
    > org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    > org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    > org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
    > org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    > org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    > org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    > org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    > org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    > org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
    > org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
    > org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    >
    >
    > root cause
    >
    > java.lang.OutOfMemoryError: Java heap space
    >
    >
    > note The full stack trace of the root cause is available in the Apache
    > Tomcat/5.5.27 logs.
    >
    >
    > --------------------------------------------------------------------------------
    >
    > Apache Tomcat/5.5.27
    >
    > Regards,
    > Naitala
    >
This discussion has been closed.