Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013702Openbravo ERPA. Platformpublic2010-06-19 00:272010-06-25 00:00
Reporterjpabloae 
Assigned Tomarvintm 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version2.6.18
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0013702: Objects in invalid state: AD_WINDOW_COPY, AD_ERROR_LOG_TRG
DescriptionThere 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 Reproduce1. 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-06-19 00:27jpabloaeNew Issue
2010-06-19 00:27jpabloaeAssigned To => marvintm
2010-06-19 00:27jpabloaeOBNetwork customer => No
2010-06-19 00:28jpabloaeDescription Updatedbug_revision_view_page.php?rev_id=522#r522
2010-06-19 11:12jpabloaeNote Added: 0028604
2010-06-19 11:12jpabloaePriorityurgent => immediate
2010-06-19 18:52priyamIssue Monitored: priyam
2010-06-21 13:00hgbotCheckin
2010-06-21 13:00hgbotNote Added: 0028610
2010-06-21 13:00hgbotStatusnew => resolved
2010-06-21 13:00hgbotResolutionopen => fixed
2010-06-21 13:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1af51dbec89551061703a70bf8639138ed6123ac [^]
2010-06-21 22:53hudsonbotCheckin
2010-06-21 22:53hudsonbotNote Added: 0028637
2010-06-24 11:42sureshbabuNote Added: 0028733
2010-06-24 11:42sureshbabuStatusresolved => closed
2010-06-25 00:00anonymoussf_bug_id0 => 3021061

Notes
(0028604)
jpabloae   
2010-06-19 11:12   
This is a showstopper for the 2.50MP19 release. Priority increased to immediate.
(0028610)
hgbot   
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   
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   
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.