AnsweredAssumed Answered

Getting [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01830: date format picture ends before converting entire input string error in GEL Script

Question asked by Anant_Raj_89 on Sep 22, 2015
Latest reply on Sep 22, 2015 by Dave_3.0

Hi All,

 

I am getting below shown error while after running a process, the same SQL works fine in SQL Developer, can you please help in this.

 

 

org.apache.commons.jelly.JellyTagException: null:19:88: <sql:query> SELECT dp.ts_dp0approved, dp.ts_dp1approved, dp.ts_dp2approved, dp.ts_dp3approved, dp.ts_dp4approved, dp.ts_dp5approved, dp.ts_dp6approved, dp.ts_dp0planned, dp.ts_dp1planned, dp.ts_dp2planned, dp.ts_dp3planned, dp.ts_dp4planned, dp.ts_dp5planned, dp.ts_dp6planned, CASE WHEN (SELECT (TO_DATE(SYSDATE, 'yyyy-MM-dd') - TO_DATE(cap.ts_next_dp_date, 'yyyy-MM-dd')) FROM DUAL) <0 THEN NULL ELSE (SELECT (TO_DATE(SYSDATE, 'yyyy-MM-dd') - TO_DATE(cap.ts_next_dp_date, 'yyyy-MM-dd')) FROM DUAL) END AS DP_DAYS_LATE FROM inv_investments inv, odf_ca_ts_decision_point dp, prtask tsk, odf_ca_project cap WHERE tsk.prid=dp.ts_dpms_task AND cap.id=inv.id AND dp.last_updated_date= (SELECT MAX(dpl.last_updated_date) FROM odf_ca_ts_decision_point dpl WHERE dpl.odf_parent_id=inv.id) AND dp.odf_parent_id=inv.id: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01830: date format picture ends before converting entire input string

Outcomes