← Back to team overview

dhis2-devs team mailing list archive

Re: Mydatamart import metadata problem.

 

You can do similar things from the pivot table module now.
On Oct 29, 2014 3:04 AM, <rin.channara@xxxxxxxxx> wrote:

>  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?
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References