After applying HotFix HF10 on top of CA 4.2.2 and restarted Process Automation, getting below error message in C2O log: Operand type clash: nvarchar is incompatible Which results in Ca Service Catalog requests not launching instances.

book

Article ID: 7803

calendar_today

Updated On:

Products

CA Process Automation Base

Issue/Introduction

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.

Cause

DB user doesn't have the DBO(Database Owner) permission while starting the PAM after applying this HotFix.

 

Environment

Release:
Component: ITPAM

Resolution

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.

Additional Information

DBO(Database Owner) permissions are required whenever we upgrade OR apply any patch which involves DB Schema changes.