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 >