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>

-------------------------------------------------