u6 3.1打开银行代发时无反应

监守自盗

原先正常,点击银行报盘文件,是否过滤实发合计不大于0的,选择是.
曾经有一次是否过滤实发合计不大于0的,偶选择了否.就出问题了.
以后就是再打开无论选择是还是否都不出界面.再双击银行代发也没有反应,重新推出工资再进入才可以让选择银行报盘文件等.但是还是打不开.
修复安装无效. 也有可能是環境問題，但是最好別讓我重新安裝軟件。凴直覺這個問題應該不用重裝軟件。
我跟踪一下没有看出什么问题,请高手帮忙看看,谢谢啦!
以下是跟踪结果，紅色區域有個2809錯誤，應該是未找到存儲過程的提示，可是WA_GZtblSet不是一個存儲過程，而是一張表，為何有這個語句呢？
USE UFSystem
go
declare @P1 int
set @P1=NULL
declare @P2 int
set @P2=557064
declare @P3 int
set @P3=98305
declare @P4 int
set @P4=NULL
exec sp_cursoropen @P1 output, N'SELECT cSub_id,cAuth_Name FROM UA_Auth WHERE cAuth_Id=''WA0305''', @P2 output, @P3 output, @P4 output
select @P1, @P2, @P3, @P4
go
exec sp_cursorfetch 180150001, 16, 1, 1
go
exec sp_cursorclose 180150001
go
USE UFSystem
go
declare @P1 int
set @P1=NULL
declare @P2 int
set @P2=557064
declare @P3 int
set @P3=98305
declare @P4 int
set @P4=NULL
exec sp_cursoropen @P1 output, N'SELECT cSub_id,cAuth_Name FROM UA_Auth WHERE cAuth_Id=''WA0305''', @P2 output, @P3 output, @P4 output
select @P1, @P2, @P3, @P4
go
exec sp_cursorfetch 180150002, 16, 1, 1
go
exec sp_cursorclose 180150002
go
SELECT DISTINCT iauthtype FROM UA_control WHERE cauth_id='WA0305' order by iauthtype asc
go
set implicit_transactions on
go
SELECT  * FROM UA_version  WITH (updlock)
go
SELECT TOP 1 cstation,csub_id,UA_task.cauth_id as cauth_id FROM UA_task,UA_Control WHERE cacc_id='991' AND (iAuthType =1 or iAuthType=2) AND UA_task.cauth_id=UA_Control.cauth_id AND UA_task.cauth_id<>'reg'
go
SELECT crepellent as ctask FROM UA_control WHERE cauth_id='WA0305' AND (iauthtype<1 OR iauthtype IS NULL)UNION SELECT cauth_id as ctask FROM UA_control WHERE crepellent='WA0305' AND (iauthtype=0 OR iauthtype IS NULL)
go
SELECT TOP 1 cstation,csub_id,cauth_id FROM UA_task WHERE cacc_id='991' AND iyear=2007 AND cauth_id IN ('WA0105','WA0301','WA0302','WA0305')
go
SELECT DISTINCT cauth_id FROM UA_control WHERE cRepellentModule='WA' AND iauthtype=4
go
SELECT TOP 1 cstation,csub_id,cauth_id FROM UA_task WHERE cacc_id='991' AND iyear=2007 AND cauth_id IN ('AS026','GF010802','GF1512','GL010802','GL1512')
go
SELECT distinct csub_id FROM UA_task WHERE cacc_id='991' AND iyear=2007 AND cauth_id<>'reg'
go
select  isnull(cNotRepellent,'') from UA_control where cauth_id='WA0305' and  iauthtype=3
go
SELECT distinct cstation,csub_id, ua_Task.cauth_id,ua_task.cacc_id,ua_task.iyear FROM ua_Task,UA_control WHERE ua_Task.cauth_id=UA_control.cauth_id and cSub_id='WA' and iauthtype=3
go
SELECT DISTINCT ctaskid FROM UA_tasklog WHERE ctaskid='3408630'
go
SELECT DISTINCT iLogId FROM UA_task WHERE iLogId=2035035153.31226
go
INSERT INTO UA_task (cAcc_Id,iYear,cUser_Id,cAuth_Id,cStation,cTaskId,iLogId,cSub_id,cAppServer) VALUES('991',2007,'xushan','WA0305','REDFLY','3408630',2035035153.31226,'WA','{5DF9E57C-13F4-4DC6-9959-4C707583B071}REDFLY@0')
go
INSERT INTO UA_log VALUES('991','WA','xushan','WA0305','REDFLY','2008-07-24 09:10:27',NULL,2035035153.31226,'2007',0)
go
IF @@TRANCOUNT > 0 COMMIT TRAN
go
SELECT * FROM WA_Bank_Set WHERE cGZGradeNum ='001'and i_id in (SELECT WA_Bank.i_id From WA_Bank WHERE (WA_Bank.bBankUse=1 and cGZGradeNum ='001'))
go
exec WA_GZtblSet
go
exec WA_GZtblSet
goselect * from WA_GZtblSet
go
SELECT WA_GZData.*FROM WA_GZData INNER JOIN WA_psn ON (WA_GZData.cPsn_Num = WA_psn.cPsn_Num) AND (WA_GZData.cPsn_Name = WA_psn.cPsn_Name) AND (WA_GZData.cGZGradeNum = WA_psn.cGZGradeNum) WHERE (WA_GZData.cGZGradeNum='001') and wa_gzdata.Btfbz<>1 and wa_gzdata.bdcbz<>1 AND (WA_GZData.iMonth=11) and WA_psn.i_id=1 ORDER BY WA_GZData.cPsn_Num
go
SELECT WA_psn.*,Department.cdepname FROM WA_GZData INNER JOIN WA_psn ON (WA_GZData.cPsn_Num = WA_psn.cPsn_Num) AND (WA_GZData.cPsn_Name = WA_psn.cPsn_Name) AND (WA_GZData.cGZGradeNum = WA_psn.cGZGradeNum)  left join Department on (WA_GZData.cDept_Num = Department.cDepcode) WHERE (WA_GZData.cGZGradeNum='001') and wa_gzdata.Btfbz<>1 and wa_gzdata.bdcbz<>1 AND (WA_GZData.iMonth=11) and WA_psn.i_id=1 ORDER BY WA_GZData.cPsn_Num
go
select * from printex where csystemname='WA' and ntablenum=12
go
SELECT * FROM WA_Bankname WHERE  i_id in (SELECT WA_Bank.i_id From WA_Bank WHERE (((WA_Bank.bBankUse)=1)) and cGZGradeNum ='001')
go
SELECT * FROM WA_BankPar WHERE cGZGradeNum ='001' and i_id in (SELECT WA_Bank.i_id From WA_Bank WHERE (cGZGradeNum ='001' and (WA_Bank.bBankUse=1)))
go
SELECT * From WA_Bank WHERE  cGZGradeNum ='001'
go

xmcsm

你们总发薪人数有多少? 过滤掉0和不过滤分别是多少?
建议你用更新工具找一下相关补丁,我觉得是产品本身的问题

监守自盗

其实是个环境问题,后来重新启动电脑n次后就好了.难以解释 ,谢谢 拉!

监守自盗

金币送你吧

yifeng651

哈哈哈哈, 原来楼主是来送金币的, 早说嘛

唐山合众

应该是后台出问题了吧，清一下TASK表试试