Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012670Openbravo ERP01. General setuppublic2010-03-12 17:112010-05-05 12:50
Reporterplujan 
Assigned Toiperdomo 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version2.50MP14Fixed in Version2.50MP14 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012670: In Oracle, I cannot unschedule background processes
DescriptionWhen 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 Reproduce1. 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.
Proposed Solution
Additional Information
TagsRegression QA
Relationships
related to defect 00123822.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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-03-12 17:11plujanNew Issue
2010-03-12 17:11plujanAssigned To => alostale
2010-03-12 17:11plujanOBNetwork customer => No
2010-03-12 17:11plujanRelationship addedrelated to 0012382
2010-03-12 17:11plujanRelationship addedrelated to 0012635
2010-03-12 17:11plujanStatusnew => scheduled
2010-03-12 17:11plujanfix_in_branch => pi
2010-03-12 17:12alostaleAssigned Toalostale => iperdomo
2010-03-14 12:03jpabloaeIssue Monitored: jpabloae
2010-03-15 11:16hgbotCheckin
2010-03-15 11:16hgbotNote Added: 0025463
2010-03-15 11:16hgbotStatusscheduled => resolved
2010-03-15 11:16hgbotResolutionopen => fixed
2010-03-15 11:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fa921f62e428c717006190aab2047f9dfdfdbf74 [^]
2010-03-15 11:46alostaleStatusresolved => closed
2010-03-15 11:46alostaleFixed in Version => 2.50MP14
2010-03-16 00:00anonymoussf_bug_id0 => 2970947
2010-03-16 08:41hudsonbotCheckin
2010-03-16 08:41hudsonbotNote Added: 0025522
2010-03-17 15:59psarobeTag Attached: Regression QA
2010-04-07 11:34psarobeversionpi => 2.50MP13
2010-04-07 11:34psarobefix_in_branchpi =>
2010-05-05 12:50psarobeversion2.50MP13 => pi

Notes
(0025463)
hgbot   
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   
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 [^]