Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0008917 | Openbravo ERP | 01. General setup | public | 2009-05-05 19:43 | 2009-06-02 06:42 |
|
| Reporter | yeasy | |
| Assigned To | iperdomo | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 10 | OS Version | Server 2003 |
| Product Version | 2.50 | |
| Target Version | | Fixed in Version | pi | |
| 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 | 0008917: Error Message when set org. as ready |
| Description | When processing "Set as Ready" during the general setup - Organization:
ERROR: value too long for type character varying(1000) |
| Steps To Reproduce | A way to reproduce this bug is:
1- As Openbravo Admin, create a lot of organizations for the same client, for example 30 (it is not important neither the org type nor the position at the org's tree)
2- Try to set as ready any of them
|
| Proposed Solution | Increase the length of the column OB_CONTEXT of the AD_PROCESS_REQUEST table |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | depends on | defect | 0009224 | | closed | marvintm | Data record insertion fails when using a CLOB column | | related to | defect | 0009238 | | closed | iperdomo | api check: build 29 failed with a warning |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2009-05-05 19:43 | yeasy | New Issue | |
| 2009-05-05 19:43 | yeasy | Assigned To | => rafaroda |
| 2009-05-06 14:05 | psarobe | Note Added: 0016100 | |
| 2009-05-06 14:05 | psarobe | Status | new => feedback |
| 2009-05-11 11:06 | psarobe | Note Added: 0016244 | |
| 2009-05-11 19:16 | yeasy | Note Added: 0016277 | |
| 2009-05-15 10:07 | rafaroda | Regression testing | => No |
| 2009-05-15 10:07 | rafaroda | Status | feedback => closed |
| 2009-05-15 10:07 | rafaroda | Note Added: 0016367 | |
| 2009-05-15 10:07 | rafaroda | Resolution | open => no change required |
| 2009-05-16 00:00 | anonymous | sf_bug_id | 0 => 2792498 |
| 2009-05-27 10:58 | pjuvara | Status | closed => new |
| 2009-05-27 10:58 | pjuvara | Resolution | no change required => open |
| 2009-05-27 10:58 | pjuvara | OBNetwork customer | => Yes |
| 2009-05-27 10:58 | pjuvara | Priority | normal => immediate |
| 2009-05-27 10:58 | pjuvara | Severity | major => critical |
| 2009-05-27 11:02 | pjuvara | Note Added: 0016672 | |
| 2009-05-27 13:35 | psarobe | Severity | critical => major |
| 2009-05-27 13:35 | psarobe | Status | new => scheduled |
| 2009-05-27 13:35 | psarobe | Assigned To | rafaroda => vmromanos |
| 2009-05-27 13:35 | psarobe | fix_in_branch | => pi |
| 2009-05-27 15:14 | vmromanos | Note Added: 0016682 | |
| 2009-05-27 15:14 | vmromanos | Assigned To | vmromanos => psarobe |
| 2009-05-27 15:14 | vmromanos | Status | scheduled => feedback |
| 2009-05-27 16:25 | vmromanos | fix_in_branch | pi => |
| 2009-05-27 16:25 | vmromanos | Proposed Solution updated | |
| 2009-05-27 16:25 | vmromanos | Steps to Reproduce Updated | |
| 2009-05-27 16:26 | rafaroda | Assigned To | psarobe => alostale |
| 2009-05-27 16:26 | rafaroda | Status | feedback => scheduled |
| 2009-05-27 18:01 | alostale | Assigned To | alostale => iperdomo |
| 2009-05-28 07:59 | pjuvara | Issue Monitored: pjuvara | |
| 2009-05-28 13:35 | iperdomo | Relationship added | depends on 0009224 |
| 2009-05-28 19:50 | hgbot | Checkin | |
| 2009-05-28 19:50 | hgbot | Note Added: 0016740 | |
| 2009-05-28 19:50 | hgbot | Status | scheduled => resolved |
| 2009-05-28 19:50 | hgbot | Resolution | open => fixed |
| 2009-05-28 19:50 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/32910a30d3cc7be3ae1cc355f29f8dd1a54a05f4 [^] |
| 2009-05-29 12:20 | iperdomo | Relationship added | related to 0009238 |
| 2009-06-01 12:04 | hgbot | Checkin | |
| 2009-06-01 12:04 | hgbot | Note Added: 0016802 | |
| 2009-06-01 12:04 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/32910a30d3cc7be3ae1cc355f29f8dd1a54a05f4 [^] => http://code.openbravo.com/erp/devel/api-checks/rev/c38acc7c0db8bfedf932143f7cdb06fff486827e [^] |
| 2009-06-02 06:42 | pjuvara | Status | resolved => closed |
| 2009-06-02 06:42 | pjuvara | Note Added: 0016834 | |
| 2009-06-02 06:42 | pjuvara | Fixed in Version | => pi |
|
Notes |
|
|
|
|
Please give more information as we cannot reproduce |
|
|
|
|
|
Reminder sent to: yeasy
Any feedback? |
|
|
|
(0016277)
|
|
yeasy
|
|
2009-05-11 19:16
|
|
|
The problem can be solved by changing the log in role. Thanks! |
|
|
|
|
|
Reporter did manage to solve his problem: it was not an Openbravo ERP issue. |
|
|
|
|
This problem happens when there is a large number of organizations and this makes the concatenated list of organization exceed the size.
This bug has been encountered in the internal Openbravo implementation (35 organizations). This is a professional subscription customer and this is a showstopper for the project. |
|
|
|
|
This is a Platform's bug, because it affects every PL procedure/function.
The column OB_CONTEXT of the AD_PROCESS_REQUEST table stores a snapshoot of the session variables, like the IDs of the clients, organizations or warehouses configured in the system when executing a PL procedure.
When the length of this string is greater than 10000 (it is easy with UUIDs), this bug appears.
The solution is to increase the length of this column, but Platform should decide the new length. |
|
|
|
(0016740)
|
|
hgbot
|
|
2009-05-28 19:50
|
|
|
|
|
(0016802)
|
|
hgbot
|
|
2009-06-01 12:04
|
|
|
|
|
|
|