Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037862Openbravo ERP01. General setuppublic2018-02-08 16:312020-11-06 07:26
Reporterngarcia 
Assigned Toplatform 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket50825
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037862: Delete Client process finishes with error if there exists records in OBANALY_Tree_Closure table
DescriptionDelete Client process finishes with error if there exists records in OBANALY_Tree_Closure table

The system becomes under maintenance and all the triggers get disabled
Steps To ReproduceIn an environment with OB Analytics installed (https://livebuilds.openbravo.com/retail_modules_pgsql_pi [^])

As System Admin role:
   Go to Process Request window and set 'Update Time Dimension Refs + Tree Closure Table' process to be run immediately
   Once it finishes, launch the Delete Client process for 'QA Testing'
   Check the process finishes with error:
"Error while executing SQL"

   The log shows:
      ERROR org.apache.ddlutils.DatabaseOperationException - Error while executing SQL
org.postgresql.util.PSQLException: ERROR: null value in column "ad_tree_id" violates not-null constraint
  Detail: Failing row contains (...
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0036109 closed inigosanchez If Delete Client Process fails, it does not show any error message and leaves the triggers disabled 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-02-08 16:31ngarciaNew Issue
2018-02-08 16:31ngarciaAssigned To => Triage Finance
2018-02-08 16:31ngarciaOBNetwork customer => Yes
2018-02-08 16:31ngarciaModules => Core
2018-02-08 16:31ngarciaSupport ticket => 50825
2018-02-08 16:31ngarciaResolution time => 1519858800
2018-02-08 16:31ngarciaTriggers an Emergency Pack => No
2018-02-08 16:33ngarciaRelationship addedrelated to 0036109
2018-02-08 16:33ngarciaIssue Monitored: networkb
2018-02-09 13:25dmiguelezAssigned ToTriage Finance => markmm82
2018-02-09 15:53markmm82Statusnew => scheduled
2018-02-15 12:52dmiguelezAssigned Tomarkmm82 => platform
2018-03-09 13:19alostaleResolution time1519858800 =>
2018-03-09 13:19alostaleNote Added: 0103135
2018-03-09 13:19alostaleSeveritymajor => minor
2018-03-09 13:19alostaleStatusscheduled => acknowledged
2020-11-06 07:25alostaleStatusacknowledged => scheduled
2020-11-06 07:25alostaleStatusscheduled => acknowledged
2020-11-06 07:25alostaleStatusacknowledged => scheduled
2020-11-06 07:26alostaleNote Added: 0124199
2020-11-06 07:26alostaleStatusscheduled => closed
2020-11-06 07:26alostaleResolutionopen => out of date

Notes
(0103135)
alostale   
2018-03-09 13:19   
Downgrading severity to minor
(0124199)
alostale   
2020-11-06 07:26   
Won't fix as it affects analytics module which is no longer maintained.