Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0012635 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2010-03-10 16:29 | 2010-03-10 18:30 | |||
| Reporter | psarobe | View Status | public | |||||
| Assigned To | iperdomo | |||||||
| Priority | urgent | Resolution | duplicate | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP12 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0012635: Process request: An error in the log | |||||||
| Description | This is the log error: ERROR org.openbravo.scheduling.ProcessRequestData - SQL error in query: »··UPDATE AD_Process_Request »SET Updatedby = ?, AD_User_ID = ?, Status = ?, Channel = ?, »··Previous_Fire_Time = TO_TIMESTAMP(?, 'DD-MM-YYYY HH24:MI:SS'), »··· e_Time = TO_TIMESTAMP(?, 'DD-MM-YYYY HH24:MI:SS'), »···Scheduled_Finish = TO_TIMESTAMP(?, 'DD-MM-YYYY HH24:MI:SS'), »·Ob_Context = ? WHERE AD_Process_Request_ID = ?Exception:java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string | |||||||
| Steps To Reproduce | Sorry but not really steps I can write. Just after a while using the ERP if you go to the logs you can see the error The error has to do with the date you pass that the value is too long. For example you can reproduce it in Oracle if you execute this statement: select TO_TIMESTAMP('01-01-2010 00:00:00,000000000', 'DD-MM-YYYY HH24:MI:SS') from dual Please notice what it's supposed to be the date | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0025212) iperdomo (reporter) 2010-03-10 16:44 |
Duplicated of existing issue targeting 2.50MP14 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-03-10 16:29 | psarobe | New Issue | |
| 2010-03-10 16:29 | psarobe | Assigned To | => iperdomo |
| 2010-03-10 16:36 | psarobe | Status | new => scheduled |
| 2010-03-10 16:36 | psarobe | fix_in_branch | => pi |
| 2010-03-10 16:44 | iperdomo | Relationship added | duplicate of 0012382 |
| 2010-03-10 16:44 | iperdomo | Note Added: 0025212 | |
| 2010-03-10 16:44 | iperdomo | Status | scheduled => closed |
| 2010-03-10 16:44 | iperdomo | Resolution | open => duplicate |
| 2010-03-10 17:25 | anonymous | sf_bug_id | 0 => |
| 2010-03-10 18:30 | anonymous | sf_bug_id | => 2968129 |
| 2010-03-12 17:11 | plujan | Relationship added | related to 0012670 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |