OHDSI Home | Forums | Wiki | Github

Altas in "Data source" Dashboard didn't work in oracle


(Park,CHANGHYUN) #1

Hi I’m Park.

My DBMS is Oracle.

When I try to “Data source”->“Dashboard” function.
It didn’t work.
So I need a that’s query directory.Where can I find it?

Like bellow added image.
Atlas 화면

It is error log.
에러로그

And I think It is a solution like this image. Where can I find out that's query.
에러 쿼리


(Park,CHANGHYUN) #2

-1.When you before build “WebAPI.war” files in maven,chage bellow file.

That is because it need alias in “oracle” syntax.

"\src\main\resources\resources\cdmresults\sql\report\observationperiod\cumulativeduration.sql"
AND
"\src\main\resources\resources\cohortresults\sql\observationperiod\cumulativeduration.sql"



(Chris Knoll) #3

So, the * requires some sort of alias when you use the select * syntax?

select a.*, 'some value' as val from (
  select a,b,c from other table
) a

(Park,CHANGHYUN) #4

Yes, you’re right .
I’ll tell you your example,

It is possible!
image

But It occurred syntax error.
image

Because
in Error Quary, it want additional things select after ‘*’ .

So in that case, bellow Quary is right.

select a.*, ‘some value’ as val
from ( select a,b,c from other table) a


(Chris Knoll) #5

Ok, thanks for the details, we’ll look for instances of *, in our sql code, and properly alias it.


t