Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0013702 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2010-06-19 00:27 | 2010-06-25 00:00 | |||
| Reporter | jpabloae | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 1af51dbec895 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.6.0_20 | |||
| OS Version | 2.6.18 | Database version | 11.1.0.7.0 | Ant version | 1.7.1 | |||
| Product Version | pi | SCM revision | 06569583f414 | |||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| 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 | 0013702: Objects in invalid state: AD_WINDOW_COPY, AD_ERROR_LOG_TRG | |||||||
| Description | There are 2 database objects in invalid state: OBJECT_ID OBJECT_NAME OBJECT_TYPE ---------- -------------------------------- ------------------- 3330495 AD_WINDOW_COPY PROCEDURE 3330774 AD_ERROR_LOG_TRG TRIGGER These 2 commits seem to be the culprits: https://code.openbravo.com/erp/devel/pi/rev/86b0e6bd04aa [^] https://code.openbravo.com/erp/devel/pi/rev/fd8cd75cd810 [^] | |||||||
| Steps To Reproduce | 1. Run "CALL DBA_RECOMPILE(NULL);" in Oracle. 2. Run "SELECT object_id, object_name, object_type FROM user_objects WHERE status<>'VALID' AND object_type IN('VIEW', 'PACKAGE', 'PACKAGE BODY', 'FUNCTION', 'PROCEDURE', 'TRIGGER', 'JAVA CLASS') ORDER BY object_type, object_name;" to check the invalid objects. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0028604) jpabloae (viewer) 2010-06-19 11:12 |
This is a showstopper for the 2.50MP19 release. Priority increased to immediate. |
|
(0028610) hgbot (developer) 2010-06-21 13:00 |
Repository: erp/devel/pi Changeset: 1af51dbec89551061703a70bf8639138ed6123ac Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Mon Jun 21 12:59:55 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/1af51dbec89551061703a70bf8639138ed6123ac [^] Fixed issue 13702. Fixed invalid state of triggers AD_WINDOW_COPY and AD_ERROR_LOG_TRG --- M src-db/database/model/functions/AD_WINDOW_COPY.xml M src-db/database/model/triggers/AD_ERROR_LOG_TRG.xml --- |
|
(0028637) hudsonbot (viewer) 2010-06-21 22:53 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/1af51dbec895 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/de0e0761bcbe [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17692.obx [^] |
|
(0028733) sureshbabu (viewer) 2010-06-24 11:42 |
verified in oracle context, after executing the two statements ( 1) CALL DBA_RECOMPILE(NULL); 2) SELECT object_id, object_name, object_type FROM user_objects WHERE status<>'VALID' AND object_type IN('VIEW', 'PACKAGE', 'PACKAGE BODY', 'FUNCTION', 'PROCEDURE', 'TRIGGER', 'JAVA CLASS') ORDER BY object_type, object_name;) , the select query returns zero records. works fine for me. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-06-19 00:27 | jpabloae | New Issue | |
| 2010-06-19 00:27 | jpabloae | Assigned To | => marvintm |
| 2010-06-19 00:27 | jpabloae | OBNetwork customer | => No |
| 2010-06-19 00:28 | jpabloae | Description Updated | View Revisions |
| 2010-06-19 11:12 | jpabloae | Note Added: 0028604 | |
| 2010-06-19 11:12 | jpabloae | Priority | urgent => immediate |
| 2010-06-19 18:52 | priyam | Issue Monitored: priyam | |
| 2010-06-21 13:00 | hgbot | Checkin | |
| 2010-06-21 13:00 | hgbot | Note Added: 0028610 | |
| 2010-06-21 13:00 | hgbot | Status | new => resolved |
| 2010-06-21 13:00 | hgbot | Resolution | open => fixed |
| 2010-06-21 13:00 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/1af51dbec89551061703a70bf8639138ed6123ac [^] |
| 2010-06-21 22:53 | hudsonbot | Checkin | |
| 2010-06-21 22:53 | hudsonbot | Note Added: 0028637 | |
| 2010-06-24 11:42 | sureshbabu | Note Added: 0028733 | |
| 2010-06-24 11:42 | sureshbabu | Status | resolved => closed |
| 2010-06-25 00:00 | anonymous | sf_bug_id | 0 => 3021061 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |