One of the SAP ASE (Sybase) agent collections causes many locks on Sybase SAP and the affected table cannot be promoted to a table lock.
The cause of the locks is due to a known issue with SAP ASE (https://help.sap.com/doc/a618a281bc2b1014953da09c84e1d2e4/16.0.3.7/en-US/SAP_ASE_Performance_Tuning_Locking_Concurrency_en.pdf).
If the database is upgraded to SAP ASE 16.0 SP03 this is not an issue.
WORKAROUND
This workaround will return a 0 count for TabRowCount.
To apply this change please do the following:
NOTE: This workaround must be applied after each Sybase SAP ASE cartridge upgrade.
STATUS
Enhancement ID FGDBSYB-I-9 has been created for this issue. This will be reviewed by Product Management for a future release of the SAP ASE cartridge.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center