struct
Cause
struct
ErrorCode 28000
Message ORA-28000: the account is locked
SQLState 99999
StackTrace java.sql.SQLException: ORA-28000: the account is locked at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:777) at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:423) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553) at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:165) at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:614) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67) at java.lang.Thread.run(Thread.java:748)
Suppressed
array [empty]
TagContext
array [empty]
Type java.sql.SQLException
DataSource GROW_COSING_EUROPA_OCI
Detail ORA-28000: the account is locked
ErrorCode 99999
Exceptions
array
1
struct
class java.sql.SQLException
message ORA-28000: the account is locked
Message Error Executing Database Query.
NativeErrorCode 28000
RootCause
struct
ErrorCode 28000
Message ORA-28000: the account is locked
SQLState 99999
StackTrace java.sql.SQLException: ORA-28000: the account is locked at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:777) at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:423) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553) at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:165) at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:614) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67) at java.lang.Thread.run(Thread.java:748)
Suppressed
array [empty]
TagContext
array [empty]
Type java.sql.SQLException
SQLState 99999
Sql SELECT v2.ing_sub_id, v2.ing_sub_cd, v2.ing_fl, v2.sub_fl, v2.dsp_name, Upper(v2.inci) As inci, v2.inn, v2.ph_eur, v2.cas_no, v2.ec_no, v2.iupac, v2.restriction, v2.chemical_descr, v2.chemical_structure, v2.ref_no, v2.sub_name, v2.colour, v2.content_f, v2.content_g, v2.content_h, v2.content_i, v2.content_j, TO_CHAR (v2.allowed_until_dt, 'dd/mm/yyyy') allowed_until_dt, v2.part_id, v2.part_no, v2.annex_cd, v2.directive_txt, v1.directive_txt As Regulated, DECODE (v2.dir_application_dt, NULL, '-', TO_CHAR (v2.dir_application_dt, 'dd/mm/yyyy')) dir_application_dt, DECODE (v2.dir_withdrawal_dt, NULL, '-', TO_CHAR (v2.dir_withdrawal_dt, 'dd/mm/yyyy')) dir_withdrawal_dt, v2.note_txt, v2.status, v2.last_version_fl, v2.version_no, TO_CHAR (v2.obsolete_dt, 'dd/mm/yyyy') obsolete_dt, TO_CHAR (v2.classification_date, 'dd/mm/yyyy') classification_date, v2.visible_fl FROM cosing.cos2_vw_europa_ing_sub v2,cosing.cos_vw_europa_ing_sub v1 WHERE v2.ing_sub_id = v1.ing_sub_id(+) AND v2.ing_sub_id = (param 1)
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:867) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cffmx_IngSub2ecfc1171639857$funcGETINGSUBBYID_V2.runFunction(/ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/components/fmx_IngSub.cfc:730) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfact_details2ecfm777197110.runPage(/ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/model/search/act_details.cfm:17) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfsearch2edetails_v22ecfm510407781.runPage(/ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/parsed/search.details_v2.cfm:37) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cffusebox52ecfm774727685.runPage(/ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/fusebox5/fusebox5.cfm:179) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfindex2ecfm1826671289.runPage(/ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/index.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:195) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2555) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2544) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: ORA-28000: the account is locked at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:777) at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:423) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553) at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:165) at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:614) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67) ... 1 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 730
RAW_TRACE at cffmx_IngSub2ecfc1171639857$funcGETINGSUBBYID_V2.runFunction(/ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/components/fmx_IngSub.cfc:730)
TEMPLATE /ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/components/fmx_IngSub.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 17
RAW_TRACE at cfact_details2ecfm777197110.runPage(/ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/model/search/act_details.cfm:17)
TEMPLATE /ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/model/search/act_details.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 37
RAW_TRACE at cfsearch2edetails_v22ecfm510407781.runPage(/ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/parsed/search.details_v2.cfm:37)
TEMPLATE /ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/parsed/search.details_v2.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 179
RAW_TRACE at cffusebox52ecfm774727685.runPage(/ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/fusebox5/fusebox5.cfm:179)
TEMPLATE /ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/fusebox5/fusebox5.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 2
RAW_TRACE at cfindex2ecfm1826671289.runPage(/ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/index.cfm:2)
TEMPLATE /ec/prod/app/cf_by_DG/GROW/cosing/growth/tools-databases/cosing/index.cfm
TYPE CFML
Type Database
queryError ORA-28000: the account is locked
where (param 1) = [type='IN', class='java.lang.String', value='32382', sqltype='cf_sql_numeric', scale='0']