It could be power cuts.  Is it on a UPS?

Cheers,
-carl 

On Feb 13, 2012, at 5:24 AM, josephat mathayo <email address hidden> wrote:

> Let us see what we can learn now. I asked IT Technician to turn off
> using command line shutdown -h now
> 
> I will update you.
> 
> On 2/10/12, Carl Leitner <email address hidden> wrote:
>> No this is not because of 4.0.19.
>> 
>> Is this the same machine that it happened on before?
>> 
>> Maybe the machine is not getting powered off correctly which is causing
>> the database to be corrupted.
>> 
>> Cheers.
>> -carl
>> 
>> On 01/10/2012 12:08 PM, josephat mathayo wrote:
>>> Public bug reported:
>>> 
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Skipping cached table for job as it is not dirty
>>> [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
>>>          I2CE_CachedForm->generateCachedTable
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:422)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Skipping cached table for cadre as it is not dirty
>>> [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
>>>          I2CE_CachedForm->generateCachedTable
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:422)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Skipping cached table for classification as it is not dirty
>>> [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Successfully cached all forms
>>> [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:599)
>>>          I2CE_FormRelationship->getFunctionDetails
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:511)
>>>          I2CE_CustomReport->getReportedFunctions
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:533)
>>>          I2CE_CustomReport->setupQueries
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:464)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Getting details on days_open
>>> [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:639)
>>>          I2CE_FormRelationship->getFunctionDetails
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:511)
>>>          I2CE_CustomReport->getReportedFunctions
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:533)
>>>          I2CE_CustomReport->setupQueries
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:464)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Returning sorted function details on days_open
>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Doing DROP TABLE IF EXISTS
>>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]`
>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Doing CREATE TABLE
>>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]` (
>>> `primary_form+id` varchar(255),`primary_form+parent`
>>> varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8
>>> COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET utf8
>>> COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8
>>> COLLATE utf8_bin,`primary_form+posted_date` datetime ,`primary_form+code`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+employer`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+pos_type`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,last_md5 BINARY(16)
>>> UNIQUE,md5 BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX
>>> `primary_form+department` (`primary_form+department` (255)),INDEX
>>> `primary_form+facility` (`primary_form+facility` (255)),INDEX
>>> `primary_form+job` (`primary_form+job` (255)),INDEX
>>> `primary_form+posted_date` (`primary_form+posted_date`),INDEX
>>> `primary_form+code` (`primary_form+code` (255)),INDEX
>>> `primary_form+employer` (`primary_form+employer` (255)),INDEX
>>> `primary_form+pos_type` (`primary_form+pos_type` (255)),INDEX
>>> `primary_form+status` (`primary_form+status` (255)),INDEX
>>> `primary_form+title` (`primary_form+title` (255)))  ENGINE=InnoDB DEFAULT
>>> CHARSET=utf8 COLLATE=utf8_bin
>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Doing INSERT INTO `manage_cssc_lake`.`tmp_custom_report_position_list[1]`
>>>  SELECT `position`.id as `primary_form+id`,`position`.parent as
>>> `primary_form+parent`,`position`.`department`  AS
>>> `primary_form+department` ,`position`.`facility`  AS
>>> `primary_form+facility` ,`position`.`job`  AS `primary_form+job`
>>> ,`position`.`posted_date`  AS `primary_form+posted_date`
>>> ,`position`.`code`  AS `primary_form+code` ,`position`.`employer`  AS
>>> `primary_form+employer` ,`position`.`pos_type`  AS `primary_form+pos_type`
>>> ,`position`.`status`  AS `primary_form+status` ,`position`.`title`  AS
>>> `primary_form+title` ,NULL AS last_md5, UNHEX(MD5(`position`.id)) AS md5
>>> FROM `manage_cssc_lake`.`hippo_position` AS `position`
>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Inserted 3761 rows
>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Doing DROP TABLE IF EXISTS
>>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]`
>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Doing CREATE TABLE
>>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]` (
>>> `primary_form+id` varchar(255),`primary_form+parent`
>>> varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8
>>> COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET utf8
>>> COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8
>>> COLLATE utf8_bin,`primary_form+posted_date` datetime ,`primary_form+code`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+employer`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+pos_type`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`current+id`
>>> varchar(255) DEFAULT '',`current+parent` varchar(255),`current+end_date`
>>> datetime ,`current+start_date` datetime ,last_md5 BINARY(16) UNIQUE,md5
>>> BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+department`
>>> (`primary_form+department` (255)),INDEX `primary_form+facility`
>>> (`primary_form+facility` (255)),INDEX `primary_form+job`
>>> (`primary_form+job` (255)),INDEX `primary_form+posted_date`
>>> (`primary_form+posted_date`),INDEX `primary_form+code`
>>> (`primary_form+code` (255)),INDEX `primary_form+employer`
>>> (`primary_form+employer` (255)),INDEX `primary_form+pos_type`
>>> (`primary_form+pos_type` (255)),INDEX `primary_form+status`
>>> (`primary_form+status` (255)),INDEX `primary_form+title`
>>> (`primary_form+title` (255)),INDEX `current+end_date`
>>> (`current+end_date`),INDEX `current+start_date` (`current+start_date`))
>>> ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Doing INSERT  IGNORE  INTO
>>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]`   SELECT
>>> `base_table`.`primary_form+id` as
>>> `primary_form+id`,`base_table`.`primary_form+parent` as
>>> `primary_form+parent`,`base_table`.`primary_form+department` as
>>> `primary_form+department`,`base_table`.`primary_form+facility` as
>>> `primary_form+facility`,`base_table`.`primary_form+job` as
>>> `primary_form+job`,`base_table`.`primary_form+posted_date` as
>>> `primary_form+posted_date`,`base_table`.`primary_form+code` as
>>> `primary_form+code`,`base_table`.`primary_form+employer` as
>>> `primary_form+employer`,`base_table`.`primary_form+pos_type` as
>>> `primary_form+pos_type`,`base_table`.`primary_form+status` as
>>> `primary_form+status`,`base_table`.`primary_form+title` as
>>> `primary_form+title` , `current`.id  as `current+id`,`current`.parent  as
>>> `current+parent`,`current`.`end_date`  AS `current+end_date`
>>> ,`current`.`start_date`  AS `current+start_date` , base_table.md5 AS
>>> last_md5 ,
>>> UNHEX(MD5(CONCAT_WS('',base_table.`primary_form+id`,`current`.id))) AS md5
>>> FROM  `manage_cssc_lake`.`tmp_custom_report_position_list[1]` AS
>>> `base_table` LEFT JOIN   `manage_cssc_lake`.`hippo_person_position` AS
>>> `current`   ON ( ( `current`.`position` = `primary_form+id`  ) )  WHERE ((
>>> ( ISNULL( `current`.`end_date`) OR `current`.`end_date` = '0000-00-00
>>> 00:00:00' )))
>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Inserted 3755 rows
>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Doing INSERT IGNORE INTO
>>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]`  SELECT
>>> `base_table`.`primary_form+id` as
>>> `primary_form+id`,`base_table`.`primary_form+parent` as
>>> `primary_form+parent`,`base_table`.`primary_form+department` as
>>> `primary_form+department`,`base_table`.`primary_form+facility` as
>>> `primary_form+facility`,`base_table`.`primary_form+job` as
>>> `primary_form+job`,`base_table`.`primary_form+posted_date` as
>>> `primary_form+posted_date`,`base_table`.`primary_form+code` as
>>> `primary_form+code`,`base_table`.`primary_form+employer` as
>>> `primary_form+employer`,`base_table`.`primary_form+pos_type` as
>>> `primary_form+pos_type`,`base_table`.`primary_form+status` as
>>> `primary_form+status`,`base_table`.`primary_form+title` as
>>> `primary_form+title` , '' AS `current+id`, NULL AS `current+parent`, NULL
>>> AS `current+end_date`, NULL AS `current+start_date`,base_table.md5 AS md5,
>>> base_table.md5 AS last_md5 FROM
>>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]` AS `base_table`
>>> WHERE md5 NOT IN ( SELECT last_md5 FROM
>>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]`)
>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Inserted 6 rows
>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Doing DROP TABLE IF EXISTS
>>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]`
>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Doing DROP TABLE IF EXISTS
>>> `manage_cssc_lake`.`tmp_custom_report_position_list[3]`
>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Doing CREATE TABLE
>>> `manage_cssc_lake`.`tmp_custom_report_position_list[3]` (
>>> `primary_form+id` varchar(255),`primary_form+parent`
>>> varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8
>>> COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET utf8
>>> COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8
>>> COLLATE utf8_bin,`primary_form+posted_date` datetime ,`primary_form+code`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+employer`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+pos_type`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`current+id`
>>> varchar(255) DEFAULT '',`current+parent` varchar(255),`current+end_date`
>>> datetime ,`current+start_date` datetime ,`department+id` varchar(255)
>>> DEFAULT '',`department+parent` varchar(255),`department+name` text
>>> CHARACTER SET utf8  COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5
>>> BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+department`
>>> (`primary_form+department` (255)),INDEX `primary_form+facility`
>>> (`primary_form+facility` (255)),INDEX `primary_form+job`
>>> (`primary_form+job` (255)),INDEX `primary_form+posted_date`
>>> (`primary_form+posted_date`),INDEX `primary_form+code`
>>> (`primary_form+code` (255)),INDEX `primary_form+employer`
>>> (`primary_form+employer` (255)),INDEX `primary_form+pos_type`
>>> (`primary_form+pos_type` (255)),INDEX `primary_form+status`
>>> (`primary_form+status` (255)),INDEX `primary_form+title`
>>> (`primary_form+title` (255)),INDEX `current+end_date`
>>> (`current+end_date`),INDEX `current+start_date` (`current+start_date`))
>>> ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->pearError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:471)
>>>          I2CE_CustomReport->_generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Unable to populate cached report:
>>>    MDB2 Error: can not create
>>>    _doQuery: [Error message: Could not execute statement]
>>>    [Last executed query: CREATE TABLE
>>> `manage_cssc_lake`.`tmp_custom_report_position_list[3]` (
>>> `primary_form+id` varchar(255),`primary_form+parent`
>>> varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8
>>> COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET utf8
>>> COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8
>>> COLLATE utf8_bin,`primary_form+posted_date` datetime ,`primary_form+code`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+employer`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+pos_type`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title`
>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`current+id`
>>> varchar(255) DEFAULT '',`current+parent` varchar(255),`current+end_date`
>>> datetime ,`current+start_date` datetime ,`department+id` varchar(255)
>>> DEFAULT '',`department+parent` varchar(255),`department+name` text
>>> CHARACTER SET utf8  COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5
>>> BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+department`
>>> (`primary_form+department` (255)),INDEX `primary_form+facility`
>>> (`primary_form+facility` (255)),INDEX `primary_form+job`
>>> (`primary_form+job` (255)),INDEX `primary_form+posted_date`
>>> (`primary_form+posted_date`),INDEX `primary_form+code`
>>> (`primary_form+code` (255)),INDEX `primary_form+employer`
>>> (`primary_form+employer` (255)),INDEX `primary_form+pos_type`
>>> (`primary_form+pos_type` (255)),INDEX `primary_form+status`
>>> (`primary_form+status` (255)),INDEX `primary_form+title`
>>> (`primary_form+title` (255)),INDEX `current+end_date`
>>> (`current+end_date`),INDEX `current+start_date` (`current+start_date`))
>>> ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin]
>>>    [Native code: 1005]
>>>    [Native message: Can't create table
>>> './manage_cssc_lake/tmp_custom_report_position_list[3].frm' (errno: 121)]
>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:439)
>>>          I2CE_CustomReport->generateCache
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>>>          I2CE_Page_CustomReports->actionGenerate
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Report generation failed for position_list
>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>    Refered by :
>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>    I2CE: I2CE->raiseError
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:145)
>>>          I2CE_Page_CustomReports->action
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>>>          I2CE_Page->display
>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>>>          I2CE_Wrangler->wrangle
>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>    Unable to generate report
>>> 
>>> ** Affects: i2ce
>>>      Importance: Undecided
>>>          Status: New
>>> 
>> 
>> --
>> You received this bug notification because you are subscribed to the bug
>> report.
>> https://bugs.launchpad.net/bugs/914185
>> 
>> Title:
>>  Position list report - Fails to generate ( The same happened, I
>>  dropped the database and restored then it worked) Does this because of
>>  4.0.19
>> 
>> To manage notifications about this bug go to:
>> https://bugs.launchpad.net/i2ce/+bug/914185/+subscriptions
>> 
> 
> 
> -- 
> -- 
> Best Regard,
> Mathayo Josephat
> CSSC Tanzania Human Resource Capacity Project
> P.O Box 9433 Dar es Salaam, Tanzania
> Cell: 255 754 940 636 | 712 191 192
> Tel:  255 22 211 2918 | 255 22 213 5070
> 
> <email address hidden> | <email address hidden>
> 
> -------------------------------------------------
> 
> -- 
> You received this bug notification because you are subscribed to I2CE.
> https://bugs.launchpad.net/bugs/914185
> 
> Title:
>  Position list report - Fails to generate ( The same happened, I
>  dropped the database and restored then it worked) Does this because of
>  4.0.19
> 
> Status in IntraHealth Informatics Core Engine:
>  New
> 
> Bug description:
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Skipping cached table for job as it is not dirty
>  [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
>            I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:422)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Skipping cached table for cadre as it is not dirty
>  [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
>            I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:422)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Skipping cached table for classification as it is not dirty
>  [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Successfully cached all forms
>  [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:599)
>            I2CE_FormRelationship->getFunctionDetails (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:511)
>            I2CE_CustomReport->getReportedFunctions (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:533)
>            I2CE_CustomReport->setupQueries (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:464)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Getting details on days_open
>  [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:639)
>            I2CE_FormRelationship->getFunctionDetails (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:511)
>            I2CE_CustomReport->getReportedFunctions (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:533)
>            I2CE_CustomReport->setupQueries (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:464)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Returning sorted function details on days_open
>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Doing DROP TABLE IF EXISTS `manage_cssc_lake`.`tmp_custom_report_position_list[1]`
>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Doing CREATE TABLE `manage_cssc_lake`.`tmp_custom_report_position_list[1]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+posted_date` datetime ,`primary_form+code` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+employer` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+pos_type` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5 BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+department` (`primary_form+department` (255)),INDEX `primary_form+facility` (`primary_form+facility` (255)),INDEX `primary_form+job` (`primary_form+job` (255)),INDEX `primary_form+posted_date` (`primary_form+posted_date`),INDEX `primary_form+code` (`primary_form+code` (255)),INDEX `primary_form+employer` (`primary_form+employer` (255)),INDEX `primary_form+pos_type` (`primary_form+pos_type` (255)),INDEX `primary_form+status` (`primary_form+status` (255)),INDEX `primary_form+title` (`primary_form+title` (255)))  ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Doing INSERT INTO `manage_cssc_lake`.`tmp_custom_report_position_list[1]`   SELECT `position`.id as `primary_form+id`,`position`.parent as `primary_form+parent`,`position`.`department`  AS `primary_form+department` ,`position`.`facility`  AS `primary_form+facility` ,`position`.`job`  AS `primary_form+job` ,`position`.`posted_date`  AS `primary_form+posted_date` ,`position`.`code`  AS `primary_form+code` ,`position`.`employer`  AS `primary_form+employer` ,`position`.`pos_type`  AS `primary_form+pos_type` ,`position`.`status`  AS `primary_form+status` ,`position`.`title`  AS `primary_form+title` ,NULL AS last_md5, UNHEX(MD5(`position`.id)) AS md5  FROM `manage_cssc_lake`.`hippo_position` AS `position`
>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Inserted 3761 rows
>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Doing DROP TABLE IF EXISTS `manage_cssc_lake`.`tmp_custom_report_position_list[2]`
>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Doing CREATE TABLE `manage_cssc_lake`.`tmp_custom_report_position_list[2]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+posted_date` datetime ,`primary_form+code` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+employer` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+pos_type` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`current+id` varchar(255) DEFAULT '',`current+parent` varchar(255),`current+end_date` datetime ,`current+start_date` datetime ,last_md5 BINARY(16) UNIQUE,md5 BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+department` (`primary_form+department` (255)),INDEX `primary_form+facility` (`primary_form+facility` (255)),INDEX `primary_form+job` (`primary_form+job` (255)),INDEX `primary_form+posted_date` (`primary_form+posted_date`),INDEX `primary_form+code` (`primary_form+code` (255)),INDEX `primary_form+employer` (`primary_form+employer` (255)),INDEX `primary_form+pos_type` (`primary_form+pos_type` (255)),INDEX `primary_form+status` (`primary_form+status` (255)),INDEX `primary_form+title` (`primary_form+title` (255)),INDEX `current+end_date` (`current+end_date`),INDEX `current+start_date` (`current+start_date`))  ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Doing INSERT  IGNORE  INTO `manage_cssc_lake`.`tmp_custom_report_position_list[2]`   SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+department` as `primary_form+department`,`base_table`.`primary_form+facility` as `primary_form+facility`,`base_table`.`primary_form+job` as `primary_form+job`,`base_table`.`primary_form+posted_date` as `primary_form+posted_date`,`base_table`.`primary_form+code` as `primary_form+code`,`base_table`.`primary_form+employer` as `primary_form+employer`,`base_table`.`primary_form+pos_type` as `primary_form+pos_type`,`base_table`.`primary_form+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title` , `current`.id  as `current+id`,`current`.parent  as `current+parent`,`current`.`end_date`  AS `current+end_date` ,`current`.`start_date`  AS `current+start_date` , base_table.md5 AS last_md5 , UNHEX(MD5(CONCAT_WS('',base_table.`primary_form+id`,`current`.id))) AS md5  FROM  `manage_cssc_lake`.`tmp_custom_report_position_list[1]` AS `base_table` LEFT JOIN   `manage_cssc_lake`.`hippo_person_position` AS `current`   ON ( ( `current`.`position` = `primary_form+id`  ) )  WHERE (( ( ISNULL( `current`.`end_date`) OR `current`.`end_date` = '0000-00-00 00:00:00' )))
>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Inserted 3755 rows
>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Doing INSERT IGNORE INTO `manage_cssc_lake`.`tmp_custom_report_position_list[2]`  SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+department` as `primary_form+department`,`base_table`.`primary_form+facility` as `primary_form+facility`,`base_table`.`primary_form+job` as `primary_form+job`,`base_table`.`primary_form+posted_date` as `primary_form+posted_date`,`base_table`.`primary_form+code` as `primary_form+code`,`base_table`.`primary_form+employer` as `primary_form+employer`,`base_table`.`primary_form+pos_type` as `primary_form+pos_type`,`base_table`.`primary_form+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title` , '' AS `current+id`, NULL AS `current+parent`, NULL AS `current+end_date`, NULL AS `current+start_date`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_cssc_lake`.`tmp_custom_report_position_list[1]` AS `base_table` WHERE md5 NOT IN ( SELECT last_md5 FROM `manage_cssc_lake`.`tmp_custom_report_position_list[2]`)
>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Inserted 6 rows
>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Doing DROP TABLE IF EXISTS `manage_cssc_lake`.`tmp_custom_report_position_list[1]`
>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Doing DROP TABLE IF EXISTS `manage_cssc_lake`.`tmp_custom_report_position_list[3]`
>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Doing CREATE TABLE `manage_cssc_lake`.`tmp_custom_report_position_list[3]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+posted_date` datetime ,`primary_form+code` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+employer` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+pos_type` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`current+id` varchar(255) DEFAULT '',`current+parent` varchar(255),`current+end_date` datetime ,`current+start_date` datetime ,`department+id` varchar(255) DEFAULT '',`department+parent` varchar(255),`department+name` text  CHARACTER SET utf8  COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5 BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+department` (`primary_form+department` (255)),INDEX `primary_form+facility` (`primary_form+facility` (255)),INDEX `primary_form+job` (`primary_form+job` (255)),INDEX `primary_form+posted_date` (`primary_form+posted_date`),INDEX `primary_form+code` (`primary_form+code` (255)),INDEX `primary_form+employer` (`primary_form+employer` (255)),INDEX `primary_form+pos_type` (`primary_form+pos_type` (255)),INDEX `primary_form+status` (`primary_form+status` (255)),INDEX `primary_form+title` (`primary_form+title` (255)),INDEX `current+end_date` (`current+end_date`),INDEX `current+start_date` (`current+start_date`))  ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:471)
>            I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Unable to populate cached report:
>      MDB2 Error: can not create
>      _doQuery: [Error message: Could not execute statement]
>      [Last executed query: CREATE TABLE `manage_cssc_lake`.`tmp_custom_report_position_list[3]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+posted_date` datetime ,`primary_form+code` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+employer` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+pos_type` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`current+id` varchar(255) DEFAULT '',`current+parent` varchar(255),`current+end_date` datetime ,`current+start_date` datetime ,`department+id` varchar(255) DEFAULT '',`department+parent` varchar(255),`department+name` text  CHARACTER SET utf8  COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5 BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+department` (`primary_form+department` (255)),INDEX `primary_form+facility` (`primary_form+facility` (255)),INDEX `primary_form+job` (`primary_form+job` (255)),INDEX `primary_form+posted_date` (`primary_form+posted_date`),INDEX `primary_form+code` (`primary_form+code` (255)),INDEX `primary_form+employer` (`primary_form+employer` (255)),INDEX `primary_form+pos_type` (`primary_form+pos_type` (255)),INDEX `primary_form+status` (`primary_form+status` (255)),INDEX `primary_form+title` (`primary_form+title` (255)),INDEX `current+end_date` (`current+end_date`),INDEX `current+start_date` (`current+start_date`))  ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin]
>      [Native code: 1005]
>      [Native message: Can't create table './manage_cssc_lake/tmp_custom_report_position_list[3].frm' (errno: 121)]
>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:439)
>            I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
>            I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Report generation failed for position_list
>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>      Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>      I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:145)
>            I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
>            I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
>            I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>      Unable to generate report
> 
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/i2ce/+bug/914185/+subscriptions