Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0006150
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupmajoralways2008-11-21 14:352008-12-31 07:47
ReporterlakshmiView Statuspublic 
Assigned Toanthony_wolski 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision10456
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6_0_07
OS VersionCent OSDatabase version8.3.5.1Ant version1.7.1
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0006150: Button "Schedule Process" cannot be changed to "Unschedule Process" in Process Request

DescriptionAfter created and schedule the accounting process successfully, the "Schedule Process" button cannot be changed to "Unschedule Process"
Steps To Reproduce1. 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0006313 closedanthony_wolski Button "Schedule Process" only changed to "Unschedule Process" in Process Request when reloading the page 

-  Notes
(0010526)
psarobe (manager)
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 (manager)
2008-11-21 19:17

 This works on 2.50alpha-r1
(0010528)
psarobe (manager)
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 (reporter)
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 (reporter)
2008-12-31 07:47

 Verified the issue and it works in Openbravo 2.50 (r11619). So i closed this issue

- Issue History
Date Modified Username Field Change
2008-11-21 14:35 lakshmi New Issue
2008-11-21 14:35 lakshmi Assigned To => rafaroda
2008-11-21 14:35 lakshmi sf_bug_id 0 => 2320811
2008-11-21 19:15 psarobe Status new => scheduled
2008-11-21 19:15 psarobe Assigned To rafaroda => iperdomo
2008-11-21 19:15 psarobe fix_in_branch => trunk
2008-11-21 19:16 psarobe Note Added: 0010526
2008-11-21 19:17 psarobe Note Added: 0010527
2008-11-21 19:25 iperdomo Assigned To iperdomo => anthony_wolski
2008-11-21 19:34 psarobe Priority normal => high
2008-11-21 19:34 psarobe fix_in_branch trunk =>
2008-11-21 19:39 psarobe Note Added: 0010528
2008-11-24 13:05 svnbot Checkin
2008-11-24 13:05 svnbot Note Added: 0010562
2008-11-24 13:05 svnbot Status scheduled => resolved
2008-11-24 13:05 svnbot Resolution open => fixed
2008-11-24 13:05 svnbot svn_revision => 10456
2008-12-02 10:01 psarobe Relationship added blocks 0006313
2008-12-31 07:47 lakshmi Regression testing => No
2008-12-31 07:47 lakshmi Status resolved => closed
2008-12-31 07:47 lakshmi Note Added: 0011778

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker