Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0015940 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 01. General setup | major | always | 2011-02-10 16:36 | 2011-03-01 00:00 | |||
| Reporter | adrianromero | View Status | public | |||||
| Assigned To | adrianromero | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 989d59afa3bb | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0015940: When you create a lot of organizations assigned to a role, the processes do not work | |||||||
| Description | When you create a lot of organizations assigned to a role, the processes do not work | |||||||
| Steps To Reproduce | - Create 400 organizations assigned to a role. - Identify in Openbravo ERP with this role - Financial Management || Accounting || Setup || Fiscal Calendar - Create a new calendar - Year - Launch "Create Periods" process. - Error "ORA-01461: can bind a LONG value only for insert into a LONG column " appears | |||||||
| Proposed Solution | The problem is in org.openbravo.scheduling.ProcessRunner, because it tries to store all the organizations separated by commas in the database. Probably the solution is just to change the type of the column OB_CONTEXT of the table AD_PROCESS_REQUEST from VARCHAR(4000) to LONG | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0034290) hgbot (developer) 2011-02-21 17:50 |
Repository: erp/devel/pi Changeset: 989d59afa3bbde98ce1bef5585c1a099681e5cbf Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Mon Feb 21 17:50:06 2011 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/989d59afa3bbde98ce1bef5585c1a099681e5cbf [^] Fixes issue 0015940: When you create a lot of organizations assigned to a role, the processes do not work It has been modified the type of the OB_CONTEXT column to CLOB --- M src-db/database/model/tables/AD_PROCESS_REQUEST.xml --- |
|
(0034291) adrianromero (viewer) 2011-02-21 17:50 |
* Testing the issue Follow the steps to test and verify that the process can be executed. Test also that processes can be scheduled too. * Other areas affected. Areas related to the execution of processes can be affected. There must be reviewed all different areas. |
|
(0034450) dalsasua (viewer) 2011-02-28 22:54 |
Verified with > 500 organizations |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-02-10 16:36 | adrianromero | New Issue | |
| 2011-02-10 16:36 | adrianromero | Assigned To | => adrianromero |
| 2011-02-10 16:36 | adrianromero | Modules | => Core |
| 2011-02-10 16:36 | adrianromero | OBNetwork customer | => Yes |
| 2011-02-10 16:36 | adrianromero | Issue generated from | 0015638 |
| 2011-02-10 16:36 | adrianromero | Relationship added | depends on 0015638 |
| 2011-02-10 16:36 | adrianromero | Status | new => scheduled |
| 2011-02-10 16:36 | adrianromero | fix_in_branch | => pi |
| 2011-02-15 13:29 | adrianromero | Relationship added | related to 0015987 |
| 2011-02-15 13:32 | adrianromero | Relationship added | related to 0015988 |
| 2011-02-15 13:32 | adrianromero | Relationship deleted | related to 0015988 |
| 2011-02-21 17:50 | hgbot | Checkin | |
| 2011-02-21 17:50 | hgbot | Note Added: 0034290 | |
| 2011-02-21 17:50 | hgbot | Status | scheduled => resolved |
| 2011-02-21 17:50 | hgbot | Resolution | open => fixed |
| 2011-02-21 17:50 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/989d59afa3bbde98ce1bef5585c1a099681e5cbf [^] |
| 2011-02-21 17:50 | adrianromero | Note Added: 0034291 | |
| 2011-02-28 22:54 | dalsasua | Note Added: 0034450 | |
| 2011-02-28 22:54 | dalsasua | Status | resolved => closed |
| 2011-03-01 00:00 | anonymous | sf_bug_id | 0 => 3195608 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |