[CORE-116] On Amazon Demo site, the Visit Detail AGE does not work - i2b2 JIRA

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: 1.7.01
Fix Version/s: 1.7.02
Component/s: Data
Labels:
None

Affects View/s:

Query Tool
i2b2 Feature/s:

Queries
i2b2 Sponsored Project/s:

i2b2 Core

Affects Web Browser/s:

Chrome, Firefox, Internet Explorer, Safari

Reproduction Notes:

Hide
I am not able to reproduce it in the i2b2 development environment but I am able to reproduce it on the public webclient (i2b2.org site).

The problem may be with the data in the metadata tables. The database/schema information prefacing the calculations may be incorrect.

Show
I am not able to reproduce it in the i2b2 development environment but I am able to reproduce it on the public webclient (i2b2.org site). The problem may be with the data in the metadata tables. The database/schema information prefacing the calculations may be incorrect.

Description

An error is returned when running a query in which one of the concepts is an "Age at visit" term.

Attachments

Activity

Mike Mendis added a comment - 04/Jun/14 1:50 PM

Updated the demo site, this is a case where the c_dimcode is hardcoded with a specific SQL statement, and in this case has i2b2demodata. as the schema name. On the amazon database the schema was not i2b2demodata

Mike Mendis added a comment - 04/Jun/14 1:50 PM Updated the demo site, this is a case where the c_dimcode is hardcoded with a specific SQL statement, and in this case has i2b2demodata. as the schema name. On the amazon database the schema was not i2b2demodata

People

Assignee:: Mike Mendis

Reporter:: Shawn Murphy

Participant/s:: Mike Mendis, Shawn Murphy

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 30/May/14 4:25 PM

Updated:: 01/Jul/14 11:38 AM

Resolved:: 04/Jun/14 1:50 PM

i2b2 Core Software