暂无图片
分享
卢春龙
2019-04-30
执行存储过程提示这个错误有影响

[‎2019/‎4/‎30 13:29] 郑稳妥:

无标题

已以用户 hr 的身份执行。 ...unt from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='服务处经理' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='KA渠道及市场专员' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='规划经理(油站)' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='电商推广经理' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='KA推广经理' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='自营区域组长' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='CVS业代' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='内务组长' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='加强组组长' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='特通业代' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='服务处司机' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='KA渠道经理' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='总经理' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='分析专员' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='支持专员' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='特通组长' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='DSR管理专员' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='即饮业务规划主任' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='发展主任' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='渠道经理' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='经理' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='总监' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='KA经理' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='KA业代' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='电商总监' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='管理专员' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='营业部司机' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='规划专员' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='销售培训主任' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='资产规划主任' [SQLSTATE 01000] (消息 0)  select count(id) as id_count from YL_czy_H_N_ORG_Position where H_isUse<>8 and  H_PositionName='内务专员' [SQLSTATE 01000] (消息 0)  select count(id) as id_count ...  该步骤失败。

 


收藏
分享
2条回答
默认
最新
我是DBA

这个错误没有啥影响,但是你这个存储过程执行失败了,需要重新执行,这个报错一般与连接有关系 ,可能需要重新配置客户端的配置。

暂无图片 评论
暂无图片 有用 0
卢春龙
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏