Problems with Spectral Counts Compare in 9.2

CPAS Forum (Inactive)
Problems with Spectral Counts Compare in 9.2 edwin.lowe  2009-10-06 20:21
Status: Closed
 
I recently upgraded 9.2 and am having problems with using the Compare tool and Spectral Counts. I was previously running 9.1 with the the data in the older PostgreSQL 8.2 server and dumped and reimported my data into PostgreSQL 8.3 when i updated.

I get the following error

An unexpected error occurred
java.lang.NullPointerException

[Show more details]

org.labkey.api.util.UnexpectedException: java.lang.NullPointerException:java.lang.NullPointerException
       at org.labkey.api.data.AsyncQueryRequest.waitForResult(AsyncQueryRequest.java:106)
       at org.labkey.api.data.Table.selectForDisplayAsync(Table.java:1332)
       at org.labkey.api.data.RenderContext.selectForDisplay(RenderContext.java:347)
       at org.labkey.api.data.RenderContext.getResultSet(RenderContext.java:228)
       at org.labkey.api.data.DataRegion.getResultSet(DataRegion.java:610)
       at org.labkey.api.data.DataRegion.getResultSet(DataRegion.java:594)
       at org.labkey.api.data.DataRegion._renderTable(DataRegion.java:683)
       at org.labkey.api.data.DataRegion.render(DataRegion.java:1915)
       at org.labkey.api.data.DataRegion.renderTable(DataRegion.java:668)
       at org.labkey.api.view.GridView._renderDataRegion(GridView.java:71)
       at org.labkey.api.view.DataView.renderView(DataView.java:124)
       at org.labkey.api.view.DataView.renderView(DataView.java:31)
       at org.labkey.api.view.WebPartView.renderView(WebPartView.java:569)
       at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:180)
       at org.labkey.api.view.HttpView.render(HttpView.java:135)
       at org.labkey.api.view.HttpView.render(HttpView.java:117)
       at org.labkey.api.view.HttpView.include(HttpView.java:536)
       at org.labkey.api.query.QueryView.renderDataRegion(QueryView.java:1049)
       at org.labkey.api.query.QueryView.renderView(QueryView.java:885)
       at org.labkey.api.view.WebPartView.renderView(WebPartView.java:569)
       at org.labkey.api.query.QueryView.renderView(QueryView.java:910)
       at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:180)
       at org.labkey.api.view.HttpView.render(HttpView.java:135)
       at org.labkey.api.view.HttpView.render(HttpView.java:117)
       at org.labkey.api.view.HttpView.include(HttpView.java:536)
       at org.labkey.jsp.compiled.org.labkey.api.view.template.CommonTemplate_jsp._jspService(CommonTemplate_jsp.java:204)
       at org.labkey.api.view.JspView.renderView(JspView.java:119)
       at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:180)
       at org.labkey.api.view.HttpView.render(HttpView.java:135)
       at org.labkey.api.view.HttpView.render(HttpView.java:117)
       at org.labkey.api.action.SpringActionController.renderInTemplate(SpringActionController.java:420)
       at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:344)
       at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:726)
       at org.labkey.api.view.ViewServlet.service(ViewServlet.java:140)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
       at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:36)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
       at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:124)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
       at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:651)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
       at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:101)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
       at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
       at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
       at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
       at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
       at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
       at org.labkey.api.query.AliasManager.legalNameFromName(AliasManager.java:70)
       at org.labkey.api.query.AliasManager.makeLegalName(AliasManager.java:96)
       at org.labkey.query.QueryServiceImpl.getSelectSQL(QueryServiceImpl.java:643)
       at org.labkey.api.data.Table.getSelectSQL(Table.java:1164)
       at org.labkey.api.data.Table.selectForDisplay(Table.java:1323)
       at org.labkey.api.data.Table.access$300(Table.java:52)
       at org.labkey.api.data.Table$2.call(Table.java:1336)
       at org.labkey.api.data.Table$2.call(Table.java:1334)
       at org.labkey.api.data.AsyncQueryRequest$1.run(AsyncQueryRequest.java:69)
       ... 1 more

request attributes
LABKEY.StartTime = 1254885570546
LABKEY.container = /Jay Kocharunchitt/Plasmid Data
LABKEY.OriginalURL = http://proteome.csl.utas.edu.au:8080/labkey/ms2/Jay%20Kocharunchitt/Plasmid%20Data/spectraCount.view?runList=127&spectraConfig=SpectraCountProteinPP&peptideFilterType=peptideProphet&peptideProphetProbability=0.8
LABKEY.action = spectraCount
org.springframework.web.servlet.DispatcherServlet.CONTEXT = org.springframework.web.context.support.XmlWebApplicationContext@5f39b0: display name [MS2 WebApplicationContext]; startup date [Tue Oct 06 16:22:52 EST 2009]; parent: org.springframework.web.context.support.XmlWebApplicationContext@1babddb
LABKEY.controller = ms2
WebPartView.frame = DIV
LABKEY.RequestURL = /labkey/ms2/Jay%20Kocharunchitt/Plasmid%20Data/spectraCount.view?runList=127&spectraConfig=SpectraCountProteinPP&peptideFilterType=peptideProphet&peptideProphetProbability=0.8

core schema database configuration
Server URL    jdbc:postgresql://xxx.yyy.zzz.au:5432/labkey
Product Name    PostgreSQL
Product Version    8.3.8
Driver Name    PostgreSQL Native Driver
Driver Version    PostgreSQL 8.3 JDBC3 with SSL (build 604)
 
 
jeckels responded:  2009-10-07 17:37
Hi Edwin,

I've seen that error message before but I haven't been able to reproduce the problem. Do you know if you've customized the columns in the grid view?

Are you able to reproduce the problem here on labkey.org, also running version 9.2?

https://www.labkey.org/project/home/CPAS/demo/begin.view?

Thanks,
Josh
 
edwin.lowe responded:  2009-10-07 19:49
Hi Josh

I am not sure what the user has changed but it appears to be a site wide issue. I have tested with different users and all throw the same error whenever using the SpectralCount compare option. I am unable to get the error to replicate on your server :(

Edwin
 
edwin.lowe responded:  2009-10-08 18:42
Ok .. I've downgraded my LabKey server down to 9.1 and the problem has gone away. Note that this is with exactly the same SQL database (i restored both from a fresh dump file in each case) and running PostgreSQL 8.3.

Edwin
 
jeckels responded:  2009-10-16 16:41
Hi Edwin,

I did a little more investigation and I found a 9.3 change that was already checked in that fixes this problem, so you shouldn't have the same problem with the next release.

Thanks,
Josh
 
edwin.lowe responded:  2009-10-29 17:58
Thanks for investigating this. Look foward to checking out 9.3.

Edwin