search cancel

Users cannot Subscribe in ESP dSeries (DE) or it may take a very long time to complete during certain times

book

Article ID: 201876

calendar_today

Updated On:

Products

CA Workload Automation DE - Business Agents (dSeries) CA Workload Automation DE DSERIES- SERVER CA Workload Automation DE - System Agent (dSeries) CA Workload Automation DE - Scheduler (dSeries)

Issue/Introduction

Users are unable to subscribe from WA Desktop Client's Monitor perspective.  Errors similar to the following may be seen in the server tracelogs.

2020XXXX 00:00:12.345 [relationaldatabase] [ERROR] DM: [2020-XX-XX_00:00:12.345] SQLCode: 16943 SQLState: S0004 Message: Could not complete cursor operation because the table schema changed after the cursor was declared.

2020XXXX 00:00:12.345 [relationaldatabase] [ERROR] DM: [2020-XX-XX_00:00:12.345] SQL Exception for query: SELECT afm_id, afm_time_id, originator, destination, priority, afm  FROM ESP_MANAGER_INQ WHERE processing_status = 0; the exception is: Could not complete cursor operation because the table schema changed after the cursor was declared.
com.microsoft.sqlserver.jdbc.SQLServerException: Could not complete cursor operation because the table schema changed after the cursor was declared.

 

Cause

The database locks the tables for some maintenance procedure such as backup or rebuilding of indexes.  This will prevent the dSeries from getting a lock and reading the tables.  If the tables are not accessible then subscription and other functionalities will not work.

Environment

Release : 12.x

Component : CA WORKLOAD AUTOMATION DE (DSERIES)

OS: ANY

DB: ANY

Resolution

Most of the DB maintenance may not affect dSeries.  In some rare cases there can be a conflict if the tables are locked by an external process.  To prevent any issues, schedule the external maintenance during non-peak hours.  It is recommended to not run long maintenance jobs that can lock tables and other database artifacts.