!SESSION 2017-11-27 11:30:07.748 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.8.0_131
java.vendor=Oracle Corporation
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_CA
Command-line arguments:  -os win32 -ws win32 -arch x86_64

!ENTRY org.locationtech.udig.ui 1 0 2017-11-27 11:30:30.646
!MESSAGE Unable to parse version from about.mappings file. Defaulting to a blank string.

!ENTRY org.eclipse.ui 4 4 2017-11-27 11:30:32.821
!MESSAGE Plugin org.wcs.smart, extension org.eclipse.ui.perspectiveExtensions, id org.wcs.smart.view.browser: Attribute 'relative' not defined.  This attribute is required when relationship="stack".

!ENTRY org.eclipse.ui 4 4 2017-11-27 11:30:32.837
!MESSAGE Unable to process element: view in perspective extension: null

!ENTRY org.eclipse.ui 4 4 2017-11-27 11:30:32.850
!MESSAGE Plugin org.wcs.smart.connect.dataqueue, extension org.eclipse.ui.perspectiveExtensions, id org.wcs.smart.connect.dataqueue.queueview: Attribute 'relative' not defined.  This attribute is required when relationship="stack".

!ENTRY org.eclipse.ui 4 4 2017-11-27 11:30:32.861
!MESSAGE Unable to process element: view in perspective extension: null

!ENTRY org.locationtech.udig.ui 1 0 2017-11-27 11:30:33.726
!MESSAGE EnablementUtil: Expected child of org.wcs.smart.actionTool but didn't find one...

!ENTRY org.eclipse.ui 2 2 2017-11-27 11:30:34.145
!MESSAGE Invalid preference category path: org.eclipse.ui.preferencePages.Workbench (bundle: org.eclipse.equinox.security.ui, page: org.eclipse.equinox.security.ui.category)

!ENTRY org.locationtech.udig.project 1 0 2017-11-27 11:30:35.646
!MESSAGE After 2 seconds unable to cancel road Renderer

!ENTRY org.locationtech.udig.project 1 0 2017-11-27 11:30:35.664
!MESSAGE After 2 seconds unable to cancel Patrol Sectors Renderer

!ENTRY org.locationtech.udig.project 1 0 2017-11-27 11:30:35.685
!MESSAGE After 2 seconds unable to cancel road Renderer

!ENTRY org.locationtech.udig.project 1 0 2017-11-27 11:30:35.700
!MESSAGE After 2 seconds unable to cancel Patrol Sectors Renderer

!ENTRY org.locationtech.udig.project 1 0 2017-11-27 11:30:35.715
!MESSAGE After 2 seconds unable to cancel All Layers Renderer

!ENTRY org.eclipse.ui 4 4 2017-11-27 11:30:56.934
!MESSAGE Plugin org.wcs.smart, extension org.eclipse.ui.perspectiveExtensions, id org.wcs.smart.view.browser: Attribute 'relative' not defined.  This attribute is required when relationship="stack".

!ENTRY org.eclipse.ui 4 4 2017-11-27 11:30:56.942
!MESSAGE Unable to process element: view in perspective extension: null

!ENTRY org.eclipse.ui 4 4 2017-11-27 11:30:56.949
!MESSAGE Plugin org.wcs.smart.connect.dataqueue, extension org.eclipse.ui.perspectiveExtensions, id org.wcs.smart.connect.dataqueue.queueview: Attribute 'relative' not defined.  This attribute is required when relationship="stack".

!ENTRY org.eclipse.ui 4 4 2017-11-27 11:30:56.956
!MESSAGE Unable to process element: view in perspective extension: null

!ENTRY org.locationtech.udig.project 1 0 2017-11-27 11:30:58.686
!MESSAGE After 2 seconds unable to cancel road Renderer

!ENTRY org.locationtech.udig.project 1 0 2017-11-27 11:30:58.703
!MESSAGE After 2 seconds unable to cancel road Renderer

!ENTRY org.locationtech.udig.project 1 0 2017-11-27 11:30:58.714
!MESSAGE After 2 seconds unable to cancel Patrol Sectors Renderer

!ENTRY org.locationtech.udig.project 1 0 2017-11-27 11:30:58.721
!MESSAGE After 2 seconds unable to cancel All Layers Renderer

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.142
!MESSAGE DROP TABLE query_temp_1

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.152
!MESSAGE DROP TABLE query_temp_2

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.162
!MESSAGE CREATE TABLE query_temp_1(p_ca_uuid char(16) for bit data,p_uuid char(16) for bit data,p_id varchar(32),p_station_uuid char(16) for bit data,p_team_uuid char(16) for bit data,p_objective varchar(8192),p_mandate_uuid  char(16) for bit data,p_type varchar(6),p_is_armed boolean,p_start_date date,p_end_date date,pl_uuid char(16) for bit data,pl_id varchar(50),pl_transport_uuid char(16) for bit data,pl_start_date date,pl_end_date date,pld_uuid char(16) for bit data,pld_patrol_day date,wp_uuid char(16) for bit data,ob_uuid char(16) for bit data,plm_leader char(16) for bit data,plm_pilot char(16) for bit data)

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.235
!MESSAGE CREATE INDEX query_temp_1_ob_uuid_idx on query_temp_1(ob_uuid)

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.314
!MESSAGE CREATE INDEX query_temp_1_wp_uuid_idx on query_temp_1(wp_uuid)

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.422
!MESSAGE INSERT INTO query_temp_1 SELECT DISTINCT p.ca_uuid, p.uuid, p.id, p.station_uuid, p.team_uuid, p.objective, pl.mandate_uuid, p.patrol_type, p.is_armed, p.start_date, p.end_date, pl.uuid, pl.id, pl.transport_uuid, pl.start_date, pl.end_date, pld.uuid, pld.patrol_day, wp.uuid, wpo.uuid, plm_leader.employee_uuid, plm_pilot.employee_uuid  FROM smart.patrol p inner join smart.patrol_leg pl on p.uuid = pl.patrol_uuid  AND (p.ca_uuid IN (:param_0)) inner join smart.patrol_leg_day pld on pl.uuid = pld.patrol_leg_uuid  left join smart.patrol_leg_members plm_leader  on pl.uuid = plm_leader.patrol_leg_uuid and  plm_leader.is_leader  left join smart.patrol_leg_members plm_pilot  on pl.uuid = plm_pilot.patrol_leg_uuid and  plm_pilot.is_pilot  left join smart.patrol_waypoint pwp on pld.uuid = pwp.leg_day_uuid  left join smart.waypoint wp on pwp.wp_uuid = wp.uuid  left join smart.wp_observation wpo on wp.uuid = wpo.wp_uuid 

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.514
!MESSAGE x'8f7fbe1b201a4ef4bda814f5581e65ce, 

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.594
!MESSAGE DROP TABLE query_temp_3

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.604
!MESSAGE SELECT count(localkey) as value,tile_id FROM (SELECT distinct wpo.uuid as localkey, smart.computeTileId(wp.x,wp.y,:param_0,:param_1,:param_2,:param_3) as tile_id  FROM smart.wp_observation as wpo JOIN query_temp_1 on wpo.uuid = query_temp_1.ob_uuid JOIN smart.dm_category as c on wpo.category_uuid = c.uuid AND hkey >= :param_4 AND hkey < :param_5 JOIN smart.waypoint as wp on wp.uuid = query_temp_1.wp_uuid) as foo  group by tile_id

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.643
!MESSAGE humanactivity., humanactivity/, GEOGCS["WGS 84", 
  DATUM["World Geodetic System 1984", 
    SPHEROID["WGS 84", 6378137.0, 298.257223563, AUTHORITY["EPSG","7030"]], 
    AUTHORITY["EPSG","6326"]], 
  PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]], 
  UNIT["degree", 0.017453292519943295], 
  AXIS["Geodetic longitude", EAST], 
  AXIS["Geodetic latitude", NORTH], 
  AUTHORITY["EPSG","4326"]], 0.0, 0.0, 0.01, 

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.676
!MESSAGE SELECT t.geometry as geom  FROM smart.track t join smart.patrol_leg_day pld on pld.uuid = t.patrol_leg_day_uuid join smart.patrol_leg pl on pl.uuid = pld.patrol_leg_uuid join smart.patrol p on p.uuid = pl.patrol_uuid and p.ca_uuid IN (:param_0)

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.705
!MESSAGE x'8f7fbe1b201a4ef4bda814f5581e65ce, 

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.713
!MESSAGE DROP TABLE query_temp_1

!ENTRY org.wcs.smart.query 1 0 2017-11-27 11:31:44.921
!MESSAGE DROP TABLE query_temp_2

!ENTRY org.wcs.smart.query 4 0 2017-11-27 11:31:44.938
!MESSAGE Could not execute query.

java.lang.ClassCastException: com.vividsolutions.jts.geom.MultiLineString cannot be cast to com.vividsolutions.jts.geom.LineString
!STACK 0
org.hibernate.exception.GenericJDBCException: error executing work
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
	at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:319)
	at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2340)
	at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2325)
	at org.wcs.smart.patrol.query.engine.DerbyGridEngine.executeQuery(DerbyGridEngine.java:144)
	at org.wcs.smart.query.common.engine.QueryExecutor.executeQuery(QueryExecutor.java:61)
	at org.wcs.smart.query.common.ui.GriddedEditor$3.run(GriddedEditor.java:179)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:56)
Caused by: java.sql.SQLException: java.lang.ClassCastException: com.vividsolutions.jts.geom.MultiLineString cannot be cast to com.vividsolutions.jts.geom.LineString
	at org.wcs.smart.patrol.query.engine.DerbyGridEngine$1.execute(DerbyGridEngine.java:241)
	at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37)
	at org.hibernate.internal.SessionImpl$1.accept(SessionImpl.java:2321)
	at org.hibernate.internal.SessionImpl$1.accept(SessionImpl.java:2318)
	at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:314)
	... 6 more
Caused by: java.lang.ClassCastException: com.vividsolutions.jts.geom.MultiLineString cannot be cast to com.vividsolutions.jts.geom.LineString
	at org.wcs.smart.patrol.query.engine.DerbyGridEngine.computePatrolTrackNoFilter(DerbyGridEngine.java:733)
	at org.wcs.smart.patrol.query.engine.DerbyGridEngine.computePatrolExistance(DerbyGridEngine.java:587)
	at org.wcs.smart.patrol.query.engine.DerbyGridEngine.access$4(DerbyGridEngine.java:579)
	at org.wcs.smart.patrol.query.engine.DerbyGridEngine$1.execute(DerbyGridEngine.java:212)
	... 10 more