maximo7.5增加视图问题

lemon7856

视图增加成功，然后在前台页面添加对话框想要实现视图数据的汇总查看，后台程序报错，错误信息如下：28 三月 2012 20:02:32:812 [INFO] [MXServer] [] BMXAA6719I - USER = (MAXADMIN) SPID = (67) app (null) object (JDTEST3) : select * from jdtest3 where jdprojectnum= 'OP-FW-070326026'
28 三月 2012 20:02:32:813 [ERROR] [MXServer] [] BMXAA6712E - The MBO record could not be fetched from the database in the mboset. The mboset has been closed. Check the log files in the home directory to determine the source and cause of the error.
28 三月 2012 20:02:32:813 [ERROR] [MXServer] [] BMXAA6713E - The MBO fetch operation failed in the mboset with the SQL error code 17006. The record could not be retrieved from the database. See the log file for more details about the error.
java.sql.SQLException: 列名无效
at Oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at Oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at Oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at Oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at Oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at Oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at Oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3378)
at Oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:2009)
at Oracle.jdbc.driver.OracleResultSet.getObject(OracleResultSet.java:458)
at psdi.mbo.MboSet.getNextRecordData(MboSet.java:3160)
at psdi.mbo.MboSet.fetchMbosActual(MboSet.java:2636)
at psdi.mbo.MboSet.fetchMbos(MboSet.java:2602)
at psdi.mbo.MboSet.getMbo(MboSet.java:1887)
at psdi.mbo.MboSet.getMboData(MboSet.java:894)
at psdi.mbo.MboSet.getMboSetData(MboSet.java:785)
at psdi.webclient.system.beans.DataBean.getMboSetData(DataBean.java:4419)
at psdi.webclient.system.beans.DataBean.fetchTableData(DataBean.java:4337)
at psdi.webclient.system.beans.DataBean.fetchTableData(DataBean.java:4327)
at psdi.webclient.system.beans.DataBean.getTableStateFlags(DataBean.java:6076)
at psdi.webclient.controls.Table.render(Table.java:902)
at psdi.webclient.system.controller.ControlInstance.renderChildren(ControlInstance.java:1032)
at psdi.webclient.system.controller.ComponentInstance.renderChildrenControls(ComponentInstance.java:597)
at jsp_servlet._webclient._components.__children._jspService(__children.java:535)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at jsp_servlet._webclient._components.__section._jspService(__section.java:621)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at jsp_servlet._webclient._components.__sectionouter._jspService(__sectionouter.java:892)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at psdi.webclient.system.controller.ControlInstance.render(ControlInstance.java:793)
at psdi.webclient.system.controller.DatasrcInstance.render(DatasrcInstance.java:218)
at psdi.webclient.controls.Section.render(Section.java:153)
at psdi.webclient.controls.Dialog.renderDialogBody(Dialog.java:321)
at jsp_servlet._webclient._components.__dialogsection._jspService(__dialogsection.java:761)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at psdi.webclient.system.controller.ComponentInstance.renderChildComponents(ComponentInstance.java:618)
at jsp_servlet._webclient._components.__dialogback._jspService(__dialogback.java:457)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at jsp_servlet._webclient._components.__dialog._jspService(__dialog.java:888)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at psdi.webclient.system.controller.ControlInstance.render(ControlInstance.java:793)
at psdi.webclient.system.controller.DatasrcInstance.render(DatasrcInstance.java:218)
at psdi.webclient.system.controller.PageInstance.render(PageInstance.java:134)
at psdi.webclient.controls.Dialog.render(Dialog.java:515)
at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at psdi.webclient.system.controller.BaseInstance.handleEvent(BaseInstance.java:400)
at psdi.webclient.system.controller.BaseInstance.handleEvent(BaseInstance.java:394)
at psdi.webclient.system.controller.ControlInstance.handleEvent(ControlInstance.java:902)
at psdi.webclient.system.session.WebClientSession.handleEvent(WebClientSession.java:1361)
at psdi.webclient.components.PageComponent.renderDialogs(PageComponent.java:111)
at jsp_servlet._webclient._components.__page._jspService(__page.java:3182)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at psdi.webclient.system.controller.ControlInstance.render(ControlInstance.java:793)
at psdi.webclient.system.controller.DatasrcInstance.render(DatasrcInstance.java:218)
at psdi.webclient.system.controller.PageInstance.render(PageInstance.java:134)
at psdi.webclient.system.controller.AppInstance.render(AppInstance.java:1358)
at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at psdi.webclient.system.controller.BaseInstance.handleEvent(BaseInstance.java:400)
at psdi.webclient.system.controller.BaseInstance.handleEvent(BaseInstance.java:394)
at psdi.webclient.system.controller.ControlInstance.handleEvent(ControlInstance.java:902)
at psdi.webclient.system.session.WebClientSession.handleEvent(WebClientSession.java:1361)
at psdi.webclient.system.session.WebClientSession.processRender(WebClientSession.java:5432)
at jsp_servlet._webclient._common.__response._jspService(__response.java:114)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.session.WebClientSession.handleRequest(WebClientSession.java:961)
at psdi.webclient.system.session.AsyncRequestManager.handleRequest(AsyncRequestManager.java:152)
at psdi.webclient.system.session.AsyncRequestManager.manageRequest(AsyncRequestManager.java:110)
at psdi.webclient.system.controller.RequestManager.manageRequest(RequestManager.java:166)
at psdi.webclient.servlet.WebClientServlet.handleRequest(WebClientServlet.java:97)
at psdi.webclient.servlet.WebClientServlet.doPost(WebClientServlet.java:46)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at psdi.webclient.system.filter.HttpCrossSiteScriptingSecurity.doFilter(HttpCrossSiteScriptingSecurity.java:66)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at psdi.webclient.system.filter.MXCorrelationFilter.doFilter(MXCorrelationFilter.java:117)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at psdi.webclient.system.filter.PerformanceMonitor.doFilter(PerformanceMonitor.java:117)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3684)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
psdi.util.MXSystemException: BMXAA4210E - Database error number {0} has occurred. Invalid SQL queries are logged in the log file. Check the SQL query to identify the error.
BMXAA4210E - Database error number 17006 has occurred. Invalid SQL queries are logged in the log file. Check the SQL query to identify the error.
at psdi.webclient.system.beans.DataBean.getMboSetData(DataBean.java:4430)
at psdi.webclient.system.beans.DataBean.fetchTableData(DataBean.java:4337)
at psdi.webclient.system.beans.DataBean.fetchTableData(DataBean.java:4327)
at psdi.webclient.system.beans.DataBean.getTableStateFlags(DataBean.java:6076)
at psdi.webclient.controls.Table.render(Table.java:902)
at psdi.webclient.system.controller.ControlInstance.renderChildren(ControlInstance.java:1032)
at psdi.webclient.system.controller.ComponentInstance.renderChildrenControls(ComponentInstance.java:597)
at jsp_servlet._webclient._components.__children._jspService(__children.java:535)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at jsp_servlet._webclient._components.__section._jspService(__section.java:621)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at jsp_servlet._webclient._components.__sectionouter._jspService(__sectionouter.java:892)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at psdi.webclient.system.controller.ControlInstance.render(ControlInstance.java:793)
at psdi.webclient.system.controller.DatasrcInstance.render(DatasrcInstance.java:218)
at psdi.webclient.controls.Section.render(Section.java:153)
at psdi.webclient.controls.Dialog.renderDialogBody(Dialog.java:321)
at jsp_servlet._webclient._components.__dialogsection._jspService(__dialogsection.java:761)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at psdi.webclient.system.controller.ComponentInstance.renderChildComponents(ComponentInstance.java:618)
at jsp_servlet._webclient._components.__dialogback._jspService(__dialogback.java:457)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at jsp_servlet._webclient._components.__dialog._jspService(__dialog.java:888)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at psdi.webclient.system.controller.ControlInstance.render(ControlInstance.java:793)
at psdi.webclient.system.controller.DatasrcInstance.render(DatasrcInstance.java:218)
at psdi.webclient.system.controller.PageInstance.render(PageInstance.java:134)
at psdi.webclient.controls.Dialog.render(Dialog.java:515)
at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at psdi.webclient.system.controller.BaseInstance.handleEvent(BaseInstance.java:400)
at psdi.webclient.system.controller.BaseInstance.handleEvent(BaseInstance.java:394)
at psdi.webclient.system.controller.ControlInstance.handleEvent(ControlInstance.java:902)
at psdi.webclient.system.session.WebClientSession.handleEvent(WebClientSession.java:1361)
at psdi.webclient.components.PageComponent.renderDialogs(PageComponent.java:111)
at jsp_servlet._webclient._components.__page._jspService(__page.java:3182)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.controller.ComponentInstance.render(ComponentInstance.java:529)
at psdi.webclient.system.controller.ControlInstance.render(ControlInstance.java:793)
at psdi.webclient.system.controller.DatasrcInstance.render(DatasrcInstance.java:218)
at psdi.webclient.system.controller.PageInstance.render(PageInstance.java:134)
at psdi.webclient.system.controller.AppInstance.render(AppInstance.java:1358)
at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at psdi.webclient.system.controller.BaseInstance.handleEvent(BaseInstance.java:400)
at psdi.webclient.system.controller.BaseInstance.handleEvent(BaseInstance.java:394)
at psdi.webclient.system.controller.ControlInstance.handleEvent(ControlInstance.java:902)
at psdi.webclient.system.session.WebClientSession.handleEvent(WebClientSession.java:1361)
at psdi.webclient.system.session.WebClientSession.processRender(WebClientSession.java:5432)
at jsp_servlet._webclient._common.__response._jspService(__response.java:114)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
at psdi.webclient.system.session.WebClientSession.handleRequest(WebClientSession.java:961)
at psdi.webclient.system.session.AsyncRequestManager.handleRequest(AsyncRequestManager.java:152)
at psdi.webclient.system.session.AsyncRequestManager.manageRequest(AsyncRequestManager.java:110)
at psdi.webclient.system.controller.RequestManager.manageRequest(RequestManager.java:166)
at psdi.webclient.servlet.WebClientServlet.handleRequest(WebClientServlet.java:97)
at psdi.webclient.servlet.WebClientServlet.doPost(WebClientServlet.java:46)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at psdi.webclient.system.filter.HttpCrossSiteScriptingSecurity.doFilter(HttpCrossSiteScriptingSecurity.java:66)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at psdi.webclient.system.filter.MXCorrelationFilter.doFilter(MXCorrelationFilter.java:117)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at psdi.webclient.system.filter.PerformanceMonitor.doFilter(PerformanceMonitor.java:117)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3684)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: psdi.util.MXSystemException: BMXAA4210E - Database error number 17006 has occurred. Invalid SQL queries are logged in the log file. Check the SQL query to identify the error.
at psdi.mbo.MboSet.fetchMbosActual(MboSet.java:2783)
at psdi.mbo.MboSet.fetchMbos(MboSet.java:2602)
at psdi.mbo.MboSet.getMbo(MboSet.java:1887)
at psdi.mbo.MboSet.getMboData(MboSet.java:894)
at psdi.mbo.MboSet.getMboSetData(MboSet.java:785)
at psdi.webclient.system.beans.DataBean.getMboSetData(DataBean.java:4419)
... 134 more
数据库配置的视图信息如下：
服务：CUSTAPP
描述：定制应用程序服务
实体：JDTEST3
类：psdi.mbo.custapp.CustomMboSet
扩展对象：JDWORKHOURS
级别：SYSTEM
查看 Where： 1 = 1 group by personid,jdprojectnum
查看 Select：sum(jdworkhours) as jdworkhours,sum(jdcost) as jdcost,personid as personid,jdprojectnum as jdprojectnum
查看 From：JDWORKHOURS
属性：jdworkhours，jdcost，personid，jdprojectnum

请大哥帮个忙，帮解决下，谢谢。

zyxvic1981

我遇到的问题跟你一样啊 ，我的 视图还是 wpmaterial  ,你的是怎么解决的 啊 ？头大哦。

maximo23

{:soso_e127:}

leishengfeng

这个报错，有那么点长

zyxvic1981

我遇到的还是升级上来 工单计划中填写物料 ，能保存到数据库，但是前台不显示。后来发现 WPMATERIAL.LDKEY  字段多了，也是一个一个对比出来的 。删除掉之后，问题解决