Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015940
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupmajoralways2011-02-10 16:362011-03-01 00:00
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision989d59afa3bb
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015940: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 00156382.50MP27 closedadrianromero When you create a lot of organizations assigned to a role, the processes do not work 
related to defect 0015987 closedadrianromero API Break. try-api fails 

-  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 (manager)
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 (reporter)
2011-02-28 22:54

 Verified with > 500 organizations

- 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 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker