Uploaded image for project: 'i2b2 Web Client'
  1. i2b2 Web Client
  2. WEBCLIENT-45

Searching in text field returns all results

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Cannot Reproduce
    • 1.6.06
    • None
    • Web Client
    • None
    • Unix, Oracle
    • Query Tool
    • Constraints - Text Search

    Description

      All,

      We are running I2B2 1.6.06 and are having issues searching on Text Reports . The issue we have is that we get all results returned and not just those filtered by the search terms. The query I see in the log , when run separately returns the correct result . so this is a mystery. No Errors anywhere just too many results. Anyone willing to look over my settings or should I submit a Jira Ticket ?

      Is this a know issue in 1.6.06 ? I don't see it in I2B2 Jira . I have a word document with screen shots of all the data involved in this search I'll try to attach after submitting this issue. Contact be at gkowalski@mcw.edu if it's not attached.

      Thanks

       
      George Kowalski

      Attachments

        Activity

          Looks like I can't upload this word doc... Bummer.
          kowalskg George Kowalski added a comment - Looks like I can't upload this word doc... Bummer.
          Getting back to this . Yes I did run the following and it still fails to search the Binary field :

          INSERT
          INTO
              QT_PRIVILEGE
              (
                  PROTECTION_LABEL_CD,
                  DATAPROT_CD,
                  HIVEMGMT_CD
              )
              VALUES
              (
                  'SETFINDER_QRY_WITH_LGTEXT',
                  'DATA_DEID',
                  'USER'
              );
          gkowalski George Kowalski added a comment - Getting back to this . Yes I did run the following and it still fails to search the Binary field : INSERT INTO     QT_PRIVILEGE     (         PROTECTION_LABEL_CD,         DATAPROT_CD,         HIVEMGMT_CD     )     VALUES     (         'SETFINDER_QRY_WITH_LGTEXT',         'DATA_DEID',         'USER'     );
          And my user has DATA_DEID perms in the PM_PROJET_USER_ROLES table.

          PROJECT_ID USER_ID USER_ROLE_CD

          CDW mcwcorp\gkowalsk DATA_OBFSC
          CDW mcwcorp\gkowalsk USER
          CDW mcwcorp\gkowalsk DATA_DEID

          gkowalski George Kowalski added a comment - And my user has DATA_DEID perms in the PM_PROJET_USER_ROLES table. PROJECT_ID USER_ID USER_ROLE_CD CDW mcwcorp\gkowalsk DATA_OBFSC CDW mcwcorp\gkowalsk USER CDW mcwcorp\gkowalsk DATA_DEID
          Exception in the log of JBoss is :

          10:54:04,760 ERROR [STDERR] Caused by: org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 3
          10:54:04,760 ERROR [STDERR] at org.springframework.dao.support.DataAccessUtils.requiredUniqueResult(DataAccessUtils.java:72)
          10:54:04,760 ERROR [STDERR] at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:621)
          10:54:04,760 ERROR [STDERR] at edu.harvard.i2b2.crc.dao.role.PriviledgeSpringDao.getPriviledgeByProtectionLabel(Unknown Source)
          10:54:04,760 ERROR [STDERR] at edu.harvard.i2b2.crc.ejb.role.PriviledgeBean.checkPriviledge(Unknown Source)
          10:54:04,760 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          10:54:04,760 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
          10:54:04,760 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          10:54:04,760 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
          10:54:04,760 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
          10:54:04,760 ERROR [STDERR] at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
          10:54:04,760 ERROR [STDERR] at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
          10:54:04,760 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
          10:54:04,760 ERROR [STDERR] at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
          10:54:04,760 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
          10:54:04,760 ERROR [STDERR] at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
          10:54:04,761 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
          10:54:04,761 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
          10:54:04,761 ERROR [STDERR] ... 48 more
          kowalskg George Kowalski added a comment - Exception in the log of JBoss is : 10:54:04,760 ERROR [STDERR] Caused by: org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 3 10:54:04,760 ERROR [STDERR] at org.springframework.dao.support.DataAccessUtils.requiredUniqueResult(DataAccessUtils.java:72) 10:54:04,760 ERROR [STDERR] at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:621) 10:54:04,760 ERROR [STDERR] at edu.harvard.i2b2.crc.dao.role.PriviledgeSpringDao.getPriviledgeByProtectionLabel(Unknown Source) 10:54:04,760 ERROR [STDERR] at edu.harvard.i2b2.crc.ejb.role.PriviledgeBean.checkPriviledge(Unknown Source) 10:54:04,760 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 10:54:04,760 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 10:54:04,760 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 10:54:04,760 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597) 10:54:04,760 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112) 10:54:04,760 ERROR [STDERR] at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166) 10:54:04,760 ERROR [STDERR] at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63) 10:54:04,760 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) 10:54:04,760 ERROR [STDERR] at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54) 10:54:04,760 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) 10:54:04,760 ERROR [STDERR] at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) 10:54:04,761 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) 10:54:04,761 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79) 10:54:04,761 ERROR [STDERR] ... 48 more
          We are not able to reproduce this issue in the latest version of i2b2 (1.7.02) that will be released soon.
          jmd86 Janice Donahoe added a comment - We are not able to reproduce this issue in the latest version of i2b2 (1.7.02) that will be released soon.

          People

            mem61 Mike Mendis
            kowalskg George Kowalski
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: