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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015638
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 01. General setupmajoralways2011-01-13 12:062011-02-28 22:53
ReporterjonalegriaesarteView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version2.50MP27
StatusclosedFix in branchFixed in SCM revision9679d1715f3b
ProjectionnoneETAnoneTarget Version2.50MP27
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.50MP25SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015638: 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 ]
blocks defect 0015940 closedadrianromero When you create a lot of organizations assigned to a role, the processes do not work 

-  Notes
(0034065)
jonalegriaesarte (reporter)
2011-02-07 10:37

 The same problem occurs when trying to schedule a new process. The error is:

ERROR
org.openbravo.scheduling.ProcessRequestData - SQL error in query: UPDATE
AD_Process_Request SET Updatedby = ?, AD_User_ID = ?, Status = substr(?, 1,
60), Channel = substr(?, 1, 20), Previous_Fire_Time = TO_TIMESTAMP(?, ?),
Next_Fire_Time = TO_TIMESTAMP(?, ?), Scheduled_Finish = TO_TIMESTAMP(?, ?),
Ob_Context = ? WHERE AD_Process_Request_ID =
?Exception:java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column " appears

So the problem is the same, because the process is trying to update a value in Ob_Context column bigger that the column size (because of the big amount of organizations)
(0034066)
jonalegriaesarte (reporter)
2011-02-07 10:47

 This second problem is in org.openbravo.scheduling.ProcessMonitor in line

ProcessRequestData.update(getConnection(), ctx.getUser(), ctx.getUser(), SCHEDULED, bundle
          .getChannel().toString(), null, null, null, null, ctx.toString(), trigger.getName());

the problem is in parameter ctx.toString()
(0034224)
hgbot (developer)
2011-02-16 12:05

 Repository: erp/stable/2.50
Changeset: 9679d1715f3b0913838c2cb5d3472eaec8fbe497
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Wed Feb 16 12:03:08 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/9679d1715f3b0913838c2cb5d3472eaec8fbe497 [^]

Fixes issue 0015638: 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
---
(0034226)
adrianromero (manager)
2011-02-16 12:22

 * 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.
(0034447)
jonalegriaesarte (reporter)
2011-02-28 20:06

 Verified
(0034449)
dalsasua (reporter)
2011-02-28 22:53

 Verified with > 500 organizations

- Issue History
Date Modified Username Field Change
2011-01-13 12:06 jonalegriaesarte New Issue
2011-01-13 12:06 jonalegriaesarte Assigned To => adrianromero
2011-01-13 12:06 jonalegriaesarte Modules => Core
2011-01-13 12:07 jonalegriaesarte Issue Monitored: networkb
2011-02-07 10:37 jonalegriaesarte Note Added: 0034065
2011-02-07 10:47 jonalegriaesarte Note Added: 0034066
2011-02-07 12:27 adrianromero Proposed Solution updated
2011-02-09 13:27 adrianromero Target Version 2.50MP26 => 2.50MP27
2011-02-10 16:35 adrianromero Status new => scheduled
2011-02-10 16:35 adrianromero fix_in_branch => pi
2011-02-10 16:35 adrianromero Type defect => backport
2011-02-10 16:35 adrianromero fix_in_branch pi =>
2011-02-10 16:36 adrianromero Issue cloned 0015940
2011-02-10 16:36 adrianromero Relationship added blocks 0015940
2011-02-16 12:05 hgbot Checkin
2011-02-16 12:05 hgbot Note Added: 0034224
2011-02-16 12:05 hgbot Status scheduled => resolved
2011-02-16 12:05 hgbot Resolution open => fixed
2011-02-16 12:05 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/9679d1715f3b0913838c2cb5d3472eaec8fbe497 [^]
2011-02-16 12:22 adrianromero Note Added: 0034226
2011-02-28 20:06 jonalegriaesarte Note Added: 0034447
2011-02-28 20:06 jonalegriaesarte Status resolved => closed
2011-02-28 20:06 jonalegriaesarte Fixed in Version => 2.50MP27
2011-02-28 22:53 dalsasua Note Added: 0034449

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker