overrides javax.servlet.http.HttpServlet.doGet and doPost

[Michele Smith]

Hello in my eclipse IDE there are a couple of green triangles on lines 4 and 14 saying the following:

overrides javax.servlet.http.HttpServlet.doGet (line 4)
overrides javax.servlet.http.HttpServlet.doPost (line 14)

What should I do, I am also receiving an error on the server, an error 500 indicating the following:



javax.servlet.ServletException: String index out of range: 11
bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:106)
bcc.lib.BaseBccServlet.doGet(BaseBccServlet.java:54)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

servlet code as follows:

abstract public class BaseBccServlet extends HttpServlet
{    

	final public void doGet( HttpServletRequest req, HttpServletResponse res ) throws ServletException, IOException 
	{
		doPost( req, res );
	}
    
    
    /**
     * Method called for every servlet.  Get pointers to Context and BcSQLAgent
     * before calling {@link #doServletFunction} in subclasses.
     */
     public void doPost( HttpServletRequest req, HttpServletResponse res ) throws ServletException, IOException
    {
		Date startTime = new Date();

        Context ctx = null;
        BcSQLAgent agt = null;
        
        try {
        	
            Logger.fine( this, "doPost", "PAGE STARTING..." );

			// Grab pointer to Context and assign current Request to it.
	       	ctx = _getContext( req );

			// If no context is found, we've timed out; redirect to the Login page.
            // This will fail if the web application is not the default web-app,
            // there is just no good way to handle this.
			if (ctx == null)
			{
                Logger.info( this, "doPost", " CANNOT FIND CONTEXT; REDIRECTING TO Login DUE TO TIMEOUT." );
	            res.sendRedirect( "Login?timeout=T" );
				return;
			}

            // Obtain agent from context to pass onto {@link #doServletFunction}.
            agt = ctx.getAgent();

            if (!ServletFileUpload.isMultipartContent(req)){

		            // Determine whether current user is authorized for the concrete page;
					// if not, redirect to the Login page.
					if ( ! _isUserAuthorizedForThisPage( ctx, agt ) )
					{
						Logger.info( this, "doPost", " REDIRECTING TO Login DUE TO UNAUTHORIZED ACCESS." );
			            res.sendRedirect( ctx.getWebApp() + "Login?unauthorized=T" );
						return;
					}
            }

	       	// Method implemented in all base classes.
	       	doServletFunction( ctx, agt, req, res );
        }
        catch( Exception e ) {
            Logger.throwing( this, "doPost", e );
            throw new ServletException( e );
        }
        finally {

            // Free connection (if any).
        	if (ctx != null)
        	{
                if (agt != null) {
                    try {
                    	agt.releaseConnection();
                    }
                    catch( Exception e2 ) {
                        Logger.throwing( this, "doPost[releaseConnection]", e2 );
                    }
                    finally {
                        agt = null;
                    }
                }
                ctx = null;
        	}  // obtained Context
        	
			Date endTime = new Date();
			float elapsedMillis = (endTime.getTime() - startTime.getTime()) / 1000.0F;
			String elapsedSecs = new DecimalFormat( "#,##0.0" ).format( elapsedMillis );

            Logger.fine( this, "doPost", "PAGE DONE [secs=" + elapsedSecs + 
                    "; agents=" + BcSQLAgent.getRefCount() +
                    "; conns=" + BcConnection.getRefCount() +
                    "; openConns=" + BcConnection.getOpenConnectionCount() +
                    "]." );
        }  // finally
    }  // doPost()
    

[Bear Bibeault]

The errors have nothing to do with the green triangles, which are just informative.

This is the important part of the error:
javax.servlet.ServletException: String index out of range: 11
bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:106)

What do you think it's telling you?

[Michele Smith]

It occurs when you have
the "<" character without a matching ">" character in your text.
(Which you may have if you are writing math equations or programming
examples) There is a problem parsing this type of input in some text
fields at the moment.

???

[Bear Bibeault]

No. What's at line 106 in bcc.lib.BaseBccServlet?

That's where the exception is occurring according to:
bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:106)

[Michele Smith]

or that one of the fields is too big?

[Michele Smith]

throw new ServletException( e );

[Bear Bibeault]

At this point, we'll need to see the entire stack trace and entire servlet source (so that the line numbers in the code tag match up with the actual line numbers).

In particular, we need to see the root cause.

[Michele Smith]

all I have is the server log from today, it says this:

2012-04-19 11:01:54,035 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('IMAGE_ROOT') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:01:54,052 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('USER_THEME') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:01:54,828 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:01:55,216 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CER_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,221 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('COM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,226 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,230 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FUN_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,273 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,277 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,281 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_ACC_NUM') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,285 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_GST_NUMBER') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,289 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_LIC') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,296 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,323 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CASE_THEME') AND REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:01:55,337 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,342 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,347 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,351 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:55,357 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [8859723]
2012-04-19 11:01:55,390 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:01:55,716 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE CASE_ID = ?ORDERBY PARMS [15318092]
2012-04-19 11:01:56,805 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:01:56,890 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:01:57,311 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[DMTemplateLoader]] Servlet.service() for servlet DMTemplateLoader threw exception
java.lang.StringIndexOutOfBoundsException: String index out of range: 11
	at java.lang.String.substring(String.java:1765)
	at bcc.pages.documentManagement.DMTemplateLoader.doAction(DMTemplateLoader.java:4877)
	at bcc.lib.BaseDoServlet.doServletFunction(BaseDoServlet.java:30)
	at bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:102)
	at bcc.lib.BaseBccServlet.doGet(BaseBccServlet.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:595)
2012-04-19 11:02:01,731 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('IMAGE_ROOT') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:01,737 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('USER_THEME') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:02,444 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:02,779 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CER_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,785 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('COM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,791 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,798 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FUN_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,805 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,810 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,817 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_ACC_NUM') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,822 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_GST_NUMBER') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,827 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_LIC') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,831 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,866 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CASE_THEME') AND REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:02,881 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,886 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,891 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,896 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:02,907 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [8859723]
2012-04-19 11:02:02,941 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:03,283 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE CASE_ID = ?ORDERBY PARMS [15318092]
2012-04-19 11:02:04,429 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:04,515 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:04,963 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[DMTemplateLoader]] Servlet.service() for servlet DMTemplateLoader threw exception
java.lang.StringIndexOutOfBoundsException: String index out of range: 11
	at java.lang.String.substring(String.java:1765)
	at bcc.pages.documentManagement.DMTemplateLoader.doAction(DMTemplateLoader.java:4877)
	at bcc.lib.BaseDoServlet.doServletFunction(BaseDoServlet.java:30)
	at bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:102)
	at bcc.lib.BaseBccServlet.doGet(BaseBccServlet.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:595)
2012-04-19 11:02:07,490 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('IMAGE_ROOT') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:07,498 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('USER_THEME') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:08,109 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:08,496 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CER_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,544 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('COM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,555 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,561 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FUN_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,641 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,648 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,652 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_ACC_NUM') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,693 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_GST_NUMBER') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,697 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_LIC') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,703 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,735 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CASE_THEME') AND REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:08,748 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,753 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,760 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,764 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:08,771 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [8859723]
2012-04-19 11:02:08,804 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:09,137 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE CASE_ID = ?ORDERBY PARMS [15318092]
2012-04-19 11:02:10,253 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:10,334 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:10,784 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[DMTemplateLoader]] Servlet.service() for servlet DMTemplateLoader threw exception
java.lang.StringIndexOutOfBoundsException: String index out of range: 11
	at java.lang.String.substring(String.java:1765)
	at bcc.pages.documentManagement.DMTemplateLoader.doAction(DMTemplateLoader.java:4877)
	at bcc.lib.BaseDoServlet.doServletFunction(BaseDoServlet.java:30)
	at bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:102)
	at bcc.lib.BaseBccServlet.doGet(BaseBccServlet.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:595)
2012-04-19 11:02:14,502 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('IMAGE_ROOT') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:14,506 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('USER_THEME') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:15,197 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:15,547 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CER_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,555 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('COM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,561 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,568 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FUN_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,578 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,585 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,592 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_ACC_NUM') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,599 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_GST_NUMBER') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,603 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_LIC') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,607 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,648 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CASE_THEME') AND REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:15,663 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,668 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,673 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,678 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:15,688 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [8859723]
2012-04-19 11:02:15,726 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:16,083 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE CASE_ID = ?ORDERBY PARMS [15318092]
2012-04-19 11:02:17,270 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:17,357 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:17,834 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[DMTemplateLoader]] Servlet.service() for servlet DMTemplateLoader threw exception
java.lang.StringIndexOutOfBoundsException: String index out of range: 11
	at java.lang.String.substring(String.java:1765)
	at bcc.pages.documentManagement.DMTemplateLoader.doAction(DMTemplateLoader.java:4877)
	at bcc.lib.BaseDoServlet.doServletFunction(BaseDoServlet.java:30)
	at bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:102)
	at bcc.lib.BaseBccServlet.doGet(BaseBccServlet.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:595)
2012-04-19 11:02:20,692 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('IMAGE_ROOT') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:20,697 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('USER_THEME') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:21,311 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:21,630 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CER_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,635 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('COM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,643 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,647 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FUN_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,655 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,659 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,663 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_ACC_NUM') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,667 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_GST_NUMBER') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,707 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_LIC') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,711 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,741 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CASE_THEME') AND REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:21,755 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,760 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,765 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,772 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:21,778 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [8859723]
2012-04-19 11:02:21,809 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:22,128 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE CASE_ID = ?ORDERBY PARMS [15318092]
2012-04-19 11:02:23,231 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:23,324 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:23,764 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[DMTemplateLoader]] Servlet.service() for servlet DMTemplateLoader threw exception
java.lang.StringIndexOutOfBoundsException: String index out of range: 11
	at java.lang.String.substring(String.java:1765)
	at bcc.pages.documentManagement.DMTemplateLoader.doAction(DMTemplateLoader.java:4877)
	at bcc.lib.BaseDoServlet.doServletFunction(BaseDoServlet.java:30)
	at bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:102)
	at bcc.lib.BaseBccServlet.doGet(BaseBccServlet.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:595)
2012-04-19 11:02:26,646 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('IMAGE_ROOT') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:26,651 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('USER_THEME') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:27,345 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:27,748 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CER_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,753 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('COM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,759 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,763 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FUN_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,806 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,811 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,815 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_ACC_NUM') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,820 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_GST_NUMBER') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,827 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_LIC') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,832 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,863 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CASE_THEME') AND REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:27,879 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,884 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,889 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,894 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:27,901 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [8859723]
2012-04-19 11:02:27,936 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:28,288 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE CASE_ID = ?ORDERBY PARMS [15318092]
2012-04-19 11:02:29,427 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:29,514 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:29,957 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[DMTemplateLoader]] Servlet.service() for servlet DMTemplateLoader threw exception
java.lang.StringIndexOutOfBoundsException: String index out of range: 11
	at java.lang.String.substring(String.java:1765)
	at bcc.pages.documentManagement.DMTemplateLoader.doAction(DMTemplateLoader.java:4877)
	at bcc.lib.BaseDoServlet.doServletFunction(BaseDoServlet.java:30)
	at bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:102)
	at bcc.lib.BaseBccServlet.doGet(BaseBccServlet.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:595)
2012-04-19 11:02:34,826 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('IMAGE_ROOT') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:34,832 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('USER_THEME') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:35,458 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:35,799 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CER_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,803 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('COM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,808 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,816 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FUN_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,821 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,829 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,832 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_ACC_NUM') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,873 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_GST_NUMBER') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,877 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_LIC') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,883 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,926 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CASE_THEME') AND REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:35,941 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,946 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,951 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,957 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:35,964 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [8859723]
2012-04-19 11:02:35,995 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:36,312 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE CASE_ID = ?ORDERBY PARMS [15318092]
2012-04-19 11:02:37,374 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:37,454 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:37,875 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[DMTemplateLoader]] Servlet.service() for servlet DMTemplateLoader threw exception
java.lang.StringIndexOutOfBoundsException: String index out of range: 11
	at java.lang.String.substring(String.java:1765)
	at bcc.pages.documentManagement.DMTemplateLoader.doAction(DMTemplateLoader.java:4877)
	at bcc.lib.BaseDoServlet.doServletFunction(BaseDoServlet.java:30)
	at bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:102)
	at bcc.lib.BaseBccServlet.doGet(BaseBccServlet.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:595)
2012-04-19 11:02:42,751 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('IMAGE_ROOT') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:42,757 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('USER_THEME') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:43,490 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:43,826 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CER_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,831 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('COM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,837 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,845 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FUN_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,851 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,859 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,864 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_ACC_NUM') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,868 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_GST_NUMBER') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,873 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_LIC') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,880 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,915 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CASE_THEME') AND REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:43,930 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,935 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,941 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,945 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:43,952 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [8859723]
2012-04-19 11:02:43,991 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:44,333 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE CASE_ID = ?ORDERBY PARMS [15318092]
2012-04-19 11:02:45,476 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:45,563 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:46,007 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[DMTemplateLoader]] Servlet.service() for servlet DMTemplateLoader threw exception
java.lang.StringIndexOutOfBoundsException: String index out of range: 11
	at java.lang.String.substring(String.java:1765)
	at bcc.pages.documentManagement.DMTemplateLoader.doAction(DMTemplateLoader.java:4877)
	at bcc.lib.BaseDoServlet.doServletFunction(BaseDoServlet.java:30)
	at bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:102)
	at bcc.lib.BaseBccServlet.doGet(BaseBccServlet.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:595)
2012-04-19 11:02:53,420 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('IMAGE_ROOT') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:53,425 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('USER_THEME') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:54,075 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:54,429 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CER_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,436 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('COM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,441 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,445 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FUN_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,453 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,457 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,461 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_ACC_NUM') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,500 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_GST_NUMBER') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,504 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_LIC') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,508 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,541 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CASE_THEME') AND REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:54,554 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,558 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,563 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,567 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:54,574 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [8859723]
2012-04-19 11:02:54,604 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:54,934 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE CASE_ID = ?ORDERBY PARMS [15318092]
2012-04-19 11:02:56,043 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:02:56,132 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:02:56,563 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[DMTemplateLoader]] Servlet.service() for servlet DMTemplateLoader threw exception
java.lang.StringIndexOutOfBoundsException: String index out of range: 11
	at java.lang.String.substring(String.java:1765)
	at bcc.pages.documentManagement.DMTemplateLoader.doAction(DMTemplateLoader.java:4877)
	at bcc.lib.BaseDoServlet.doServletFunction(BaseDoServlet.java:30)
	at bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:102)
	at bcc.lib.BaseBccServlet.doGet(BaseBccServlet.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:595)
2012-04-19 11:02:59,797 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('IMAGE_ROOT') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:02:59,801 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('USER_THEME') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:03:00,510 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:03:00,860 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CER_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:00,868 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('COM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:00,874 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:00,879 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FUN_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:00,923 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:00,928 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:00,932 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_ACC_NUM') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:00,939 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_GST_NUMBER') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:00,944 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_LIC') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:00,948 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:00,984 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CASE_THEME') AND REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:03:00,996 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:01,004 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:01,010 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:01,014 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:01,021 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [8859723]
2012-04-19 11:03:01,056 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:03:01,420 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE CASE_ID = ?ORDERBY PARMS [15318092]
2012-04-19 11:03:02,627 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:02,719 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:03:03,171 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[DMTemplateLoader]] Servlet.service() for servlet DMTemplateLoader threw exception
java.lang.StringIndexOutOfBoundsException: String index out of range: 11
	at java.lang.String.substring(String.java:1765)
	at bcc.pages.documentManagement.DMTemplateLoader.doAction(DMTemplateLoader.java:4877)
	at bcc.lib.BaseDoServlet.doServletFunction(BaseDoServlet.java:30)
	at bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:102)
	at bcc.lib.BaseBccServlet.doGet(BaseBccServlet.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:595)
2012-04-19 11:03:05,692 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('IMAGE_ROOT') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:03:05,697 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('USER_THEME') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:03:06,385 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:03:06,736 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CER_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,741 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('COM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,745 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,749 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FUN_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,792 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,795 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,799 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_ACC_NUM') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,803 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_GST_NUMBER') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,807 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_LIC') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,814 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,842 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CASE_THEME') AND REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:03:06,856 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,861 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,866 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,870 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:06,876 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [8859723]
2012-04-19 11:03:06,907 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:03:07,231 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE CASE_ID = ?ORDERBY PARMS [15318092]
2012-04-19 11:03:08,314 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:08,408 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:03:08,839 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[DMTemplateLoader]] Servlet.service() for servlet DMTemplateLoader threw exception
java.lang.StringIndexOutOfBoundsException: String index out of range: 11
	at java.lang.String.substring(String.java:1765)
	at bcc.pages.documentManagement.DMTemplateLoader.doAction(DMTemplateLoader.java:4877)
	at bcc.lib.BaseDoServlet.doServletFunction(BaseDoServlet.java:30)
	at bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:102)
	at bcc.lib.BaseBccServlet.doGet(BaseBccServlet.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:595)
2012-04-19 11:03:11,633 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('IMAGE_ROOT') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:03:11,638 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('USER_THEME') AND REF_ID = 8967431 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:03:12,383 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:03:12,779 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CER_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,784 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('COM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,789 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,794 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FUN_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,804 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,809 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('FAM_ED_TXT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,813 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_ACC_NUM') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,821 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_GST_NUMBER') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,825 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_LIC') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,829 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,864 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('CASE_THEME') AND REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:03:12,876 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,881 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,886 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,895 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:12,902 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [8859723]
2012-04-19 11:03:12,937 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:03:13,294 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE CASE_ID = ?ORDERBY PARMS [15318092]
2012-04-19 11:03:14,505 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 8859234 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:03:14,593 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE REF_ID = 15318092 AND REF_TABLE = 'THE_CASE'ORDERBY PARMS []
2012-04-19 11:03:15,054 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[DMTemplateLoader]] Servlet.service() for servlet DMTemplateLoader threw exception
java.lang.StringIndexOutOfBoundsException: String index out of range: 11
	at java.lang.String.substring(String.java:1765)
	at bcc.pages.documentManagement.DMTemplateLoader.doAction(DMTemplateLoader.java:4877)
	at bcc.lib.BaseDoServlet.doServletFunction(BaseDoServlet.java:30)
	at bcc.lib.BaseBccServlet.doPost(BaseBccServlet.java:102)
	at bcc.lib.BaseBccServlet.doGet(BaseBccServlet.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
	at java.lang.Thread.run(Thread.java:595)
2012-04-19 11:15:25,654 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE USER_NAME = ?ORDERBY  PARMS [greenhillsadmin]
2012-04-19 11:15:25,663 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE USER_NAME = ? AND PASSWORD = ? ORDERBY  PARMS [greenhillsadmin, greenhillsadmin1]
2012-04-19 11:15:25,667 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE USER_NAME = ?ORDERBY  PARMS [greenhillsadmin]
2012-04-19 11:15:25,676 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE USER_NAME = ? AND PASSWORD = ? ORDERBY  PARMS [greenhillsadmin, greenhillsadmin1]
2012-04-19 11:15:25,728 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('IMAGE_ROOT') AND REF_ID = 12197388 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:15:25,762 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('USER_THEME') AND REF_ID = 12197388 AND REF_TABLE = 'APP_USER'ORDERBY PARMS []
2012-04-19 11:15:25,778 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,801 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_IS_WEB_HOME') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,802 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,805 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_THEME') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,814 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,817 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_DOCUMENT_SCHEME') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,828 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,829 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('HOME_QB_FILE') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,873 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [12197199]
2012-04-19 11:15:25,873 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE THEME_ID = ?ORDERBY PARMS [12197199]
2012-04-19 11:15:25,912 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('MMP_SERVICE_PACK_VERSION') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,913 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('MMP_SERVICE_PACK_VERSION') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,923 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('MMP_SERVICE_PACK_VERSION') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,926 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('MMP_SERVICE_PACK_VERSION') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,927 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('MMP_SERVICE_PACK_VERSION') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,928 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('NEXT_MMP_SERVICE_PACK_MONTH','NEXT_MMP_SERVICE_PACK_DAY','NEXT_MMP_SERVICE_PACK_YEAR') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,928 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('MMP_SERVICE_PACK_VERSION') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,930 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('NEXT_MMP_SERVICE_PACK_MONTH','NEXT_MMP_SERVICE_PACK_DAY','NEXT_MMP_SERVICE_PACK_YEAR') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,943 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('NEXT_MMP_SERVICE_PACK_READY') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,947 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('NEXT_MMP_SERVICE_PACK_READY') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,954 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('NEXT_MMP_SERVICE_PACK_READY') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,956 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT','VISIT_ED_TXT','FUN_ED_TXT','COM_ED_TXT','GAT_ED_TXT','CER_ED_TXT','FAM_ED_TXT','OS_FILE','VT_FILE','AV_FILE','AV_LINK','HOME_LIC','HOME_ACC_NUM','HOME_QB_FILE','CAS_ACC_CLASS','CAP_ACC_CLASS','COR_ACC_CLASS','CEN_ACC_CLASS','URN_ACC_CLASS','APP_ACC_CLASS','UEN_ACC_CLASS','BRCAS_ACC_CLASS','COCAS_ACC_CLASS','STCAS_ACC_CLASS','MECAS_ACC_CLASS','WOCAS_ACC_CLASS','CBURN_ACC_CLASS','SBURN_ACC_CLASS','CAURN_ACC_CLASS','MAURN_ACC_CLASS','CLURN_ACC_CLASS','OTURN_ACC_CLASS','WOURN_ACC_CLASS','HOME_GST_NUMBER','HOME_DOCUMENT_SCHEME') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,958 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('NEXT_MMP_SERVICE_PACK_READY') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:25,965 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('OUR_COMMITMENT','VISIT_ED_TXT','FUN_ED_TXT','COM_ED_TXT','GAT_ED_TXT','CER_ED_TXT','FAM_ED_TXT','OS_FILE','VT_FILE','AV_FILE','AV_LINK','HOME_LIC','HOME_ACC_NUM','HOME_QB_FILE','CAS_ACC_CLASS','CAP_ACC_CLASS','COR_ACC_CLASS','CEN_ACC_CLASS','URN_ACC_CLASS','APP_ACC_CLASS','UEN_ACC_CLASS','BRCAS_ACC_CLASS','COCAS_ACC_CLASS','STCAS_ACC_CLASS','MECAS_ACC_CLASS','WOCAS_ACC_CLASS','CBURN_ACC_CLASS','SBURN_ACC_CLASS','CAURN_ACC_CLASS','MAURN_ACC_CLASS','CLURN_ACC_CLASS','OTURN_ACC_CLASS','WOURN_ACC_CLASS','HOME_GST_NUMBER','HOME_DOCUMENT_SCHEME') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:26,067 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('NEXT_MMP_SERVICE_PACK_READY') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []
2012-04-19 11:15:26,077 INFO  [STDOUT] BcDOMAINOBJECT SELECT STATEMENT: WHERE WHERE ITEM IN ('NEXT_MMP_SERVICE_PACK_READY') AND REF_ID = 12196714 AND REF_TABLE = 'HOME'ORDERBY PARMS []

and here is the code for the servlet:

package bcc.lib;

import java.io.IOException;
import java.text.DecimalFormat;
import java.util.Collection;
import java.util.Date;
import java.util.Iterator;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.commons.fileupload.servlet.ServletFileUpload;

import com.bc.util.BcConnection;
import com.bc.util.BcSQLAgent;
import com.bc.util.BcUtil;
import com.bc.util.logging.Logger;

/**
 * 
 *
 * 
 * 
 *   
 *              
 *   
 *             
 *   
 *             
 *              
 *   
 *              
 *              
 *              
*   
 *    
 *              
 *               
 * 
 *
 * 
 *
 * 
 * 
 */
abstract public class BaseBccServlet extends HttpServlet
{    

	final public void doGet( HttpServletRequest req, HttpServletResponse res ) throws ServletException, IOException 
	{
		doPost( req, res );
	}
    
    
    /**
     * Method called for every servlet.  Get pointers to Context and BcSQLAgent
     * before calling {@link #doServletFunction} in subclasses.
     */
     public void doPost( HttpServletRequest req, HttpServletResponse res ) throws ServletException, IOException
    {
		Date startTime = new Date();

        Context ctx = null;
        BcSQLAgent agt = null;
        
        try {
        	
            Logger.fine( this, "doPost", "PAGE STARTING..." );

			// Grab pointer to Context and assign current Request to it.
	       	ctx = _getContext( req );

			// If no context is found, we've timed out; redirect to the Login page.
            // This will fail if the web application is not the default web-app,
            // there is just no good way to handle this.
			if (ctx == null)
			{
                Logger.info( this, "doPost", " CANNOT FIND CONTEXT; REDIRECTING TO Login DUE TO TIMEOUT." );
	            res.sendRedirect( "Login?timeout=T" );
				return;
			}

            // Obtain agent from context to pass onto {@link #doServletFunction}.
            agt = ctx.getAgent();

            if (!ServletFileUpload.isMultipartContent(req)){

		            // Determine whether current user is authorized for the concrete page;
					// if not, redirect to the Login page.
					if ( ! _isUserAuthorizedForThisPage( ctx, agt ) )
					{
						Logger.info( this, "doPost", " REDIRECTING TO Login DUE TO UNAUTHORIZED ACCESS." );
			            res.sendRedirect( ctx.getWebApp() + "Login?unauthorized=T" );
						return;
					}
            }

	       	// Method implemented in all base classes.
	       	doServletFunction( ctx, agt, req, res );
        }
        catch( Exception e ) {
            Logger.throwing( this, "doPost", e );
            throw new ServletException( e );
        }
        finally {

            // Free connection (if any).
        	if (ctx != null)
        	{
                if (agt != null) {
                    try {
                    	agt.releaseConnection();
                    }
                    catch( Exception e2 ) {
                        Logger.throwing( this, "doPost[releaseConnection]", e2 );
                    }
                    finally {
                        agt = null;
                    }
                }
                ctx = null;
        	}  // obtained Context
        	
			Date endTime = new Date();
			float elapsedMillis = (endTime.getTime() - startTime.getTime()) / 1000.0F;
			String elapsedSecs = new DecimalFormat( "#,##0.0" ).format( elapsedMillis );

            Logger.fine( this, "doPost", "PAGE DONE [secs=" + elapsedSecs + 
                    "; agents=" + BcSQLAgent.getRefCount() +
                    "; conns=" + BcConnection.getRefCount() +
                    "; openConns=" + BcConnection.getOpenConnectionCount() +
                    "]." );
        }  // finally
    }  // doPost()
    
    
    /******************************************************************
    * Overriden in subclasses to display HTML, update, etc.
    ******************************************************************/
	abstract public void doServletFunction( Context ctx, BcSQLAgent agt, HttpServletRequest req, HttpServletResponse res ) throws ServletException;

	
	/******************************************************************
	* Overridden in subclasses if they are only valid for one or more
	* roles.  If no role-requirement exists for that page, it can be
	* left as is.
    ******************************************************************/
	public Collection getAuthorizedRoles() {
		return null;
	}

    /******************************************************************
    * If concrete page overrides getAuthorizedRoles to a non-empty
	* list, make sure (1) user is currently set in Context, and (2)
	* that user's role is one of the authorized ones.
    * @return TRUE unless user is not authorized
    ******************************************************************/
    private boolean _isUserAuthorizedForThisPage( Context ctx, BcSQLAgent agt ) 
    {
        try {
        	
            Collection authRoles = getAuthorizedRoles();

            // If no roles are listed, any user can access the page.
            if (authRoles == null || authRoles.isEmpty()) return true;

            // If user (or his role) is not set, user can NOT access the page.
            String userRole = ctx.getUserRoleName( agt );
            if (userRole == null || userRole.length() == 0) return false;

            // Check each authorized role.  If any match, user can access the
            // page.
            for (Iterator it = authRoles.iterator(); it.hasNext(); )
            {
                String role = (String) it.next();
                if (role.equals(userRole)) return true;
            }

            return false;
        }
        catch( Exception e ) {
        	Logger.warning( this, "_isUserAuthorizedForThisPage", "Trapped and ignored exception: " + e.toString() );
            return false;
        }
    }  // _isUserAuthorizedForThisPage()


	/**
	 * Overridden in subclasses if a new Context should be created if
	 * none exists in the session.  Most likely the only pages that will
	 * override this to TRUE are the login/authorization pages.
     */
	public boolean canCreateContext() {
		return false;
	}


	/**
	 * Overridden in subclasses if existing context should be destroyed
     * before creating a new one; intended for logging in, changing users,
     * etc.
     */
	public boolean mustCreateContext() {
		return false;
	}


    /**
     * Helper function to strip spaces from given string.
     * @return String with spaces removed
     */
    protected String removeSpaces( final String sIn ) 
    {
        if ( !BcUtil.hasChars( sIn ) ) {
            return "";
        }

	    StringBuffer sb = new StringBuffer( sIn );
	    for (int i = sb.length() - 1; i >= 0; i--)
	    {
	        if (sb.charAt(i) == ' ')
	        {
	            sb.deleteCharAt(i);
	        }
	    }
        return sb.toString();
    }  // removeSpaces


    /**
 	 * Assign the current Session to the Context and return it.
     *
     * If the Context does not already reside in the Session, create it and
	 * put it there (if concrete page overrides canCreateContext() to
	 * TRUE) or just return null.
     *
     * If the subclass overrides {@link #mustCreateContext} to true, destroy
     * existing Context (if any) and create a new one.
	 *
	 * @return Context
     */
	final private Context _getContext( final HttpServletRequest req ) throws Exception
	{
		try {
		 
            HttpSession sess = req.getSession( true );
	        Context ctx = (Context) sess.getAttribute( "Context" );

            // If no context is found and the subclass cannot create a new one, just return null.
            if ( ctx == null && !canCreateContext() ) {
                Logger.info( this, "_getContext", "NO CONTEXT FOUND AND PAGE CANNOT CREATE ONE; RETURNING NULL." );
                return null;
            }

            // If Context is found but mustCreateContext() returns true, destroy it.
            if ( ctx != null && mustCreateContext() ) {
                Logger.info( this, "_getContext", "Destroying existing context and creating a new one." );
                sess.removeAttribute( "Context" );
                ctx = null;
            }

            // Okay, if we get here and ctx is null, go ahead and create a new one.
            if ( ctx == null ) {
                Logger.info( this, "_getContext", "Creating new Context." );
	            ctx = new Context( getServletContext(), sess );
	            sess.setAttribute( "Context", ctx );

				//	Default timeout to 12 hours.
				sess.setMaxInactiveInterval( 60 * 60 * 12 );
	        }else {// I know you have context get me your state
 	        	_getState( req, ctx );
	        }

	        return ctx;
		}
		catch( Exception e ) {
            Logger.throwing( this, "_getContext", e );
			throw e;
		}
	}  // _getContext(req)
	
	
	
	protected Context _getState( final HttpServletRequest req, Context ctx ) throws Exception
	{
		try {
			
			String loginstate= helperRequest(req,"login", "no");
			if("yes".equalsIgnoreCase(loginstate)){
				 return ctx; // He doesn't logged in yet
			}
		 
			String userid= helperRequest(req,"userid", "0");
			String mode= helperRequest(req,"mode", ""); 
			String parentid= helperRequest(req,"parentid", "0"); 
			String homeid= helperRequest(req,"homeid", "0");  
			String caseid= helperRequest(req,"caseid", "0"); 
			ctx.setMode(mode);
			ctx.setUser(userid);
			ctx.setParent(parentid);
			ctx.setHome(homeid);
			ctx.setCase(caseid);
			
	        return ctx;
		}
		catch( Exception e ) {
            Logger.throwing( this, "_getContext", e );
			throw e;
		}
	}  // _getContext(req)
	
	protected Context _getState( final com.oreilly.servlet.MultipartRequest multi, Context ctx ) throws Exception
	{
		try {
		    		      
			String userid= helperRequest(multi,"userid", "0");
			String mode= helperRequest(multi,"mode", ""); 
			String parentid= helperRequest(multi,"parentid", "0"); 
			String homeid= helperRequest(multi,"homeid", "0");  
			String caseid= helperRequest(multi,"caseid", "0"); 
			ctx.setMode(mode);
			ctx.setUser(userid);
			ctx.setParent(parentid);
			ctx.setHome(homeid);
			ctx.setCase(caseid);
			
	        return ctx;
		}
		catch( Exception e ) {
            Logger.throwing( this, "_getContext", e );
			throw e;
		}
	}  // _getContext(req)
	
	final protected String helperRequest( final HttpServletRequest req, String parm, String defaultValue){
		try {
			String value=req.getParameter(parm);
			if(value==null || "".equals(value)){
				value=defaultValue;
			}
			return value;
		}catch(Exception e){
			return defaultValue;
		}
	}
	
	final protected String helperRequest( com.oreilly.servlet.MultipartRequest req, String parm, String defaultValue){
		try {
			String value=req.getParameter(parm);
			if(value==null || "".equals(value)){
				value=defaultValue;
			}
			return value;
		}catch(Exception e){
			return defaultValue;
		}
	}
   
}  // BaseBccServlet

[Bear Bibeault]

Here's the interesting part:

java.lang.StringIndexOutOfBoundsException: String index out of range: 11
at java.lang.String.substring(String.java:1765)
at bcc.pages.documentManagement.DMTemplateLoader.doAction(DMTemplateLoader.java:4877)

What does it tell us?

Yeah, it does seem to go back into whatever template system you're using (I assume a template loader means you're using some sort of proprietary templates).

What it boils down to is that the String.substring() method is being called with indexes that are beyond the bounds of the string and it's throwing an exception. You'll need to backtrack it from there to find out why bad indexes are being passed.

[Michele Smith]

How would I go about:

You'll need to backtrack it from there to find out why bad indexes are being passed.

Thanks,

[Bear Bibeault]

Use a debugger. FInd out what the bas indices are, and look at the code to find out how they are being set to bad values.