dhis2-devs team mailing list archive

[<rin.channara@xxxxxxxxx>]

Hi all Dev,

mydatamart is important to download raw data from DHIS2 for conduce pivot table and can manipulate data for offline.

Every I download metadata. it always has error like:

Popup message: Problem importing metadata near "case": syntax error

or

try many time:

Popup message: Problem importing metadata cannot start a transaction within a transaction


and the status displaying text take long time: importing metadata


and console(F2):

----------------------------------------------------------------------------------

[Wed Oct 29 10:49:39 +0800 2014] [dhisweb] [debug] 'in loginCallback'
[Wed Oct 29 10:49:39 +0800 2014] [dhisweb] [debug] 'login success'
[Wed Oct 29 10:49:39 +0800 2014] [main] [debug] 'login status: LSUCCESS'
[Wed Oct 29 10:49:39 +0800 2014] [main] [debug] 'dhis(status) = Logged in'
[Wed Oct 29 10:49:41 +0800 2014] [main] [debug] 'dhis(status) = No orgunit data - you need to download metadata'
[Wed Oct 29 10:49:44 +0800 2014] [main] [debug] 'dhis(status) = Logging in to http://localhost:8090/flagship'
[Wed Oct 29 10:49:44 +0800 2014] [dhisweb] [debug] '{Using sock656 for localhost:8090} {}'
[Wed Oct 29 10:49:44 +0800 2014] [main] [debug] 'Persisting url'
[Wed Oct 29 10:49:44 +0800 2014] [main] [debug] 'Persisting username'
[Wed Oct 29 10:49:44 +0800 2014] [dhisweb] [debug] '{Closing socket sock656 (no connection info)}'
[Wed Oct 29 10:49:44 +0800 2014] [dhisweb] [debug] 'in loginCallback'
[Wed Oct 29 10:49:44 +0800 2014] [dhisweb] [debug] 'login success'
[Wed Oct 29 10:49:44 +0800 2014] [main] [debug] 'login status: LSUCCESS'
[Wed Oct 29 10:49:44 +0800 2014] [main] [debug] 'dhis(status) = Logged in'
[Wed Oct 29 10:49:45 +0800 2014] [main] [debug] 'dhis(status) = No orgunit data - you need to download metadata'
[Wed Oct 29 10:49:47 +0800 2014] [main] [debug] 'dhis(status) = Logging in to http://localhost:8090/flagship'
[Wed Oct 29 10:49:47 +0800 2014] [dhisweb] [debug] '{Using sock960 for localhost:8090} {}'
[Wed Oct 29 10:49:47 +0800 2014] [main] [debug] 'Persisting url'
[Wed Oct 29 10:49:47 +0800 2014] [main] [debug] 'Persisting username'
[Wed Oct 29 10:49:47 +0800 2014] [dhisweb] [debug] '{Closing socket sock960 (no connection info)}'
[Wed Oct 29 10:49:47 +0800 2014] [dhisweb] [debug] 'in loginCallback'
[Wed Oct 29 10:49:47 +0800 2014] [dhisweb] [debug] 'login success'
[Wed Oct 29 10:49:47 +0800 2014] [main] [debug] 'login status: LSUCCESS'
[Wed Oct 29 10:49:47 +0800 2014] [main] [debug] 'dhis(status) = Logged in'
[Wed Oct 29 10:53:39 +0800 2014] [dhisweb] [debug] 'fetching metadata'
[Wed Oct 29 10:53:39 +0800 2014] [dhisweb] [debug] '{Using sock988 for localhost:8090} {}'
finally
[Wed Oct 29 10:53:39 +0800 2014] [main] [debug] 'dhis(status) = Downloading metadata'
[Wed Oct 29 10:53:41 +0800 2014] [dhisweb] [debug] '{final chunk part}'
[Wed Oct 29 10:53:41 +0800 2014] [main] [debug] 'Metadata download success'
[Wed Oct 29 10:53:41 +0800 2014] [main] [debug] 'extracting zip'
[Wed Oct 29 10:53:41 +0800 2014] [main] [debug] 'transforming metadata'
[Wed Oct 29 10:53:41 +0800 2014] [main] [debug] 'dhis(status) = Transforming metadata'
[Wed Oct 29 10:53:41 +0800 2014] [dhisweb] [debug] '{Closing socket sock988 (no connection info)}'
[Wed Oct 29 10:53:41 +0800 2014] [dhisweb] [debug] 'Metadata download done: HTTP/1.1 200 OK'
[Wed Oct 29 10:53:42 +0800 2014] [main] [debug] 'transform: Done'
[Wed Oct 29 10:53:42 +0800 2014] [main] [debug] 'Transform metadata done'
[Wed Oct 29 10:53:42 +0800 2014] [main] [debug] 'dhis(status) = Importing metadata'
[Wed Oct 29 11:00:09 +0800 2014] [dhisweb] [debug] 'fetching metadata'
[Wed Oct 29 11:00:09 +0800 2014] [dhisweb] [debug] '{Using sock1208 for localhost:8090} {}'
finally
[Wed Oct 29 11:00:09 +0800 2014] [main] [debug] 'dhis(status) = Downloading metadata'
[Wed Oct 29 11:00:11 +0800 2014] [dhisweb] [debug] '{final chunk part}'
[Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'Metadata download success'
[Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'extracting zip'
[Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'transforming metadata'
[Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'dhis(status) = Transforming metadata'
[Wed Oct 29 11:00:11 +0800 2014] [dhisweb] [debug] '{Closing socket sock1208 (no connection info)}'
[Wed Oct 29 11:00:11 +0800 2014] [dhisweb] [debug] 'Metadata download done: HTTP/1.1 200 OK'
[Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'transform: Done'
[Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'Transform metadata done'
[Wed Oct 29 11:00:11 +0800 2014] [main] [debug] 'dhis(status) = Importing metadata'
[Wed Oct 29 11:00:46 +0800 2014] [dhisweb] [debug] 'fetching metadata'
[Wed Oct 29 11:00:46 +0800 2014] [dhisweb] [debug] '{Using sock680 for localhost:8090} {}'
finally
[Wed Oct 29 11:00:46 +0800 2014] [main] [debug] 'dhis(status) = Downloading metadata'
[Wed Oct 29 11:00:47 +0800 2014] [dhisweb] [debug] '{final chunk part}'
[Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'Metadata download success'
[Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'extracting zip'
[Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'transforming metadata'
[Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'dhis(status) = Transforming metadata'
[Wed Oct 29 11:00:47 +0800 2014] [dhisweb] [debug] '{Closing socket sock680 (no connection info)}'
[Wed Oct 29 11:00:47 +0800 2014] [dhisweb] [debug] 'Metadata download done: HTTP/1.1 200 OK'
[Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'transform: Done'
[Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'Transform metadata done'
[Wed Oct 29 11:00:47 +0800 2014] [main] [debug] 'dhis(status) = Importing metadata'
(1.myDataMart) 1 % 


----------------------------------------------------------------------------------






Can anyone help me?