打开存货档案或新增/打开科目报错为“8156数据库错误，请重试！多次为'T'指定了列'inventorydto_code'或‘accountdto_tode'”的说明

[重要通告]如您遇疑难杂症,本站支持知识付费业务,扫右边二维码加博主微信,可节省您宝贵时间哦!

这文章存了有几天了，群里大佬说他的用友畅捷通T+客户打开存货档案一些文件的时候，出现“8156数据库错误请重试！多次为'T'指定了列'inventorydto_code'”，如下图所示

打开存货档案或新增/打开科目报错为“8156数据库错误，请重试！多次为'T'指定了列'inventorydto_code'或‘accountdto_tode'”的说明

其实这就是有些东西被重复了，删除一些重复的东西即可，此刻为“新增/打开科目报错：8156数据库错误，请重试！多次为'T'指定了列‘accountdto_tode'”作为教程来处理

问题原因是，用户的栏目方案有问题；

解决方案就是“删除重复的用户栏目”即可

执行前先备份账套，执行后重启服务

---删除重复的用户栏目方案

DELETE FROM Eap_ColumnSet_User

WHERE id IN (SELECT r.eid

FROM (SELECT Row_number()

OVER(

PARTITION BY eSolutionID, eUserId, eField, eIdSearchPlan

ORDER BY eSolutionID, eUserId, eField, eIdSearchPlan) AS rankid,

*

FROM (SELECT e.SolutionID AS eSolutionID,

e.UserId AS eUserId,

e.Field AS efield,

e.IdSearchPlan AS eIdSearchPlan,

id AS eid

FROM Eap_ColumnSet_User e

INNER JOIN (SELECT *

FROM (SELECT SolutionID,

UserId,

Field,

IdSearchPlan,

Count(*) AS y

FROM Eap_ColumnSet_User

GROUP BY SolutionID,

UserId,

Field,

IdSearchPlan)a

WHERE a.y > 1)b

ON b.SolutionID = e.SolutionID

AND b.UserId = e.UserId

AND b.Field = e.Field

AND b.IdSearchPlan = e.IdSearchPlan)h)r

WHERE r.rankid > 1)

---删除重复栏目方案

DELETE FROM eap_ColumnSetSolution_User

WHERE id IN (SELECT r.eid

FROM (SELECT Row_number()

OVER(

PARTITION BY eSolutionID, eUserId, eIdSearchPlan

ORDER BY eSolutionID, eUserId, eIdSearchPlan) AS rankid,

*

FROM (SELECT e.SolutionID AS eSolutionID,

e.UserId AS eUserId,

e.IdSearchPlan AS eIdSearchPlan,

id AS eid

FROM eap_ColumnSetSolution_User e

INNER JOIN (SELECT *

FROM (SELECT SolutionID,

UserId,

IdSearchPlan,

Count(*) AS y

FROM eap_ColumnSetSolution_User

GROUP BY SolutionID,

UserId,

IdSearchPlan)a

WHERE a.y > 1)b

ON b.SolutionID = e.SolutionID

AND b.UserId = e.UserId

AND b.IdSearchPlan = e.IdSearchPlan)h)r

WHERE r.rankid > 1)

根据以上操作就可以解决问题，出现啥问题可以比葫芦画瓢来解决即可！

文章来源官方：chanjetvip.com/doc/cate-68/doc-36745.html

问题未解决？付费解决问题加Q或微信 2589053300 (即Q号又微信号)右上方扫一扫可加博主微信

所写所说，是心之所感，思之所悟，行之所得；文当无敷衍，落笔求简洁。 以所舍，求所获；有所依，方所成！