IBM Support

webMethods Knowlegebase : Analysis schema - ORA-28000: the account is locked (1753666)

Troubleshooting


Problem

Analysis schema used by Optimize Analytic Engine to connect to Oracle database is locked very frequently without any indication of why it is locked. There is no user interaction with the database using Analysis schema so it is not caused by incorrect password.

This error is logged in <SAG>\optimize\analysis\logs\error.log when it happens, and the errors are logged several times every second, affecting database performance until the schema is unlocked manually to stop the errors.

() [JDBCPools.admin.1100] 2014-01-14 23:04:27.975 CST ERROR: Failed to create connection due to SQLException-- URL 'jdbc:wm:oracle://xxxxxx', user 'xxxxxx', reason: [28000] [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-28000: the account is locked

Document Location

Worldwide

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSAWP1J","label":"IBM webMethods BPM"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Optimize Base Engine (OBE)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Win Server 2003 Enterprise Edt"}],"Version":"8.2.1"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
20 March 2025

UID

ibm17193566

Page Feedback