Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0006150 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 01. General setup | major | always | 2008-11-21 14:35 | 2008-12-31 07:47 | |||
| Reporter | lakshmi | View Status | public | |||||
| Assigned To | anthony_wolski | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 10456 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6_0_07 | |||
| OS Version | Cent OS | Database version | 8.3.5.1 | Ant version | 1.7.1 | |||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0006150: Button "Schedule Process" cannot be changed to "Unschedule Process" in Process Request | |||||||
| Description | After created and schedule the accounting process successfully, the "Schedule Process" button cannot be changed to "Unschedule Process" | |||||||
| Steps To Reproduce | 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0010526) psarobe (viewer) 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 (viewer) 2008-11-21 19:17 |
This works on 2.50alpha-r1 |
|
(0010528) psarobe (viewer) 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 (viewer) 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 (viewer) 2008-12-31 07:47 |
Verified the issue and it works in Openbravo 2.50 (r11619). So i closed this issue |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |