2017/08/18 18:40:30.769 [ 1] (http-bio-8080-exec-3330) Problem including template component SQLLOOP name="sq" query=" SELECT ws.Css_Url,ws.Html_Header1,ws.Html_Footer,ac.Company_Name,ws.Html_Header2,ws.Html_Header3,ws.Html_Footer2,g.canNotify FROM Accounts ac JOIN QCPI_Group g ON g.QCPI_Group_No=<?p:group?> INNER JOIN Provider_Web_Styles pws ON ac.Account_No=pws.Account_No INNER JOIN Ipp_Web_Styles ws ON pws.Style_Id=ws.Style_Id AND ws.Application_Context='<?a:appContext?>' WHERE ac.Account_No=<?p:provider.toSQLString()?> "
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
 while executing: 
	SELECT
		ws.Css_Url,ws.Html_Header1,ws.Html_Footer,ac.Company_Name,ws.Html_Header2,ws.Html_Header3,ws.Html_Footer2,g.canNotify
	FROM
		Accounts ac
		JOIN QCPI_Group g ON g.QCPI_Group_No=5027134.html
		INNER JOIN Provider_Web_Styles pws ON ac.Account_No=pws.Account_No
		INNER JOIN Ipp_Web_Styles ws ON pws.Style_Id=ws.Style_Id AND ws.Application_Context='/qap'
	WHERE
		ac.Account_No='5027134'


	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498)
	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
	at dynamic.dbtk.connection.StandaloneConnectionWrapper.select(StandaloneConnectionWrapper.java:552)
	at dynamic.dbtk.connection.AbstractConnectionWrapper.select(AbstractConnectionWrapper.java:177)
	at dynamic.intraframe.templates.components.SQLLoopComponent.includeInternal(SQLLoopComponent.java:90)
	at dynamic.intraframe.templates.TemplateComponent.include(TemplateComponent.java:165)
	at dynamic.intraframe.templates.TemplateComponent.includeChildren(TemplateComponent.java:312)
	at dynamic.intraframe.templates.Template.includeInternal(Template.java:85)
	at dynamic.intraframe.templates.TemplateComponent.include(TemplateComponent.java:165)
	at dynamic.intraframe.templates.Template.include(Template.java:58)
	at dynamic.intraframe.engine.BaseApplicationContext.handleTemplate(BaseApplicationContext.java:1026)
	at dynamic.intraframe.engine.BaseApplicationContext.handle(BaseApplicationContext.java:842)
	at dynamic.intraframe.engine.BaseServlet.service(BaseServlet.java:234)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)