Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036441ModulesAnalyticspublic2017-07-06 17:492017-07-17 09:35
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toalostale
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary0036441: Modularity (needs module in development) check for cube dimensions is not working correctly
DescriptionThe obanaly_cube_dim_mod_Trg triggers is not working correctly.

It has a coalesce (:OLD.line, '.') while the datatype of that column is numeric.

That makes the trigger fail to work correctly when it should reject an eject with message to need a module in development instead of shows some SQLException about the data type mismatch.
Steps To ReproduceInstall analytics module
Go to Cube definition window and select a record having 'cube dimension' entries in its child tab.
Try to edit edit existing cube dimension entry without the module in development.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0036452 closed rqueralta Retail Modules 2 warnings found in pl code by plpgsql_check 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-07-06 17:49shuehnerNew Issue
2017-07-06 17:49shuehnerAssigned To => platform
2017-07-06 17:49shuehnerOBNetwork customer => No
2017-07-06 17:50shuehnerAssigned Toplatform => shuehner
2017-07-06 18:01hgbotCheckin
2017-07-06 18:01hgbotNote Added: 0097922
2017-07-06 18:01hgbotStatusnew => resolved
2017-07-06 18:01hgbotResolutionopen => fixed
2017-07-06 18:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/79857c7405e161f4a61bb261874e31c402a78fd4 [^]
2017-07-10 18:06shuehnerRelationship addedrelated to 0036452
2017-07-14 15:06alostaleReview Assigned To => alostale
2017-07-17 09:35alostaleNote Added: 0098094
2017-07-17 09:35alostaleStatusresolved => closed

Notes
(0097922)
hgbot   
2017-07-06 18:01   
Repository: erp/pmods/org.openbravo.client.analytics
Changeset: 79857c7405e161f4a61bb261874e31c402a78fd4
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Jul 06 18:01:24 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/79857c7405e161f4a61bb261874e31c402a78fd4 [^]

Fixed 36441. Fix modularity trigger typ mismatch.

Fix type-mismatch in coalesce statement by using 0 and not '.' for a numeric
column. Also remove a couple of unused declared variables to get the module
clean as per plpgsql_check warnings.

---
M src-db/database/model/triggers/OBANALY_CUBE_DIM_MOD_TRG.xml
M src-db/database/model/triggers/OBANALY_REPORT_QUERY_MOD_TRG.xml
M src-db/database/model/triggers/OBANALY_WIDGT_ANALYTIC_MOD_TRG.xml
---
(0098094)
alostale   
2017-07-17 09:35   
reviewed