PutSQL error: ORA-28000: the account is locked

[#1]

Hi everyone, i was trying to insert into Oracle 12c DB and i got the error "cannot create PoolableConnectionFactory (ORA-28000: the account is locked)". I have tried to run the insert statement generated manually and it worked fine but NiFi gives the account is locked error. What could possibly the cause of this error?

[#2 · Accepted solution]

Issue resolved! It was due to an account lock that was only discovered when i disconnected and tried reconnecting with SQL developer. Account has been unlocked and all good!