Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0044901Openbravo ERPY. DBSourceManagerpublic2020-08-26 14:412022-11-03 12:42
Reportershuehner 
Assigned ToTriage Platform Base 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0PR18Q3 
Target VersionFixed in VersionPR23Q1 
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
Summary0044901: PostgreSQL fails applying changes to columns used in views (during install.source)
DescriptionRunning install.source having a template increasing a column length while at the same time having a view using that column fails on PostgreSQL (unknown if also oracle).

ORA fails applying changes to columns used in functional indexes

Example:
Loading config script for module from path <hidden>/modules/org.openbravo.openbravoatopenbravo.template/src-db/database/configScript.xml
SQL Command failed with: ERROR: cannot alter type of a column used by a view or rule
  Detail: rule _RETURN on view obzdint_partners_v depends on column "name"
-- END
ALTER TABLE C_BPARTNER ALTER COLUMN NAME TYPE VARCHAR(150)

Steps To ReproduceCreate configScript modifying length of name column while having a view created using that column.
Example discovered in current ob@ob code (for this and several other columns).
Proposed SolutionProbably idea of 44892 which is part of fixing 44612 will fix this problem 'for free' (for the install.source part)
Additional Information
TagsNo tags attached.
Relationships
related to defect 0044612 new Triage Platform Base ORA fails applying changes to columns used in functional indexes 
related to defect 0044892 closed alostale On install.source config scripts are applied in two steps 
related to feature request 0050243 closed aferraz Increase the Column size for Product Characteristics Description 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-08-26 14:41shuehnerNew Issue
2020-08-26 14:41shuehnerAssigned To => platform
2020-08-26 14:41shuehnerModules => Core
2020-08-26 14:41shuehnerTriggers an Emergency Pack => No
2020-08-26 14:41shuehnerRelationship addedrelated to 0044612
2020-08-26 14:41shuehnerRelationship addedrelated to 0044892
2022-02-01 07:24alostaleAssigned Toplatform => Triage Platform Base
2022-07-29 13:17shuehnerNote Added: 0139720
2022-11-03 12:40hgbotNote Added: 0142872
2022-11-03 12:42alostaleNote Added: 0142878
2022-11-03 12:42alostaleStatusnew => closed
2022-11-03 12:42alostaleResolutionopen => fixed
2022-11-03 12:42alostaleFixed in Version => PR23Q1
2022-11-08 17:41aferrazRelationship addedrelated to 0050243

Notes
(0139720)
shuehner   
2022-07-29 13:17   
Adding 4 weeks SLA after chat ALO/SHU
(0142872)
hgbot   
2022-11-03 12:40   
Repository: https://gitlab.com/openbravo/product/dbsm [^]
Changeset: 7c083a878d524051d35fa2b0eb3bb68ab04de8a4
Author: Asier Lostalé <asier.lostale@openbravo.com>
Date: 03-11-2022 11:24:30
URL: https://gitlab.com/openbravo/product/dbsm/-/commit/7c083a878d524051d35fa2b0eb3bb68ab04de8a4 [^]

[create-db] related to BUG-44901: adds test case

---
A src-test/model/configScripts/BASE_MODEL_VIEW.xml
M src-test/src/org/openbravo/dbsm/test/configscript/ConfigScriptColumnSizeChange.java
---
(0142878)
alostale   
2022-11-03 12:42   
Fixed by 0044892