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/22.214.171.124/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.
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.
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.