[WEBCLIENT-45] Searching in text field returns all results - i2b2 JIRA

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Cannot Reproduce
Affects Version/s: 1.6.06
Fix Version/s: None
Component/s: Web Client
Labels:
None
Environment:
Unix, Oracle

Affects View/s:

Query Tool
i2b2 Feature/s:

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

Ascending order - Click to sort in descending order

George Kowalski added a comment - 24/Jun/13 12:10 PM

Looks like I can't upload this word doc... Bummer.

George Kowalski added a comment - 24/Jun/13 12:10 PM Looks like I can't upload this word doc... Bummer.

George Kowalski added a comment - 20/Dec/13 4:53 PM

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'
    );

George Kowalski added a comment - 20/Dec/13 4:53 PM 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' );

George Kowalski added a comment - 20/Dec/13 4:55 PM

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

George Kowalski added a comment - 20/Dec/13 4:55 PM 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

George Kowalski added a comment - 03/Jan/14 12:01 PM

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

George Kowalski added a comment - 03/Jan/14 12:01 PM 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

Janice Donahoe added a comment - 08/May/14 11:53 AM

We are not able to reproduce this issue in the latest version of i2b2 (1.7.02) that will be released soon.

Janice Donahoe added a comment - 08/May/14 11:53 AM We are not able to reproduce this issue in the latest version of i2b2 (1.7.02) that will be released soon.

People

Assignee:: Mike Mendis

Reporter:: George Kowalski

Participant/s:: George Kowalski, George Kowalski, Janice Donahoe, Mike Mendis

Votes:: 0 Vote for this issue

Watchers:: 0 Start watching this issue

Dates

Created:: 24/Jun/13 12:09 PM

Updated:: 05/Jun/14 6:07 PM

Resolved:: 08/May/14 11:53 AM

i2b2 Web Client