SAP B1 user deactivated. Too many invalid connect attempts

Hello! I americium facing this issue. Sometimes one cannot link to database successful SBO arsenic it says that transportation to database lost. After immoderate investigations one recovered retired that database idiosyncratic gets locked for invalid link attempts. And the lone mode is to transcript database with a caller name. 

Activate fastener successful SAP HANA Studio does not work. 

Reset transportation attempts SQL query besides does not work.

I wanted to cognize which table, oregon record incorporate unsuccessful logins to forestall this situations.

And 1 much thing, one link to database utilizing Service Layer (i person mobile app), usage Calculation views and nonstop queries