Open GoogleCodeExporter opened 9 years ago
And i'm not sure whether to start new issue:
3. In case of javax.el.ElException error in response phase the Exception is
completely hidden from the app - i mean that ExceptionHandler is not even
invoked to handle this.
Below the example - it is simple SQLException while rendering p:dataTable
INFO: 2012-12-31 01:25:17,371 [0:0:0:0:0:0:0:1@mj-krotov] INFO
(org.springframework.jdbc.support.SQLErrorCodesFactory:126) -
SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle,
PostgreSQL, Sybase]
INFO: 2012-12-31 01:25:17,381 [0:0:0:0:0:0:0:1@mj-krotov] DEBUG
(ru.evosystems.aurix.surfbird.util.cache.DataSourceCredentialsThreadCache:21) -
counter: 1
WARNING: EJB5184:A system exception occurred during an invocation on EJB
PropertyServiceEJB, method: public java.util.List
ru.evosystems.aurix.surfbird.service.impl.PropertyServiceImpl.getManagedObjectPr
opertyTypes(java.lang.Long)
WARNING: javax.ejb.EJBException
at com.sun.ejb.containers.BaseContainer.processSystemException(BaseContainer.java:5215)
at com.sun.ejb.containers.BaseContainer.checkExceptionNoTx(BaseContainer.java:5044)
at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:4935)
at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:2045)
at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1994)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:222)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:88)
at $Proxy174.getManagedObjectPropertyTypes(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.ejb.access.LocalSlsbInvokerInterceptor.invokeInContext(LocalSlsbInvokerInterceptor.java:71)
at org.springframework.ejb.access.AbstractSlsbInvokerInterceptor.invoke(AbstractSlsbInvokerInterceptor.java:189)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy190.getManagedObjectPropertyTypes(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at ru.evosystems.aurix.surfbird.service.EJBProxy.invoke(EJBProxy.java:92)
at $Proxy184.getManagedObjectPropertyTypes(Unknown Source)
at ru.evosystems.aurix.surfbird.web.beans.managedobjects.PropertyBean.initPropertyTypeList(PropertyBean.java:77)
at ru.evosystems.aurix.surfbird.web.beans.managedobjects.PropertyBean.getPropertyTypeList(PropertyBean.java:99)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at javax.el.BeanELResolver.getValue(BeanELResolver.java:363)
at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
at com.sun.el.parser.AstValue.getValue(AstValue.java:138)
at com.sun.el.parser.AstValue.getValue(AstValue.java:183)
at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:224)
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:182)
at javax.faces.component.UIData.getValue(UIData.java:731)
at org.primefaces.component.datatable.DataTable.getValue(DataTable.java:729)
at org.primefaces.component.api.UIData.getDataModel(UIData.java:575)
at javax.faces.component.UIData.getRowCount(UIData.java:356)
at org.primefaces.component.datatable.DataTableRenderer.encodeTbody(DataTableRenderer.java:579)
at org.primefaces.component.datatable.DataTableRenderer.encodeRegularTable(DataTableRenderer.java:220)
at org.primefaces.component.datatable.DataTableRenderer.encodeMarkup(DataTableRenderer.java:192)
at org.primefaces.component.datatable.DataTableRenderer.encodeEnd(DataTableRenderer.java:74)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1764)
at javax.faces.render.Renderer.encodeChildren(Renderer.java:168)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:845)
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:55)
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:43)
at org.primefaces.component.panel.PanelRenderer.encodeContent(PanelRenderer.java:198)
at org.primefaces.component.panel.PanelRenderer.encodeMarkup(PanelRenderer.java:115)
at org.primefaces.component.panel.PanelRenderer.encodeEnd(PanelRenderer.java:55)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1764)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1760)
at org.primefaces.component.panelgrid.PanelGridRenderer.encodeRow(PanelGridRenderer.java:137)
at org.primefaces.component.panelgrid.PanelGridRenderer.encodeStaticBody(PanelGridRenderer.java:107)
at org.primefaces.component.panelgrid.PanelGridRenderer.encodeBody(PanelGridRenderer.java:63)
at org.primefaces.component.panelgrid.PanelGridRenderer.encodeEnd(PanelGridRenderer.java:49)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1764)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1760)
at org.primefaces.component.tabview.TabViewRenderer.encodeEnd(TabViewRenderer.java:56)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1764)
at com.sun.faces.context.PartialViewContextImpl$PhaseAwareVisitCallback.visit(PartialViewContextImpl.java:518)
at com.sun.faces.component.visit.PartialVisitContext.invokeVisitCallback(PartialVisitContext.java:183)
at org.primefaces.component.tabview.TabView.visitTree(TabView.java:391)
at javax.faces.component.UIComponent.visitTree(UIComponent.java:1601)
at javax.faces.component.UIComponent.visitTree(UIComponent.java:1601)
at javax.faces.component.UIComponent.visitTree(UIComponent.java:1601)
at javax.faces.component.UIComponent.visitTree(UIComponent.java:1601)
at javax.faces.component.UIComponent.visitTree(UIComponent.java:1601)
at javax.faces.component.UIComponent.visitTree(UIComponent.java:1601)
at javax.faces.component.UIComponent.visitTree(UIComponent.java:1601)
at javax.faces.component.UIComponent.visitTree(UIComponent.java:1601)
at com.sun.faces.context.PartialViewContextImpl.processComponents(PartialViewContextImpl.java:376)
at com.sun.faces.context.PartialViewContextImpl.processPartial(PartialViewContextImpl.java:297)
at javax.faces.context.PartialViewContextWrapper.processPartial(PartialViewContextWrapper.java:183)
at javax.faces.context.PartialViewContextWrapper.processPartial(PartialViewContextWrapper.java:183)
at javax.faces.component.UIViewRoot.encodeChildren(UIViewRoot.java:981)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1757)
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:391)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:131)
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:288)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)
at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1542)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
at org.omnifaces.filter.FacesExceptionFilter.doFilter(FacesExceptionFilter.java:56)
at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
at ru.evosystems.aurix.surfbird.web.filters.ThreadCacheFilter.doFilter(ThreadCacheFilter.java:34)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:64)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:125)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
at ru.evosystems.aurix.surfbird.web.filters.AppGatewayFilter.doFilter(AppGatewayFilter.java:63)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:328)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231)
at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)
at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)
at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:849)
at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:746)
at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1045)
at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:228)
at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
at java.lang.Thread.run(Thread.java:722)
Caused by: org.springframework.dao.PermissionDeniedDataAccessException:
PreparedStatementCallback; SQL [ SELECT PropertyType.PropertyTypeId
PropertyType_ID, PropertyType.PropertyTypeName PropertyType_Name,
PropertyType.PropertyTypeProgramCode PropertyType_Code FROM
ManageObjectPropertyTypes PropertyType WHERE ManageObject = ?];
Запрещено разрешение "SELECT" на объект
"ManageObjectPropertyTypes" базы данных "AuStoreDBN1", схемы
"dbo".; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException:
Запрещено разрешение "SELECT" на объект
"ManageObjectPropertyTypes" базы данных "AuStoreDBN1", схемы
"dbo".
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:249)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
at ru.evosystems.aurix.surfbird.dao.impl.AbstractDaoSupportWithConnection.queryForList(AbstractDaoSupportWithConnection.java:109)
at ru.evosystems.aurix.surfbird.dao.impl.PropertyDaoImpl.getManagedObjectPropertyTypes(PropertyDaoImpl.java:66)
at ru.evosystems.aurix.surfbird.service.impl.PropertyServiceImpl.getManagedObjectPropertyTypes(PropertyServiceImpl.java:54)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1052)
at org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1124)
at com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:5388)
at com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:619)
at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:800)
at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:571)
at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doAround(SystemInterceptorProxy.java:162)
at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:144)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:861)
at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:800)
at com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:370)
at com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:5360)
at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:5348)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:214)
... 153 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Запрещено
разрешение "SELECT" на объект "ManageObjectPropertyTypes"
базы данных "AuStoreDBN1", схемы "dbo".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
at com.sun.gjc.spi.jdbc40.PreparedStatementWrapper40.executeQuery(PreparedStatementWrapper40.java:642)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
... 181 more
INFO: 2012-12-31 01:25:17,423 [0:0:0:0:0:0:0:1@mj-krotov] ERROR
(ru.evosystems.aurix.surfbird.service.EJBProxy:99) -
EJBProxy invocation EJBException :
org.springframework.dao.PermissionDeniedDataAccessException:
PreparedStatementCallback; SQL [ SELECT PropertyType.PropertyTypeId
PropertyType_ID, PropertyType.PropertyTypeName PropertyType_Name,
PropertyType.PropertyTypeProgramCode PropertyType_Code FROM
ManageObjectPropertyTypes PropertyType WHERE ManageObject = ?];
Запрещено разрешение "SELECT" на объект
"ManageObjectPropertyTypes" базы данных "AuStoreDBN1", схемы
"dbo".; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException:
Запрещено разрешение "SELECT" на объект
"ManageObjectPropertyTypes" базы данных "AuStoreDBN1", схемы
"dbo".
SEVERE: javax.el.ELException:
/sections/managed-objects/tabs/properties/managedObjectsPropertyTypesTab.xhtml
@45,24 value="#{propertyBean.propertyTypeList}":
org.springframework.dao.PermissionDeniedDataAccessException:
PreparedStatementCallback; SQL [ SELECT PropertyType.PropertyTypeId
PropertyType_ID, PropertyType.PropertyTypeName PropertyType_Name,
PropertyType.PropertyTypeProgramCode PropertyType_Code FROM
ManageObjectPropertyTypes PropertyType WHERE ManageObject = ?];
Запрещено разрешение "SELECT" на объект
"ManageObjectPropertyTypes" базы данных "AuStoreDBN1", схемы
"dbo".; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException:
Запрещено разрешение "SELECT" на объект
"ManageObjectPropertyTypes" базы данных "AuStoreDBN1", схемы
"dbo".
INFO: 2012-12-31 01:44:10,131 [0:0:0:0:0:0:0:1@mj-krotov] DEBUG
(ru.evosystems.aurix.surfbird.web.faces.JSFPhaseListener:20) -
afterPhase(): RENDER_RESPONSE 6
And the peace of code from the debugger:
com.sun.faces.context.PartialViewContextImpl line 520 - exception is caught and
not processed any more.
...
} else if (curPhase == PhaseId.RENDER_RESPONSE) {
PartialResponseWriter writer = ctx.getPartialViewContext().getPartialResponseWriter();
writer.startUpdate(comp.getClientId(ctx));
try {
// do the default behavior...
comp.encodeAll(ctx);
}
catch (Exception ce) {
if (LOGGER.isLoggable(Level.SEVERE)) {
LOGGER.severe(ce.toString());
}
if (LOGGER.isLoggable(Level.FINE)) {
LOGGER.log(Level.FINE,
ce.toString(),
ce);
}
}
writer.endUpdate();
...
Is there a way to handle this?
Thanks in advance.
And with coming New Year )
Original comment by alex...@gmail.com
on 30 Dec 2012 at 10:45
FYI: problem is reproduced. The cause is an empty ajax response. Will
debug/investigate later.
Original comment by balusc
on 6 Jan 2013 at 3:17
I spent some hours debugging again. With the TestErrorHandler project as
provided in issue 51 I could reproduce the problem with just this in
content.xhtml (the update="XXX" refers an invalid component ID)
<p:tree>
<p:ajax event="expand" update="XXX" />
</p:tree>
But if I change it to this
<p:tree>
<p:ajax event="expand" update="@form" />
</p:tree>
<p:commandButton value="test">
<p:ajax update="XXX"/>
</p:commandButton>
then the same exception is thrown, but the error page is displayed properly. I
looked around in the source code of <p:tree>, but I couldn't find any clues why
it's behaving like that.
I can at least tell that the problem is not in OmniFaces.
Original comment by balusc
on 14 Jan 2013 at 9:40
Ok, if i'll have something specific and reproducible that looks like a bug,
i'll try to do another small app.
But now i wonder why JSF doesn't queue exception while render error happens
(com.sun.faces.context.PartialViewContextImpl) - or exception handler should be
somewhere in different place to recognize this errors?
Original comment by alex...@gmail.com
on 15 Jan 2013 at 8:50
[deleted comment]
Nevermind my previous comment, I've deleted it. I had MyFaces still in the
runtime classpath. This problem still manifests with Mojarra after changing the
FullAjaxExceptionHandler as per issue 120.
Original comment by balusc
on 18 Jan 2013 at 10:18
Tested on 1.4-SNAPSHOT-20130118.
Problem still exist: ajax http response contains full error page in the update
tag, but the error page doesn't pop up.
Web debugger reponse:
<?xml version='1.0' encoding='UTF-8'?>
<partial-response><changes><update id="javax.faces.ViewRoot"><![CDATA[<!DOCTYPE
html>
<html xmlns="http://www.w3.org/1999/xhtml"><head><link type="text/css"
rel="stylesheet"
href="/surfbird/javax.faces.resource/theme.css.jsf?ln=primefaces-cupertino"
/><link type="text/css" rel="stylesheet"
href="/surfbird/javax.faces.resource/layout/layout.css.jsf?ln=primefaces-extensi
ons&v=0.6.2" /><link type="text/css" rel="stylesheet"
href="/surfbird/javax.faces.resource/primefaces.css.jsf?ln=primefaces" /><link
type="text/css" rel="stylesheet"
href="/surfbird/javax.faces.resource/surfbird.css.jsf?ln=css" /><script
type="text/javascript"
src="/surfbird/javax.faces.resource/jquery/jquery.js.jsf?ln=primefaces"></script
><script type="text/javascript"
src="/surfbird/javax.faces.resource/primefaces.js.jsf?ln=primefaces"></script><s
cript type="text/javascript"
src="/surfbird/javax.faces.resource/hotkey/hotkey.js.jsf?ln=primefaces"></script
><script type="text/javascript"
src="/surfbird/javax.faces.resource/primefaces-extensions.js.jsf?ln=primefaces-e
xtensions&v=0.6.2"></script><script type="text/javascript"
src="/surfbird/javax.faces.resource/layout/layout.js.jsf?ln=primefaces-extension
s&v=0.6.2"></script><script type="text/javascript"
src="/surfbird/javax.faces.resource/surfbird.js.jsf?ln=js"></script>
<title>Aurix Surfbird</title>
<meta charset="utf-8" />
<link type="image/x-icon" rel="shortcut icon" href="/surfbird/javax.faces.resource/favicon.ico.jsf?ln=ico" /></head><body><script type="text/javascript">$(function() {$(document).bind('keydown', 'esc', function(){closeOnEscape();;return false;});});</script><div id="blockUI" style="display: none;"><img id="ajaxloading" src="/surfbird/javax.faces.resource/ajaxloading.gif.jsf?ln=img" alt="" /></div><script id="masterLayout_s" type="text/javascript">$(function() {PrimeFacesExt.cw('Layout', 'widget_masterLayout',{id:'masterLayout',forTarget:'body',clientState:false,serverState:false,options:{"north":{"resizeWhileDragging":false,"closable":true,"initHidden":false,"resizable":false,"initClosed":false,"spacing":6,"size":"66"},"south":{"resizeWhileDragging":false,"closable":true,"initHidden":false,"resizable":false,"initClosed":false,"spacing":6,"size":"30"},"center":{"resizeWhileDragging":false,"closable":true,"initHidden":false,"resizable":true,"initClosed":false,"spacing":6}}},true);});</script><div id="masterHeaderLayoutUnit" class="ui-layout-north ui-widget-content ui-corner-all pe-layout-pane-content" data-combinedposition="north">
<form id="headerForm" name="headerForm" method="post"
action="/surfbird/errors/serverError.jsf"
enctype="application/x-www-form-urlencoded">
<input type="hidden" name="headerForm" value="headerForm" />
<a id="headerForm:j_idt11" href="#" class="ui-commandlink left"
onclick="PrimeFaces.ab({source:'headerForm:j_idt11'});return false;"><img
id="headerForm:j_idt12"
src="/surfbird/javax.faces.resource/FMAssistantLogo.png.jsf?ln=img" alt=""
/></a>
<div class="ajaxstatus right"><div id="headerForm:j_idt14"><div id="headerForm:j_idt14_start" style="display:none"><img id="headerForm:ajaxloading" src="/surfbird/javax.faces.resource/ajaxloading.gif.jsf?ln=img" alt="" /></div><div id="headerForm:j_idt14_complete" style="display:none"> </div><div id="headerForm:j_idt14_error" style="display:none">Error</div></div><script id="headerForm:j_idt14_s" type="text/javascript">
//<![CDATA[
PrimeFaces.cw('AjaxStatus','widget_headerForm_j_idt14',{id:'headerForm:j_idt14'}
);widget_headerForm_j_idt14.bindFacet('ajaxStart',
'start');widget_headerForm_j_idt14.bindFacet('ajaxError',
'error');widget_headerForm_j_idt14.bindFacet('ajaxComplete', 'complete');
//]]>
</script>
</div><label class="logo left">
ООО "УК Мажитель"</label><label class="logo left">
</label><div id="headerForm:j_idt20" class="ui-menu ui-menubar ui-widget
ui-widget-content ui-corner-all ui-helper-clearfix top_header_menu right"
role="menubar"><ul class="ui-menu-list ui-helper-reset"><li class="ui-widget
ui-menuitem ui-corner-all ui-menu-parent" role="menuitem"
aria-haspopup="true"><a href="javascript:void(0)" class="ui-menuitem-link
ui-corner-all"><span class="ui-menuitem-text">FAQ</span><span class="ui-icon
ui-icon-triangle-1-s"></span></a></li><li class="ui-widget ui-menuitem
ui-corner-all ui-menu-parent" role="menuitem" aria-haspopup="true"><a
href="javascript:void(0)" class="ui-menuitem-link ui-corner-all"><span
class="ui-menuitem-text">Support</span><span class="ui-icon
ui-icon-triangle-1-s"></span></a></li><li class="ui-widget ui-menuitem
ui-corner-all ui-menu-parent" role="menuitem" aria-haspopup="true"><a
href="javascript:void(0)" class="ui-menuitem-link ui-corner-all"><span
class="ui-menuitem-text">Борис Кротов</span><span class="ui-icon
ui-icon-triangle-1-s"></span></a><ul class="ui-widget-content ui-menu-list
ui-corner-all ui-helper-clearfix ui-menu-child ui-shadow" role="menu"><li
class="ui-menuitem ui-widget ui-corner-all" role="menuitem"><a
id="headerForm:j_idt24" class="ui-menuitem-link ui-corner-all" href="#"
onclick="PrimeFaces.ab({source:'headerForm:j_idt24',formId:'headerForm'});return
false;"><span class="ui-menuitem-icon ui-icon
ui-icon-triangle-1-e"></span><span class="ui-menuitem-text">Изменить
персональные данные</span></a></li><li class="ui-menuitem
ui-widget ui-corner-all" role="menuitem"><a id="headerForm:j_idt25"
class="ui-menuitem-link ui-corner-all" href="/surfbird/logout"><span
class="ui-menuitem-icon ui-icon ui-icon-triangle-1-e"></span><span
class="ui-menuitem-text">Выход</span></a></li></ul></li></ul></div><script
id="headerForm:j_idt20_s" type="text/javascript">
//<![CDATA[
PrimeFaces.cw('Menubar','widget_headerForm_j_idt20',{id:'headerForm:j_idt20',aut
oDisplay:true});
//]]>
</script><span id="headerForm:globalMessages"></span><script
id="headerForm:globalMessages_s" type="text/javascript">
//<![CDATA[
$(function(){PrimeFaces.cw('Growl','widget_headerForm_globalMessages',{id:'heade
rForm:globalMessages',sticky:false,life:6000,escape:true,msgs:[]});});
//]]>
</script>
</form></div><div id="masterCenterLayoutUnit" class="ui-layout-center
ui-widget-content ui-corner-all pe-layout-pane-content"
data-combinedposition="center">
<div style="font-size: 1.35em">
<p></p>
<form id="j_idt27" name="j_idt27" method="post"
action="/surfbird/errors/serverError.jsf"
enctype="application/x-www-form-urlencoded">
<input type="hidden" name="j_idt27" value="j_idt27" />
<script type="text/javascript"
src="/surfbird/javax.faces.resource/jsf.js.jsf?ln=javax.faces"></script>
<a href="#" style="margin-right: 10px"
onclick="mojarra.jsfcljs(document.getElementById('j_idt27'),{'j_idt27:j_idt28':'
j_idt27:j_idt28'},'');return false">Домой</a><a
href="/surfbird/logout">Вход в систему</a>
</form>
<p></p><h1>Ошибка при обработке запроса</h1>
<p></p>
<ul>
<li>Date/time: 2013-01-21 00:29:07</li>
<li>User agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17</li>
<li>User IP: 0:0:0:0:0:0:0:1</li>
<li>Request URI: /surfbird/views/main.jsf</li>
<li>Ajax request: Yes</li>
<li>Status code: 500</li>
<li>Exception type: class org.springframework.jdbc.BadSqlGrammarException</li>
<li>Exception message: CallableStatementCallback; bad SQL grammar [{? = call sp_AddFunctionalRoleToPerson(?, ?)}]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Процедура или функция "sp_AddFunctionalRoleToPerson" ожидает параметр "@FunctionalRoleID", который не был указан.</li>
<li>Stack trace:
<pre>org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{? = call sp_AddFunctionalRoleToPerson(?, ?)}]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Процедура или функция "sp_AddFunctionalRoleToPerson" ожидает параметр "@FunctionalRoleID", который не был указан.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1030)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1042)
at ru.evosystems.aurix.surfbird.dao.impl.BusinessModuleDaoImpl.addFunctionalRoleToPerson(BusinessModuleDaoImpl.java:123)
at ru.evosystems.aurix.surfbird.service.impl.BusinessModuleServiceImpl.addFunctionalRoleToPerson(BusinessModuleServiceImpl.java:89)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1052)
at org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1124)
at com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:5388)
at com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:619)
at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:800)
at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:571)
at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doAround(SystemInterceptorProxy.java:162)
at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:144)
at sun.reflect.GeneratedMethodAccessor254.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:861)
at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:800)
at com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:370)
at com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:5360)
at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:5348)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:214)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:88)
at $Proxy173.addFunctionalRoleToPerson(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.ejb.access.LocalSlsbInvokerInterceptor.invokeInContext(LocalSlsbInvokerInterceptor.java:71)
at org.springframework.ejb.access.AbstractSlsbInvokerInterceptor.invoke(AbstractSlsbInvokerInterceptor.java:189)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy185.addFunctionalRoleToPerson(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at ru.evosystems.aurix.surfbird.service.EJBProxy.invoke(EJBProxy.java:92)
at $Proxy207.addFunctionalRoleToPerson(Unknown Source)
at ru.evosystems.aurix.surfbird.web.beans.PersonBean.addRole(PersonBean.java:118)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at com.sun.el.parser.AstValue.invoke(AstValue.java:254)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)
at javax.faces.event.MethodExpressionActionListener.processAction(MethodExpressionActionListener.java:153)
at javax.faces.event.ActionEvent.processListener(ActionEvent.java:88)
at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:769)
at javax.faces.component.UICommand.broadcast(UICommand.java:300)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1542)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
at org.omnifaces.filter.GzipResponseFilter.doFilter(GzipResponseFilter.java:148)
at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
at ru.evosystems.aurix.surfbird.web.filters.ThreadCacheFilter.doFilter(ThreadCacheFilter.java:34)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:64)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:125)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
at ru.evosystems.aurix.surfbird.web.filters.AppGatewayFilter.doFilter(AppGatewayFilter.java:65)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:331)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231)
at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)
at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)
at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:849)
at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:746)
at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1045)
at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:228)
at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
at java.lang.Thread.run(Thread.java:722)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Процедура
или функция "sp_AddFunctionalRoleToPerson" ожидает
параметр "@FunctionalRoleID", который не был указан.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)
at com.sun.gjc.spi.base.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:508)
at ru.evosystems.aurix.surfbird.dao.impl.BusinessModuleDaoImpl$1.doInCallableStatement(BusinessModuleDaoImpl.java:129)
at ru.evosystems.aurix.surfbird.dao.impl.BusinessModuleDaoImpl$1.doInCallableStatement(BusinessModuleDaoImpl.java:1)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1014)
... 123 more
</pre>
</li>
</ul>
</div></div><div id="masterFooterLayoutUnit" class="ui-layout-south ui-widget-content ui-corner-all pe-layout-pane-content" data-combinedposition="south">
<p align="center" id="footer">© Evo-systems, 2012. Aurix Surfbird 1.0.0-SNAPSHOT-${buildNumber} (21.01.2013 00:26)</p></div></body>
</html>]]></update><update
id="javax.faces.ViewState"><![CDATA[-5408848808484326251:3020032497351947303]]><
/update></changes></partial-response>
Original comment by alex...@gmail.com
on 20 Jan 2013 at 8:33
Setting "Hold" as I couldn't naildown the cause yet.
Fact is, this works when MyFaces is used instead of Mojarra.
Original comment by balusc
on 5 Apr 2013 at 3:15
Original comment by balusc
on 8 Apr 2013 at 10:56
Is this still an issue for anyone?
Original comment by arjan.tijms
on 8 Sep 2013 at 10:41
I think we can close it. I get sometimes exceptions that is not processed (see
comment #1) - i see it only in the log file, but this is probably not Omnifaces
issue
Original comment by alex...@gmail.com
on 9 Sep 2013 at 6:23
Original issue reported on code.google.com by
alex...@gmail.com
on 30 Dec 2012 at 10:29