The following errors are observed in the TSSA Live Reporting yellowfin.log files: YF:2019-02-13 15:50:07:ERROR (DBAction:doSelect) - Error occured selecting data: java.sql.SQLException: Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. |
This error can be encountered in environments which use MS SQL Server as the backend DB for TSSA Live Reporting's Yellowfin DB: If encountered, ask the DBA to run the following commands on the Yellowfin DB instance. ALTER DATABASE <DATABASENAME> SET ALLOW_SNAPSHOT_ISOLATION ON ALTER DATABASE <DATABASENAME> SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE No service restart is required. These settings are documented for the TSSA DB but also need to be set on the Yellowfin DB: https://docs.bmc.com/docs/display/tssa89/Walkthrough%3A+Setting+up+a+SQL+Server+database |