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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0042419
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2019-11-27 14:332020-01-20 09:11
ReportershuehnerView Statuspublic 
Assigned Tocberner 
PrioritynormalResolutionfixedFixed in Version3.0PR20Q2
StatusclosedFix in branchFixed in SCM revisionbff30b62883c
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0042419: Error about non-existing table on each install.source in pg logfile (related to obsolete table recreation in dbsm)

DescriptionOn each install.source the following error can be found in postgresql.log

2019-11-27 14:16:08.486 CET [11876] tadpi_pg12_pg@obpi_pg12_pg ERROR: relation "m_requisitionline_" does not exist at character 33
2019-11-27 14:16:08.486 CET [11876] tadpi_pg12_pg@obpi_pg12_pg STATEMENT: SELECT (SELECT DATEPLANNED FROM M_REQUISITIONLINE_ WHERE M_REQUISITIONLINE_.M_REQUISITIONLINE_ID = M_REQUISITIONLINE.M_REQUISITIONLINE_ID) FROM M_REQUISITIONLINE LIMIT 1

Technically that some from an onCreateDefault clause on the table definition:
database/model/tables/M_REQUISITIONLINE.xml: <onCreateDefault><![CDATA[SELECT DATEPLANNED FROM M_REQUISITIONLINE_ WHERE M_REQUISITIONLINE_.M_REQUISITIONLINE_ID = M_REQUISITIONLINE.M_REQUISITIONLINE_ID]]></onCreateDefault>

Technical error comes from the fact that the clause is reading from a M_REQUISITIONLINE_ table which is a intermediate table which was several years ago by update.database when modifying tables.

However that 'table recreation' is not done anymore for some years (except very special cases) so probably the onCreateDefault clause does not even provide value today.


Steps To ReproduceCheck postgresql log file after any install.source for above error.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0116532)
AugustoMauch (administrator)
2019-12-26 11:42

 This is the changeset where the onCreateDefault was introduced:

https://gitlab.com/openbravo/product/openbravo/commit/3d193630bc9a2e62deeee8a445792b0c3338ee2e [^]
(0116577)
cberner (viewer)
2019-12-30 16:36

 Being tracked in this merge request: https://gitlab.com/openbravo/product/openbravo/merge_requests/28 [^]
(0116782)
hgbot (developer)
2020-01-13 09:42

 Repository: erp/devel/pi
Changeset: bff30b62883c6fc9089d0ea30d34d6c7f493fa53
Author: Cristian Berner <cristian.berner <at> openbravo.com>
Date: Thu Dec 26 16:36:15 2019 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/bff30b62883c6fc9089d0ea30d34d6c7f493fa53 [^]

Fixes BUG-42419: Remove onDefaultCreate clause referencing intermediate table

---
M src-db/database/model/tables/M_REQUISITIONLINE.xml
---
(0117051)
AugustoMauch (administrator)
2020-01-20 09:11

 Code reviewed and verified

- Issue History
Date Modified Username Field Change
2019-11-27 14:33 shuehner New Issue
2019-11-27 14:33 shuehner Assigned To => platform
2019-11-27 14:33 shuehner OBNetwork customer => No
2019-11-27 14:33 shuehner Modules => Core
2019-11-27 14:33 shuehner Triggers an Emergency Pack => No
2019-12-26 11:42 AugustoMauch Note Added: 0116532
2019-12-26 11:43 AugustoMauch Assigned To platform => cberner
2019-12-30 16:28 cberner Status new => scheduled
2019-12-30 16:28 cberner Review Assigned To => AugustoMauch
2019-12-30 16:36 cberner Note Added: 0116577
2020-01-13 09:42 hgbot Checkin
2020-01-13 09:42 hgbot Note Added: 0116782
2020-01-13 09:42 hgbot Status scheduled => resolved
2020-01-13 09:42 hgbot Resolution open => fixed
2020-01-13 09:42 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bff30b62883c6fc9089d0ea30d34d6c7f493fa53 [^]
2020-01-20 09:11 AugustoMauch Note Added: 0117051
2020-01-20 09:11 AugustoMauch Status resolved => closed
2020-01-20 09:11 AugustoMauch Fixed in Version => 3.0PR20Q2

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker