Not possible to start JWP using "Windows Authentication".

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

Error Message :
Error message in the JWP log:
20171220/115709.933 - U00003590 UCUDB - DB error: '08S01', 'This driver is not configured for integrated authentication. ClientConnectionId:ada2a0df-50b0-4b18-8650-aaddd25a998d', '0', 'com.microsoft.sqlserver.jdbc.SQLServerException'
20171220/115710.089 - U00003432 Termination of Server 'AE12#WP' initiated

It is not possible to start Automic's Java Worker Process (JWP) using "Windows Authentication".

 

Another possible error message is the following:

Monitoring Data could not be retrieved. No JWP active.

Hide Details

(Stacktrace)

 

Error during XRequest com.uc4.communication.requests.TaskList

com.uc4.ecc.backends.exceptions.AutomationEngineAPIException

com.uc4.ecc.backends.util.APICallHelper.sendRequestAndWait(APICallHelper.java:57) com.uc4.ecc.backends.impl.dataservice.request.RequestService.lambda$sendAndWait$4(RequestService.java:65) com.uc4.ecc.framework.core.async.VaadinSessionLockUtil.reportLock(VaadinSessionLockUtil.java:89) com.uc4.ecc.backends.impl.dataservice.request.RequestService.sendAndWait(RequestService.java:65) com.uc4.ecc.backends.impl.dataservice.request.RequestService.sendAndWait(RequestService.java:85) com.uc4.ecc.backends.dataservice.request.IRequestService$pbryglu.sendAndWait(Unknown Source) com.uc4.ecc.plugins.ae.common.views.processmonitoringlist.processmonitoringtable.ProcessMonitoringListTableController.load(ProcessMonitoringListTableController.java:449) com.uc4.ecc.plugins.ae.common.views.processmonitoringlist.processmonitoringtable.ProcessMonitoringListTableController.load(ProcessMonitoringListTableController.java:54) com.uc4.ecc.framework.commons.controls.datatable.BaseDataTableController$2.loadWithNullOrEmptyAsDefault(BaseDataTableController.java:111) com.uc4.webui.common.async.EmptyCollectionOrNullAsDefaultLoader.load(EmptyCollectionOrNullAsDefaultLoader.java:12) com.uc4.webui.common.async.EmptyCollectionOrNullAsDefaultLoader.load(EmptyCollectionOrNullAsDefaultLoader.java:6) com.uc4.ecc.framework.core.async.BaseRequestCoordinator$1$1.call(BaseRequestCoordinator.java:223) com.uc4.ecc.framework.core.pool.ContextAwareExecutorService$CallableImplementation.call(ContextAwareExecutorService.java:72) java.util.concurrent.FutureTask.run(Unknown Source) java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.lang.Thread.run(Unknown Source)

Message box received: 3200 of type E with inserts shown, message 'No JWP active.'.

com.uc4.webui.util.MessageBoxException

com.uc4.webui.util.MessageBoxException.provoke(MessageBoxException.java:33) com.uc4.ecc.backends.util.APICallHelper.sendRequestAndWait(APICallHelper.java:52) com.uc4.ecc.backends.impl.dataservice.request.RequestService.lambda$sendAndWait$4(RequestService.java:65) com.uc4.ecc.framework.core.async.VaadinSessionLockUtil.reportLock(VaadinSessionLockUtil.java:89) com.uc4.ecc.backends.impl.dataservice.request.RequestService.sendAndWait(RequestService.java:65) com.uc4.ecc.backends.impl.dataservice.request.RequestService.sendAndWait(RequestService.java:85) com.uc4.ecc.backends.dataservice.request.IRequestService$pbryglu.sendAndWait(Unknown Source) com.uc4.ecc.plugins.ae.common.views.processmonitoringlist.processmonitoringtable.ProcessMonitoringListTableController.load(ProcessMonitoringListTableController.java:449) com.uc4.ecc.plugins.ae.common.views.processmonitoringlist.processmonitoringtable.ProcessMonitoringListTableController.load(ProcessMonitoringListTableController.java:54) com.uc4.ecc.framework.commons.controls.datatable.BaseDataTableController$2.loadWithNullOrEmptyAsDefault(BaseDataTableController.java:111) com.uc4.webui.common.async.EmptyCollectionOrNullAsDefaultLoader.load(EmptyCollectionOrNullAsDefaultLoader.java:12) com.uc4.webui.common.async.EmptyCollectionOrNullAsDefaultLoader.load(EmptyCollectionOrNullAsDefaultLoader.java:6) com.uc4.ecc.framework.core.async.BaseRequestCoordinator$1$1.call(BaseRequestCoordinator.java:223) com.uc4.ecc.framework.core.pool.ContextAwareExecutorService$CallableImplementation.call(ContextAwareExecutorService.java:72) java.util.concurrent.FutureTask.run(Unknown Source) java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.lang.Thread.run(Unknown Source)

Environment

OS: All Windows

Cause

Cause type:
Other
Root Cause: The latest 6.2.2 JDBC driver from Microsoft are required for this to work.

Resolution

Download the latest 6.2.2 JDBC driver from Microsoft and follow these steps:

1. Rename mssql-jdbc-6.2.2.jre8.jar to sqljdbc4.jar and put it in <AE installation>\bin\lib directory
2. Put the sqljdbc_auth.dll in <AE installation>\bin directory
3. Make sure to set the integratedSecurity=true parameter in the SQLDRIVERCONNECT setting for jdbc in the ucsrv.ini file(s).

Fix Status: No Fix

Fix Version(s):
N/A

Additional Information

Workaround :
N/A