After applying HotFix HF10 on top of PA 4.2.2 and restarted Process Automation, getting below error message in C2O log:
: java.lang.Throwable: java.sql.BatchUpdateException: Operand type clash: nvarchar is incompatible with image at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:1069)
Due to this, CAService catalog requests are not being received by Process Auto.
DB user doesn't have the DBO(Database Owner) permission while starting the PAM after applying this HotFix.
Please provide DBO permission to DB user for PAM.
HotFix HF10 contains DB schema changes related to ActiveMQ which got upgraded to latest version through this hotfix.
So, PAM must have DBO permission while starting the PAM after applying this HotFix.
DBO(Database Owner) permissions are required whenever we upgrade OR apply any patch which involves DB Schema changes.