← Back to team overview

dhis2-devs team mailing list archive

Mydatamart import metadata problem.

 

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?

Follow ups