Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009238Openbravo ERPA. Platformpublic2009-05-29 11:492009-06-04 00:00
Reportershuehner 
Assigned Toiperdomo 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
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
Summary0009238: api check: build 29 failed with a warning
Descriptionhttps://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/29/ [^]

+++++++++++++++++++++++++++++++++++++++++++++++++++
  Warnings in API model validation
+++++++++++++++++++++++++++++++++++++++++++++++++++
  Column size changed from 1000 to 4000: column: AD_PROCESS_REQUEST.OB_CONTEXT


Test validate API with warnings
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0008917 closed iperdomo Error Message when set org. as ready 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-05-29 11:49shuehnerNew Issue
2009-05-29 11:49shuehnerAssigned To => iperdomo
2009-05-29 12:20iperdomoNote Added: 0016759
2009-05-29 12:20iperdomoRelationship addedrelated to 0008917
2009-05-29 12:20iperdomoAssigned Toiperdomo => pjuvara
2009-06-01 06:59pjuvaraNote Added: 0016779
2009-06-01 06:59pjuvaraStatusnew => scheduled
2009-06-01 06:59pjuvaraAssigned Topjuvara => iperdomo
2009-06-01 06:59pjuvarafix_in_branch => pi
2009-06-01 11:58iperdomoStatusscheduled => resolved
2009-06-01 11:58iperdomoFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/32910a30d3cc7be3ae1cc355f29f8dd1a54a05f4 [^]
2009-06-01 11:58iperdomoResolutionopen => fixed
2009-06-03 13:15psarobeStatusresolved => closed
2009-06-04 00:00anonymoussf_bug_id0 => 2800789

Notes
(0016759)
iperdomo   
2009-05-29 12:20   
Type: Change column datatype

Description: AD_PROCESS_REQUEST.OB_CONTEXT length change from VARCHAR(1000) to VARCHAR(4000)

Risk: LOW

Comments:
This change was made to fix the issue 8917 (immediate) [1]. The OB_Context columns holds a json serialized version of the user context. This information is part of a Process Bundled, required by the Process Scheduler (based on Quartz). As you may see in the comments of the resolved issue, if you have several organizations, we try to store a very long string on this column. This is a long string because part of the user context is the 'accessible organization tree'. With UUID as ids for the organizations, 1000 characters container can be filled easily.

The increase of the length of this column will not break any available module, since is used in a internal scheduling operation.

[1] https://issues.openbravo.com/view.php?id=8917 [^]

Best Regards,

Iván
(0016779)
pjuvara   
2009-06-01 06:59   
Approved.
Please publish an alert.