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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0037862
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupminoralways2018-02-08 16:312020-11-06 07:26
ReporterngarciaView Statuspublic 
Assigned Toplatform 
PriorityurgentResolutionout of dateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0037862: 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 (...
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0036109 closedinigosanchez If Delete Client Process fails, it does not show any error message and leaves the triggers disabled 

-  Notes
(0103135)
alostale (viewer)
2018-03-09 13:19

 Downgrading severity to minor
(0124199)
alostale (viewer)
2020-11-06 07:26

 Won't fix as it affects analytics module which is no longer maintained.

- Issue History
Date Modified Username Field Change
2018-02-08 16:31 ngarcia New Issue
2018-02-08 16:31 ngarcia Assigned To => Triage Finance
2018-02-08 16:31 ngarcia OBNetwork customer => Yes
2018-02-08 16:31 ngarcia Modules => Core
2018-02-08 16:31 ngarcia Support ticket => 50825
2018-02-08 16:31 ngarcia Resolution time => 1519858800
2018-02-08 16:31 ngarcia Triggers an Emergency Pack => No
2018-02-08 16:33 ngarcia Relationship added related to 0036109
2018-02-08 16:33 ngarcia Issue Monitored: networkb
2018-02-09 13:25 dmiguelez Assigned To Triage Finance => markmm82
2018-02-09 15:53 markmm82 Status new => scheduled
2018-02-15 12:52 dmiguelez Assigned To markmm82 => platform
2018-03-09 13:19 alostale Resolution time 1519858800 =>
2018-03-09 13:19 alostale Note Added: 0103135
2018-03-09 13:19 alostale Severity major => minor
2018-03-09 13:19 alostale Status scheduled => acknowledged
2020-11-06 07:25 alostale Status acknowledged => scheduled
2020-11-06 07:25 alostale Status scheduled => acknowledged
2020-11-06 07:25 alostale Status acknowledged => scheduled
2020-11-06 07:26 alostale Note Added: 0124199
2020-11-06 07:26 alostale Status scheduled => closed
2020-11-06 07:26 alostale Resolution open => out of date

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker