Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

ERROR: testGetAvailableLocations (awips.test.dafTests.testClimate.ClimateTestCase) #19

Open
mjames-upc opened this issue Oct 16, 2018 · 4 comments
Open

ERROR: testGetAvailableLocations (awips.test.dafTests.testClimate.ClimateTestCase) #19

mjames-upc opened this issue Oct 16, 2018 · 4 comments

Comments

@mjames-upc
Copy link
Member 

======================================================================
ERROR: testGetAvailableLocations (awips.test.dafTests.testClimate.ClimateTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/scrutinizer/build/awips/test/dafTests/testClimate.py", line 49, in testGetAvailableLocations
    self.runLocationsTest(req)
  File "/home/scrutinizer/build/awips/test/dafTests/baseDafTestCase.py", line 123, in runLocationsTest
    locs = DAL.getAvailableLocationNames(req)
  File "/home/scrutinizer/build/awips/dataaccess/DataAccessLayer.py", line 208, in getAvailableLocationNames
    return router.getAvailableLocationNames(request)
  File "/home/scrutinizer/build/awips/dataaccess/ThriftClientRouter.py", line 167, in getAvailableLocationNames
    response = self._client.sendRequest(locNamesRequest)
  File "/home/scrutinizer/build/awips/ThriftClient.py", line 68, in sendRequest
    raise ThriftRequestException(forceError)
awips.ThriftClient.ThriftRequestException: b'com.raytheon.uf.common.dataaccess.exception.DataRetrievalException' exception thrown: b'Error retrieving climate data (failed query="select column_name from information_schema.columns where column_name in (\'station_code\', \'station_id\', \'inform_id\', \'icao_loc_id\') and table_name = \'cli_asos_monthly\';")'
	at com.raytheon.uf.common.dataaccess.util.DatabaseQueryUtil.executeDatabaseQuery(DatabaseQueryUtil.java:129)
	at com.raytheon.uf.common.dataaccess.impl.AbstractGeometryDatabaseFactory.executeQuery(AbstractGeometryDatabaseFactory.java:238)
	at com.raytheon.uf.common.dataaccess.impl.AbstractGeometryDatabaseFactory.executeGetColumnNames(AbstractGeometryDatabaseFactory.java:628)
	at com.raytheon.uf.common.dataplugin.climate.ClimateGeometryFactory.getLocationColumnName(ClimateGeometryFactory.java:173)
	at com.raytheon.uf.common.dataplugin.climate.ClimateGeometryFactory.assembleGetAvailableLocationNames(ClimateGeometryFactory.java:189)
	at com.raytheon.uf.common.dataaccess.impl.AbstractGeometryDatabaseFactory.getAvailableLocationNames(AbstractGeometryDatabaseFactory.java:246)
	at com.raytheon.uf.common.dataaccess.DataAccessLayer.getAvailableLocationNames(DataAccessLayer.java:211)
	at com.raytheon.uf.edex.dataaccess.handler.GetAvailableLocationNamesHandler.handleRequest(GetAvailableLocationNamesHandler.java:57)
	at com.raytheon.uf.edex.dataaccess.handler.GetAvailableLocationNamesHandler.handleRequest(GetAvailableLocationNamesHandler.java:1)
	at com.raytheon.uf.edex.requestsrv.RequestServiceExecutor.execute(RequestServiceExecutor.java:155)
	at com.raytheon.uf.edex.requestsrv.serialization.SerializingStreamExecutor.execute(SerializingStreamExecutor.java:107)
	at com.raytheon.uf.edex.requestsrv.serialization.ByteLimitingStreamExecutor.execute(ByteLimitingStreamExecutor.java:76)
	at com.raytheon.uf.edex.requestsrv.http.HttpRequestServiceExecutor.execute(HttpRequestServiceExecutor.java:102)
	at sun.reflect.GeneratedMethodAccessor137.invoke()
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.camel.component.bean.MethodInfo.invoke(MethodInfo.java:458)
	at org.apache.camel.component.bean.MethodInfo$1.doProceed(MethodInfo.java:289)
	at org.apache.camel.component.bean.MethodInfo$1.proceed(MethodInfo.java:262)
	at org.apache.camel.component.bean.BeanProcessor.process(BeanProcessor.java:178)
	at org.apache.camel.component.bean.BeanProducer.process(BeanProducer.java:41)
	at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:145)
	at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:109)
	at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:116)
	at com.raytheon.uf.edex.esb.camel.MessageProducer$2.process(MessageProducer.java:439)
	at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110)
	at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:542)
	at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:197)
	at org.apache.camel.processor.Pipeline.process(Pipeline.java:120)
	at org.apache.camel.processor.Pipeline.process(Pipeline.java:83)
	at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:197)
	at org.apache.camel.component.jetty.CamelContinuationServlet.doService(CamelContinuationServlet.java:191)
	at org.apache.camel.http.common.CamelServlet.service(CamelServlet.java:74)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
	at org.eclipse.jetty.server.Server.handle(Server.java:499)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
	at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
	at java.lang.Thread.run(Thread.java:745)
Caused by: b'java.lang.NullPointerException' exception thrown: 
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
	at com.raytheon.uf.edex.database.dao.CoreDao.executeSQLQuery(CoreDao.java:894)
	at com.raytheon.uf.edex.database.dao.CoreDao.executeSQLQuery(CoreDao.java:875)
	at com.raytheon.uf.edex.database.dao.CoreDao.executeMappedSQLQuery(CoreDao.java:953)
	at com.raytheon.uf.edex.database.QlServerRequestHandler.handleRequest(QlServerRequestHandler.java:74)
	at com.raytheon.uf.edex.database.QlServerRequestHandler.handleRequest(QlServerRequestHandler.java:1)
	at com.raytheon.uf.edex.requestsrv.RequestServiceExecutor.execute(RequestServiceExecutor.java:155)
	at com.raytheon.uf.edex.requestsrv.router.ServerRequestRouter.route(ServerRequestRouter.java:58)
	at com.raytheon.uf.common.serialization.comm.RequestRouter.route(RequestRouter.java:130)
	at com.raytheon.uf.common.serialization.comm.RequestRouter.route(RequestRouter.java:107)
	at com.raytheon.uf.common.dataaccess.util.DatabaseQueryUtil.executeDatabaseQuery(DatabaseQueryUtil.java:127)
	at com.raytheon.uf.common.dataaccess.impl.AbstractGeometryDatabaseFactory.executeQuery(AbstractGeometryDatabaseFactory.java:238)
	at com.raytheon.uf.common.dataaccess.impl.AbstractGeometryDatabaseFactory.executeGetColumnNames(AbstractGeometryDatabaseFactory.java:628)
	at com.raytheon.uf.common.dataplugin.climate.ClimateGeometryFactory.getLocationColumnName(ClimateGeometryFactory.java:173)
	at com.raytheon.uf.common.dataplugin.climate.ClimateGeometryFactory.assembleGetAvailableLocationNames(ClimateGeometryFactory.java:189)
	at com.raytheon.uf.common.dataaccess.impl.AbstractGeometryDatabaseFactory.getAvailableLocationNames(AbstractGeometryDatabaseFactory.java:246)
	at com.raytheon.uf.common.dataaccess.DataAccessLayer.getAvailableLocationNames(DataAccessLayer.java:211)
	at com.raytheon.uf.edex.dataaccess.handler.GetAvailableLocationNamesHandler.handleRequest(GetAvailableLocationNamesHandler.java:57)
	at com.raytheon.uf.edex.dataaccess.handler.GetAvailableLocationNamesHandler.handleRequest(GetAvailableLocationNamesHandler.java:1)
	at com.raytheon.uf.edex.requestsrv.RequestServiceExecutor.execute(RequestServiceExecutor.java:155)
	at com.raytheon.uf.edex.requestsrv.serialization.SerializingStreamExecutor.execute(SerializingStreamExecutor.java:107)
	at com.raytheon.uf.edex.requestsrv.serialization.ByteLimitingStreamExecutor.execute(ByteLimitingStreamExecutor.java:76)
	at com.raytheon.uf.edex.requestsrv.http.HttpRequestServiceExecutor.execute(HttpRequestServiceExecutor.java:102)
	at sun.reflect.GeneratedMethodAccessor137.invoke()
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.camel.component.bean.MethodInfo.invoke(MethodInfo.java:458)
	at org.apache.camel.component.bean.MethodInfo$1.doProceed(MethodInfo.java:289)
	at org.apache.camel.component.bean.MethodInfo$1.proceed(MethodInfo.java:262)
	at org.apache.camel.component.bean.BeanProcessor.process(BeanProcessor.java:178)
	at org.apache.camel.component.bean.BeanProducer.process(BeanProducer.java:41)
	at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:145)
	at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:109)
	at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:116)
	at com.raytheon.uf.edex.esb.camel.MessageProducer$2.process(MessageProducer.java:439)
	at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110)
	at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:542)
	at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:197)
	at org.apache.camel.processor.Pipeline.process(Pipeline.java:120)
	at org.apache.camel.processor.Pipeline.process(Pipeline.java:83)
	at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:197)
	at org.apache.camel.component.jetty.CamelContinuationServlet.doService(CamelContinuationServlet.java:191)
	at org.apache.camel.http.common.CamelServlet.service(CamelServlet.java:74)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
	at org.eclipse.jetty.server.Server.handle(Server.java:499)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
	at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
	at java.lang.Thread.run(Thread.java:745)
@mjames-upc
Copy link
Member Author

mjames-upc commented Oct 16, 2018 •
edited
Loading

query is

"select column_name from information_schema.columns where column_name in 
(\'station_code\', \'station_id\', \'inform_id\', \'icao_loc_id\') 
and table_name = \'cli_asos_monthly\';"

@mjames-upc
Copy link
Member Author 

climate=> \d cli_asos_monthly;
            Table "public.cli_asos_monthly"
       Column       |         Type          | Modifiers 
--------------------+-----------------------+-----------
 station_code       | character varying(9)  | not null
 year               | smallint              | 
 month              | smallint              | not null
 maxtemp_mon        | smallint              | 
 maxtemp_day1       | smallint              | 
 maxtemp_day2       | smallint              | 
 maxtemp_day3       | smallint              | 
 mintemp_mon        | smallint              | 
 mintemp_day1       | smallint              | 
 mintemp_day2       | smallint              | 
 mintemp_day3       | smallint              | 
 avg_daily_max      | real                  | 
 avg_daily_min      | real                  | 
 avg_mon_temp       | real                  | 
 days_maxt_blo_fzg  | smallint              | 
 days_maxt_hot      | smallint              | 
 days_mint_blo_fzg  | smallint              | 
 days_mint_blo_0f   | smallint              | 
 heating            | smallint              | 
 cooling            | smallint              | 
 mean_stn_press     | real                  | 
 mean_sea_press     | real                  | 
 max_sea_press      | real                  | 
 max_slp_date       | character varying(8)  | 
 max_slp_occur      | character varying(1)  | 
 min_sea_press      | real                  | 
 min_slp_date       | character varying(8)  | 
 min_slp_occur      | character varying(1)  | 
 month_precip       | real                  | 
 days_hundreth      | smallint              | 
 days_tenth         | smallint              | 
 days_half          | smallint              | 
 days_inch          | smallint              | 
 max_24h_pcp        | real                  | 
 max_24h_pcp_day1   | smallint              | 
 max_24h_pcp_day2   | smallint              | 
 shrtdurpcp5        | real                  | 
 shrtdurpcp10       | real                  | 
 shrtdurpcp15       | real                  | 
 shrtdurpcp20       | real                  | 
 shrtdurpcp30       | real                  | 
 shrtdurpcp45       | real                  | 
 shrtdurpcp60       | real                  | 
 shrtdurpcp80       | real                  | 
 shrtdurpcp100      | real                  | 
 shrtdurpcp120      | real                  | 
 shrtdurpcp150      | real                  | 
 shrtdurpcp180      | real                  | 
 shrtdurpcp_date5   | character varying(8)  | 
 shrtdurpcp_date10  | character varying(8)  | 
 shrtdurpcp_date15  | character varying(8)  | 
 shrtdurpcp_date20  | character varying(8)  | 
 shrtdurpcp_date30  | character varying(8)  | 
 shrtdurpcp_date45  | character varying(8)  | 
 shrtdurpcp_date60  | character varying(8)  | 
 shrtdurpcp_date80  | character varying(8)  | 
 shrtdurpcp_date100 | character varying(8)  | 
 shrtdurpcp_date120 | character varying(8)  | 
 shrtdurpcp_date150 | character varying(8)  | 
 shrtdurpcp_date180 | character varying(8)  | 
 hrs_sun            | real                  | 
 percent_sun        | real                  | 
 max_24h_snow       | real                  | 
 max_24h_snow_date1 | smallint              | 
 max_24h_snow_date2 | smallint              | 
 snowdepth          | smallint              | 
 snowdepth_date     | smallint              | 
 clear_days         | smallint              | 
 pcloud_days        | smallint              | 
 cloud_days         | smallint              | 
 remarks            | character varying(20) | 
Indexes:
    "cli_asos_monthly_pk" PRIMARY KEY, btree (station_code, month)
    "p189_250" UNIQUE, btree (station_code, month)

@mjames-upc
Copy link
Member Author

mjames-upc commented Oct 16, 2018 •
edited
Loading 

DefaultDataRequest(datatype=climate, identifiers={'table': 'public.cli_asos_monthly'}, 
                   parameters=[], levels=[], locationNames=[], envelope=None)

@mjames-upc
Copy link
Member Author

mjames-upc commented Oct 16, 2018 •
edited
Loading 

ERROR 2018-10-16 19:38:23,238 3005 [qtp534951830-4227] ThriftSrvRequestLogger: EDEX: ThriftSrvRequestLogger - Error executing request: com.raytheon.uf.common.dataaccess.request.GetAvailableParametersRequest@78441339:
com.raytheon.uf.common.dataaccess.exception.DataRetrievalException: Error retrieving climate data (failed query="select column_name from information_schema.columns where table_schema = 'public' and table_name = 'cli_asos_monthly';")
        at com.raytheon.uf.common.dataaccess.util.DatabaseQueryUtil.executeDatabaseQuery(DatabaseQueryUtil.java:129) ~[com.raytheon.uf.common.dataaccess.jar:na]
        at com.raytheon.uf.common.dataaccess.impl.AbstractGeometryDatabaseFactory.executeQuery(AbstractGeometryDatabaseFactory.java:238) ~[com.raytheon.uf.common.dataaccess.jar:na]
        at com.raytheon.uf.common.dataaccess.impl.AbstractGeometryDatabaseFactory.getAvailableParameters(AbstractGeometryDatabaseFactory.java:259) ~[com.raytheon.uf.common.dataaccess.jar:na]
        at com.raytheon.uf.common.dataaccess.DataAccessLayer.getAvailableParameters(DataAccessLayer.java:254) ~[com.raytheon.uf.common.dataaccess.jar:na]
        at com.raytheon.uf.edex.dataaccess.handler.GetAvailableParametersHandler.handleRequest(GetAvailableParametersHandler.java:49) ~[com.raytheon.uf.edex.dataaccess.jar:na]
        at com.raytheon.uf.edex.dataaccess.handler.GetAvailableParametersHandler.handleRequest(GetAvailableParametersHandler.java:1) ~[com.raytheon.uf.edex.dataaccess.jar:na]
        at com.raytheon.uf.edex.requestsrv.RequestServiceExecutor.execute(RequestServiceExecutor.java:155) ~[com.raytheon.uf.edex.requestsrv.jar:na]
        at com.raytheon.uf.edex.requestsrv.serialization.SerializingStreamExecutor.execute(SerializingStreamExecutor.java:107) ~[com.raytheon.uf.edex.requestsrv.jar:na]
        at com.raytheon.uf.edex.requestsrv.serialization.ByteLimitingStreamExecutor.execute(ByteLimitingStreamExecutor.java:76) [com.raytheon.uf.edex.requestsrv.jar:na]
        at com.raytheon.uf.edex.requestsrv.http.HttpRequestServiceExecutor.execute(HttpRequestServiceExecutor.java:102) [com.raytheon.uf.edex.requestsrv.jar:na]
        at sun.reflect.GeneratedMethodAccessor137.invoke(Unknown Source) ~[na:na]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_101]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_101]
...

relevant part

(failed query="select column_name from information_schema.columns where table_schema = 'public' and table_name = 'cli_asos_monthly';")

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@mjames-upc