VERIFIED SOLUTION i
Product Features: Sagent Automation and BPA server
Issue
On execution of Sagent plan having Baseview as "trusted connection" option with the database produces "Task stopped with user error: Attempt to impersonate client security context failed”. error in BPA. The same issue also occurs in the older version of Opalis 4 Automation.
Cause
Sagent plan using "Trusted connection " with DB failed to execute successfully. It throws an error "Task stopped with user error: Attempt to impersonate client security context failed”.
Resolution
UPDATED: August 28, 2017The user needs to use "SQL Authentication" option while creating baseview with the database(s).