Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0027742 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | have not tried | 2014-10-02 13:09 | 2014-12-30 23:26 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | e352011a1215 | |||
| Projection | none | ETA | none | Target Version | 3.0PR15Q1 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | pramakrishnan | |||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0027742: The database view C_ORDER_LINETAX_VT is not used at all and has syntax concistency problem with pgsql 9.3 | |||||||
| Description | This view has same dbconsistency problems as described in issue 27741. But also this c_order_linetax_vt view seems completely unused. See following comments for more how that 'unused' was tested. | |||||||
| Steps To Reproduce | - | |||||||
| Proposed Solution | Delete that view completely from the ERP as it seems not to be used at all. NOTE: This will be an api-change | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0070660) shuehner (administrator) 2014-10-02 13:26 |
Testing done to find usage of this view: 1.) in a pi clone: grep -Iir C_ORDER_LINETAX_VT . No occurrence found besides view definition itself. Note: Not mapped at all in AD, so there cannot be any user via DAL. 2.) Search for view name in all gpscode hg-repos (130 repos) containing many modules by gps which are likely to not be in CR) No occurrence found (ignoring pi branch which can be ignored) 3.) Grepping same way in most modules published in CR in status QAA. Number of checked modules: 772, downloaded at 2014-08-04 No occurrence found. Based on those checks i think we can fairly assume that it is very unlikely that the view is used by modules. |
|
(0072075) hgbot (developer) 2014-11-27 16:38 |
Repository: erp/devel/pi Changeset: e352011a1215d4e395ee469b99e7667fc1ad46c2 Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> Date: Thu Nov 27 16:37:56 2014 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/e352011a1215d4e395ee469b99e7667fc1ad46c2 [^] Fixes bug 27742: The database view C_ORDER_LINETAX_VT is not used --- R src-db/database/model/views/C_ORDER_LINETAX_VT.xml --- |
|
(0072412) pramakrishnan (viewer) 2014-12-11 06:57 |
Verified |
|
(0073152) hudsonbot (viewer) 2014-12-30 23:26 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/6525fe229e06 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-10-02 13:09 | shuehner | New Issue | |
| 2014-10-02 13:09 | shuehner | Assigned To | => dmiguelez |
| 2014-10-02 13:09 | shuehner | OBNetwork customer | => No |
| 2014-10-02 13:09 | shuehner | Modules | => Core |
| 2014-10-02 13:09 | shuehner | Triggers an Emergency Pack | => No |
| 2014-10-02 13:11 | shuehner | Target Version | => 3.0PR15Q1 |
| 2014-10-02 13:26 | shuehner | Note Added: 0070660 | |
| 2014-10-02 13:31 | shuehner | Relationship added | related to 0027741 |
| 2014-11-26 18:18 | shuehner | Assigned To | dmiguelez => eduardo_Argal |
| 2014-11-26 18:51 | eduardo_Argal | Status | new => scheduled |
| 2014-11-26 18:51 | eduardo_Argal | fix_in_branch | => pi |
| 2014-11-27 16:38 | hgbot | Checkin | |
| 2014-11-27 16:38 | hgbot | Note Added: 0072075 | |
| 2014-11-27 16:38 | hgbot | Status | scheduled => resolved |
| 2014-11-27 16:38 | hgbot | Resolution | open => fixed |
| 2014-11-27 16:38 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/e352011a1215d4e395ee469b99e7667fc1ad46c2 [^] |
| 2014-12-11 06:57 | pramakrishnan | Review Assigned To | => pramakrishnan |
| 2014-12-11 06:57 | pramakrishnan | Note Added: 0072412 | |
| 2014-12-11 06:57 | pramakrishnan | Status | resolved => closed |
| 2014-12-30 23:26 | hudsonbot | Checkin | |
| 2014-12-30 23:26 | hudsonbot | Note Added: 0073152 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |