Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012047Openbravo ERPA. Platformpublic2010-01-22 17:142010-02-03 00:00
Reportermarvintm 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP11 
Target VersionFixed in Version2.50MP12 
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
Summary0012047: Sometimes the build raises an error related to missing database objects, but it continues executing
DescriptionIn some (rare) cases when doing a rebuild of the system through the application, it could happen that the build raises an error, sometimes with the following message:

"Error checking access"

and/or complaining about a missing database object, with a message similar to this one:

"Error: SQL error in query: SELECT ACCESSLEVEL FROM AD_FORM WHERE TO_CHAR('X') = ? AND AD_FORM_ID = ? UNION SELECT ACCESSLEVEL FROM AD_PROCESS WHERE (TO_CHAR('P') = ? OR TO_CHAR('R') = ?) AND AD_PROCESS_ID = ? UNION SELECT T.ACCESSLEVEL FROM AD_TABLE T, AD_TAB TB WHERE T.AD_TABLE_ID = TB.AD_TABLE_ID AND TO_CHAR('W') = ? AND TB.AD_TAB_ID = ? UNION SELECT ACCESSLEVEL FROM AD_TASK WHERE TO_CHAR('T') = ? AND AD_TASK_ID = ? UNION SELECT ACCESSLEVEL FROM AD_WORKFLOW WHERE TO_CHAR('F') = ? AND AD_WORKFLOW_ID = ?Exception:org.postgresql.util.PSQLException: ERROR: relation "ad_table" does not exist"


This happens because the access permission is checked on every AJAX call, while update.database recreates tables, and this sometimes can fail if the table checked is being recreated at the same time.
Steps To ReproduceThis is hard to reproduce. All the times this has happened it's been with a rebuild of Core through the application.
Proposed SolutionAccess will not be checked for the AJAX calls that the rebuild window creates.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-01-22 17:14marvintmNew Issue
2010-01-22 17:14marvintmAssigned To => alostale
2010-01-22 17:14marvintmOBNetwork customer => No
2010-01-22 17:14marvintmAssigned Toalostale => marvintm
2010-01-22 17:15marvintmversion => 2.50MP11
2010-01-22 17:15marvintmStatusnew => scheduled
2010-01-22 17:15marvintmfix_in_branch => pi
2010-01-22 17:16hgbotCheckin
2010-01-22 17:16hgbotNote Added: 0023761
2010-01-22 17:16hgbotStatusscheduled => resolved
2010-01-22 17:16hgbotResolutionopen => fixed
2010-01-22 17:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/27bf5acf156126ba64f9a0ea1f8080111d198b6f [^]
2010-01-23 12:44hudsonbotCheckin
2010-01-23 12:44hudsonbotNote Added: 0023777
2010-02-02 11:26sureshbabuNote Added: 0023909
2010-02-02 11:26sureshbabuStatusresolved => closed
2010-02-02 11:26sureshbabuFixed in Version => 2.50MP12
2010-02-03 00:00anonymoussf_bug_id0 => 2944922

Notes
(0023761)
hgbot   
2010-01-22 17:16   
Repository: erp/devel/pi
Changeset: 27bf5acf156126ba64f9a0ea1f8080111d198b6f
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Fri Jan 22 17:15:40 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/27bf5acf156126ba64f9a0ea1f8080111d198b6f [^]

Fixed 12047. AJAX calls created by the rebuild window will no longer be checked for access permissions.

---
M src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_PROCESS.xml
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
M src/org/openbravo/erpCommon/ad_process/ApplyModules.html
M src/org/openbravo/erpCommon/ad_process/ApplyModules.java
A src/org/openbravo/erpCommon/ad_process/ApplyModulesCallServlet.java
---
(0023777)
hudsonbot   
2010-01-23 12:44   
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/27bf5acf1561 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/71fb509c32a4 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15974.obx [^]
(0023909)
sureshbabu   
2010-02-02 11:26   
I rebuild the ERP through application, i didn't find the problem mentioned by the reporter.