Credentials multiple attempts invalid

mjocasio
Giga Contributor

I have an application which uses a jdbc connection to connect to sap hana table for query. Apparently the application sometimes recognizes the credentials and execute the in schedule three tables. One schedule at 6:00 am and two other same time 10:00 am. Apparently, the application attemp multiple times locking the sap hana account. Can it be the MID Server which does not contains latest credentials change ....  

2 REPLIES 2

Tanushree Maiti
Tera Patron

Hi @mjocasio 

 

After consecutive 2/3 times failure , generally Application ID got locked. 

Check with Hana Team to know whether the user id got locked.

Request for the password and update it in your data source.

 

Check System log for exact error. Till the issue is solved, stop scheduled job(if any) /manual run.

 

 

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti

mjocasio
Giga Contributor

Yes the account is currently lock according SAP HANA administrator. Im requesting user to suspend the schedule tasks. Another information i could provide, the account password was reset a couple of days ago. According to the user the new password was updated in the data source of the JDBC connection properties. So is there any other place the application needs to be refresh . Example Mid Server ???? Guessing.