DHIS fails to import iHRIS SDMX-HD data
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Zanzibar SDMX-HD |
New
|
Undecided
|
Unassigned |
Bug Description
I am trying to export the file from iHRIS but I receive this error:
* INFO 16:27:43,272 User login success: 'sele' (DefaultUserAud
* INFO 16:28:52,786 Content-type: application/
* INFO 16:28:52,809 Internal process started (AbstractStatem
* INFO 16:28:52,809 Importing stream (DefaultImportS
* INFO 16:28:52,811 Zip file detected (DefaultImportS
* INFO 16:28:52,814 Saved zipstream to file: /usr/local/
* INFO 16:28:52,897 Transforming stream (DefaultImportS
* ERROR 16:28:53,120 Internal process failed (AbstractStatem
java.lang.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.amplecode.
at java.lang.
java.lang.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.amplecode.
at java.lang.
Carl Leitner (litlfred) wrote : | #1 |
Carl Leitner (litlfred) wrote : | #2 |
The iHRIS export does not seem to be transforming properly. You do have php5-xsl installed (which is necessary) so we need to debug this.
Carl Leitner (litlfred) wrote : | #3 |
- znz_xsl.png Edit (236.0 KiB, image/png)
Click on "Administer System" -> "Report Views" and then "Edit" under "SDMX-HD Export: Health workers per facility".
Then click "Edit Display Options" -> "Export Options" -> "XSL Transforms" -> "Existing XSL Transforms"
I dragged the lower right hand corner of the "Definition" box down so everything was in view and I got this screenshot.
Can you do the same?
Sele (seleman-ally) wrote : Re: [Bug 823302] Re: DHIS fails to import iHRIS SDMX-HD data | #4 |
php5-xsl is installed. I just double checked it
Cheers
Sele
--- On Tue, 8/9/11, Carl Leitner <email address hidden> wrote:
From: Carl Leitner <email address hidden>
Subject: [Bug 823302] Re: DHIS fails to import iHRIS SDMX-HD data
To: <email address hidden>
Date: Tuesday, August 9, 2011, 6:48 AM
The iHRIS export does not seem to be transforming properly. You do
have php5-xsl installed (which is necessary) so we need to debug this.
--
You received this bug notification because you are a member of Zanzibar
HIS, which is subscribed to the bug report.
https:/
Title:
DHIS fails to import iHRIS SDMX-HD data
Status in Zanzibar SDMX-HD:
New
Bug description:
I am trying to export the file from iHRIS but I receive this error:
* INFO 16:27:43,272 User login success: 'sele' (DefaultUserAud
* INFO 16:28:52,786 Content-type: application/
* INFO 16:28:52,809 Internal process started (AbstractStatem
* INFO 16:28:52,809 Importing stream (DefaultImportS
* INFO 16:28:52,811 Zip file detected (DefaultImportS
* INFO 16:28:52,814 Saved zipstream to file: /usr/local/
* INFO 16:28:52,897 Transforming stream (DefaultImportS
* ERROR 16:28:53,120 Internal process failed (AbstractStatem
java.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.amplecode.
at java.lang.
java.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
Sele (seleman-ally) wrote : | #5 |
let me try right away
--- On Tue, 8/9/11, Carl Leitner <email address hidden> wrote:
From: Carl Leitner <email address hidden>
Subject: [Bug 823302] Re: DHIS fails to import iHRIS SDMX-HD data
To: <email address hidden>
Date: Tuesday, August 9, 2011, 6:56 AM
Click on "Administer System" -> "Report Views" and then "Edit" under
"SDMX-HD Export: Health workers per facility".
Then click "Edit Display Options" -> "Export Options" -> "XSL
Transforms" -> "Existing XSL Transforms"
I dragged the lower right hand corner of the "Definition" box down so
everything was in view and I got this screenshot.
Can you do the same?
** Attachment added: "znz_xsl.png"
https:/
--
You received this bug notification because you are a member of Zanzibar
HIS, which is subscribed to the bug report.
https:/
Title:
DHIS fails to import iHRIS SDMX-HD data
Status in Zanzibar SDMX-HD:
New
Bug description:
I am trying to export the file from iHRIS but I receive this error:
* INFO 16:27:43,272 User login success: 'sele' (DefaultUserAud
* INFO 16:28:52,786 Content-type: application/
* INFO 16:28:52,809 Internal process started (AbstractStatem
* INFO 16:28:52,809 Importing stream (DefaultImportS
* INFO 16:28:52,811 Zip file detected (DefaultImportS
* INFO 16:28:52,814 Saved zipstream to file: /usr/local/
* INFO 16:28:52,897 Transforming stream (DefaultImportS
* ERROR 16:28:53,120 Internal process failed (AbstractStatem
java.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.amplecode.
at java.lang.
java.
at org.hisp.
at org.hisp.
at org.hisp.
Sele (seleman-ally) wrote : | #6 |
Quick looking I get the same file
Sele
.......
--- On Tue, 8/9/11, Carl Leitner <email address hidden> wrote:
From: Carl Leitner <email address hidden>
Subject: [Bug 823302] Re: DHIS fails to import iHRIS SDMX-HD data
To: <email address hidden>
Date: Tuesday, August 9, 2011, 6:56 AM
Click on "Administer System" -> "Report Views" and then "Edit" under
"SDMX-HD Export: Health workers per facility".
Then click "Edit Display Options" -> "Export Options" -> "XSL
Transforms" -> "Existing XSL Transforms"
I dragged the lower right hand corner of the "Definition" box down so
everything was in view and I got this screenshot.
Can you do the same?
** Attachment added: "znz_xsl.png"
https:/
--
You received this bug notification because you are a member of Zanzibar
HIS, which is subscribed to the bug report.
https:/
Title:
DHIS fails to import iHRIS SDMX-HD data
Status in Zanzibar SDMX-HD:
New
Bug description:
I am trying to export the file from iHRIS but I receive this error:
* INFO 16:27:43,272 User login success: 'sele' (DefaultUserAud
* INFO 16:28:52,786 Content-type: application/
* INFO 16:28:52,809 Internal process started (AbstractStatem
* INFO 16:28:52,809 Importing stream (DefaultImportS
* INFO 16:28:52,811 Zip file detected (DefaultImportS
* INFO 16:28:52,814 Saved zipstream to file: /usr/local/
* INFO 16:28:52,897 Transforming stream (DefaultImportS
* ERROR 16:28:53,120 Internal process failed (AbstractStatem
java.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.amplecode.
at java.lang.
java.
at org.hisp.
at org.hisp.
at org.hisp.
Sele (seleman-ally) wrote : | #8 |
- View SDMX-HD Export.txt Edit (2.8 KiB, text/plain; name="View SDMX-HD Export.txt")
I get exactly the same file.
See attachment
--- On Tue, 8/9/11, Seleman <email address hidden> wrote:
From: Seleman <email address hidden>
Subject: Re: [Bug 823302] Re: DHIS fails to import iHRIS SDMX-HD data
To: <email address hidden>
Date: Tuesday, August 9, 2011, 11:47 AM
let me try right away
--- On Tue, 8/9/11, Carl Leitner <email address hidden> wrote:
From: Carl Leitner <email address hidden>
Subject: [Bug 823302] Re: DHIS fails to import iHRIS SDMX-HD data
To: <email address hidden>
Date: Tuesday, August 9, 2011, 6:56 AM
Click on "Administer System" -> "Report Views" and then "Edit" under
"SDMX-HD Export: Health workers per facility".
Then click "Edit Display Options" -> "Export Options" -> "XSL
Transforms" -> "Existing XSL Transforms"
I dragged the lower right hand corner of the "Definition" box down so
everything was in view and I got this screenshot.
Can you do the same?
** Attachment added: "znz_xsl.png"
https:/
--
You received this bug notification because you are a member of Zanzibar
HIS, which is subscribed to the bug report.
https:/
Title:
DHIS fails to import iHRIS SDMX-HD data
Status in Zanzibar SDMX-HD:
New
Bug description:
I am trying to export the file from iHRIS but I receive this error:
* INFO 16:27:43,272 User login success: 'sele' (DefaultUserAud
* INFO 16:28:52,786 Content-type: application/
* INFO 16:28:52,809 Internal process started (AbstractStatem
* INFO 16:28:52,809 Importing stream (DefaultImportS
* INFO 16:28:52,811 Zip file detected (DefaultImportS
* INFO 16:28:52,814 Saved zipstream to file: /usr/local/
* INFO 16:28:52,897 Transforming stream (DefaultImportS
* ERROR 16:28:53,120 Internal process failed (AbstractStatem
java.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.amplecode.
at java.lang.
java.
...
Sele (seleman-ally) wrote : | #9 |
- View SDMX-HD Export.txt Edit (2.8 KiB, text/plain; name="View SDMX-HD Export.txt")
--- On Tue, 8/9/11, Seleman <email address hidden> wrote:
From: Seleman <email address hidden>
Subject: Re: [Bug 823302] Re: DHIS fails to import iHRIS SDMX-HD data
To: <email address hidden>
Date: Tuesday, August 9, 2011, 12:13 PM
Quick looking I get the same file
Sele
.......
--- On Tue, 8/9/11, Carl Leitner <email address hidden> wrote:
From: Carl Leitner <email address hidden>
Subject: [Bug 823302] Re: DHIS fails to import iHRIS SDMX-HD data
To: <email address hidden>
Date: Tuesday, August 9, 2011, 6:56 AM
Click on "Administer System" -> "Report Views" and then "Edit" under
"SDMX-HD Export: Health workers per facility".
Then click "Edit Display Options" -> "Export Options" -> "XSL
Transforms" -> "Existing XSL Transforms"
I dragged the lower right hand corner of the "Definition" box down so
everything was in view and I got this screenshot.
Can you do the same?
** Attachment added: "znz_xsl.png"
https:/
--
You received this bug notification because you are a member of Zanzibar
HIS, which is subscribed to the bug report.
https:/
Title:
DHIS fails to import iHRIS SDMX-HD data
Status in Zanzibar SDMX-HD:
New
Bug description:
I am trying to export the file from iHRIS but I receive this error:
* INFO 16:27:43,272 User login success: 'sele' (DefaultUserAud
* INFO 16:28:52,786 Content-type: application/
* INFO 16:28:52,809 Internal process started (AbstractStatem
* INFO 16:28:52,809 Importing stream (DefaultImportS
* INFO 16:28:52,811 Zip file detected (DefaultImportS
* INFO 16:28:52,814 Saved zipstream to file: /usr/local/
* INFO 16:28:52,897 Transforming stream (DefaultImportS
* ERROR 16:28:53,120 Internal process failed (AbstractStatem
java.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.amplecode.
at java.lang.
java.
at org...
Carl Leitner (litlfred) wrote : | #7 |
Can you run apache_tail.php and then try the export again to see the error messages.
I am not sure where apache_tail was installed, but this should work for you:
`locate apache_tail.php | head -1` 0
(Note there are backtics here, not quotes. On a US keyboard this is to the left of the number 1)
Sele (seleman-ally) wrote : | #10 |
Seems like I have done silly mistake somewhere here is Error after running
sudo php /var/lib/
I am running ubuntu 11.04, please assist
zanhealth@
memory storage[Wed Aug 10 01:48:47 2011] [error] [client 41.204.134.159] Refered by : http://
41.204.134.159] Refered by : http://
'=' in /etc/php5/
Carl Leitner (litlfred) wrote : | #11 |
OK There are two issues here, one with memcached and one with APC. They are not causing the issue with the report export, but we should get them fixed.
To fix memcached, please see:
http://
There are instructions for the various versions of Ubuntu. To check which version of Ubuntu you have installed, you can do this:
lsb_release -a
The APC problem is with the file:
/etc/
there seems to be a typo there. If you don't see the problem, please attach it and we can figure it out together.
Once these two issues are fixed, we can continue working on fixing the SDMX-HD export issue.
Sele (seleman-ally) wrote : | #12 |
Hi Carl
Seems to be better now, just have a look
Cheers
Sele
--- On Tue, 8/9/11, Carl Leitner <email address hidden> wrote:
From: Carl Leitner <email address hidden>
Subject: [Bug 823302] Re: DHIS fails to import iHRIS SDMX-HD data
To: <email address hidden>
Date: Tuesday, August 9, 2011, 5:15 PM
OK There are two issues here, one with memcached and one with APC. They
are not causing the issue with the report export, but we should get them
fixed.
To fix memcached, please see:
http://
There are instructions for the various versions of Ubuntu. To check which version of Ubuntu you have installed, you can do this:
lsb_release -a
The APC problem is with the file:
/etc/
there seems to be a typo there. If you don't see the problem, please attach it and we can figure it out together.
Once these two issues are fixed, we can continue working on fixing the SDMX-HD export issue.
--
You received this bug notification because you are a member of Zanzibar
HIS, which is subscribed to the bug report.
https:/
Title:
DHIS fails to import iHRIS SDMX-HD data
Status in Zanzibar SDMX-HD:
New
Bug description:
I am trying to export the file from iHRIS but I receive this error:
* INFO 16:27:43,272 User login success: 'sele' (DefaultUserAud
* INFO 16:28:52,786 Content-type: application/
* INFO 16:28:52,809 Internal process started (AbstractStatem
* INFO 16:28:52,809 Importing stream (DefaultImportS
* INFO 16:28:52,811 Zip file detected (DefaultImportS
* INFO 16:28:52,814 Saved zipstream to file: /usr/local/
* INFO 16:28:52,897 Transforming stream (DefaultImportS
* ERROR 16:28:53,120 Internal process failed (AbstractStatem
java.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.amplecode.
at java.lang.
java.
at org.hisp.
Sele (seleman-ally) wrote : | #13 |
- apache_tail_php.txt Edit (4.3 KiB, text/plain; name="apache_tail_php.txt")
Sorry, here is an attachment
--- On Tue, 8/9/11, Carl Leitner <email address hidden> wrote:
From: Carl Leitner <email address hidden>
Subject: [Bug 823302] Re: DHIS fails to import iHRIS SDMX-HD data
To: <email address hidden>
Date: Tuesday, August 9, 2011, 5:15 PM
OK There are two issues here, one with memcached and one with APC. They
are not causing the issue with the report export, but we should get them
fixed.
To fix memcached, please see:
http://
There are instructions for the various versions of Ubuntu. To check which version of Ubuntu you have installed, you can do this:
lsb_release -a
The APC problem is with the file:
/etc/
there seems to be a typo there. If you don't see the problem, please attach it and we can figure it out together.
Once these two issues are fixed, we can continue working on fixing the SDMX-HD export issue.
--
You received this bug notification because you are a member of Zanzibar
HIS, which is subscribed to the bug report.
https:/
Title:
DHIS fails to import iHRIS SDMX-HD data
Status in Zanzibar SDMX-HD:
New
Bug description:
I am trying to export the file from iHRIS but I receive this error:
* INFO 16:27:43,272 User login success: 'sele' (DefaultUserAud
* INFO 16:28:52,786 Content-type: application/
* INFO 16:28:52,809 Internal process started (AbstractStatem
* INFO 16:28:52,809 Importing stream (DefaultImportS
* INFO 16:28:52,811 Zip file detected (DefaultImportS
* INFO 16:28:52,814 Saved zipstream to file: /usr/local/
* INFO 16:28:52,897 Transforming stream (DefaultImportS
* ERROR 16:28:53,120 Internal process failed (AbstractStatem
java.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.amplecode.
at java.lang.
java.
at org.hisp.
Carl Leitner (litlfred) wrote : | #14 |
We can ignore this error for now:
as it is a typo in the html and can be ignored for now. We can fix it later.
This message
Undefined offset: 1
Occurred on line 791 of /var/lib/
I think we can also ignore for now.
Is this all that apache_tail sent out when you tried to export the SDMX-HD report?
Carl Leitner (litlfred) wrote : | #15 |
For the second error message, I created the following bug report:
https:/
Sele (seleman-ally) wrote : | #16 |
Done Successfully
I don't have to celebrate early, Let me check the other things related to iHRIS in DHIS2, I will let you know
Cheers
Sele
--- On Wed, 8/10/11, Carl Leitner <email address hidden> wrote:
From: Carl Leitner <email address hidden>
Subject: [Bug 823302] Re: DHIS fails to import iHRIS SDMX-HD data
To: <email address hidden>
Date: Wednesday, August 10, 2011, 6:37 AM
We can ignore this error for now:
as it is a typo in the html and can be ignored for now. We can fix it later.
This message
Undefined offset: 1
Occurred on line 791 of /var/lib/
I think we can also ignore for now.
Is this all that apache_tail sent out when you tried to export the SDMX-HD report?
--
You received this bug notification because you are a member of Zanzibar
HIS, which is subscribed to the bug report.
https:/
Title:
DHIS fails to import iHRIS SDMX-HD data
Status in Zanzibar SDMX-HD:
New
Bug description:
I am trying to export the file from iHRIS but I receive this error:
* INFO 16:27:43,272 User login success: 'sele' (DefaultUserAud
* INFO 16:28:52,786 Content-type: application/
* INFO 16:28:52,809 Internal process started (AbstractStatem
* INFO 16:28:52,809 Importing stream (DefaultImportS
* INFO 16:28:52,811 Zip file detected (DefaultImportS
* INFO 16:28:52,814 Saved zipstream to file: /usr/local/
* INFO 16:28:52,897 Transforming stream (DefaultImportS
* ERROR 16:28:53,120 Internal process failed (AbstractStatem
java.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.hisp.
at org.amplecode.
at java.lang.
java.
at org.hisp.
at org.hisp.
Digbeu Paul-Emile (pabloderuvess) wrote : | #17 |
1- can i know if we can import SDMX-HD file in DHIS2?
2- if we can, say me how to import it?
Here is the header of the file exported from iHRIS: SDMX-HD Export: Number of health workers per facility disaggregated by job and gender< /description> d>2011- 08-09T15: 47:58+03: 00</whenGenerat ed> sele</user> admin</ role> facility+ id'> Total</ name>
<ihrisReport id='kf_hw_by_fac'>
<reportDetails>
<name>SDMX-HD Export: Health workers per facility</name>
<description>
<whenGenerate
<sender>
<user>
<name>Seleman Ally</name>
<role>
<email></email>
</sender>
<dataElements>
<elemDesc id='cl_
<name>Facility (CL)</name>
</elemDesc>
<elemDesc id='cl_gender+id'>
<name>Gender (CL)</name>
</elemDesc>
<elemDesc id='cl_job+id'>
<name>Job (CL)</name>
</elemDesc>
<elemDesc id='total'>
<name>
</elemDesc>
</dataElements>
</reportDetails>