万能报出现ora 00904错误
金蝶云社区-徐思
徐思
0人赞赏了该文章 1,110次浏览 未经作者许可,禁止转载编辑于2015年12月24日 18:07:31

在K3Cloud万能报表设计器做了一张单据类报表,打开就报ora00904 错误,FNAME数据库表里面是有这个字段的,不清楚错误的原因,麻烦大神看一下

[{"operation":"6467972d-1fca-44db-bc91-fffeff252809.LoadData"}]
发生时间: 2015-12-24 05:33:24
错误编号: DoLoadDataSet
错误信息: ORA-00904: "ST05"."FNAME": invalid identifier
Sql语句: SELECT t0.FID FID,
t0.FDESC FDESC,
t0.FMEDICALDATAID FMEDICALDATAID,
st03.FNAME FMEDICALDATAID_FNAME,
t0.FTELEPHONE FTELEPHONE,
t0.FNAME FNAME,
st08.FNAME FNAME_FNAME,
t0.FCREATORID FCREATORID,
st01.FNAME FCREATORID_FNAME,
t0.FCREATEDATE FCREATEDATE,
t0.FPAYMENT FPAYMENT,
st09.FSETNUMBER FPAYMENT_FSETNUMBER,
st09.FSETNAME FPAYMENT_FSETNAME,
t0.FOPNO FOPNO,
t0.FOPDEPT FOPDEPT,
st05.FNUMBER FOPDEPT_FNUMBER,
st05.FNAME FOPDEPT_FDEPTNAME,
t0.FDIAGNOSE FDIAGNOSE,
t0.FAGE FAGE,
t0.FADMWARDNAME FADMWARDNAME,
t0.FADMPURPOSE FADMPURPOSE,
t0.FADMCONDITION FADMCONDITION,
t0.FADMISSIONDATE FADMISSIONDATE,
t0.FBILLNO FBILLNO,
t0.FADMNOTIFICATIONDATE FADMNOTIFICATIONDATE,
t0.FADMROUTE FADMROUTE,
t0.FAPPLICANTDOCTOR FAPPLICANTDOCTOR,
st06.FMasterId FAPPLICANTDOCTOR_FMASTERID,
st06.FSTAFFNUMBER FAPPLICANTDOCTOR_FSTAFFNUMBER,
st06_L.FNAME FAPPLICANTDOCTOR_FNAME,
t0.FAPPLICANTDOCTORID FAPPLICANTDOCTORID,
st04.FNAME FAPPLICANTDOCTORID_FNAME,
t0.FSEX FSEX,
st07.FNUMBER FSEX_FNUMBER,
st07_L.FDATAVALUE FSEX_FDATAVALUE,
t0.FMODIFIERID FMODIFIERID,
st02.FNAME FMODIFIERID_FNAME,
t0.FMODIFYDATE FMODIFYDATE,
t0.FBILLSTATUS FBILLSTATUS,
t0.FIPNO FIPNO FROM KDY_ADM_T_ADMREQUISITION T0 LEFT OUTER JOIN T_SEC_user ST01 ON t0.FCREATORID = st01.FUserID LEFT OUTER JOIN T_SEC_user ST02 ON t0.FMODIFIERID = st02.FUserID LEFT OUTER JOIN KDY_REG_T_OPPATIENTINFO ST03 ON t0.FMEDICALDATAID = st03.FID LEFT OUTER JOIN KDY_REG_T_OPPATIENTINFO ST04 ON t0.FAPPLICANTDOCTORID = st04.FID LEFT OUTER JOIN T_BD_DEPARTMENT ST05 ON t0.FOPDEPT = st05.FDEPTID LEFT OUTER JOIN T_HR_EMPINFO ST06 ON t0.FAPPLICANTDOCTOR = st06.FID LEFT OUTER JOIN T_HR_EMPINFO_L ST06_L ON (t0.FAPPLICANTDOCTOR = st06_L.FID AND st06_L.FLocaleId = 2052) LEFT OUTER JOIN T_BAS_ASSISTANTDATAENTRY ST07 ON t0.FSEX = st07.FEntryId LEFT OUTER JOIN T_BAS_ASSISTANTDATAENTRY_L ST07_L ON (t0.FSEX = st07_L.FEntryId AND st07_L.FLocaleId = 2052) LEFT OUTER JOIN KDY_PAT_T_SIMPLEPATIENT ST08 ON t0.FNAME = st08.FID LEFT OUTER JOIN KDY_MDM_T_SETTLEMENTWAY ST09 ON t0.FPAYMENT = st09.FENTRYID WHERE ((t0.FID IN (108001)) AND (t0.FID IS NOT NULL))
===================================================
调用堆栈:

Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.DoLoadDataSet(IDbCommand command, DataSet dataSet, String[] tableNames)
在 Kingdee.BOS.App.Data.AbstractDatabase.LoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.AbstractDatabase.LoadDataSet(DbCommand command, DataSet dataSet, String tableName, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteDataSet(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteDataSet(Context ctx, String strSQL, List`1 paramList)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteDataSet(Context ctx, String strSQL)
在 Kingdee.BOS.App.Core.Report.DevReportService.Do_Entity(DataSet ds, DataTable parent, Entity entity, MetadataXmlReader reader, BusinessInfo busiInfo, Context ctx, Dictionary`2 dispNameDicts, String bindingPath, Func`3 getNeedFields, List`1 relaPks)
在 Kingdee.BOS.App.Core.Report.DevReportService.GetBillData(Context ctx, String formId, String reportId, Object[] pkArray)

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.Report.IDevReportService.GetBillData(Context ctx, String formId, String reportId, Object[] pkArray)
在 Kingdee.BOS.ServiceHelper.Report.DevReportServiceHelper.GetBillData(Context ctx, String formId, String reportId, Object[] pkArray)
在 Kingdee.BOS.Model.WNReport.WNReportModel.GetDocPreviewConfig(WNDevRptConfigArgs e)
在 Kingdee.BOS.Web.WNReport.WNReportView.GetDocPreviewConfig()
在 Kingdee.BOS.Core.Metadata.WNReport.DevDocPreviewAppearance.GetBindStateCore(IDynamicFormView view)
在 Kingdee.BOS.Web.DynamicForm.DataBinder.BindControlState(ControlAppearance ctl)
在 Kingdee.BOS.Web.DynamicForm.DataBinder.BindControlData(ControlAppearance ctl)
在 Kingdee.BOS.Web.DynamicForm.DataBinder.BindControlsData(List`1 list)
在 Kingdee.BOS.Web.DynamicForm.DataBinder.BindControlData(ControlAppearance ctl)
在 Kingdee.BOS.Web.DynamicForm.DataBinder.BindControlsData(List`1 list)
在 Kingdee.BOS.Web.DynamicForm.DataBinder.UpdateView()
在 Kingdee.BOS.Web.WNReport.WNReportView.GetListData()
在 Kingdee.BOS.Web.WNReport.WNReportView.LoadData()
在 Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.LoadData()