问题现象: | 年转后2011和2012年度中,人事管理-人员档案及基础档案-人员档案打开后均为空,经查数据表数据未缺失,打最新补丁测试问题仍存在,数据已上传至FTP,名称为“滨海快餐.rar” |
问题原因: | |
解决方案: | 您好, 此问题【经查看数据/测试】现做如下分析与答复: 【问题原因】 跟踪sql语句如下: declare @P1 int set @P1 = 1 declare @P2 int set @P2 = 1 exec hr_sp_GetPageRecords N'hr_v_HR31_show', N'cPsn_Num ASC', N''''' as SelCol,(iRecordID) as iRecordID,(cPsn_Num) as cPsn_Num,(cPsn_Name) as cPsn_Name,(cDept_num) as cDept_num,(cDept_Name) as cDept_Name,(rPersonType) as rPersonType,(rSex) as rSex,(vCardNo) as vCardNo,(reducation) as reducation,(cdutyclass) as cdutyclass,(cDutycode) as cDutycode,(cjobcode) as cjobcode,(dBirthDate) as dBirthDate,(vIDNo) as vIDNo,(cpsnBankCode) as cpsnBankCode,(cpsnAccount) as cpsnAccount,(cDepCode) as cDepCode,(cDepName) as cDepName,(fCreditQuantity) as fCreditQuantity,(iCreDate) as iCreDate,(cCreGrade) as cCreGrade,(dPValidDate) as dPValidDate,(dPInValidDate) as dPInValidDate,(cPsnEmail) as cPsnEmail,(cPsnFAddr) as cPsnFAddr,(cPsnFPhone) as cPsnFPhone,(cPsnInPhone) as cPsnInPhone,(cPsnMobilePhone) as cPsnMobilePhone,(cPsnOPhone) as cPsnOPhone,(cPsnOSeat) as cPsnOSeat,(cPsnPostAddr) as cPsnPostAddr,(cPsnPostCode) as cPsnPostCode,(cPsnProperty) as cPsnProperty,(cPsnQQCode) as cPsnQQCode,(cPsnURL) as cPsnURL,(dJoinworkDate) as dJoinworkDate,(dEnterDate) as dEnterDate,(dEnterUnitDate) as dEnterUnitDate,(dRegularDate) as dRegularDate,(rNativePlace) as rNativePlace,(rPerResidence) as rPerResidence,(rNational) as rNational,(rMarriStatus) as rMarriStatus,(rhealthStatus) as rhealthStatus,(vAliaName) as vAliaName,(vSSNo) as vSSNo,(bProbation) as bProbation,(rCheckInFlag) as rCheckInFlag,(rCountry) as rCountry,(dLeaveDate) as dLeaveDate,(rFigure) as rFigure,(rWorkStatus) as rWorkStatus,(EmploymentForm) as EmploymentForm,(rPersonParameters) as rPersonParameters,bPsnPerson,hrts', N'((1=1)) and (1=1 and ((rPersonType = N''在职人员'') or (rPersonType = N''五险人员'') or (rPersonType = N''三险人员'') or (rPersonType = N''意外保险人员'') or (rPersonType = N''无保险人员'') or (rPersonType = N''三险补助人员'') or (rPersonType = N''五险补助人员'')))', N'cPsn_Num', 1000, @P1 output, @P2 output 执行该存储过程提示“列名 'rPersonParameters' 无效”。 该存储过程使用的视图为hr_v_HR31_show。 执行select rPersonParameters,* from hr_v_HR31_show,发现视图中缺少rPersonParameters列。 【解决方案】 请与年结前备份帐套中的hr_v_HR31_show视图做比较,参照年结前帐套修改该视图。主要分析rPersonParameters列。请先在测试环境验证。 请做好数据备份。 |
相关补丁: | |
版本: | 8.72sp1 |
模块: | 人事信息管理 |
产品: | 人力资源 |
问题名称: | 年转后人员档案显示为空 |
最后更新: | 2012-01-12 23:56:01 |