Re: [Gnumed-bugs] <bug>: Import

[Karsten Hilbert]

Hello ALI,

thanks for your report.

> 2011-07-16 22:08:46  ERROR     gm.ui 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\logging::exception()
>  #1021): report query failed
> Traceback (most recent call last):
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/Gnumed.wxpython.gmDataMiningWidgets",
>  line 388, in _on_run_button_pressed
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/Gnumed.pycommon.gmPG2",
>  line 1121, in run_ro_queries
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/psycopg2.extras",
>  line 88, in execute
> ProgrammingError: relation "substance_intake" does not exist
> LINE 1: select * from (select * from substance_intake where pk_audit...
>                                      ^

This must be

        clin.substance_intake

> 2011-07-16 22:10:21  ERROR     gm.ui 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\logging::exception()
>  #1021): report query failed
> Traceback (most recent call last):
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/Gnumed.wxpython.gmDataMiningWidgets",
>  line 388, in _on_run_button_pressed
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/Gnumed.pycommon.gmPG2",
>  line 1121, in run_ro_queries
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/psycopg2.extras",
>  line 88, in execute
> ProgrammingError: relation "health_issue" does not exist
> LINE 1: select * from (select * from health_issue where pk_audit = 1...
>                                      ^

This must be

        clin.health_issue

> 2011-07-16 22:17:33  ERROR     gm.db 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.pycommon.gmpg2::run_ro_queries()
>  #1133): query failed: [select * from (select *
>         from
>                 dem.v_basic_person
>                         inner join
>                 clin.v_coded_item_narrative
>                         using (pk_identity)
> ) as real_query limit 1024]
> 2011-07-16 22:17:33  ERROR     gm.db 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.pycommon.gmpg2::run_ro_queries()
>  #1134): PG status message: 
> 2011-07-16 22:17:33  ERROR     gm.ui 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\logging::exception()
>  #1021): report query failed
> Traceback (most recent call last):
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/Gnumed.wxpython.gmDataMiningWidgets",
>  line 388, in _on_run_button_pressed
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/Gnumed.pycommon.gmPG2",
>  line 1121, in run_ro_queries
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/psycopg2.extras",
>  line 88, in execute
> ProgrammingError: relation "clin.v_coded_item_narrative" does not exist
> LINE 5:                 clin.v_coded_item_narrative

This query is outdated and does not work anymore.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346