#87: Deploy, document R Data Builder demo service
--------------------------+------------------------
Reporter: dconnolly | Owner: dconnolly
Type: task | Status: accepted
Priority: major | Milestone: data-agg1
Component: data-sharing | Resolution:
Keywords: | Blocked By: 134, 179
Blocking: 119 |
--------------------------+------------------------
Comment (by gkowalski):
Well I rau the query on Endocrine like the demo video showed and it didn't
work. I didn't get the Job queued message , but rather a broken link (
See broken-link.png image attachment ) .
I don't see the JSON file in the queue dir to process :
[root@localhost heron]# ls -l /var/log/data_builder/queue/
total 0
[root@localhost heron]#
Also No errors in the server.log jboss file, just normal stuff :
{{{
14:50:47,494 INFO [edu.harvard.i2b2.crc.dao.OracleDAOFactory]
(Thread-138) Using datasource java:/QueryToolDemoDS
14:50:47,546 INFO [stdout] (Thread-138) panel accuracy scale100
14:50:47,547 INFO
[edu.harvard.i2b2.crc.dao.setfinder.querybuilder.temporal.TemporalPanelConceptItem]
(Thread-138) Item value constrain sql [Ljava.lang.String;@a9cc99
14:50:47,547 INFO [stdout] (Thread-138) insert into QUERY_GLOBAL_TEMP
(patient_num, panel_count)
14:50:47,552 INFO [stdout] (Thread-138) with t as (
14:50:47,553 INFO [stdout] (Thread-138) select f.patient_num
14:50:47,553 INFO [stdout] (Thread-138) from public.observation_fact f
14:50:47,553 INFO [stdout] (Thread-138) where
14:50:47,554 INFO [stdout] (Thread-138) f.concept_cd IN (select
concept_cd from public.concept_dimension where concept_path LIKE
'\\i2b2\\Diagnoses\\Endocrine disorders (240-259)\\%')
14:50:47,554 INFO [stdout] (Thread-138) group by f.patient_num
14:50:47,554 INFO [stdout] (Thread-138) )
14:50:47,555 INFO [stdout] (Thread-138) select t.patient_num, 0 as
panel_count from t
14:50:47,559 INFO [stdout] (Thread-138) <*>
14:50:47,559 INFO [stdout] (Thread-138) insert into DX ( patient_num
) select * from ( select distinct patient_num from QUERY_GLOBAL_TEMP
where panel_count = 0 ) q
14:50:47,561 INFO [edu.harvard.i2b2.crc.dao.DataSourceLookupHelper]
(Thread-138) Located DataSource for hiveId=[i2b2demo] projectId=[/Demo/]
and ownerId =[@]
14:50:47,562 INFO [edu.harvard.i2b2.crc.dao.OracleDAOFactory]
(Thread-138) Using datasource java:/QueryToolDemoDS
14:50:47,641 INFO [edu.harvard.i2b2.crc.dao.DataSourceLookupHelper]
(Thread-138) Located DataSource for hiveId=[i2b2demo] projectId=[/Demo/]
and ownerId =[@]
14:50
}}}
But when I look in that directory I don't see an output file , not sure
where the timeline_3.db came from but you had one of those also :
[root@localhost heron]# pwd
/home/demo/heron
[root@localhost heron]# ls -ltr
total 128
-rw-r--r-- 1 root root 126976 Nov 4 14:19 timeline_3.db
[root@localhost heron]#
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/87#comment:53>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
