原文：
Module RXCCGLCG generates ERR REP-1401: 'cf_descriptionformula': Fatal PL/SQL error occurred. ORA-01427: single-row subquery returns more than one row
Applies to:
Oracle Clinical - Version: 4.0.3 and later [Release: 4 and later ]
Information in this document applies to any platform.
Symptoms
Given a copy group of a GLIB domain, include in the copy group an active validation procedure with at least two versions and submit the module RXCCGLCG (Glib -> Glib Reports -> Copy Groups).
The job will fail with the following error:
"ERR REP-1401: 'cf_descriptionformula': Fatal PL/SQL error occurred. ORA-01427: single-row subquery returns more than one row"
This issue was reported on all versions from pre 4.0 up to 4.6
Cause
See Bug 956965 - COPY GROUP REPORT FAILS IF CG CONTAINS A PROCEDURE WITH MULTIPLE VERSIONS
Solution
Review and implement solution (if available) described in Bug 956965 - COPY GROUP REPORT FAILS IF CG CONTAINS A PROCEDURE WITH MULTIPLE VERSIONS
References
BUG:956965 - COPY GROUP REPORT FAILS IF CG CONTAINS A PROCEDURE WITH MULTIPLE VERSIONS
译文：
模块RXCCGLCG发生 REP-1401错误：’cf_descriptionformula’: Fatal PL/SQL error occurred。
ORA-01427：single-row subquery returns more than one row.
文档中的信息适用于任何平台
症状
赋予一个复制组一个GLIB域，包括拥有至少两个版本和提交RXCCGLCG模块（Glib -> Glib reports -> copy Groups）的一个有效批准程序。
失败后，出现以下的错误：
"ERR REP-1401: 'cf_descriptionformula': Fatal PL/SQL error occurred. ORA-01427: single-row subquery returns more than one row"
这个错误发生在4.0到4.6的所有版本
失败原因：
参考Bug 956965 – 如果CG包含的程序中有多个版本，导致复制报告组失败。
解决方法：
如果可行，回顾并且执行Bug 956965中的解决方案。
当前位置：
论坛首页 »
自由讨论区 »
Hadoop，ERP及大数据讨论区
»
发起投票
技术讨论
加好友
发消息
2011-8-18 11:33:26 |
赞(
操作
