[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. |