timestamp issue - urgent

[rbojja]

 

Hii Am getting the below exception when try to run the report.what might be the issue.I tried all the possibilities?can any one help me out..its urgent plz

Query: is as follows!

SELECT XMRH.MR_NUM
,XMRL.MR_LINE_NUM
,XMRH.MR_DATE
,XP.NAME
,XMRH.LOCATION
,XMRH.EMP_NUM
,XMRL.MR_LINE_ID SEQ_NUM
,XI.SEGMENT1 ITEM_CODE
,XI.DESCRIPTION
,XI.PRIMARY_UNIT_OF_MEASURE UOM
,REQUESTED_QTY QTY ,XMRL.STATUS
,XE.FULL_NAME REQUESTED_BY
, CB.EMP_NUM PREPARED_BY
, UB.EMP_NUM APPROVED_BY 
FROM XXSEW_MR_REQ_HDR XMRH
,XXSEW_MR_REQ_LINES XMRL
, XXSEW_LOCATIONS XL
,XXSEW_OA_LOC_USERS CB
,XXSEW_OA_LOC_USERS UB
,XXSEW_ITEMS XI
,XXSEW_PROJECTS XP
,XXSEW_EMPLOYEES XE
WHERE XMRH.MR_NUM =XMRL.MR_NUM
AND XMRH.REQUESTED_BY = XE.PERSON_ID
AND XI.INVENTORY_ITEM_ID=XMRL.ITEM_ID
AND XI.ORGANIZATION_CODE = XMRH.LOCATION
AND XI.ORGANIZATION_CODE = XL.ORGANIZATION_CODE
AND XMRL.CREATED_BY = CB.EMP_ID (+)
AND XMRL.LAST_UPDATE_BY = UB.EMP_ID (+)
AND XMRH.PROJECT_ID =XP.PROJECT_ID
AND XMRL.STATUS = NVL($P{status},XMRL.STATUS)
AND XMRH.MR_NUM LIKE NVL($P{mrNumber},XMRH.MR_NUM)
AND XMRH.PROJECT_ID = NVL($P{projectId},XMRH.PROJECT_ID)
AND XMRH.MR_DATE = NVL($P{mrDate},XMRH.MR_DATE)
ORDER BY XMRH.MR_NUM, XMRL.MR_LINE_ID

Error trace:

net.sf.jasperreports.engine.JRException: Unable to get value for field 'MR_DATE' of class 'java.sql.Timestamp'
at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:314)
at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:787)
at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:751)
at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1438)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:111)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:895)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:798)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)
at com.osi.sew.model.ReportBean.materialRequisition(ReportBean.java:169)
at com.osi.sew.servlet.InventoryReportServlet.doPost(InventoryReportServlet.java:72)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at oracle.lite.web.JupServlet.service(Unknown Source)
at oracle.lite.web.AppServletHandler.handle(Unknown Source)
at oracle.lite.web.JupApplication.handle(Unknown Source)
at oracle.lite.web.JupApplication.service(Unknown Source)
at oracle.lite.web.JupHandler.handle(Unknown Source)
at oracle.lite.web.HTTPServer.process(Unknown Source)
at oracle.lite.web.HTTPServer.handleRequest(Unknown Source)
at oracle.lite.web.JupServer.handle(Unknown Source)
at oracle.lite.web.SocketListener.process(Unknown Source)
at oracle.lite.web.ClientListener.process(Unknown Source)
at oracle.lite.web.SocketListener$ReqHandler.run(Unknown Source)
Caused by: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
at java.sql.Timestamp.valueOf(Unknown Source)
 

[Teodor Danciu]

Hi,

 

The exception tells you exactly what could be wrong. Look at the bottom of your own post.

You did not attach the report template so that we see the report field definitions.

Also, what data base server is it? What is the type of that column in the database?

I understand it is urgent, but if you want urgent replies, you have to give enough details.

 

Thank you,

Teodor