[WEBCLIENT-45] Searching in text field returns all results Created: 24/Jun/13  Updated: 05/Jun/14  Resolved: 08/May/14

Status: Closed
Project: i2b2 Web Client
Component/s: Web Client
Affects Version/s: 1.6.06
Fix Version/s: None

Type: Bug Priority: Major
Reporter: George Kowalski Assignee: Mike Mendis
Resolution: Cannot Reproduce Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment: Unix, Oracle

Affects View/s:
Query Tool
i2b2 Feature/s:
Constraints - Text Search
Participant/s:

 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

 Comments   
Comment by George Kowalski [ 24/Jun/13 ]
Looks like I can't upload this word doc... Bummer.
Comment by George Kowalski [ 20/Dec/13 ]
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'
    );
Comment by George Kowalski [ 20/Dec/13 ]
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

Comment by George Kowalski [ 03/Jan/14 ]
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
Comment by Janice Donahoe [ 08/May/14 ]
We are not able to reproduce this issue in the latest version of i2b2 (1.7.02) that will be released soon.
Generated at Tue Apr 23 15:56:35 UTC 2024 using Jira 8.20.11#820011-sha1:0629dd8d260e3954ece49053e565d01dabe11609.