升级报错：错误信息：SQL 脚本: 16.000.000.0055 DATA_DPRD_PU_DTO_NL-33401 出错：子查询返回的值不止一个。

【问题现象】

升级报错：错误信息：SQL 脚本: 16.000.000.0055 DATA_DPRD_PU_DTO_NL-33401 出错：子查询返回的值不止一个。当子查询跟随在 =、!=、<、<=、>、>= 之后，或子查询用作表达式时，这种情况是不允许的。

【问题原因】

老版本的bug会导致查询方案产生垃圾数据，执行以下脚本可以删除垃圾数据

【解决方案】

切记备份好账套数据，再执行以下脚本去删除重复的多方案，执行脚本后再前往升级

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,

                         id AS eid,

 e.IdSearchPlan AS eIdSearchPlan

                  FROM Eap_ColumnSet_User e

                      INNER JOIN

                       (

                           SELECT *

                           FROM

                           (

                               SELECT SolutionID,

                                      UserId,

                                      Field,

  IdSearchPlan,

                                      COUNT(*) AS y

                               FROM Eap_ColumnSet_User

   WHERE SolutionID<>0

                               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

 AND b.SolutionID<>0

              ) h

          ) r

          WHERE r.rankid > 1

      ) AND SolutionID<>0