Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015940Openbravo ERP01. General setuppublic2011-02-10 16:362011-03-01 00:00
Reporteradrianromero 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015940: When you create a lot of organizations assigned to a role, the processes do not work
DescriptionWhen 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 SolutionThe 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
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00156382.50MP27 closed adrianromero When you create a lot of organizations assigned to a role, the processes do not work 
related to defect 0015987 closed adrianromero API Break. try-api fails 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-02-10 16:36adrianromeroNew Issue
2011-02-10 16:36adrianromeroAssigned To => adrianromero
2011-02-10 16:36adrianromeroModules => Core
2011-02-10 16:36adrianromeroIssue generated from0015638
2011-02-10 16:36adrianromeroRelationship addeddepends on 0015638
2011-02-10 16:36adrianromeroStatusnew => scheduled
2011-02-10 16:36adrianromerofix_in_branch => pi
2011-02-15 13:29adrianromeroRelationship addedrelated to 0015987
2011-02-15 13:32adrianromeroRelationship addedrelated to 0015988
2011-02-15 13:32adrianromeroRelationship deletedrelated to 0015988
2011-02-21 17:50hgbotCheckin
2011-02-21 17:50hgbotNote Added: 0034290
2011-02-21 17:50hgbotStatusscheduled => resolved
2011-02-21 17:50hgbotResolutionopen => fixed
2011-02-21 17:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/989d59afa3bbde98ce1bef5585c1a099681e5cbf [^]
2011-02-21 17:50adrianromeroNote Added: 0034291
2011-02-28 22:54dalsasuaNote Added: 0034450
2011-02-28 22:54dalsasuaStatusresolved => closed
2011-03-01 00:00anonymoussf_bug_id0 => 3195608

Notes
(0034290)
hgbot   
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   
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   
2011-02-28 22:54   
Verified with > 500 organizations