Error in Site Users - Community Edition 19.1 - Can't view users list

General Server Forum (Inactive)
Error in Site Users - Community Edition 19.1 - Can't view users list Gina M Scott  2019-07-02 12:59
Status: Closed
 

Version 19.1
We get an error when we click on Site Users -
only shows one user and it is not the logged in user and displays this error:
An unexpected error occurred
Could not convert '-4,-1' to an integer


Details:
org.apache.commons.beanutils.ConversionException: Could not convert '-4,-1' to an integer
at org.labkey.api.data.ConvertHelper$_IntegerConverter.convert(ConvertHelper.java:606)
at org.apache.commons.beanutils.ConvertUtilsBean.convert(ConvertUtilsBean.java:428)
at org.apache.commons.beanutils.ConvertUtils.convert(ConvertUtils.java:217)
at org.labkey.api.data.MultiValuedRenderContext.get(MultiValuedRenderContext.java:116)
at org.labkey.api.data.DataColumn.getValue(DataColumn.java:243)
at org.labkey.api.data.DataColumn.renderGridCellContents(DataColumn.java:324)
at org.labkey.api.data.DisplayColumnDecorator.renderGridCellContents(DisplayColumnDecorator.java:51)
at org.labkey.api.data.MultiValuedDisplayColumn.renderGridCellContents(MultiValuedDisplayColumn.java:139)
at org.labkey.api.data.DisplayColumn.renderGridDataCell(DisplayColumn.java:980)
at org.labkey.api.data.DataRegion.renderTableRow(DataRegion.java:1642)
at org.labkey.api.data.DataRegion.renderTableContents(DataRegion.java:1601)
at org.labkey.api.data.DataRegion.renderTableContent(DataRegion.java:1173)
at org.labkey.api.data.DataRegion.renderCenterContent(DataRegion.java:1214)
at org.labkey.api.data.DataRegion._renderDataTableNew(DataRegion.java:1188)
at org.labkey.api.data.DataRegion._renderTableNew(DataRegion.java:1077)
at org.labkey.api.data.DataRegion.renderTable(DataRegion.java:980)
at org.labkey.api.data.DataRegion.render(DataRegion.java:2518)
at org.labkey.api.view.GridView._renderDataRegion(GridView.java:64)
at org.labkey.api.view.DataView.renderView(DataView.java:211)
at org.labkey.api.view.DataView.renderView(DataView.java:58)
at org.labkey.api.view.WebPartView.renderView(WebPartView.java:476)
at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:371)
at org.labkey.api.view.HttpView.render(HttpView.java:132)
at org.labkey.api.view.HttpView.render(HttpView.java:117)
at org.labkey.api.view.HttpView.include(HttpView.java:512)
at org.labkey.api.view.HttpView.include(HttpView.java:489)
at org.labkey.api.query.QueryView.renderDataRegion(QueryView.java:2231)
at org.labkey.api.query.QueryView.renderView(QueryView.java:1977)
at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:371)
at org.labkey.api.view.HttpView.render(HttpView.java:132)
at org.labkey.api.view.HttpView.render(HttpView.java:117)
at org.labkey.api.view.HttpView.include(HttpView.java:512)
at org.labkey.api.view.HttpView.include(HttpView.java:489)
at org.labkey.api.view.HttpView.include(HttpView.java:477)
at org.labkey.api.view.VBox.renderView(VBox.java:74)
at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:371)
at org.labkey.api.view.HttpView.render(HttpView.java:132)
at org.labkey.api.view.HttpView.render(HttpView.java:117)
at org.labkey.api.view.HttpView.include(HttpView.java:512)
at org.labkey.api.view.HttpView.include(HttpView.java:489)
at org.labkey.jsp.compiled.org.labkey.core.view.template.bootstrap.body_jsp._jspService(body_jsp.java:259)
at org.labkey.api.view.JspView.renderView(JspView.java:170)
at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:371)
at org.labkey.api.view.HttpView.render(HttpView.java:132)
at org.labkey.api.view.HttpView.render(HttpView.java:117)
at org.labkey.api.view.HttpView.include(HttpView.java:512)
at org.labkey.api.view.HttpView.include(HttpView.java:489)
at org.labkey.jsp.compiled.org.labkey.core.view.template.bootstrap.pageTemplate_jsp._jspService(pageTemplate_jsp.java:214)
at org.labkey.api.view.JspView.renderView(JspView.java:170)
at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:371)
at org.labkey.api.view.HttpView.render(HttpView.java:132)
at org.labkey.api.view.HttpView.render(HttpView.java:117)
at org.labkey.api.action.SpringActionController.renderInTemplate(SpringActionController.java:615)
at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:495)
at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:1265)
at org.labkey.api.view.ViewServlet._service(ViewServlet.java:204)
at org.labkey.api.view.ViewServlet.service(ViewServlet.java:131)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:38)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:1220)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:215)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:835)
Caused by: java.lang.NumberFormatException: Character , is neither a decimal digit number, decimal point, nor "e" notation exponential mark.
at java.base/java.math.BigDecimal.<init>(BigDecimal.java:518)
at java.base/java.math.BigDecimal.<init>(BigDecimal.java:401)
at java.base/java.math.BigDecimal.<init>(BigDecimal.java:834)
at org.labkey.api.data.ConvertHelper$_IntegerConverter.convert(ConvertHelper.java:595)
... 91 more
request attributes
LABKEY.OriginalURL = http://labkey.nrel.gov/labkey/user-showUsers.view?returnUrl=%2Flabkey%2Fadmin-showAdmin.view%3F
LABKEY.StartTime = 1562084593824
LABKEY.action = showUsers
org.springframework.web.servlet.DispatcherServlet.CONTEXT = Root WebApplicationContext: startup date [Sat Jun 15 01:43:22 MDT 2019]; parent: Root WebApplicationContext
LABKEY.controller = user
LABKEY.Counter = 0
X-LABKEY-CSRF = acfbfcfe610545c7d52c6743d6e51b1f
LABKEY.container =
LABKEY.RequestURL = /labkey/user-showUsers.view?returnUrl=%2Flabkey%2Fadmin-showAdmin.view%3F
LABKEY.OriginalURLHelper = /labkey/user-showUsers.view?returnUrl=%2Flabkey%2Fadmin-showAdmin.view%3F

core schema database configuration
Server URL jdbc:jtds:sqlserver://ignsql-listener.nrel.gov:1433/Labkey
Product Name Microsoft SQL Server
Product Version 13.00.5292
Driver Name jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
Driver Version 1.3.1

 
 
Jon (LabKey DevOps) responded:  2019-07-02 21:26
Hi Gina,

Can you see what permissions this user is setup as? I think they may be configured as a Site Admin and a Developer, which is a redundancy since a Site Admin automatically has Developer access.

If you go to the Gear Icon > Site > Site Admins and check the list and then go to the Gear Icon > Site > Site Developers, you should see the user listed in both places. Select the Remove checkbox for that user in the Site Developers list and click Update Group Membership, then check the Site Users page again to see if the error appears again.

Regards,

Jon