Select to view content in your preferred language

Failed to update user 'user@domain'. Unable to update user.

425
0
07-28-2023 01:08 AM
Oiligriv
Occasional Contributor

Hello Community
I'm experiencing strange behavior on the Portal
Below is an extract from the logs

the portal is configured in HA, but the Standby portal always reports this error when users login.
Users complain about login errors from mobile devices.

 

Error: 

SEVERE
Failed to update user 'christian.carbone@BIM_BL'. Unable to update user.
2023-07-28T10:01:16,81 Sharing AGSPORTAL1.BIM.BL 204016 1316
DEBUG
com.esri.gw.GWException: Unable to update user. at com.esri.gw.db.GWDatabaseImpl.a(GWDatabaseImpl.java:1330) at com.esri.gw.db.GWDatabaseImpl.updateUser(GWDatabaseImpl.java:1057) at jdk.internal.reflect.GeneratedMethodAccessor228.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) at com.sun.proxy.$Proxy69.updateUser(Unknown Source) at com.esri.gw.community.GWCommunity.updateUser(GWCommunity.java:2233) at com.esri.gw.community.GWCommunity.updateUser(GWCommunity.java:2151) at com.esri.gw.community.GWCommunity.updateUser(GWCommunity.java:2147) at com.esri.gw.security.GWSecurityRequestHandlerPortalImpl.a(GWSecurityRequestHandlerPortalImpl.java:639) at com.esri.gw.security.GWSecurityRequestHandlerPortalImpl.checkForWebAdaptorAuthentication(GWSecurityRequestHandlerPortalImpl.java:377) at com.esri.gw.security.GWSecurityRequestHandlerPortalImpl.extractUserFromRequest(GWSecurityRequestHandlerPortalImpl.java:208) at com.esri.gw.GWRequestFactory.getGWRequest(GWRequestFactory.java:59) at com.esri.gw.DispatchServlet.b(DispatchServlet.java:235) at com.esri.gw.DispatchServlet.service(DispatchServlet.java:127) at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.filters.HttpHeaderSecurityFilter.doFilter(HttpHeaderSecurityFilter.java:126) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at com.esri.gw.filters.PortalFilter.doFilter(PortalFilter.java:82) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at com.esri.gw.filters.JSONFilter.doFilter(JSONFilter.java:133) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at com.esri.gw.filters.GZipFilter.doFilter(GZipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at com.esri.gw.filters.SecurityFilter.doFilter(SecurityFilter.java:100) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at com.esri.gw.filters.ErrorFilter.doFilter(ErrorFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at com.esri.gw.filters.TraceFilter.doFilter(TraceFilter.java:103) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at com.esri.gw.filters.ProxyRequestCaptureFilter.doFilter(ProxyRequestCaptureFilter.java:126) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at com.esri.gw.filters.CharEncodingFilter.doFilter(CharEncodingFilter.java:32) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:660) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at com.esri.arcgis.portal.util.TomcatValve.invoke(TomcatValve.java:43) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891) at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1703) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.net.AbstractEndpoint.processSocket(AbstractEndpoint.java:1190) at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:634) at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:612) at org.apache.tomcat.util.net.SecureNio2Channel$1.completed(SecureNio2Channel.java:1008) at org.apache.tomcat.util.net.SecureNio2Channel$1.completed(SecureNio2Channel.java:936) at java.base/sun.nio.ch.Invoker.invokeUnchecked(Unknown Source) at java.base/sun.nio.ch.Invoker$2.run(Unknown Source) at java.base/sun.nio.ch.AsynchronousChannelGroupImpl$1.run(Unknown Source) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source) Caused by: com.esri.gw.GWException: DBUtil.doUpdateTransaction(): failed, at com.esri.gw.db.DBUtil.doUpdateTransactionNoRetry(DBUtil.java:253) at com.esri.gw.db.DBUtil.lambda$doUpdateTransaction$4(DBUtil.java:422) at com.esri.gw.db.DBUtil.a(DBUtil.java:441) at com.esri.gw.db.DBUtil.doUpdateTransaction(DBUtil.java:422) at com.esri.gw.db.GWDatabaseImpl.a(GWDatabaseImpl.java:1323) ... 80 more Caused by: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:132) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:93) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:93) at com.esri.gw.db.DBUtil.doUpdateTransactionNoRetry(DBUtil.java:239) ... 84 more
2023-07-28T10:01:16,81 Sharing AGSPORTAL1.BIM.BL 9999 1316

 

Thank you

Virgilio

Tags (1)
0 Kudos
0 Replies