K/3 Cloud 6.1 ora11.2.0.1g
打开报表时，提示：
查询出现异常。ORA-03113: end-of-file on communication channel
Process ID: 6715
Session ID: 234 Serial number: 19371
详细信息如下：
INSERT /*+ APPEND */ INTO TMPC7A21293DD1E11E680B70050568 (FSOFID, FORDERID, FSEQ, FSALEBILLNO, FSOQTY, FSOAMOUNT, FDELIID, FDELIBILLNO, FDELIQTY, FDELIAMOUNT, FOUTID, FOUTBILLNO, FOUTQTY, FOUTAMOUNT, FRETURNPRDID, FRETURNPRDBILLNO, FRETURNPQTY, FRETURNPAMOUNT, FRETURNID, FRETURNBILLNO, FRETURNQTY, FRETURNAMOUNT, FRECEIVEBILLNO, FRECQTY, FRECAMOUNT, FWRITEOFFAMOUNT, FINVOECEBILLNO, FINVOECEQTY, FINVOECEAMOUNT, FRECBILLNO, FRECEIPTAMOUNT, FCHARGEOFFBILLNO, FCHARGEOFFAMOUNT, FNRECEIPTAMOUNT, FRECSUMAMOUNNT, FRECBILLID, FPRECISION, FPRICEDIGITS, FAMOUNTDIGITS) SELECT TSO.FID FSOFID, TSOE.FENTRYID FORDERID, T1.FSEQ, TSO.FBILLNO FSALEBILLNO, CASE WHEN TBSU.FSaleURNum = 0 THEN (T1.FBASEORDERQTY * TBSU.FSaleURNom) ELSE ((T1.FBASEORDERQTY * TBSU.FSaleURNom) / TBSU.FSaleURNum) END FSOQTY, CASE WHEN NVL(T1.FBASEORDERQTY, 0) = 0 THEN NULL ELSE TSOF.FALLAMOUNT END FSOAMOUNT, CASE WHEN TSD.FDOCUMENTSTATUS = 'C' THEN TSDE.FEntryID ELSE 0 END FDELIID, CASE WHEN TSD.FDOCUMENTSTATUS = 'C' THEN TSD.FBILLNO ELSE NULL END FDELIBILLNO, CASE WHEN TBSU.FSaleURNum = 0 THEN (T1.FBASEDENOQTY * TBSU.FSaleURNom) ELSE ((T1.FBASEDENOQTY * TBSU.FSaleURNom) / TBSU.FSaleURNum) END FDELIQTY, CASE WHEN NVL(T1.FBASECAlCQTY, 0) = 0 THEN NULL ELSE ((T1.FBASEDENOQTY * TSOF.FALLAMOUNT) / T1.FBASECAlCQTY) END FDELIAMOUNT, CASE WHEN (TSOS.FDOCUMENTSTATUS = 'C' OR TSOSE.FSTOCKFLAG = 1) THEN TSOSE.FEntryId ELSE 0 END FOUTID, CASE WHEN (TSOS.FDOCUMENTSTATUS = 'C' OR TSOSE.FSTOCKFLAG = 1) THEN TSOS.FBILLNO ELSE NULL END FOUTBILLNO, CASE WHEN TBSU.FSaleURNum = 0 THEN (T1.FBASEOUTQTY * TBSU.FSaleURNom) ELSE ((T1.FBASEOUTQTY * TBSU.FSaleURNom) / TBSU.FSaleURNum) END FOUTQTY, CASE WHEN NVL(T1.FBASECAlCQTY, 0) = 0 THEN NULL ELSE ((T1.FBASEOUTQTY * TSOF.FALLAMOUNT) / T1.FBASECAlCQTY) END FOUTAMOUNT, CASE WHEN TSR.FDOCUMENTSTATUS = 'C' THEN TSRE.FENTRYID ELSE 0 END FRETURNPRDID, CASE WHEN TSR.FDOCUMENTSTATUS = 'C' THEN TSR.FBILLNO ELSE NULL END FRETURNPRDBILLNO, CASE WHEN TBSU.FSaleURNum = 0 THEN (T1.FBASERETQTY * TBSU.FSaleURNom) ELSE ((T1.FBASERETQTY * TBSU.FSaleURNom) / TBSU.FSaleURNum) END FRETURNPQTY, CASE WHEN NVL(T1.FBASECAlCQTY, 0) = 0 THEN NULL ELSE ((T1.FBASERETQTY * TSOF.FALLAMOUNT) / T1.FBASECAlCQTY) END FRETURNAMOUNT, CASE WHEN (TSRS.FDOCUMENTSTATUS = 'C' OR TSRSE.FSTOCKFLAG = 1) THEN TSRSE.FENTRYID ELSE 0 END FRETURNID, CASE WHEN (TSRS.FDOCUMENTSTATUS = 'C' OR TSRSE.FSTOCKFLAG = 1) THEN TSRS.FBILLNO ELSE NULL END FRETURNBILLNO, CASE WHEN TBSU.FSaleURNum = 0 THEN (T1.FBASERETURNQTY * TBSU.FSaleURNom) ELSE ((T1.FBASERETURNQTY * TBSU.FSaleURNom) / TBSU.FSaleURNum) END FRETURNQTY, CASE WHEN NVL(T1.FBASECAlCQTY, 0) = 0 THEN NULL ELSE ((T1.FBASERETURNQTY * TSOF.FALLAMOUNT) / T1.FBASECAlCQTY) END FRETURNAMOUNT, TAR.FBILLNO FRECEIVEBILLNO, CASE WHEN TBSU.FSaleURNum = 0 THEN (T1.FBASERECQTY * TBSU.FSaleURNom) ELSE ((T1.FBASERECQTY * TBSU.FSaleURNom) / TBSU.FSaleURNum) END FRECQTY, CASE WHEN NVL(T1.FBASERECQTY, 0) = 0 THEN NULL ELSE TARS.FALLAMOUNTFOR END FRECAMOUNT, NVL(TB1.FCUROPENAMOUNTFOR, 0) FWRITEOFFAMOUNT, TINO.FINVOCEBILLNO FINVOECEBILLNO, ((((NVL(T1.FBASERECQTY, 0) / DECODE(NVL(TARS.FBASICUNITQTY, 1), 0, 1, NVL(TARS.FBASICUNITQTY, 1))) * NVL(T1.FOPENQTY, 1)) * TBSU.FSaleURNom) / CASE WHEN TBSU.FSaleURNum = 0 THEN 1 ELSE TBSU.FSaleURNum END) FINVOECEQTY, ((NVL(T1.FBASERECQTY, 0) / DECODE(NVL(TARS.FBASICUNITQTY, 1), 0, 1, NVL(TARS.FBASICUNITQTY, 1))) * TARS.FIVALLAMOUNTFOR) FINVOECEAMOUNT, TBNO.FRECBILLNO, ROUND(((NVL(T1.FBASERECQTY, 0) / DECODE(NVL(TARS.FBASICUNITQTY, 1), 0, 1, NVL(TARS.FBASICUNITQTY, 1))) * ((TA.FROWAMOUNTFOR / DECODE(NVL(TA.FALLAMOUNTFOR, 1), 0, 1, NVL(TA.FALLAMOUNTFOR, 1))) * TA.FRECEIVEAMOUNT)), TBCU.FAMOUNTDIGITS) FRECEIPTAMOUNT, TBNO.FCHARGEOFFBILLNO, ROUND(((NVL(T1.FBASERECQTY, 0) / DECODE(NVL(TARS.FBASICUNITQTY, 1), 0, 1, NVL(TARS.FBASICUNITQTY, 1))) * ((TA.FROWAMOUNTFOR / DECODE(NVL(TA.FALLAMOUNTFOR, 1), 0, 1, NVL(TA.FALLAMOUNTFOR, 1))) * TA.FCHARGEOFFAMOUNT)), 6) FCHARGEOFFAMOUNT, NULL FNRECEIPTAMOUNT, TA.FRECEIVEAMOUNT FRECSUMAMOUNNT, TARS.FID FRECBILLID, TBUT.FPRECISION, TBCU.FPRICEDIGITS, TBCU.FAMOUNTDIGITS FROM TMPC7A21285DD1E11E680B70050568 T1 LEFT OUTER JOIN T_SAL_ORDERENTRY TSOE ON T1.FORDERID = TSOE.FENTRYID LEFT OUTER JOIN T_SAL_ORDER TSO ON TSOE.FID = TSO.FID INNER JOIN T_SAL_ORDERENTRY_F TSOF ON T1.FORDERID = TSOF.FENTRYID INNER JOIN T_SAL_ORDERENTRY_D TSRD ON T1.FORDERID = TSRD.FENTRYID LEFT OUTER JOIN T_SAL_DELIVERYNOTICEENTRY TSDE ON T1.FDENOID = TSDE.FENTRYID LEFT OUTER JOIN T_SAL_DELIVERYNOTICE TSD ON TSDE.FID = TSD.FID LEFT OUTER JOIN T_SAL_OUTSTOCKENTRY TSOSE ON T1.FOUTID = TSOSE.FENTRYID LEFT OUTER JOIN T_SAL_OUTSTOCK TSOS ON TSOSE.FID = TSOS.FID LEFT OUTER JOIN T_SAL_RETURNNOTICEENTRY TSRE ON T1.FRETNOID = TSRE.FENTRYID LEFT OUTER JOIN T_SAL_RETURNNOTICE TSR ON TSRE.FID = TSR.FID LEFT OUTER JOIN T_SAL_RETURNSTOCKENTRY TSRSE ON T1.FRETURNID = TSRSE.FENTRYID LEFT OUTER JOIN T_SAL_RETURNSTOCK TSRS ON TSRSE.FID = TSRS.FID LEFT OUTER JOIN T_BD_DEPARTMENT_L TBD ON (TSO.FSALEDEPTID = TBD.FDEPTID AND TBD.FLOCALEID = 2052) LEFT OUTER JOIN T_BD_DEPARTMENT TBDE ON TSO.FSALEDEPTID = TBDE.FDEPTID LEFT OUTER JOIN T_BD_CUSTOMER_L TBC ON (TSO.FCUSTID = TBC.FCUSTID AND TBC.FLOCALEID = 2052) LEFT OUTER JOIN V_BD_SALESMAN_L VBS ON (TSO.FSALERID = VBS.FID AND VBS.FLOCALEID = 2052) LEFT OUTER JOIN V_BD_SALESMAN VBSE ON TSO.FSALERID = VBSE.FID LEFT OUTER JOIN T_BD_MATERIAL_L TBM ON (TBM.FMATERIALID = TSOE.FMATERIALID AND TBM.FLOCALEID = 2052) LEFT OUTER JOIN V_BD_OPERATORGROUP_L VBO ON (TSO.FSALEGROUPID = VBO.FENTRYID AND VBO.FLOCALEID = 2052) LEFT OUTER JOIN T_BD_MATERIAL TBDM ON TSOE.FMATERIALID = TBDM.FMATERIALID LEFT OUTER JOIN T_BD_MATERIALSALE TBSU ON TBSU.FMATERIALID = TSOE.FMATERIALID LEFT OUTER JOIN T_BD_MATERIALBASE TBSE ON TBSE.FMATERIALID = TSOE.FMATERIALID LEFT OUTER JOIN T_BD_MATERIALGROUP_L TGOU ON (TGOU.FID = TBDM.FMATERIALGROUP AND TGOU.FLOCALEID = 2052) LEFT OUTER JOIN t_BD_Unit_L TBU ON (TBU.FUNITID = TBSU.FSALEUNITID AND TBU.FLOCALEID = 2052) LEFT OUTER JOIN T_BD_CUSTOMER TBDC ON TSO.FCUSTID = TBDC.FCUSTID INNER JOIN T_SAL_ORDERFIN TSF ON TSO.FID = TSF.FID LEFT OUTER JOIN T_BD_CURRENCY_L TBCL ON (TSF.FSETTLECURRID = TBCL.FCURRENCYID AND TBCL.FLOCALEID = 2052) LEFT OUTER JOIN T_ORG_ORGANIZATIONS TORG ON TSO.FSALEORGID = TORG.FORGID LEFT OUTER JOIN T_ORG_ORGANIZATIONS_L TORGL ON (TSO.FSALEORGID = TORGL.FORGID AND TORGL.FLOCALEID = 2052) LEFT OUTER JOIN T_BD_CURRENCY TBCU ON TSF.FSETTLECURRID = TBCU.FCURRENCYID LEFT OUTER JOIN T_BD_UNIT TBUT ON TBSU.FSALEUNITID = TBUT.FUNITID LEFT OUTER JOIN T_AR_RECEIVABLEENTRY TARS ON TARS.FENTRYID = T1.FRECID LEFT OUTER JOIN T_AR_BillingMatchLogENTRY TB1 ON ((TB1.FTARGETENTRYID = TARS.FENTRYID AND TB1.FTARGETFROMID = 'AR_receivable') AND TB1.FISADIBILL = '1') LEFT OUTER JOIN T_AR_RECEIVABLE TAR ON (TAR.FID = TARS.FID AND TAR.FDOCUMENTSTATUS = 'C') LEFT OUTER JOIN (SELECT DISTINCT FID, FRECID, FALLAMOUNTFOR, FRECEIVEAMOUNT, FROWAMOUNTFOR, FCHARGEOFFAMOUNT FROM TMPC7A21288DD1E11E680B70050568) TA ON TA.FRECID = T1.FRECID LEFT OUTER JOIN TMPC7A2128CDD1E11E680B70050568 TBNO ON TBNO.FRECID = T1.FRECID LEFT OUTER JOIN TMPC7A2128FDD1E11E680B70050568 TINO ON TINO.FRECID = T1.FRECID
Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteBatchWithTime(Context ctx, List`1 lstSqlObj, Int32 commandTimeout)
在 Kingdee.K3.CRM.OPP.APP.Report.ContractDetailRpt.GetFinalSODetailData()
在 Kingdee.K3.CRM.OPP.APP.Report.ContractDetailRpt.BuilderReportSqlAndTempTable(IRptParams filter, String tableName)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetData(IRptParams filter)
在 Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetReportData(ReportServiceParameter parameter)
在 Kingdee.BOS.App.Core.SysReportService.GetReportData(ReportServiceParameter parameter)
Exception rethrown at [0]:
在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
在 Kingdee.BOS.Contracts.ISysReportService.GetReportData(ReportServiceParameter parameter)
在 Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetReportData(ReportServiceParameter parameter)
在 Kingdee.BOS.Model.Report.SysReportModel.GetData(Int32 start, Int32 rows)
在 Kingdee.BOS.Web.Report.SysReportView.GetListData()
在 Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass4d.