ihris-manage-cssc

In 4.0.19; One site still not generating a Tange report(Staff Directory report)

Bug #898977 reported by josephat mathayo on 2011-12-02

This bug report is a duplicate of: Bug #893478: Checking more than 17 fields in Report View for 4.0.18 - fails in generating report. Edit Remove

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	ihris-manage-cssc	New	Undecided	Unassigned

Bug Description

The Lake Zone site is a bit not generating but the rest of the site is ok what could be cause. I tried to copy the customreport.php from the other site and paste to the LZ site but i am getting this.

       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_staff_list[4]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+end_date` as `primary_form+end_date`,`base_table`.`primary_form+position` as `primary_form+position`,`base_table`.`primary_form+start_date` as `primary_form+start_date`,`base_table`.`current_salary+id` as `current_salary+id`,`base_table`.`current_salary+parent` as `current_salary+parent`,`base_table`.`current_salary+end_date` as `current_salary+end_date`,`base_table`.`person+id` as `person+id`,`base_table`.`person+parent` as `person+parent`,`base_table`.`person+nationality` as `person+nationality`,`base_table`.`person+firstname` as `person+firstname`,`base_table`.`person+othername` as `person+othername`,`base_table`.`person+relg_affil` as `person+relg_affil`,`base_table`.`person+residence` as `person+residence`,`base_table`.`person+surname` as `person+surname` , `position`.id as `position+id`,`position`.parent as `position+parent`,`position`.`department` AS `position+department` ,`position`.`facility` AS `position+facility` ,`position`.`job` AS `position+job` ,`position`.`employer` AS `position+employer` ,`position`.`pos_type` AS `position+pos_type` ,`position`.`title` AS `position+title` , base_table.md5 AS last_md5 , UNHEX(MD5(CONCAT_WS('',base_table.`primary_form+id`,base_table.`current_salary+id`,base_table.`person+id`,`position`.id))) AS md5 FROM `manage_cssc_lake`.`tmp_custom_report_staff_list[3]` AS `base_table` LEFT JOIN `manage_cssc_lake`.`hippo_position` as `position` ON ( ( `primary_form+position` = `position`.`id` ) )
[Fri Dec 02 01:51:31 2011] [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 3633 rows
[Fri Dec 02 01:51:31 2011] [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_staff_list[4]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+end_date` as `primary_form+end_date`,`base_table`.`primary_form+position` as `primary_form+position`,`base_table`.`primary_form+start_date` as `primary_form+start_date`,`base_table`.`current_salary+id` as `current_salary+id`,`base_table`.`current_salary+parent` as `current_salary+parent`,`base_table`.`current_salary+end_date` as `current_salary+end_date`,`base_table`.`person+id` as `person+id`,`base_table`.`person+parent` as `person+parent`,`base_table`.`person+nationality` as `person+nationality`,`base_table`.`person+firstname` as `person+firstname`,`base_table`.`person+othername` as `person+othername`,`base_table`.`person+relg_affil` as `person+relg_affil`,`base_table`.`person+residence` as `person+residence`,`base_table`.`person+surname` as `person+surname` , '' AS `position+id`, NULL AS `position+parent`, NULL AS `position+department`, NULL AS `position+facility`, NULL AS `position+job`, NULL AS `position+employer`, NULL AS `position+pos_type`, NULL AS `position+title`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_cssc_lake`.`tmp_custom_report_staff_list[3]` AS `base_table` WHERE md5 NOT IN ( SELECT last_md5 FROM `manage_cssc_lake`.`tmp_custom_report_staff_list[4]`)
[Fri Dec 02 01:51:31 2011] [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 0 rows
[Fri Dec 02 01:51:31 2011] [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_staff_list[3]`
[Fri Dec 02 01:51:31 2011] [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_staff_list[5]`
[Fri Dec 02 01:51:31 2011] [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_staff_list[5]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+end_date` datetime ,`primary_form+position` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+start_date` datetime ,`current_salary+id` varchar(255) DEFAULT '',`current_salary+parent` varchar(255),`current_salary+end_date` datetime ,`person+id` varchar(255) DEFAULT '',`person+parent` varchar(255),`person+nationality` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+othername` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+relg_affil` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+residence` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+surname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+id` varchar(255) DEFAULT '',`position+parent` varchar(255),`position+department` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+facility` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+job` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+employer` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+pos_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`start_salary+id` varchar(255) DEFAULT '',`start_salary+parent` varchar(255),`start_salary+start_date` datetime ,`start_salary+salary` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5 BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+end_date` (`primary_form+end_date`),INDEX `primary_form+parent` (`primary_form+parent` (255)),INDEX `primary_form+position` (`primary_form+position` (255)),INDEX `primary_form+start_date` (`primary_form+start_date`),INDEX `current_salary+end_date` (`current_salary+end_date`),INDEX `person+nationality` (`person+nationality` (255)),INDEX `person+firstname` (`person+firstname` (255)),INDEX `person+othername` (`person+othername` (255)),INDEX `person+relg_affil` (`person+relg_affil` (255)),INDEX `person+residence` (`person+residence` (255)),INDEX `person+surname` (`person+surname` (255)),INDEX `position+department` (`position+department` (255)),INDEX `position+facility` (`position+facility` (255)),INDEX `position+job` (`position+job` (255)),INDEX `position+employer` (`position+employer` (255)),INDEX `position+pos_type` (`position+pos_type` (255)),INDEX `position+title` (`position+title` (255)),INDEX `start_salary+start_date` (`start_salary+start_date`),INDEX `start_salary+salary` (`start_salary+salary` (255))) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
[Fri Dec 02 01:51:31 2011] [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_staff_list[5]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+end_date` as `primary_form+end_date`,`base_table`.`primary_form+position` as `primary_form+position`,`base_table`.`primary_form+start_date` as `primary_form+start_date`,`base_table`.`current_salary+id` as `current_salary+id`,`base_table`.`current_salary+parent` as `current_salary+parent`,`base_table`.`current_salary+end_date` as `current_salary+end_date`,`base_table`.`person+id` as `person+id`,`base_table`.`person+parent` as `person+parent`,`base_table`.`person+nationality` as `person+nationality`,`base_table`.`person+firstname` as `person+firstname`,`base_table`.`person+othername` as `person+othername`,`base_table`.`person+relg_affil` as `person+relg_affil`,`base_table`.`person+residence` as `person+residence`,`base_table`.`person+surname` as `person+surname`,`base_table`.`position+id` as `position+id`,`base_table`.`position+parent` as `position+parent`,`base_table`.`position+department` as `position+department`,`base_table`.`position+facility` as `position+facility`,`base_table`.`position+job` as `position+job`,`base_table`.`position+employer` as `position+employer`,`base_table`.`position+pos_type` as `position+pos_type`,`base_table`.`position+title` as `position+title` , `start_salary`.id as `start_salary+id`,`start_salary`.parent as `start_salary+parent`,`start_salary`.`start_date` AS `start_salary+start_date` ,`start_salary`.`salary` AS `start_salary+salary` , base_table.md5 AS last_md5 , UNHEX(MD5(CONCAT_WS('',base_table.`primary_form+id`,base_table.`current_salary+id`,base_table.`person+id`,base_table.`position+id`,`start_salary`.id))) AS md5 FROM `manage_cssc_lake`.`tmp_custom_report_staff_list[4]` AS `base_table` LEFT JOIN `manage_cssc_lake`.`hippo_salary` AS `start_salary` ON ( ( `start_salary`.parent = `primary_form+id` ) ) WHERE (( `start_salary`.`start_date` = (SELECT DISTINCT `start_date` AS `start_date` FROM `manage_cssc_lake`.`hippo_salary` WHERE (( `manage_cssc_lake`.`hippo_salary`.parent = `primary_form+id` )) ORDER BY `start_date` ASC LIMIT 0, 1)))
[Fri Dec 02 01:51:32 2011] [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 3633 rows
[Fri Dec 02 01:51:32 2011] [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_staff_list[5]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+end_date` as `primary_form+end_date`,`base_table`.`primary_form+position` as `primary_form+position`,`base_table`.`primary_form+start_date` as `primary_form+start_date`,`base_table`.`current_salary+id` as `current_salary+id`,`base_table`.`current_salary+parent` as `current_salary+parent`,`base_table`.`current_salary+end_date` as `current_salary+end_date`,`base_table`.`person+id` as `person+id`,`base_table`.`person+parent` as `person+parent`,`base_table`.`person+nationality` as `person+nationality`,`base_table`.`person+firstname` as `person+firstname`,`base_table`.`person+othername` as `person+othername`,`base_table`.`person+relg_affil` as `person+relg_affil`,`base_table`.`person+residence` as `person+residence`,`base_table`.`person+surname` as `person+surname`,`base_table`.`position+id` as `position+id`,`base_table`.`position+parent` as `position+parent`,`base_table`.`position+department` as `position+department`,`base_table`.`position+facility` as `position+facility`,`base_table`.`position+job` as `position+job`,`base_table`.`position+employer` as `position+employer`,`base_table`.`position+pos_type` as `position+pos_type`,`base_table`.`position+title` as `position+title` , '' AS `start_salary+id`, NULL AS `start_salary+parent`, NULL AS `start_salary+start_date`, NULL AS `start_salary+salary`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_cssc_lake`.`tmp_custom_report_staff_list[4]` AS `base_table` WHERE md5 NOT IN ( SELECT last_md5 FROM `manage_cssc_lake`.`tmp_custom_report_staff_list[5]`)
[Fri Dec 02 01:51:32 2011] [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 0 rows
[Fri Dec 02 01:51:32 2011] [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_staff_list[4]`
[Fri Dec 02 01:51:32 2011] [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_staff_list[6]`
[Fri Dec 02 01:51:32 2011] [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_staff_list[6]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+end_date` datetime ,`primary_form+position` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+start_date` datetime ,`current_salary+id` varchar(255) DEFAULT '',`current_salary+parent` varchar(255),`current_salary+end_date` datetime ,`person+id` varchar(255) DEFAULT '',`person+parent` varchar(255),`person+nationality` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+othername` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+relg_affil` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+residence` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+surname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+id` varchar(255) DEFAULT '',`position+parent` varchar(255),`position+department` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+facility` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+job` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+employer` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+pos_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`start_salary+id` varchar(255) DEFAULT '',`start_salary+parent` varchar(255),`start_salary+start_date` datetime ,`start_salary+salary` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`demographic+id` varchar(255) DEFAULT '',`demographic+parent` varchar(255),`demographic+birth_date` datetime ,`demographic+gender` text CHARACTER SET utf8 COLLATE utf8_bin,`demographic+marital_status` text CHARACTER SET utf8 COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5 BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+end_date` (`primary_form+end_date`),INDEX `primary_form+parent` (`primary_form+parent` (255)),INDEX `primary_form+position` (`primary_form+position` (255)),INDEX `primary_form+start_date` (`primary_form+start_date`),INDEX `current_salary+end_date` (`current_salary+end_date`),INDEX `person+nationality` (`person+nationality` (255)),INDEX `person+firstname` (`person+firstname` (255)),INDEX `person+othername` (`person+othername` (255)),INDEX `person+relg_affil` (`person+relg_affil` (255)),INDEX `person+residence` (`person+residence` (255)),INDEX `person+surname` (`person+surname` (255)),INDEX `position+department` (`position+department` (255)),INDEX `position+facility` (`position+facility` (255)),INDEX `position+job` (`position+job` (255)),INDEX `position+employer` (`position+employer` (255)),INDEX `position+pos_type` (`position+pos_type` (255)),INDEX `position+title` (`position+title` (255)),INDEX `start_salary+start_date` (`start_salary+start_date`),INDEX `start_salary+salary` (`start_salary+salary` (255))) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
[Fri Dec 02 01:51:32 2011] [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_staff_list[6]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+end_date` datetime ,`primary_form+position` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+start_date` datetime ,`current_salary+id` varchar(255) DEFAULT '',`current_salary+parent` varchar(255),`current_salary+end_date` datetime ,`person+id` varchar(255) DEFAULT '',`person+parent` varchar(255),`person+nationality` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+othername` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+relg_affil` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+residence` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+surname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+id` varchar(255) DEFAULT '',`position+parent` varchar(255),`position+department` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+facility` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+job` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+employer` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+pos_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`start_salary+id` varchar(255) DEFAULT '',`start_salary+parent` varchar(255),`start_salary+start_date` datetime ,`start_salary+salary` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`demographic+id` varchar(255) DEFAULT '',`demographic+parent` varchar(255),`demographic+birth_date` datetime ,`demographic+gender` text CHARACTER SET utf8 COLLATE utf8_bin,`demographic+marital_status` text CHARACTER SET utf8 COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5 BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+end_date` (`primary_form+end_date`),INDEX `primary_form+parent` (`primary_form+parent` (255)),INDEX `primary_form+position` (`primary_form+position` (255)),INDEX `primary_form+start_date` (`primary_form+start_date`),INDEX `current_salary+end_date` (`current_salary+end_date`),INDEX `person+nationality` (`person+nationality` (255)),INDEX `person+firstname` (`person+firstname` (255)),INDEX `person+othername` (`person+othername` (255)),INDEX `person+relg_affil` (`person+relg_affil` (255)),INDEX `person+residence` (`person+residence` (255)),INDEX `person+surname` (`person+surname` (255)),INDEX `position+department` (`position+department` (255)),INDEX `position+facility` (`position+facility` (255)),INDEX `position+job` (`position+job` (255)),INDEX `position+employer` (`position+employer` (255)),INDEX `position+pos_type` (`position+pos_type` (255)),INDEX `position+title` (`position+title` (255)),INDEX `start_salary+start_date` (`start_salary+start_date`),INDEX `start_salary+salary` (`start_salary+salary` (255))) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin]
[Native code: 1005]
[Native message: Can't create table './manage_cssc_lake/tmp_custom_report_staff_list[6].frm' (errno: 121)]
[Fri Dec 02 01:51:32 2011] [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 staff_list
[Fri Dec 02 01:51:32 2011] [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
[Fri Dec 02 01:56:06 2011] [error] [client 196.46.109.151]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/view/reportViews
I2CE: SELECT SQL_CALC_FOUND_ROWS `primary_table`.`primary_form+id` AS `primary_form+id`,`primary_table`.`last_position+id` AS `last_position+id`,`primary_table`.`last_person_position+id` AS `last_person_position+id`,`primary_table`.`last_facility+id` AS `last_facility+id`,`primary_table`.`primary_form+firstname` AS `primary_form+firstname`,`primary_table`.`primary_form+surname` AS `primary_form+surname`,`primary_table`.`last_position+title` AS `last_position+title`,`primary_table`.`last_person_position+start_date` AS `last_person_position+start_date`,`primary_table`.`last_position+employer` AS `last_position+employer`,`primary_table`.`last_position+pos_type` AS `last_position+pos_type`,`primary_table`.`last_facility+name` AS `last_facility+name`,`primary_table`.`last_facility+facility_type` AS `last_facility+facility_type`,`primary_table`.`+employee_status` AS `+employee_status`,`primary_table`.`last_facility+parent` AS `last_facility+parent`,`primary_table`.`last_person_position+parent` AS `last_person_position+parent`,`primary_table`.`last_position+parent` AS `last_position+parent`,`primary_table`.`primary_form+parent` AS `primary_form+parent` FROM `manage_cssc_lake`.`zebra_search_people` AS primary_table ORDER BY `primary_form+surname`,`primary_form+firstname` LIMIT 50 OFFSET 0

Revision history for this message

Carl Leitner (litlfred) wrote on 2011-12-02:

This error message:
[Native code: 1005]
[Native message: Can't create table './manage_cssc_lake/tmp_custom_report_staff_list[6].frm' (errno: 121)]
has already been reported. So this bug has been reported as a duplicate. You do not need to keep reporting it.

We do not yet know what the issue is.

Cheers.
-carl

affects:

i2ce → ihris-manage-cssc

Report a bug

This report contains Public information

Everyone can see this information.

Duplicate of bug #893478 Remove

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

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