[CORE-116] On Amazon Demo site, the Visit Detail AGE does not work Created: 30/May/14  Updated: 01/Jul/14  Resolved: 04/Jun/14

Status: Closed
Project: i2b2 Core Software
Component/s: Data
Affects Version/s: 1.7.01
Fix Version/s: 1.7.02

Type: Bug Priority: Major
Reporter: Shawn Murphy Assignee: Mike Mendis
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Rank: 0|i000fr:
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: 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.
Participant/s:

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

 Comments   
Comment by Mike Mendis [ 04/Jun/14 ]
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
Generated at Thu Jun 30 09:43:55 UTC 2022 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.