已配置后台事务、调度计划但是还是无法自动更新银企平台付款返回的状态给EAS银行付款单.
解决方案 执行以下脚本:
1.---删除升级前的参数BE010
delete from t_bas_paramitem where fkeyid in (select fid from t_bas_param where fnumber in ('BE010','BE010'));
delete from t_bas_param where fnumber in ('BE010','BE010');
delete from t_bas_paramvaluerange where fid in ('R8MAAAAAt54bKFGT');
2.---新增850版本的参数BE010
if not exists (select * from T_BAS_Param where fnumber in ('BE010'))
insert into T_BAS_Param (FID , FDEFAULTVAL_L1 , FDEFAULTVAL_L2 , FDEFAULTVAL_L3 , FVALUEALIAS_L1 , FVALUEALIAS_L2 , FVALUEALIAS_L3 , FDESC_L1 , FDESC_L2 , FDESC_L3 , FISUSERDEFINED , FNAME_L1 , FNAME_L2 , FNAME_L3 , FNUMBER , FISGROUPCONTROL , FCANBEMODIFIED , FDEFAULTVAL , FORGTYPE , FCREATORID , FCREATETIME , FLASTUPDATEUSERID , FLASTUPDATETIME , FVALUERANGE , FDATATYPE , FSUBSYSID , FBASETYPE , FUSEREDIT , FUSERCLASS , FVALUEALIAS , FCONTROLUNITID) values( 'R8MAAAAAt52ogfPn' , '0' , '0' , '0' , '0' , '0' , '0' , '0 indicates that the background transaction does not stop regardless of how many scheduling settings exist during one scheduling process. 10 indicates that the background transaction stops for 5s each time 10 scheduling settings are called' , N'0代表一次调度过程中不论调多少个调度设置后台事务都不停,而参数值为10代表后台事务调度了10个调度设置停5秒 ' , N'0代表一次調度過程中不論調多少個調度設置後臺事務都不停,而參數值為10代表後臺事務調度了10個調度設置停5秒 ' , 0 , 'Set the number of schedule items for each scheduling (5s) by the background transaction' , N'设置调度设置后台事务一次调度多少个调度设置停5秒' , N'設置調度設置後臺事務一次調度多少個調度設置停5秒' , 'BE010' , 1 , 0 , null , 1 , '00000000-0000-0000-0000-00000000000013B7DE7F' , {ts'2016-09-12 10:02:57'} , '00000000-0000-0000-0000-00000000000013B7DE7F' , {ts'2016-09-12 10:02:57'} , 'R8MAAAAAt54bKFGT' , 1 , 'com.kingdee.eas.fm.be.be' , null , 0 , null , null , '00000000-0000-0000-0000-000000000000CCE7AED4');
注意:如果执行第二个语句报错,提示值太大,错误提示如下:列 "HNXJEAS"."T_BAS_PARAM"."FDESC_L1" 的值太大 (实际值: 239, 最大值: 200) 可以参照以下语句拓展字段长度。
alter table T_BAS_Param alter FDESC_L1 NVARCHAR(610);
alter table T_BAS_Param alter FDESC_L2 NVARCHAR(610);
alter table T_BAS_Param alter FDESC_L3 NVARCHAR(610);
3.---新增850版本的参数BE010的参数范围
if not exists (select * from T_BAS_ParamValueRange where fid in ('R8MAAAAAt54bKFGT'))
insert into T_BAS_ParamValueRange (FID , FEXCLUSVALUE_L1 , FEXCLUSVALUE_L2 , FEXCLUSVALUE_L3 , FVALUEENUM_L1 , FVALUEENUM_L2 , FVALUEENUM_L3 , FMAXVALUE , FMINVALUE , FVALUEENUM , FEXCLUSVALUE ) values( 'R8MAAAAAt54bKFGT' , null , null , null , null , null , null , null , '0' , null , null );
推荐阅读