org.apache.jasper.JasperException: ORA-01841: (full) year must be between -4713 and +9999, and not be 0 SELECT REQUEST_ID,to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss') P_DEPLOYDATE, trim(to_char(to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss'),'DAY')) P_DEPLOYDAY, to_char(to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss'),'hh:mi') START_TIME, to_char(to_date(P_REQ_END_DATE,'yyyy-mm-dd hh24:mi:ss'),'mm-dd-yyyy hh24:mi') P_REQ_END_DATE, replace(P_IMPACT_BUSINESS,'#@#',','),P_TITLE,P_CLASSIFICATION,P_REQUESTED_BY, replace(p_pole,'#@#',','), to_date(P_REQ_END_DATE,'yyyy-mm-dd hh24:mi:ss') FROM KINTANA.MREQ_TSO_CHANGE_REQUEST where to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss') >= to_date('2006-04-24 00:00:00','yyyy-mm-dd hh24:mi:ss') and to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss') <= to_date('2006-04-24 00:00:00','yyyy-mm-dd hh24:mi:ss')+7 and P_POLE like '%Europe%' order by 2,11

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 509346, 1 year ago
ORA-01841: (full) year must be between -4713 and +9999, and not be 0 SELECT REQUEST_ID,to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss') P_DEPLOYDATE, trim(to_char(to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss'),'DAY')) P_DEPLOYDAY, to_char(to_date
via Oracle Community by 843829, 6 months ago
java.rmi.MarshalException: CORBA MARSHAL 1398079699 Maybe; nested exception is: org.omg.CORBA.MARSHAL: Unable to read value from underlying bridge : Serializable readObject method failed internally vmcid: SUN minor code: 211 completed: Maybe
via Coderanch by Sudharsan Govindarajan, 1 year ago
bean phoneBook not found within scope
org.apache.jasper.JasperException: ORA-01841: (full) year must be between -4713 and +9999, and not be 0 SELECT REQUEST_ID,to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss') P_DEPLOYDATE, trim(to_char(to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss'),'DAY')) P_DEPLOYDAY, to_char(to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss'),'hh:mi') START_TIME, to_char(to_date(P_REQ_END_DATE,'yyyy-mm-dd hh24:mi:ss'),'mm-dd-yyyy hh24:mi') P_REQ_END_DATE, replace(P_IMPACT_BUSINESS,'#@#',','),P_TITLE,P_CLASSIFICATION,P_REQUESTED_BY, replace(p_pole,'#@#',','), to_date(P_REQ_END_DATE,'yyyy-mm-dd hh24:mi:ss') FROM KINTANA.MREQ_TSO_CHANGE_REQUEST where to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss') >= to_date('2006-04-24 00:00:00','yyyy-mm-dd hh24:mi:ss') and to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss') <= to_date('2006-04-24 00:00:00','yyyy-mm-dd hh24:mi:ss')+7 and P_POLE like '%Europe%' order by 2,11
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.mortbay.jetty.servlet.ServletHolder.handle(Unknown Source)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(Unknown Source)
at org.mortbay.jetty.servlet.Dispatcher.dispatch(Dispatcher.java:192)
at com.kintana.rpt.web.servlet.RunJspReport.doPost(RunJspReport.java:73)
at javax.servlet.http.HttpServlet.service(Unknown Source)
at org.mortbay.jetty.servlet.ServletHolder.handle(Unknown Source)
at com.kintana.core.web.filter.ControlFilter.doFilter(ControlFilter.java:627)
at com.kintana.core.web.filter.MultipartRequestFilter.doFilter(MultipartRequestFilter.java:77)
at com.kintana.core.web.filter.I18nFilter.doFilter(I18nFilter.java:45)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(Unknown Source)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(Unknown Source)
at org.mortbay.http.HttpContext.handle(Unknown Source)
at org.mortbay.http.HttpContext.handle(Unknown Source)
at org.mortbay.http.HttpServer.service(Unknown Source)
at org.jboss.jetty.Jetty.service(Unknown Source)
at org.mortbay.http.HttpConnection.service(Unknown Source)
at org.mortbay.http.HttpConnection.handleNext(Unknown Source)
at org.mortbay.http.HttpConnection.handle(Unknown Source)
at org.mortbay.http.SocketListener.handleConnection(Unknown Source)
at org.mortbay.util.ThreadedServer.handle(Unknown Source)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.