2018-01-14 13:33:28 Commons Daemon procrun stderr initialized 14-Jan-2018 13:33:30.849 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.24 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Nov 27 2017 13:05:30 UTC 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.24.0 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows Server 2012 R2 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 6.3 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: x86 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:\Program Files (x86)\Java\jre1.8.0_151 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_151-b12 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\temp 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\conf\logging.properties 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: exit 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: abort 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms128m 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx256m 14-Jan-2018 13:33:30.927 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\;D:\Program Files\Microsoft SQL Server\130\Tools\Binn\;D:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;D:\Program Files\Microsoft SQL Server\130\DTS\Binn\;D:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;D:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;D:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\;C:\Program Files\nodejs\;C:\Program Files (x86)\Java\jre1.8.0_151\bin;;.] 14-Jan-2018 13:33:31.584 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-80"] 14-Jan-2018 13:33:31.802 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read 14-Jan-2018 13:33:31.818 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"] 14-Jan-2018 13:33:31.818 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read 14-Jan-2018 13:33:31.818 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1940 ms 14-Jan-2018 13:33:31.849 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina] 14-Jan-2018 13:33:31.849 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.24 14-Jan-2018 13:33:31.881 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\webapps\ODKAggregate.war] 14-Jan-2018 13:33:48.151 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file 14-Jan-2018 13:33:48.167 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/ODKAggregate] startup failed due to previous errors 14-Jan-2018 13:33:48.198 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [ODKAggregate] registered the JDBC driver [com.microsoft.sqlserver.jdbc.SQLServerDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. 14-Jan-2018 13:33:48.198 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.checkThreadLocalMapForLeaks The web application [ODKAggregate] created a ThreadLocal with key of type [com.microsoft.sqlserver.jdbc.ActivityCorrelator$1] (value [com.microsoft.sqlserver.jdbc.ActivityCorrelator$1@1a5d102]) and a value of type [com.microsoft.sqlserver.jdbc.ActivityId] (value [31732a27-54aa-41c5-80dc-5c96476d86e4-17]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. 14-Jan-2018 13:33:48.276 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\webapps\ODKAggregate.war] has finished in [16,395] ms 14-Jan-2018 13:33:48.276 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\webapps\host-manager] 14-Jan-2018 13:33:48.355 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\webapps\host-manager] has finished in [79] ms 14-Jan-2018 13:33:48.355 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\webapps\manager] 14-Jan-2018 13:33:48.433 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\webapps\manager] has finished in [78] ms 14-Jan-2018 13:33:48.433 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\webapps\ROOT] 14-Jan-2018 13:33:48.480 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\webapps\ROOT] has finished in [47] ms 14-Jan-2018 13:33:48.480 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-80"] 14-Jan-2018 13:33:48.495 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"] 14-Jan-2018 13:33:48.495 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 16669 ms 14-Jan-2018 13:35:55.959 SEVERE [http-nio-80-exec-10] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file 14-Jan-2018 13:35:55.959 SEVERE [http-nio-80-exec-10] org.apache.catalina.core.StandardContext.startInternal Context [/ODKAggregate] startup failed due to previous errors 14-Jan-2018 13:35:55.990 WARNING [http-nio-80-exec-10] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [ODKAggregate] registered the JDBC driver [com.microsoft.sqlserver.jdbc.SQLServerDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. 14-Jan-2018 13:35:55.991 SEVERE [http-nio-80-exec-10] org.apache.catalina.loader.WebappClassLoaderBase.checkThreadLocalMapForLeaks The web application [ODKAggregate] created a ThreadLocal with key of type [com.microsoft.sqlserver.jdbc.ActivityCorrelator$1] (value [com.microsoft.sqlserver.jdbc.ActivityCorrelator$1@84924a]) and a value of type [com.microsoft.sqlserver.jdbc.ActivityId] (value [10b8d74e-5b87-4769-8a99-2f7354a7a163-18]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. e 'hasRole('ROLE_ADMINISTER_TABLES')' for /aggregateui/odktablesadmin Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /aggregateui/serverdataservice Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /aggregateui/serverdiffservice Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /aggregateui/servertableservice Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_ADMINISTER_TABLES')' for /aggregateui/servertableaclservice Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /aggregateui/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /images/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /javascript/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /res/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /stylesheets/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /access-denied.html Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /over-quota.html Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /robots.txt Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /service-error.html Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /AggregateUI.css Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /favicon.ico Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /index.html Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /logout.html Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /odk_color.png Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /multimode_login.html Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /relogin.html Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'isFullyAuthenticated() and (hasAuthority('AUTH_LOCAL') or hasAuthority('AUTH_ACTIVE_DIRECTORY'))' for /local_login.html Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /formList Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /formXml Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_OWNER')' for /submission Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_OWNER')' for /formUpload Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_OWNER')' for /upload Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /xformsDownload Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /xformsList Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /xformsManifest Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_USER')' for /www/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_VIEWER') or hasRole('ROLE_ATTACHMENT_VIEWER')' for /view/binaryData Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_VIEWER')' for /view/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_OWNER')' for /auth/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SITE_ACCESS_ADMIN')' for /ssl/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER') or hasRole('ROLE_SITE_ACCESS_ADMIN')' for /enk/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /gae/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /remote_api Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/manifest/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/files/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/* Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/properties/* Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/* Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/clientVersions Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'isFullyAuthenticated() and hasRole('ROLE_USER')' for /odktables/*/privilegesInfo Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'isFullyAuthenticated() and hasRole('ROLE_USER')' for /odktables/*/usersInfo Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/installationInfo Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/diff/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/diff Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/query/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/attachments/*/manifest Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/attachments/*/download Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/attachments/*/upload Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/attachments/*/file/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/rows/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/rows Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/installationStatus Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_ADMINISTER_TABLES')' for /odktables/*/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_USER')' for /odktables/ Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_USER')' for /odktables Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES') or hasRole('ROLE_ADMINISTER_TABLES')' for /appLevelFileUpload/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES') or hasRole('ROLE_ADMINISTER_TABLES')' for /tableFileUpload/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES') or hasRole('ROLE_ADMINISTER_TABLES')' for /tableFileDownload/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES') or hasRole('ROLE_ADMINISTER_TABLES')' for /tableKeyValueManifest/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_ADMINISTER_TABLES')' for /uploadTableFromCSV/** Jan 14, 2018 1:33:33 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'isAnonymous()' for /** Jan 14, 2018 1:33:33 PM org.springframework.beans.factory.config.PropertyPlaceholderConfigurer loadProperties INFO: Loading properties file from class path resource [jdbc.properties] Jan 14, 2018 1:33:33 PM org.springframework.beans.factory.config.PropertyPlaceholderConfigurer loadProperties INFO: Loading properties file from class path resource [security.properties] Jan 14, 2018 1:33:33 PM org.springframework.beans.factory.config.PropertyPlaceholderConfigurer loadProperties INFO: Loading properties file from class path resource [logging.properties] Jan 14, 2018 1:33:33 PM org.springframework.beans.factory.config.PropertyPlaceholderConfigurer loadProperties INFO: Loading properties file from class path resource [jdbc.properties] Jan 14, 2018 1:33:33 PM org.springframework.beans.factory.config.PropertyPlaceholderConfigurer loadProperties INFO: Loading properties file from class path resource [security.properties] Jan 14, 2018 1:33:33 PM org.springframework.beans.factory.config.PropertyPlaceholderConfigurer loadProperties INFO: Loading properties file from class path resource [logging.properties] Jan 14, 2018 1:33:33 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: Version: v1.4.15 Production Jan 14, 2018 1:33:33 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: Hostname: laborm-srv.itsector.gov.eg Jan 14, 2018 1:33:33 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: Port: 80 Jan 14, 2018 1:33:33 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: SecurePort: 8443 Jan 14, 2018 1:33:33 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: SslIsRequired: no Jan 14, 2018 1:33:33 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: SslIsAvailable: no Jan 14, 2018 1:33:33 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: RealmString: ELMPS2018 ODK Aggregate Jan 14, 2018 1:33:33 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: isGaeEnvironment: no Jan 14, 2018 1:33:33 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: java.library.path: C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\;D:\Program Files\Microsoft SQL Server\130\Tools\Binn\;D:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;D:\Program Files\Microsoft SQL Server\130\DTS\Binn\;D:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;D:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;D:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\;C:\Program Files\nodejs\;C:\Program Files (x86)\Java\jre1.8.0_151\bin;;. Jan 14, 2018 1:33:33 PM org.opendatakit.common.security.spring.UserServiceImpl afterPropertiesSet INFO: superUserEmail: null Jan 14, 2018 1:33:33 PM org.opendatakit.common.security.spring.UserServiceImpl afterPropertiesSet INFO: superUserUsername: admin Jan 14, 2018 1:33:33 PM org.opendatakit.common.security.spring.UserServiceImpl reloadPermissions INFO: Executing: reloadPermissions Jan 14, 2018 1:33:33 PM org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler initialize INFO: Initializing ExecutorService 'task_scheduler' Jan 14, 2018 1:33:33 PM org.opendatakit.common.security.spring.RoleHierarchyImpl refreshReachableGrantedAuthorities INFO: Executing: refreshReachableGrantedAuthorities Jan 14, 2018 1:33:34 PM com.microsoft.sqlserver.jdbc.AuthenticationJNI WARNING: Failed to load the sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path Jan 14, 2018 1:33:48 PM org.opendatakit.common.security.spring.RoleHierarchyImpl refreshReachableGrantedAuthorities WARNING: Datastore failure: refreshReachableGrantedAuthorities -- adjusting retry time Jan 14, 2018 1:33:48 PM org.springframework.web.context.support.XmlWebApplicationContext refresh WARNING: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hierarchicalRoleRelationships' defined in ServletContext resource [/WEB-INF/applicationContext-security.xml]: Invocation of init method failed; nested exception is org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:913806f3-a612-4e26-8f21-75eda73f9795) Jan 14, 2018 1:33:48 PM org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler shutdown INFO: Shutting down ExecutorService 'task_scheduler' Jan 14, 2018 1:33:48 PM org.springframework.web.context.ContextLoader initWebApplicationContext SEVERE: Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hierarchicalRoleRelationships' defined in ServletContext resource [/WEB-INF/applicationContext-security.xml]: Invocation of init method failed; nested exception is org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:913806f3-a612-4e26-8f21-75eda73f9795) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1583) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:754) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:986) at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:913806f3-a612-4e26-8f21-75eda73f9795) at org.opendatakit.common.persistence.engine.sqlserver.DatastoreImpl.assertRelation(DatastoreImpl.java:713) at org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.assertRelation(GrantedAuthorityHierarchyTable.java:115) at org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.getEntireGrantedAuthorityHierarchy(GrantedAuthorityHierarchyTable.java:186) at org.opendatakit.common.security.spring.RoleHierarchyImpl.buildRolesReachableInOneStepMap(RoleHierarchyImpl.java:465) at org.opendatakit.common.security.spring.RoleHierarchyImpl.refreshReachableGrantedAuthorities(RoleHierarchyImpl.java:282) at org.opendatakit.common.security.spring.RoleHierarchyImpl.afterPropertiesSet(RoleHierarchyImpl.java:132) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1642) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1579) ... 25 more Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:913806f3-a612-4e26-8f21-75eda73f9795) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:252) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) at org.opendatakit.common.persistence.engine.sqlserver.DatastoreImpl.assertRelation(DatastoreImpl.java:558) ... 32 more Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:913806f3-a612-4e26-8f21-75eda73f9795) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:211) ... 34 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:913806f3-a612-4e26-8f21-75eda73f9795 at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2307) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:73) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3000) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:81) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2992) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7024) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2350) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1932) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1612) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1458) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:840) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:561) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290) ... 37 more Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path at java.lang.ClassLoader.loadLibrary(Unknown Source) at java.lang.Runtime.loadLibrary0(Unknown Source) at java.lang.System.loadLibrary(Unknown Source) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:48) ... 51 more Jan 14, 2018 1:33:48 PM org.apache.catalina.core.StandardContext listenerStart SEVERE: Exception sending context initialized event to listener instance of class [org.springframework.web.context.ContextLoaderListener] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hierarchicalRoleRelationships' defined in ServletContext resource [/WEB-INF/applicationContext-security.xml]: Invocation of init method failed; nested exception is org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:913806f3-a612-4e26-8f21-75eda73f9795) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1583) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:754) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:986) at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:913806f3-a612-4e26-8f21-75eda73f9795) at org.opendatakit.common.persistence.engine.sqlserver.DatastoreImpl.assertRelation(DatastoreImpl.java:713) at org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.assertRelation(GrantedAuthorityHierarchyTable.java:115) at org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.getEntireGrantedAuthorityHierarchy(GrantedAuthorityHierarchyTable.java:186) at org.opendatakit.common.security.spring.RoleHierarchyImpl.buildRolesReachableInOneStepMap(RoleHierarchyImpl.java:465) at org.opendatakit.common.security.spring.RoleHierarchyImpl.refreshReachableGrantedAuthorities(RoleHierarchyImpl.java:282) at org.opendatakit.common.security.spring.RoleHierarchyImpl.afterPropertiesSet(RoleHierarchyImpl.java:132) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1642) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1579) ... 25 more Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:913806f3-a612-4e26-8f21-75eda73f9795) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:252) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) at org.opendatakit.common.persistence.engine.sqlserver.DatastoreImpl.assertRelation(DatastoreImpl.java:558) ... 32 more Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:913806f3-a612-4e26-8f21-75eda73f9795) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:211) ... 34 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:913806f3-a612-4e26-8f21-75eda73f9795 at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2307) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:73) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3000) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:81) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2992) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7024) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2350) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1932) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1612) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1458) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:840) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:561) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290) ... 37 more Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path at java.lang.ClassLoader.loadLibrary(Unknown Source) at java.lang.Runtime.loadLibrary0(Unknown Source) at java.lang.System.loadLibrary(Unknown Source) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:48) ... 51 more Jan 14, 2018 1:33:48 PM org.apache.catalina.core.ApplicationContext log INFO: Closing Spring root WebApplicationContext Jan 14, 2018 1:35:40 PM org.apache.catalina.core.ApplicationContext log INFO: No Spring WebApplicationInitializer types detected on classpath Jan 14, 2018 1:35:40 PM org.apache.catalina.core.ApplicationContext log INFO: Initializing Spring root WebApplicationContext Jan 14, 2018 1:35:40 PM org.springframework.web.context.ContextLoader initWebApplicationContext INFO: Root WebApplicationContext: initialization started Jan 14, 2018 1:35:40 PM org.springframework.web.context.support.XmlWebApplicationContext prepareRefresh INFO: Refreshing Root WebApplicationContext: startup date [Sun Jan 14 13:35:40 GMT+02:00 2018]; root of context hierarchy Jan 14, 2018 1:35:40 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions INFO: Loading XML bean definitions from class path resource [odk-settings.xml] Jan 14, 2018 1:35:40 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions INFO: Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext-security.xml] Jan 14, 2018 1:35:40 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions INFO: Loading XML bean definitions from class path resource [odk-security-settings.xml] Jan 14, 2018 1:35:40 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions INFO: Loading XML bean definitions from class path resource [odk-common-security-settings.xml] Jan 14, 2018 1:35:40 PM org.springframework.security.core.SpringSecurityCoreVersion performVersionChecks INFO: You are running with Spring Security Core 4.2.0.RELEASE Jan 14, 2018 1:35:40 PM org.springframework.security.config.SecurityNamespaceHandler INFO: Spring Security 'config' module version is 4.2.0.RELEASE Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /_ah/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_USER') or hasRole('ROLE_SITE_ACCESS_ADMIN')' for /Aggregate.html Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_USER')' for /aggregateui/preferenceservice Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_USER') or hasRole('ROLE_SITE_ACCESS_ADMIN')' for /aggregateui/securityservice Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_VIEWER')' for /aggregateui/filterservice Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_VIEWER')' for /aggregateui/submissionservice Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_VIEWER')' for /aggregateui/formservice Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_OWNER')' for /aggregateui/formadminservice Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_OWNER')' for /aggregateui/servicesadminservice Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SITE_ACCESS_ADMIN')' for /aggregateui/securityadminservice Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_ADMINISTER_TABLES')' for /aggregateui/odktablesadmin Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /aggregateui/serverdataservice Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /aggregateui/serverdiffservice Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /aggregateui/servertableservice Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_ADMINISTER_TABLES')' for /aggregateui/servertableaclservice Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /aggregateui/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /images/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /javascript/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /res/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /stylesheets/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /access-denied.html Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /over-quota.html Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /robots.txt Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /service-error.html Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /AggregateUI.css Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /favicon.ico Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /index.html Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /logout.html Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /odk_color.png Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /multimode_login.html Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /relogin.html Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'isFullyAuthenticated() and (hasAuthority('AUTH_LOCAL') or hasAuthority('AUTH_ACTIVE_DIRECTORY'))' for /local_login.html Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /formList Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /formXml Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_OWNER')' for /submission Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_OWNER')' for /formUpload Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_OWNER')' for /upload Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /xformsDownload Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /xformsList Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER')' for /xformsManifest Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_USER')' for /www/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_VIEWER') or hasRole('ROLE_ATTACHMENT_VIEWER')' for /view/binaryData Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_VIEWER')' for /view/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_OWNER')' for /auth/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SITE_ACCESS_ADMIN')' for /ssl/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_DATA_COLLECTOR') or hasRole('ROLE_DATA_VIEWER') or hasRole('ROLE_SITE_ACCESS_ADMIN')' for /enk/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /gae/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'true' for /remote_api Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/manifest/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/files/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/* Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/properties/* Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/* Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/clientVersions Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'isFullyAuthenticated() and hasRole('ROLE_USER')' for /odktables/*/privilegesInfo Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'isFullyAuthenticated() and hasRole('ROLE_USER')' for /odktables/*/usersInfo Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/installationInfo Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/diff/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/diff Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/query/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/attachments/*/manifest Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/attachments/*/download Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/attachments/*/upload Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/attachments/*/file/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/rows/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/rows Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES')' for /odktables/*/tables/*/ref/*/installationStatus Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_ADMINISTER_TABLES')' for /odktables/*/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_USER')' for /odktables/ Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_USER')' for /odktables Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES') or hasRole('ROLE_ADMINISTER_TABLES')' for /appLevelFileUpload/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES') or hasRole('ROLE_ADMINISTER_TABLES')' for /tableFileUpload/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES') or hasRole('ROLE_ADMINISTER_TABLES')' for /tableFileDownload/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_SYNCHRONIZE_TABLES') or hasRole('ROLE_ADMINISTER_TABLES')' for /tableKeyValueManifest/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'hasRole('ROLE_ADMINISTER_TABLES')' for /uploadTableFromCSV/** Jan 14, 2018 1:35:40 PM org.springframework.security.config.http.FilterInvocationSecurityMetadataSourceParser parseInterceptUrlsForFilterInvocationRequestMap INFO: Creating access control expression attribute 'isAnonymous()' for /** Jan 14, 2018 1:35:40 PM org.springframework.beans.factory.config.PropertyPlaceholderConfigurer loadProperties INFO: Loading properties file from class path resource [jdbc.properties] Jan 14, 2018 1:35:40 PM org.springframework.beans.factory.config.PropertyPlaceholderConfigurer loadProperties INFO: Loading properties file from class path resource [security.properties] Jan 14, 2018 1:35:40 PM org.springframework.beans.factory.config.PropertyPlaceholderConfigurer loadProperties INFO: Loading properties file from class path resource [logging.properties] Jan 14, 2018 1:35:40 PM org.springframework.beans.factory.config.PropertyPlaceholderConfigurer loadProperties INFO: Loading properties file from class path resource [jdbc.properties] Jan 14, 2018 1:35:40 PM org.springframework.beans.factory.config.PropertyPlaceholderConfigurer loadProperties INFO: Loading properties file from class path resource [security.properties] Jan 14, 2018 1:35:40 PM org.springframework.beans.factory.config.PropertyPlaceholderConfigurer loadProperties INFO: Loading properties file from class path resource [logging.properties] Jan 14, 2018 1:35:40 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: Version: v1.4.15 Production Jan 14, 2018 1:35:40 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: Hostname: laborm-srv.itsector.gov.eg Jan 14, 2018 1:35:40 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: Port: 80 Jan 14, 2018 1:35:40 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: SecurePort: 8443 Jan 14, 2018 1:35:40 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: SslIsRequired: no Jan 14, 2018 1:35:40 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: SslIsAvailable: no Jan 14, 2018 1:35:40 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: RealmString: ELMPS2018 ODK Aggregate Jan 14, 2018 1:35:40 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: isGaeEnvironment: no Jan 14, 2018 1:35:40 PM org.opendatakit.common.security.Realm afterPropertiesSet INFO: java.library.path: C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\;D:\Program Files\Microsoft SQL Server\130\Tools\Binn\;D:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;D:\Program Files\Microsoft SQL Server\130\DTS\Binn\;D:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;D:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;D:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\;C:\Program Files\nodejs\;C:\Program Files (x86)\Java\jre1.8.0_151\bin;;. Jan 14, 2018 1:35:40 PM org.opendatakit.common.security.spring.UserServiceImpl afterPropertiesSet INFO: superUserEmail: null Jan 14, 2018 1:35:40 PM org.opendatakit.common.security.spring.UserServiceImpl afterPropertiesSet INFO: superUserUsername: admin Jan 14, 2018 1:35:40 PM org.opendatakit.common.security.spring.UserServiceImpl reloadPermissions INFO: Executing: reloadPermissions Jan 14, 2018 1:35:40 PM org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler initialize INFO: Initializing ExecutorService 'task_scheduler' Jan 14, 2018 1:35:41 PM org.opendatakit.common.security.spring.RoleHierarchyImpl refreshReachableGrantedAuthorities INFO: Executing: refreshReachableGrantedAuthorities Jan 14, 2018 1:35:41 PM com.microsoft.sqlserver.jdbc.AuthenticationJNI WARNING: Failed to load the sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path Jan 14, 2018 1:35:55 PM org.opendatakit.common.security.spring.RoleHierarchyImpl refreshReachableGrantedAuthorities WARNING: Datastore failure: refreshReachableGrantedAuthorities -- adjusting retry time Jan 14, 2018 1:35:55 PM org.springframework.web.context.support.XmlWebApplicationContext refresh WARNING: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hierarchicalRoleRelationships' defined in ServletContext resource [/WEB-INF/applicationContext-security.xml]: Invocation of init method failed; nested exception is org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:5e1948a8-8815-4cfd-948c-fcb1d96ed641) Jan 14, 2018 1:35:55 PM org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler shutdown INFO: Shutting down ExecutorService 'task_scheduler' Jan 14, 2018 1:35:55 PM org.springframework.web.context.ContextLoader initWebApplicationContext SEVERE: Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hierarchicalRoleRelationships' defined in ServletContext resource [/WEB-INF/applicationContext-security.xml]: Invocation of init method failed; nested exception is org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:5e1948a8-8815-4cfd-948c-fcb1d96ed641) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1583) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:754) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1309) at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:665) at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:211) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:136) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108) 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:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:621) at org.apache.catalina.valves.RequestFilterValve.process(RequestFilterValve.java:348) at org.apache.catalina.valves.RemoteAddrValve.invoke(RemoteAddrValve.java:52) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:5e1948a8-8815-4cfd-948c-fcb1d96ed641) at org.opendatakit.common.persistence.engine.sqlserver.DatastoreImpl.assertRelation(DatastoreImpl.java:713) at org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.assertRelation(GrantedAuthorityHierarchyTable.java:115) at org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.getEntireGrantedAuthorityHierarchy(GrantedAuthorityHierarchyTable.java:186) at org.opendatakit.common.security.spring.RoleHierarchyImpl.buildRolesReachableInOneStepMap(RoleHierarchyImpl.java:465) at org.opendatakit.common.security.spring.RoleHierarchyImpl.refreshReachableGrantedAuthorities(RoleHierarchyImpl.java:282) at org.opendatakit.common.security.spring.RoleHierarchyImpl.afterPropertiesSet(RoleHierarchyImpl.java:132) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1642) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1579) ... 50 more Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:5e1948a8-8815-4cfd-948c-fcb1d96ed641) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:252) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) at org.opendatakit.common.persistence.engine.sqlserver.DatastoreImpl.assertRelation(DatastoreImpl.java:558) ... 57 more Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:5e1948a8-8815-4cfd-948c-fcb1d96ed641) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:211) ... 59 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:5e1948a8-8815-4cfd-948c-fcb1d96ed641 at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2307) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:73) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3000) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:81) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2992) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7024) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2350) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1932) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1612) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1458) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:840) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:561) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290) ... 62 more Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path at java.lang.ClassLoader.loadLibrary(Unknown Source) at java.lang.Runtime.loadLibrary0(Unknown Source) at java.lang.System.loadLibrary(Unknown Source) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:48) ... 76 more Jan 14, 2018 1:35:55 PM org.apache.catalina.core.StandardContext listenerStart SEVERE: Exception sending context initialized event to listener instance of class [org.springframework.web.context.ContextLoaderListener] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hierarchicalRoleRelationships' defined in ServletContext resource [/WEB-INF/applicationContext-security.xml]: Invocation of init method failed; nested exception is org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:5e1948a8-8815-4cfd-948c-fcb1d96ed641) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1583) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:754) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1309) at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:665) at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:211) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:136) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108) 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:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:621) at org.apache.catalina.valves.RequestFilterValve.process(RequestFilterValve.java:348) at org.apache.catalina.valves.RemoteAddrValve.invoke(RemoteAddrValve.java:52) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: org.opendatakit.common.persistence.exception.ODKDatastoreException: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:5e1948a8-8815-4cfd-948c-fcb1d96ed641) at org.opendatakit.common.persistence.engine.sqlserver.DatastoreImpl.assertRelation(DatastoreImpl.java:713) at org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.assertRelation(GrantedAuthorityHierarchyTable.java:115) at org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.getEntireGrantedAuthorityHierarchy(GrantedAuthorityHierarchyTable.java:186) at org.opendatakit.common.security.spring.RoleHierarchyImpl.buildRolesReachableInOneStepMap(RoleHierarchyImpl.java:465) at org.opendatakit.common.security.spring.RoleHierarchyImpl.refreshReachableGrantedAuthorities(RoleHierarchyImpl.java:282) at org.opendatakit.common.security.spring.RoleHierarchyImpl.afterPropertiesSet(RoleHierarchyImpl.java:132) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1642) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1579) ... 50 more Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:5e1948a8-8815-4cfd-948c-fcb1d96ed641) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:252) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) at org.opendatakit.common.persistence.engine.sqlserver.DatastoreImpl.assertRelation(DatastoreImpl.java:558) ... 57 more Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:5e1948a8-8815-4cfd-948c-fcb1d96ed641) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:211) ... 59 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:5e1948a8-8815-4cfd-948c-fcb1d96ed641 at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2307) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:73) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3000) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:81) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2992) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7024) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2350) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1932) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1612) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1458) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:840) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:561) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290) ... 62 more Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path at java.lang.ClassLoader.loadLibrary(Unknown Source) at java.lang.Runtime.loadLibrary0(Unknown Source) at java.lang.System.loadLibrary(Unknown Source) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:48) ... 76 more Jan 14, 2018 1:35:55 PM org.apache.catalina.core.ApplicationContext log INFO: Closing Spring root WebApplicationContext