I2CE

Failed to generate report in 4.0.18 for cssc customization, tmp

Bug #893980 reported by josephat mathayo on 2011-11-23

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
	I2CE	New	Undecided	Unassigned

Bug Description

sition+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)))
[Wed Nov 23 07:43:41 2011] [error] [client 196.43.81.121]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
       I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
       I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
       I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
       I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
Inserted 3616 rows
[Wed Nov 23 07:43:41 2011] [error] [client 196.43.81.121]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
       I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
       I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
       I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
       I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/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]`)
[Wed Nov 23 07:43:41 2011] [error] [client 196.43.81.121]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
       I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
       I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
       I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
       I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/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
[Wed Nov 23 07:43:41 2011] [error] [client 196.43.81.121]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
       I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
       I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
       I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
       I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/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]`
[Wed Nov 23 07:43:41 2011] [error] [client 196.43.81.121]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
       I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
       I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
       I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
       I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/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]`
[Wed Nov 23 07:43:41 2011] [error] [client 196.43.81.121]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
       I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
       I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
       I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
       I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/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
[Wed Nov 23 07:43:41 2011] [error] [client 196.43.81.121]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:471)
       I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
       I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
       I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
       I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/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)]
[Wed Nov 23 07:43:41 2011] [error] [client 196.43.81.121]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:439)
       I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
       I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
       I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/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
[Wed Nov 23 07:43:41 2011] [error] [client 196.43.81.121]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:145)
       I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/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
[Wed Nov 23 07:43:42 2011] [error] [client 196.43.68.201]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/contact?contact_type=work
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/ihris-manage/modules/ManagePersonPosition/lib/iHRIS_Module_PersonPosition.php:367)
       iHRIS_Module_PersonPosition->action_person_position
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_person_position (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
Adding person posotion
[Wed Nov 23 07:43:42 2011] [error] [client 196.43.68.201]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/contact?contact_type=work
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:128)
       iHRIS_PageView->appendChildTemplate (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:108)
       iHRIS_PageView->addLastChildForm (/var/lib/iHRIS/cssc_zonal_deploy/modules/EmploymentID/lib/iHRIS_Module_EmploymentID.php:47)
       iHRIS_Module_EmploymentID->action_employmentid
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_employmentid (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
Do not know where to add child form employmentid
[Wed Nov 23 07:44:08 2011] [error] [client 196.43.68.201]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/employment
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/ihris-manage/modules/ManagePersonPosition/lib/iHRIS_Module_PersonPosition.php:367)
       iHRIS_Module_PersonPosition->action_person_position
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_person_position (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
Adding person posotion
[Wed Nov 23 07:44:08 2011] [error] [client 196.43.68.201]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/employment
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:128)
       iHRIS_PageView->appendChildTemplate (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:108)
       iHRIS_PageView->addLastChildForm (/var/lib/iHRIS/cssc_zonal_deploy/modules/EmploymentID/lib/iHRIS_Module_EmploymentID.php:47)
       iHRIS_Module_EmploymentID->action_employmentid
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_employmentid (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
Do not know where to add child form employmentid
[Wed Nov 23 07:44:52 2011] [error] [client 196.43.68.201]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/show/search_people/Default
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 WHERE ((((`last_position+facility` = 'facility|14'))) AND (((LCASE(`primary_form+surname`) LIKE '%kayila%')))) ORDER BY `primary_form+surname`,`primary_form+firstname` LIMIT 50 OFFSET 0
[Wed Nov 23 07:45:01 2011] [error] [client 196.43.68.201]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/manage
I2CE: I2CE_Error->handleError (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE.php:858)
       I2CE->handleError
       DOMDocument->loadHTML (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Template.php:114)
       I2CE_Template->_loadFile (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_TemplateMeister.php:644)
       I2CE_TemplateMeister->loadFile (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_TemplateMeister.php:673)
       I2CE_TemplateMeister->addFile (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:134)
       I2CE_Page->loadHTMLTemplates (/var/lib/iHRIS/lib/4.0.18/ihris-manage/modules/ManagePerson/lib/iHRIS_PageFormPersonManage.php:47)
       iHRIS_PageFormPersonManage->loadHTMLTemplates (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/lib/I2CE_PageForm.php:362)
       I2CE_PageForm->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
DOMDocument::loadHTML() [<a href='domdocument.loadhtml'>domdocument.loadhtml</a>]: End tag : expected '>' in Entity, line: 21
Occured on line 114 of /var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Template.php
[Wed Nov 23 07:45:48 2011] [error] [client 196.43.68.201]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/person
I2CE: I2CE_Error->handleError (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE.php:858)
       I2CE->handleError
       DOMDocument->loadHTML (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Template.php:114)
       I2CE_Template->_loadFile (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_TemplateMeister.php:644)
       I2CE_TemplateMeister->loadFile (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_TemplateMeister.php:673)
       I2CE_TemplateMeister->addFile (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:134)
       I2CE_Page->loadHTMLTemplates (/var/lib/iHRIS/lib/4.0.18/ihris-manage/modules/ManagePerson/lib/iHRIS_PageFormPersonManage.php:47)
       iHRIS_PageFormPersonManage->loadHTMLTemplates (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/lib/I2CE_PageForm.php:362)
       I2CE_PageForm->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
DOMDocument::loadHTML() [<a href='domdocument.loadhtml'>domdocument.loadhtml</a>]: End tag : expected '>' in Entity, line: 21
Occured on line 114 of /var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Template.php
[Wed Nov 23 07:45:51 2011] [error] [client 196.43.68.201]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/person
I2CE: I2CE_Error->handleError (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE.php:858)
       I2CE->handleError
       DOMDocument->loadHTML (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Template.php:114)
       I2CE_Template->_loadFile (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_TemplateMeister.php:644)
       I2CE_TemplateMeister->loadFile (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_TemplateMeister.php:673)
       I2CE_TemplateMeister->addFile (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:134)
       I2CE_Page->loadHTMLTemplates (/var/lib/iHRIS/lib/4.0.18/ihris-manage/modules/ManagePerson/lib/iHRIS_PageFormPersonManage.php:47)
       iHRIS_PageFormPersonManage->loadHTMLTemplates (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/lib/I2CE_PageForm.php:362)
       I2CE_PageForm->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
DOMDocument::loadHTML() [<a href='domdocument.loadhtml'>domdocument.loadhtml</a>]: End tag : expected '>' in Entity, line: 21
Occured on line 114 of /var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Template.php
[Wed Nov 23 07:46:04 2011] [error] [client 196.43.68.201]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/person
I2CE: I2CE_Error->handleError (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE.php:858)
       I2CE->handleError
       DOMDocument->loadHTML (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Template.php:114)
       I2CE_Template->_loadFile (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_TemplateMeister.php:644)
       I2CE_TemplateMeister->loadFile (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_TemplateMeister.php:673)
       I2CE_TemplateMeister->addFile (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:134)
       I2CE_Page->loadHTMLTemplates (/var/lib/iHRIS/lib/4.0.18/ihris-manage/modules/ManagePerson/lib/iHRIS_PageFormPersonManage.php:47)
       iHRIS_PageFormPersonManage->loadHTMLTemplates (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/lib/I2CE_PageForm.php:362)
       I2CE_PageForm->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
DOMDocument::loadHTML() [<a href='domdocument.loadhtml'>domdocument.loadhtml</a>]: End tag : expected '>' in Entity, line: 21
Occured on line 114 of /var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Template.php
[Wed Nov 23 07:46:07 2011] [error] [client 196.43.68.201]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/person
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/ihris-manage/modules/ManagePersonPosition/lib/iHRIS_Module_PersonPosition.php:367)
       iHRIS_Module_PersonPosition->action_person_position
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_person_position (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
Adding person posotion
[Wed Nov 23 07:46:07 2011] [error] [client 196.43.68.201]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/person
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/ihris-manage/modules/ManagePersonPosition/lib/iHRIS_Module_PersonPosition.php:371)
       iHRIS_Module_PersonPosition->action_person_position
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_person_position (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
Adding person posotion failed

Revision history for this message

josephat mathayo (jmathayo) wrote on 2011-11-23:

I wish to use 4.1 if the few issue fixed instead of 4.0.18/4.0.19, because of access privileges to hospital manager, they shoud see only one hospital/facility data.

I tried to reduce the check list of in Report View to see if the report will be generated automatically or because of huge data about 4015 employee. Can this be a point

Revision history for this message

Carl Leitner (litlfred) wrote on 2011-11-23:

Marking as duplicate of https://bugs.launchpad.net/ihris-manage-cssc/+bug/893478
as the error message on failure to create the table is essentially the same

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.