DHIS fails to import iHRIS SDMX-HD data

[Carl Leitner]

I am trying to export the file from iHRIS but I receive this error:
* INFO 16:27:43,272 User login success: 'sele' (DefaultUserAuditService.java [http-bio-8080-exec-6])
* INFO 16:28:52,786 Content-type: application/x-zip-compressed, filename: /usr/local/apache-tomcat-7.0.19/work/Catalina/localhost/dhis/upload_41f1340e_131aebb410b__8000_00000001.tmp (ImportAction.java [http-bio-8080-exec-6])
* INFO 16:28:52,809 Internal process started (AbstractStatementInternalProcess.java [Thread-14])
* INFO 16:28:52,809 Importing stream (DefaultImportService.java [Thread-14])
* INFO 16:28:52,811 Zip file detected (DefaultImportService.java [Thread-14])
* INFO 16:28:52,814 Saved zipstream to file: /usr/local/apache-tomcat-7.0.19/temp/IMPORT_5661984542839526104_ZIP (DefaultImportService.java [Thread-14])
* INFO 16:28:52,897 Transforming stream (DefaultImportService.java [Thread-14])
* ERROR 16:28:53,120 Internal process failed (AbstractStatementInternalProcess.java [Thread-14])
java.lang.NullPointerException
        at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
        at org.hisp.dhis.importexport.xml.XMLPreConverter.transform(XMLPreConverter.java:139)
        at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImportService.java:171)
        at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89)
        at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103)
        at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40)
        at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
        at java.lang.Thread.run(Thread.java:662)
java.lang.NullPointerException
        at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
        at org.hisp.dhis.importexport.xml.XMLPreConverter.transform(XMLPreConverter.java:139)
        at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImportService.java:171)
        at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89)
        at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103)
        at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40)
        at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
        at java.lang.Thread.run(Thread.java:662)

[Carl Leitner (litlfred)]

Here is the header of the file exported from iHRIS:
<ihrisReport id='kf_hw_by_fac'>
 <reportDetails>
  <name>SDMX-HD Export: Health workers per facility</name>
  <description>SDMX-HD Export: Number of health workers per facility disaggregated by job and gender</description>
  <whenGenerated>2011-08-09T15:47:58+03:00</whenGenerated>
  <sender>
   <user>sele</user>
   <name>Seleman Ally</name>
   <role>admin</role>
   <email></email>
  </sender>
  <dataElements>
   <elemDesc id='cl_facility+id'>
    <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>Total</name>
   </elemDesc>
  </dataElements>
 </reportDetails>

[Carl Leitner (litlfred)]

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)]

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)]

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://bugs.launchpad.net/bugs/823302

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' (DefaultUserAuditService.java [http-bio-8080-exec-6])
  * INFO  16:28:52,786 Content-type: application/x-zip-compressed, filename: /usr/local/apache-tomcat-7.0.19/work/Catalina/localhost/dhis/upload_41f1340e_131aebb410b__8000_00000001.tmp (ImportAction.java [http-bio-8080-exec-6])
  * INFO  16:28:52,809 Internal process started (AbstractStatementInternalProcess.java [Thread-14])
  * INFO  16:28:52,809 Importing stream (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,811 Zip file detected (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,814 Saved zipstream to file: /usr/local/apache-tomcat-7.0.19/temp/IMPORT_5661984542839526104_ZIP (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,897 Transforming stream (DefaultImportService.java [Thread-14])
  * ERROR 16:28:53,120 Internal process failed (AbstractStatementInternalProcess.java [Thread-14])
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
          at org.hisp.dhis.importexport.xml.XMLPreConverter.transform(XMLPreConverter.java:139)
          at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImportService.java:171)
          at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40)
          at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
          at java.lang.Thread.run(Thread.java:662)
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
          at org.hisp.dhis.importexport.xml.XMLPreConverter.transform(XMLPreConverter.java:139)
          at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImportService.java:171)
          at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103)
          at org.hisp.dhis.system.process.AbstractStatemen...

[Sele (seleman-ally)]

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://bugs.launchpad.net/zanzibar-sdmx-hd/+bug/823302/+attachment/2263919/+files/znz_xsl.png

--
You received this bug notification because you are a member of Zanzibar
HIS, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/823302

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' (DefaultUserAuditService.java [http-bio-8080-exec-6])
  * INFO  16:28:52,786 Content-type: application/x-zip-compressed, filename: /usr/local/apache-tomcat-7.0.19/work/Catalina/localhost/dhis/upload_41f1340e_131aebb410b__8000_00000001.tmp (ImportAction.java [http-bio-8080-exec-6])
  * INFO  16:28:52,809 Internal process started (AbstractStatementInternalProcess.java [Thread-14])
  * INFO  16:28:52,809 Importing stream (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,811 Zip file detected (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,814 Saved zipstream to file: /usr/local/apache-tomcat-7.0.19/temp/IMPORT_5661984542839526104_ZIP (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,897 Transforming stream (DefaultImportService.java [Thread-14])
  * ERROR 16:28:53,120 Internal process failed (AbstractStatementInternalProcess.java [Thread-14])
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
          at org.hisp.dhis.importexport.xml.XMLPreConverter.transform(XMLPreConverter.java:139)
          at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImportService.java:171)
          at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40)
          at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
          at java.lang.Thread.run(Thread.java:662)
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
          at org.hisp.dhis.importexport.xml.XMLPreConverter.transform(XMLPreConverter.java:139)
          at org.hisp.dhis.importexport.DefaultImportService.importData(Default...

[Sele (seleman-ally)]

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://bugs.launchpad.net/zanzibar-sdmx-hd/+bug/823302/+attachment/2263919/+files/znz_xsl.png

--
You received this bug notification because you are a member of Zanzibar
HIS, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/823302

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' (DefaultUserAuditService.java [http-bio-8080-exec-6])
  * INFO  16:28:52,786 Content-type: application/x-zip-compressed, filename: /usr/local/apache-tomcat-7.0.19/work/Catalina/localhost/dhis/upload_41f1340e_131aebb410b__8000_00000001.tmp (ImportAction.java [http-bio-8080-exec-6])
  * INFO  16:28:52,809 Internal process started (AbstractStatementInternalProcess.java [Thread-14])
  * INFO  16:28:52,809 Importing stream (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,811 Zip file detected (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,814 Saved zipstream to file: /usr/local/apache-tomcat-7.0.19/temp/IMPORT_5661984542839526104_ZIP (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,897 Transforming stream (DefaultImportService.java [Thread-14])
  * ERROR 16:28:53,120 Internal process failed (AbstractStatementInternalProcess.java [Thread-14])
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
          at org.hisp.dhis.importexport.xml.XMLPreConverter.transform(XMLPreConverter.java:139)
          at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImportService.java:171)
          at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40)
          at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
          at java.lang.Thread.run(Thread.java:662)
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
          at org.hisp.dhis.importexport.xml.XMLPreConverter.transform(XMLPreConverter.java:139)
          at org.hisp.dhis.importexport.De...

[Sele (seleman-ally)]

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://bugs.launchpad.net/zanzibar-sdmx-hd/+bug/823302/+attachment/2263919/+files/znz_xsl.png

--
You received this bug notification because you are a member of Zanzibar
HIS, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/823302

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' (DefaultUserAuditService.java [http-bio-8080-exec-6])
  * INFO  16:28:52,786 Content-type: application/x-zip-compressed, filename: /usr/local/apache-tomcat-7.0.19/work/Catalina/localhost/dhis/upload_41f1340e_131aebb410b__8000_00000001.tmp (ImportAction.java [http-bio-8080-exec-6])
  * INFO  16:28:52,809 Internal process started (AbstractStatementInternalProcess.java [Thread-14])
  * INFO  16:28:52,809 Importing stream (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,811 Zip file detected (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,814 Saved zipstream to file: /usr/local/apache-tomcat-7.0.19/temp/IMPORT_5661984542839526104_ZIP (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,897 Transforming stream (DefaultImportService.java [Thread-14])
  * ERROR 16:28:53,120 Internal process failed (AbstractStatementInternalProcess.java [Thread-14])
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
          at org.hisp.dhis.importexport.xml.XMLPreConverter.transform(XMLPreConverter.java:139)
          at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImportService.java:171)
          at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40)
          at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
          at java.lang.Thread.run(Thread.java:662)
  java.lang.NullPointerException
         ...

[Sele (seleman-ally)]

--- 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://bugs.launchpad.net/zanzibar-sdmx-hd/+bug/823302/+attachment/2263919/+files/znz_xsl.png

--
You received this bug notification because you are a member of Zanzibar
HIS, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/823302

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' (DefaultUserAuditService.java [http-bio-8080-exec-6])
  * INFO  16:28:52,786 Content-type: application/x-zip-compressed, filename: /usr/local/apache-tomcat-7.0.19/work/Catalina/localhost/dhis/upload_41f1340e_131aebb410b__8000_00000001.tmp (ImportAction.java [http-bio-8080-exec-6])
  * INFO  16:28:52,809 Internal process started (AbstractStatementInternalProcess.java [Thread-14])
  * INFO  16:28:52,809 Importing stream (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,811 Zip file detected (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,814 Saved zipstream to file: /usr/local/apache-tomcat-7.0.19/temp/IMPORT_5661984542839526104_ZIP (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,897 Transforming stream (DefaultImportService.java [Thread-14])
  * ERROR 16:28:53,120 Internal process failed (AbstractStatementInternalProcess.java [Thread-14])
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
          at org.hisp.dhis.importexport.xml.XMLPreConverter.transform(XMLPreConverter.java:139)
          at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImportService.java:171)
          at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40)
          at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
          at java.lang.Thread.run(Thread.java:662)
  java.lang.NullPointerException
          at org...

[Carl Leitner (litlfred)]

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)]

Seems like I have done silly mistake somewhere here is Error after running
sudo php /var/lib/iHRIS/lib/4.0.16/I2CE/tools/apache_tail.php
I am running ubuntu 11.04, please assist

zanhealth@ZANHEALTH:~$ sudo php /var/lib/iHRIS/lib/4.0.16/I2CE/tools/apache_tail.php[Wed Aug 10 01:48:46 2011] [error] [client 41.204.134.159]        Refered by : http://196.41.62.90/znz_hr/login        I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.16/I2CE/lib/I2CE.php:304)              I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.16/I2CE/lib/I2CE.php:592)              I2CE->initializeDSN (/var/lib/iHRIS/sites/znz_hr/pages/index.php:49)        No memcached[Wed Aug 10 01:48:46 2011] [error] [client 41.204.134.159]        Refered by : http://196.41.62.90/znz_hr/login        I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.16/I2CE/lib/I2CE.php:307)              I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.16/I2CE/lib/I2CE.php:592)              I2CE->initializeDSN (/var/lib/iHRIS/sites/znz_hr/pages/index.php:49)        No persistent caching storage mechanism (apc or memchached) is available. Adding simple
 memory storage[Wed Aug 10 01:48:47 2011] [error] [client 41.204.134.159]        Refered by : http://196.41.62.90/znz_hr/login        I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.16/I2CE/lib/I2CE.php:304)              I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.16/I2CE/lib/I2CE.php:592)              I2CE->initializeDSN (/var/lib/iHRIS/sites/znz_hr/pages/index.php:49)        No memcached[Wed Aug 10 01:48:47 2011] [error] [client 41.204.134.159]        Refered by : http://196.41.62.90/znz_hr/login        I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.16/I2CE/lib/I2CE.php:307)              I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.16/I2CE/lib/I2CE.php:592)              I2CE->initializeDSN (/var/lib/iHRIS/sites/znz_hr/pages/index.php:49)        No persistent caching storage mechanism (apc or memchached) is available. Adding simple memory storage[Wed Aug 10 01:48:49 2011] [error] [client
 41.204.134.159]        Refered by : http://196.41.62.90/znz_hr/login        I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.16/I2CE/lib/I2CE.php:304)              I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.16/I2CE/lib/I2CE.php:592)              I2CE->initializeDSN (/var/lib/iHRIS/sites/znz_hr/pages/index.php:49)        No memcached[Wed Aug 10 01:48:49 2011] [error] [client 41.204.134.159]        Refered by : http://196.41.62.90/znz_hr/login        I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.16/I2CE/lib/I2CE.php:307)              I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.16/I2CE/lib/I2CE.php:592)              I2CE->initializeDSN (/var/lib/iHRIS/sites/znz_hr/pages/index.php:49)        No persistent caching storage mechanism (apc or memchached) is available. Adding simple memory storagePHP:  syntax error, unexpected '=' in /etc/php5/apache2/conf.d/apc.ini on line 1PHP:  syntax error, unexpected
 '=' in /etc/php5/apache2/conf.d/apc.ini on line 1[Wed Aug 10 01:56:02 2011] [error] [client 207.46.204.235] File does not exist: /var/www/robots.txtPHP:  syntax error, unexpected '=' in /etc/php5/apache2/conf.d/apc.ini on line 1PHP:  syntax error, unexpected '=' in /etc/php5/apache2/conf...

[Carl Leitner (litlfred)]

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://open.intrahealth.org/mediawiki/HowTo:_Install_Memcached
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/php5/apache2/conf.d/apc.ini
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)]

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://open.intrahealth.org/mediawiki/HowTo:_Install_Memcached
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/php5/apache2/conf.d/apc.ini
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://bugs.launchpad.net/bugs/823302

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' (DefaultUserAuditService.java [http-bio-8080-exec-6])
  * INFO  16:28:52,786 Content-type: application/x-zip-compressed, filename: /usr/local/apache-tomcat-7.0.19/work/Catalina/localhost/dhis/upload_41f1340e_131aebb410b__8000_00000001.tmp (ImportAction.java [http-bio-8080-exec-6])
  * INFO  16:28:52,809 Internal process started (AbstractStatementInternalProcess.java [Thread-14])
  * INFO  16:28:52,809 Importing stream (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,811 Zip file detected (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,814 Saved zipstream to file: /usr/local/apache-tomcat-7.0.19/temp/IMPORT_5661984542839526104_ZIP (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,897 Transforming stream (DefaultImportService.java [Thread-14])
  * ERROR 16:28:53,120 Internal process failed (AbstractStatementInternalProcess.java [Thread-14])
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
          at org.hisp.dhis.importexport.xml.XMLPreConverter.transform(XMLPreConverter.java:139)
          at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImportService.java:171)
          at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40)
          at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
          at java.lang.Thread.run(Thread.java:662)
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.get...

[Sele (seleman-ally)]

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://open.intrahealth.org/mediawiki/HowTo:_Install_Memcached
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/php5/apache2/conf.d/apc.ini
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://bugs.launchpad.net/bugs/823302

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' (DefaultUserAuditService.java [http-bio-8080-exec-6])
  * INFO  16:28:52,786 Content-type: application/x-zip-compressed, filename: /usr/local/apache-tomcat-7.0.19/work/Catalina/localhost/dhis/upload_41f1340e_131aebb410b__8000_00000001.tmp (ImportAction.java [http-bio-8080-exec-6])
  * INFO  16:28:52,809 Internal process started (AbstractStatementInternalProcess.java [Thread-14])
  * INFO  16:28:52,809 Importing stream (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,811 Zip file detected (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,814 Saved zipstream to file: /usr/local/apache-tomcat-7.0.19/temp/IMPORT_5661984542839526104_ZIP (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,897 Transforming stream (DefaultImportService.java [Thread-14])
  * ERROR 16:28:53,120 Internal process failed (AbstractStatementInternalProcess.java [Thread-14])
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
          at org.hisp.dhis.importexport.xml.XMLPreConverter.transform(XMLPreConverter.java:139)
          at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImportService.java:171)
          at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40)
          at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
          at java.lang.Thread.run(Thread.java:662)
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocat...

[Carl Leitner (litlfred)]

We can ignore this error for now:
          DOMDocument::loadHTML(): Unexpected end tag : p in Entity, line: 6
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/iHRIS/lib/4.0.16/I2CE/modules/Forms/modules/FieldLimits/lib/I2CE_Module_FieldLimits.php
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)]

For the second error message, I created the following bug report:
  https://bugs.edge.launchpad.net/i2ce/+bug/823965

[Sele (seleman-ally)]

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:
          DOMDocument::loadHTML(): Unexpected end tag : p in Entity, line: 6
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/iHRIS/lib/4.0.16/I2CE/modules/Forms/modules/FieldLimits/lib/I2CE_Module_FieldLimits.php
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://bugs.launchpad.net/bugs/823302

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' (DefaultUserAuditService.java [http-bio-8080-exec-6])
  * INFO  16:28:52,786 Content-type: application/x-zip-compressed, filename: /usr/local/apache-tomcat-7.0.19/work/Catalina/localhost/dhis/upload_41f1340e_131aebb410b__8000_00000001.tmp (ImportAction.java [http-bio-8080-exec-6])
  * INFO  16:28:52,809 Internal process started (AbstractStatementInternalProcess.java [Thread-14])
  * INFO  16:28:52,809 Importing stream (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,811 Zip file detected (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,814 Saved zipstream to file: /usr/local/apache-tomcat-7.0.19/temp/IMPORT_5661984542839526104_ZIP (DefaultImportService.java [Thread-14])
  * INFO  16:28:52,897 Transforming stream (DefaultImportService.java [Thread-14])
  * ERROR 16:28:53,120 Internal process failed (AbstractStatementInternalProcess.java [Thread-14])
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
          at org.hisp.dhis.importexport.xml.XMLPreConverter.transform(XMLPreConverter.java:139)
          at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImportService.java:171)
          at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103)
          at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40)
          at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
          at java.lang.Thread.run(Thread.java:662)
  java.lang.NullPointerException
          at org.hisp.dhis.importexport.xml.LocManagerXSLTLocator.getTransformerByTag(LocManagerXSLTLocator.java:109)
          at org.hisp.dhis.importexport.xml.XMLPreConverter.transfor...

[Digbeu Paul-Emile (pabloderuvess)]

1- can i know if we can import SDMX-HD file in DHIS2?
2- if we can, say me how to import it?