When attempting to publish a Batch Class with a Kofax Analytics for Capture (KAFC) workflow agent included, then an error is received and the Batch Class is not published successfully.
The Kofax Capture ERR Log is not shown with any related errors but, the KAFC Listener Logs are shown with a similar error.
Test Connections from the KAFC Workflow Agent and Listener are successful and the Insight Dashboard View is accessible.
Checking for errors... Can't send publish data to Analytics
How can this issue be resolved?
IIS DefaultAppPool Identity.
The issue encountered during the Batch Class publishing can be due to the configured IIS DefaultAppPool Identity.
An example of the error in the Listener Log is below:
KAFC LISTENER LOG: 2017-11-14T13:19:09.0180907-05:00, Can't send publish data to Analytics: System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]: Can`t open connection to database. Login failed for user 'US\CWD1-001256$'. (Fault Detail is equal to An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is: AltoSoft.Insight.DBCore.AltoSoftDBException: Can`t open connection to database. Login failed for user 'US\CWD1-001256$'. ----> System.Data.SqlClient.SqlException: Login failed for user 'US\CWD1- 001256$'. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePoole...).
At least one case using two KAFC Listeners and a Load Balancer had a specific Application Pool Identity for the DefaultAppPool. Once that Identity was updated to match the explicit Domain User and an IIS Reset was completed, then the error was no longer received during Batch Class publishing.
Steps to Resolve:
- Access the Application Pools for each of the KAFC Listeners such as with INETMGR
- Right-Click on the KAFC Listener and select: Set Application Pool Defaults...
- Scroll To & Expand: Process Model
- Set the 'Identity' to the Domain/User or 'Network Service' & click OK to save changes
- Complete an IISRESET on each of the affected Listeners
Level of Complexity