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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0013702
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2010-06-19 00:272010-06-25 00:00
ReporterjpabloaeView Statuspublic 
Assigned Tomarvintm 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision1af51dbec895
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6.0_20
OS Version2.6.18Database version11.1.0.7.0Ant version1.7.1
Product VersionpiSCM revision06569583f414 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0028604)
jpabloae (reporter)
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 (developer)
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 (reporter)
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.

- 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: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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker