TXEB Monthly Filings by County & Chapter
as of Friday, May 1, 2015 12:5:0 AM

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

Could not do an indexed read to get the next row.
 
The error occurred in D:\Inetpub\wwwroot\cgi-bin\reports\monthlyfilingsdump.cfm: line 15
13 : as of <cfoutput>#DateFormat(Now(),'dddd, mmmm d, yyyy')# #Timeformat(now(),'h:m:s tt')#</cfoutput>
14 : <hr />
15 : <cfquery name="q_stat" datasource="txeb_live">
16 : 	select year(cs_date_filed) as year, month(cs_date_filed) as month, substr(co_translation,1,15) as county, cs_chapter, count(*) as filings
17 : 	from case, codes

VENDORERRORCODE   -246
SQLSTATE   IX000
SQL    select year(cs_date_filed) as year, month(cs_date_filed) as month, substr(co_translation,1,15) as county, cs_chapter, count(*) as filings from case, codes where cs_date_filed >= '1-1-2004' and cs_type='bk' and co_type='county' and co_code=cs_county group by 1,2,3,4 order by 1,2,3,4
DATASOURCE   txeb_live
Resources:

Browser   CFSCHEDULE
Remote Address   156.119.204.123
Referrer  
Date/Time   01-May-15 12:05 AM
Stack Trace
at cfmonthlyfilingsdump2ecfm1112853277.runPage(D:\Inetpub\wwwroot\cgi-bin\reports\monthlyfilingsdump.cfm:15) at cfmonthlyfilingsdump2ecfm1112853277.runPage(D:\Inetpub\wwwroot\cgi-bin\reports\monthlyfilingsdump.cfm:15)

java.sql.SQLException: Could not do an indexed read to get the next row.
	at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3118)
	at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3400)
	at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2317)
	at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2242)
	at com.informix.jdbc.IfxSqli.a(IfxSqli.java:1554)
	at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2170)
	at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2125)
	at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java:367)
	at com.informix.jdbc.IfxStatement.a(IfxStatement.java:1142)
	at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1118)
	at com.informix.jdbc.IfxStatement.c(IfxStatement.java:864)
	at com.informix.jdbc.IfxStatement.execute(IfxStatement.java:804)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1364)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1127)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1058)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
	at cfmonthlyfilingsdump2ecfm1112853277.runPage(D:\Inetpub\wwwroot\cgi-bin\reports\monthlyfilingsdump.cfm:15)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	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:200)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Caused by: java.sql.SQLException: ISAM error: record is locked.
	at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:407)
	at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3405)
	... 49 more