Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006150Openbravo ERP01. General setuppublic2008-11-21 14:352008-12-31 07:47
lakshmi 
anthony_wolski 
highmajoralways
closedfixed 
20Cent OS
pi 
 
Core
No
0006150: Button "Schedule Process" cannot be changed to "Unschedule Process" in Process Request
After created and schedule the accounting process successfully, the "Schedule Process" button cannot be changed to "Unschedule Process"
1. Login as userA
2. Go to General setup->Process Scheduling->Process request
3. Create the schedule Process and press "Schedule Process" button
4. After created successfully, the button "Schedule Process" cannot be changed to "Unschedule Process" to deactivate.
No tags attached.
blocks defect 0006313 closed anthony_wolski Button "Schedule Process" only changed to "Unschedule Process" in Process Request when reloading the page 
Issue History
2008-11-21 14:35lakshmiNew Issue
2008-11-21 14:35lakshmiAssigned To => rafaroda
2008-11-21 14:35lakshmisf_bug_id0 => 2320811
2008-11-21 19:15psarobeStatusnew => scheduled
2008-11-21 19:15psarobeAssigned Torafaroda => iperdomo
2008-11-21 19:15psarobefix_in_branch => trunk
2008-11-21 19:16psarobeNote Added: 0010526
2008-11-21 19:17psarobeNote Added: 0010527
2008-11-21 19:25iperdomoAssigned Toiperdomo => anthony_wolski
2008-11-21 19:34psarobePrioritynormal => high
2008-11-21 19:34psarobefix_in_branchtrunk =>
2008-11-21 19:39psarobeNote Added: 0010528
2008-11-24 13:05svnbotCheckin
2008-11-24 13:05svnbotNote Added: 0010562
2008-11-24 13:05svnbotStatusscheduled => resolved
2008-11-24 13:05svnbotResolutionopen => fixed
2008-11-24 13:05svnbotsvn_revision => 10456
2008-12-02 10:01psarobeRelationship addedblocks 0006313
2008-12-31 07:47lakshmiRegression testing => No
2008-12-31 07:47lakshmiStatusresolved => closed
2008-12-31 07:47lakshmiNote Added: 0011778

Notes
(0010526)
psarobe   
2008-11-21 19:16   
This is the log:

18:48:00 [DefaultQuartzScheduler_Worker-7] ERROR org.openbravo.scheduling.ProcessRunData - SQL error in query: UPDATE AD_Process_Run SET Updated = NOW(), UpdatedBy = ?, Status = ?, End_Time = TO_TIMESTAMP(?, 'DD-MM-YYYY HH24:MI:SS'), Runtime = ?, Log = ? WHERE AD_Process_Run_ID = ?Exception:java.sql.SQLException: ORA-01461: sólo puede enlazar un valor LONG para insertarlo en una columna LONG

18:49:00 [DefaultQuartzScheduler_Worker-8] ERROR org.openbravo.scheduling.ProcessRunData - SQL error in query: UPDATE AD_Process_Run SET Updated = NOW(), UpdatedBy = ?, Status = ?, End_Time = TO_TIMESTAMP(?, 'DD-MM-YYYY HH24:MI:SS'), Runtime = ?, Log = ? WHERE AD_Process_Run_ID = ?Exception:java.sql.SQLException: ORA-01461: sólo puede enlazar un valor LONG para insertarlo en una columna LONG

18:50:00 [DefaultQuartzScheduler_Worker-9] ERROR org.openbravo.scheduling.ProcessRunData - SQL error in query: UPDATE AD_Process_Run SET Updated = NOW(), UpdatedBy = ?, Status = ?, End_Time = TO_TIMESTAMP(?, 'DD-MM-YYYY HH24:MI:SS'), Runtime = ?, Log = ? WHERE AD_Process_Run_ID = ?Exception:java.sql.SQLException: ORA-01461: sólo puede enlazar un valor LONG para insertarlo en una columna LONG

18:51:00 [DefaultQuartzScheduler_Worker-10] ERROR org.openbravo.scheduling.ProcessRunData - SQL error in query: UPDATE AD_Process_Run SET Updated = NOW(), UpdatedBy = ?, Status = ?, End_Time = TO_TIMESTAMP(?, 'DD-MM-YYYY HH24:MI:SS'), Runtime = ?, Log = ? WHERE AD_Process_Run_ID = ?Exception:java.sql.SQLException: ORA-01461: sólo puede enlazar un valor LONG para insertarlo en una columna LONG
(0010527)
psarobe   
2008-11-21 19:17   
This works on 2.50alpha-r1
(0010528)
psarobe   
2008-11-21 19:39   
After a while you get stuck

Configuration of the schedule process to reproduce:

    * Login as Openbravo/openbravo with role Openbravo admin
    * Go to General setup->Process Scheduling->Process request
    * Click new and fill
    * Select process: Acct Server Process
    * Timing: Schedule
    * Start date: first day of the current year
    * Frequency: Minutely
    * Interval minutes: 1
    * Save
    * Press Schedule Process button

When stuck you see this log:

19:21:08 [http-8880-2] ERROR org.openbravo.database.ConnectionProviderImpl - java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
localhost:1521:ob

Doing this select:
select * from v$parameter where name = 'processes' I have the value 150

Doing this select I have:

select * from v$session

Almost 150 sessions
(0010562)
svnbot   
2008-11-24 13:05   
Repository: openbravo
Revision: 10456
Author: anthony.wolski
Date: 2008-11-24 13:04:24 +0100 (Mon, 24 Nov 2008)

Fixes bug 0006150. Changed data type in AD_PROCESS_RUN and scheduling logic.

---
U trunk/src/org/openbravo/scheduling/DefaultJob.java
U trunk/src/org/openbravo/scheduling/ProcessBundle.java
U trunk/src/org/openbravo/scheduling/ProcessMonitor.java
U trunk/src-db/database/model/tables/AD_PROCESS_RUN.xml
U trunk/src-db/database/sourcedata/AD_ALERTRULE.xml
U trunk/src-db/database/sourcedata/AD_FIELD.xml
U trunk/src-db/database/sourcedata/AD_MODULE.xml
U trunk/src-db/database/sourcedata/AD_PREFERENCE.xml
U trunk/src-db/database/sourcedata/AD_REF_LIST.xml
U trunk/src-db/database/sourcedata/AD_TABLE.xml
U trunk/src-db/database/sourcedata/AD_TEXTINTERFACES.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=10456&sc=1 [^]
(0011778)
lakshmi   
2008-12-31 07:47   
Verified the issue and it works in Openbravo 2.50 (r11619). So i closed this issue