Job(Datamart Rollup – Time Fact and Time Summary) Error (Cursor Operation SQL Server)
search cancel

Job(Datamart Rollup – Time Fact and Time Summary) Error (Cursor Operation SQL Server)

book

Article ID: 246099

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

The Datamart Rollup job fails on a SQL Server database with BG log error:

ERROR 2022-06-30 02:14:14,428 [Dispatch Datamart Rollup - Time Facts and Time Summary : bg@<host> (tenant=clarity)] niku.njs (clarity:admin:session:Datamart Rollup - Time Facts and Time Summary) Error executing job: 5605111
com.niku.union.persistence.PersistenceException: 
SQL error code: 16943
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Could not complete cursor operation because the table schema changed after the cursor was declared.
SQL error code: 16917
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cursor is not open.
SQL error code: 16917
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cursor is not open.
SQL error code: 0
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Time: 0
SQL error code: 0
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Rolling up NBI_FM_PROJECT_TIME_SUMMARY

 

Environment

Release : 16.0.2

 

Resolution

The cursor error points alludes to an issue with the tempdb sharing between databases installed on the server.

1. Proceed to delete all cancelled jobs in the Scheduled jobs page 
2. Then run the job as an immediate job to check if it fails. 
To resolve the issue, schedule the job to a different time from what it is currently scheduled.