Packs button throws error validating task 'CheckActive' (check). Error during XRequest

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When checking the Centralized Agent Upgrade by clicking on the "Packs" option in Administration perspective, the following error shows in the AWI:

2019-08-09 10:49:18,044 pool-2-thread-30 [ERROR] PreProd:0/USER/DEPT 0 0000000001454068 [com.uc4.webui.common.errorhandling.Safe] - An error occurred while validating task 'CheckActive' (check). Error during XRequest com.uc4.communication.requests.ActivityList. Error during XRequest com.uc4.communication.requests.ActivityList
com.uc4.ecc.plugins.actioncommon.utils.UIException$UIUnexpectedException: An error occurred while validating task 'CheckActive' (check). Error during XRequest com.uc4.communication.requests.ActivityList. Error during XRequest com.uc4.communication.requests.ActivityList
at com.uc4.ecc.plugins.actioncommon.utils.UIException.transform(UIException.java:88)
at com.uc4.ecc.plugins.actioncommon.utils.UIException.transform(UIException.java:53)
at com.uc4.ecc.plugins.actioncommon.apm.APMOperation.renderResult(APMOperation.java:110)
at com.uc4.ecc.plugins.actioncommon.apm.APMOperation.process(APMOperation.java:105)
at com.uc4.ecc.plugins.actioncommon.apm.APMOperation.validate(APMOperation.java:76)
at com.uc4.ecc.plugins.actionmanager.content.model.PackActiveObjectHandler.loadActiveObjects(PackActiveObjectHandler.java:105)
at com.uc4.ecc.plugins.actionmanager.content.model.PackActiveObjectHandler.getActiveObjects(PackActiveObjectHandler.java:73)
at com.uc4.ecc.plugins.actionmanager.content.view.install.ProcessVerifyPackActiveObjectStep.onStart(ProcessVerifyPackActiveObjectStep.java:59)
at com.uc4.ecc.plugins.actioncommon.uicore.RealtimeLoading.run(RealtimeLoading.java:81)
at com.uc4.ecc.framework.core.pool.ContextAwareExecutorService$RunnableImplementation.run(ContextAwareExecutorService.java:44)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

WP log also shows:
U00003590 UCUDB - DB error: 'SQLBindParameter', 'ERROR ', 'HY104', 'Invalid precision value''.'

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

Troubleshooting:

Check the database driver version and database version

Resolution:

An unsupported version of SQL Server was used.  Please confirm compatibility here: https://downloads.automic.com/tools/compatibility_matrix?compatibility-mode=component&lifecycle_entity_id=1409143059253&component_id=1409731986667&version_id=1637003273101