I2CE

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

Bug #914185 reported by josephat mathayo
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
I2CE
New
Undecided
Unassigned

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

Revision history for this message
Carl Leitner (litlfred) wrote : Re: [Bug 914185] [NEW] 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
Download full text (31.1 KiB)

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...

Revision history for this message
josephat mathayo (jmathayo) wrote :
Download full text (33.2 KiB)

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

Revision history for this message
Carl Leitner (litlfred) wrote :
Download full text (66.3 KiB)

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
>>> ...

Revision history for this message
josephat mathayo (jmathayo) wrote :
Download full text (69.3 KiB)

Dear all

It is cconnected to UPS and Power Stabilizer.

what about if we upgrade the mysql 5.0.67 to the next version. I am
using mysql 5.0.67 to all CSSC site, APHFTA & BAKWATA.

But my worry is, if i upgrade to another version above 5.x may affect
the php 5.x and apache 2.0

Your comment can help me to see if i can upgrade due to your experience!!

On 2/13/12, Carl Leitner <email address hidden> wrote:
> 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/Page...

Revision history for this message
Carl Leitner (litlfred) wrote :
Download full text (16.0 KiB)

I don't think it is a MySQL version is. For some reason the database is getting corrupted. Is the UPS setup to automatically power down the computer when there is a power cut?

Cheers,
-carl

On Feb 14, 2012, at 2:06 AM, josephat mathayo <email address hidden> wrote:

> Dear all
>
> It is cconnected to UPS and Power Stabilizer.
>
> what about if we upgrade the mysql 5.0.67 to the next version. I am
> using mysql 5.0.67 to all CSSC site, APHFTA & BAKWATA.
>
>
> But my worry is, if i upgrade to another version above 5.x may affect
> the php 5.x and apache 2.0
>
> Your comment can help me to see if i can upgrade due to your
> experience!!
>
>
>
> On 2/13/12, Carl Leitner <email address hidden> wrote:
>> 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_CustomRep...

Revision history for this message
josephat mathayo (jmathayo) wrote :
Download full text (17.1 KiB)

Surely no. May be we set it and see what happend.

On 2/14/12, Carl Leitner <email address hidden> wrote:
> I don't think it is a MySQL version is. For some reason the database is
> getting corrupted. Is the UPS setup to automatically power down the
> computer when there is a power cut?
>
> Cheers,
> -carl
>
> On Feb 14, 2012, at 2:06 AM, josephat mathayo
> <email address hidden> wrote:
>
>> Dear all
>>
>> It is cconnected to UPS and Power Stabilizer.
>>
>> what about if we upgrade the mysql 5.0.67 to the next version. I am
>> using mysql 5.0.67 to all CSSC site, APHFTA & BAKWATA.
>>
>>
>> But my worry is, if i upgrade to another version above 5.x may affect
>> the php 5.x and apache 2.0
>>
>> Your comment can help me to see if i can upgrade due to your
>> experience!!
>>
>>
>>
>> On 2/13/12, Carl Leitner <email address hidden> wrote:
>>> 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:...

Revision history for this message
josephat mathayo (jmathayo) wrote : Invitation to connect on LinkedIn

LinkedIn
------------

Bug,

I'd like to add you to my professional network on LinkedIn.

- Mathayo

Mathayo Josephat
ICT Consultant at MARO Technology Limited
Tanzania

Confirm that you know Mathayo Josephat:
https://www.linkedin.com/e/o88w8e-hqkm9xan-3v/isd/19428948943/sapNtyP0/?hs=false&tok=3F54soFz3_w641

--
You are receiving Invitation to Connect emails. Click to unsubscribe:
http://www.linkedin.com/e/o88w8e-hqkm9xan-3v/qTC8UOsFcp8TdwF-DYwOGR_FFLptR0H4-eh6DiL/goo/914185%40bugs%2Elaunchpad%2Enet/20061/I6296821721_1/?hs=false&tok=3UEgHOtT__w641

(c) 2012 LinkedIn Corporation. 2029 Stierlin Ct, Mountain View, CA 94043, USA.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.