0012670: In Oracle, I cannot unschedule background processes

Description

When I go to a scheduled process, clicking the "Unschedule process" shows a pop up of success. However, button does not change its status.
Log shows this error:

16:55:40 [ajp-8009-5] ERROR org.openbravo.scheduling.OBScheduler - An error occurred unscheduling process 9B2B32C0BAF146F783A50C6F69251BC4
javax.servlet.ServletException: @CODE=1821@ORA-01821: date format not recognized

    at org.openbravo.scheduling.ProcessRequestData.update(ProcessRequestData.java:290)
    at org.openbravo.scheduling.OBScheduler.unschedule(OBScheduler.java:217)
    at org.openbravo.erpCommon.ad_process.UnscheduleProcess.doPost(UnscheduleProcess.java:50)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:402)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
    at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:99)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:427)
    at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384)
    at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
    at java.lang.Thread.run(Thread.java:619)

Steps To Reproduce

1. Go to General Setup > Process Scheduling
2. Choose the accounting process and click Unschedule
3. The pop up says it was unscheduled, but the button does not change.

I can reproduce this issue in live.builds for Oracle. In postgres it worked fine.

Tags

Regression QA

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0012382	2.50MP14	closed	iperdomo	The ProcessReques_data.xsql file does not take into account the date format defined on the Openbravo.properties file
related to	defect	0012635		closed	iperdomo	Process request: An error in the log

Notes
(0025463) hgbot (developer) 2010-03-15 11:16	Repository: erp/devel/pi Changeset: fa921f62e428c717006190aab2047f9dfdfdbf74 Author: Iván Perdomo <ivan.perdomo <at> openbravo.com> Date: Mon Mar 15 11:22:12 2010 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/fa921f62e428c717006190aab2047f9dfdfdbf74 [^] Fixes issue 12670: Fixed parameter values --- M src/org/openbravo/scheduling/OBScheduler.java ---

(0025522) hudsonbot (developer) 2010-03-16 08:41	A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/fa921f62e428 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/3e52c5b52d67 [^] Tests: http://builds.openbravo.com/view/devel-int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16713.obx [^]

Issue History
Date Modified	Username	Field	Change
2010-03-12 17:11	plujan	New Issue
2010-03-12 17:11	plujan	Assigned To	=> alostale
2010-03-12 17:11	plujan	Relationship added	related to 0012382
2010-03-12 17:11	plujan	Relationship added	related to 0012635
2010-03-12 17:11	plujan	Status	new => scheduled
2010-03-12 17:11	plujan	fix_in_branch	=> pi
2010-03-12 17:12	alostale	Assigned To	alostale => iperdomo
2010-03-14 12:03	jpabloae	Issue Monitored: jpabloae
2010-03-15 11:16	hgbot	Checkin
2010-03-15 11:16	hgbot	Note Added: 0025463
2010-03-15 11:16	hgbot	Status	scheduled => resolved
2010-03-15 11:16	hgbot	Resolution	open => fixed
2010-03-15 11:16	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/fa921f62e428c717006190aab2047f9dfdfdbf74 [^]
2010-03-15 11:46	alostale	Status	resolved => closed
2010-03-15 11:46	alostale	Fixed in Version	=> 2.50MP14
2010-03-16 00:00	anonymous	sf_bug_id	0 => 2970947
2010-03-16 08:41	hudsonbot	Checkin
2010-03-16 08:41	hudsonbot	Note Added: 0025522
2010-03-17 15:59	psarobe	Tag Attached: Regression QA
2010-04-07 11:34	psarobe	version	pi => 2.50MP13
2010-04-07 11:34	psarobe	fix_in_branch	pi =>
2010-05-05 12:50	psarobe	version	2.50MP13 => pi