JBWEB000065: HTTP Status 500 - java.lang.RuntimeException: java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string


JBWEB000309: type JBWEB000066: Exception report

JBWEB000068: message java.lang.RuntimeException: java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string

JBWEB000069: description JBWEB000145: The server encountered an internal error that prevented it from fulfilling this request.

JBWEB000070: exception

org.apache.jasper.JasperException: java.lang.RuntimeException: java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string

	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:409)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:246)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

JBWEB000071: root cause

java.lang.RuntimeException: java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string

	br.gov.in.pesquisa.dao.ConsultaDAO.consultarPaginas(ConsultaDAO.java:538)
	br.gov.in.pesquisa.PDFReader.PDFViewerFramework.consultarPaginas(PDFViewerFramework.java:63)
	org.apache.jsp.jsp.visualiza.index_jsp._jspService(index_jsp.java:150)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:69)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:365)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:246)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

JBWEB000071: root cause

java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string

	oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
	oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
	oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
	oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)
	oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
	oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
	oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
	oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
	oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807)
	oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
	oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
	oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
	oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
	oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713)
	oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167)
	org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:106)
	org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
	core.connection.JDBC.TrataSql.queryResultSet(TrataSql.java:54)
	br.gov.in.pesquisa.dao.ConsultaDAO.consultarPaginas(ConsultaDAO.java:534)
	br.gov.in.pesquisa.PDFReader.PDFViewerFramework.consultarPaginas(PDFViewerFramework.java:63)
	org.apache.jsp.jsp.visualiza.index_jsp._jspService(index_jsp.java:150)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:69)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:365)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:246)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

JBWEB000071: root cause

Error : 1830, Position : 185, Sql = select count(codigo) as valor from SGPUB.tb_pagina_edicao where codigo_edicao = (select codigo from SGPUB.tb_edicao where codigo_tipo_periodico = 1 and trunc(data_publicacao) = to_date('08/06/2001|original','dd/mm/yyyy')), OriginalSql = select count(codigo) as valor from SGPUB.tb_pagina_edicao where codigo_edicao = (select codigo from SGPUB.tb_edicao where codigo_tipo_periodico = 1 and trunc(data_publicacao) = to_date('08/06/2001|original','dd/mm/yyyy')), Error Msg = ORA-01830: date format picture ends before converting entire input string

	oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
	oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
	oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
	oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)
	oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
	oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
	oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
	oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
	oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807)
	oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
	oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
	oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
	oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
	oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713)
	oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167)
	org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:106)
	org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
	core.connection.JDBC.TrataSql.queryResultSet(TrataSql.java:54)
	br.gov.in.pesquisa.dao.ConsultaDAO.consultarPaginas(ConsultaDAO.java:534)
	br.gov.in.pesquisa.PDFReader.PDFViewerFramework.consultarPaginas(PDFViewerFramework.java:63)
	org.apache.jsp.jsp.visualiza.index_jsp._jspService(index_jsp.java:150)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:69)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:365)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:246)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:847)