852应收年结失败?

liuqingfeng

852应收年结失败,下面是部分跟踪文件,不知什么原因,谢谢!帐套055
USE UFSystem
go
declare @P1 int
set @P1=180150144
declare @P2 int
set @P2=8
declare @P3 int
set @P3=1
declare @P4 int
set @P4=5
exec sp_cursoropen @P1 output, N'SELECT csub_name ,cstation ,TaskState ,dintime ,csub_id,ctaskid FROM UA_TaskLog WHERE cAppServer like ''{152D3537-34FA-4C19-B719-C0FB6D8CEA9D}%'' ORDER BY cstation,csub_name,TaskState', @P2 output, @P3 output, @P4 output
select @P1, @P2, @P3, @P4
go
exec sp_cursorfetch 180150144, 16, 1, 1
go
exec sp_cursorfetch 180150144, 16, 1, 1
go
exec sp_cursorfetch 180150144, 16, 2, 1
go
exec sp_cursorfetch 180150144, 16, 3, 1
go
exec sp_cursorfetch 180150144, 16, 4, 1
go
exec sp_cursorfetch 180150144, 16, 5, 1
go
exec sp_cursorfetch 180150144, 16, 6, 1
go
USE UFSystem
go
declare @P1 int
set @P1=180150145
declare @P2 int
set @P2=8
declare @P3 int
set @P3=1
declare @P4 int
set @P4=2
exec sp_cursoropen @P1 output, N'SELECT UA_Task.cacc_id AS 账套号,iyear AS 年度,cUser_Id AS 操作员,''[''+UA_Task.cauth_id+'']''+UA_Auth.cauth_name AS 执行功能 FROM UA_Task,UA_Auth WHERE cTaskId=''10484672'' AND UA_Task.cAuth_id=UA_Auth.cAuth_id ORDER BY cAuth_name', @P2 output, @P3 output, @P4 output
select @P1, @P2, @P3, @P4
go
exec sp_cursorfetch 180150145, 16, 1, 1
go
exec sp_cursorfetch 180150145, 16, 1, 1
go
exec sp_cursorfetch 180150145, 16, 2, 1
go
exec sp_cursorfetch 180150145, 16, 3, 1
go
exec sp_cursorclose 180150145
go
exec sp_cursorclose 180150144
go
select bcal from ForeignCurrency where cexch_name='人民币'
go
select fadvdate from venandinv where cvencode='02005' and cinvcode='PG1101003804'
go

stonys

可能是某个字段有特殊字符

33299255

可能是某个字段有特殊字符

gaoruixia

可能是某个字段有特殊字符

销魂

跟踪那么少？都是进系统的东西。你要跟重点。把语句复制到查询语句执行。看是看不出来的。

hanshan

我的应收也无法年桔

kinseybaby

非常非常感谢楼主

zhang_miao

学习了，呵呵，

xgm

应该有单据做的时候出现了特殊符号  把这样的单据修改一下