Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0012047 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | have not tried | 2010-01-22 17:14 | 2010-02-03 00:00 | |||
| Reporter | marvintm | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.50MP12 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 27bf5acf1561 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP11 | SCM revision | ||||||
| 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 | 0012047: Sometimes the build raises an error related to missing database objects, but it continues executing | |||||||
| Description | In 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 Reproduce | This is hard to reproduce. All the times this has happened it's been with a rebuild of Core through the application. | |||||||
| Proposed Solution | Access will not be checked for the AJAX calls that the rebuild window creates. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0023761) hgbot (developer) 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 (viewer) 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 (viewer) 2010-02-02 11:26 |
I rebuild the ERP through application, i didn't find the problem mentioned by the reporter. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-01-22 17:14 | marvintm | New Issue | |
| 2010-01-22 17:14 | marvintm | Assigned To | => alostale |
| 2010-01-22 17:14 | marvintm | OBNetwork customer | => No |
| 2010-01-22 17:14 | marvintm | Assigned To | alostale => marvintm |
| 2010-01-22 17:15 | marvintm | version | => 2.50MP11 |
| 2010-01-22 17:15 | marvintm | Status | new => scheduled |
| 2010-01-22 17:15 | marvintm | fix_in_branch | => pi |
| 2010-01-22 17:16 | hgbot | Checkin | |
| 2010-01-22 17:16 | hgbot | Note Added: 0023761 | |
| 2010-01-22 17:16 | hgbot | Status | scheduled => resolved |
| 2010-01-22 17:16 | hgbot | Resolution | open => fixed |
| 2010-01-22 17:16 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/27bf5acf156126ba64f9a0ea1f8080111d198b6f [^] |
| 2010-01-23 12:44 | hudsonbot | Checkin | |
| 2010-01-23 12:44 | hudsonbot | Note Added: 0023777 | |
| 2010-02-02 11:26 | sureshbabu | Note Added: 0023909 | |
| 2010-02-02 11:26 | sureshbabu | Status | resolved => closed |
| 2010-02-02 11:26 | sureshbabu | Fixed in Version | => 2.50MP12 |
| 2010-02-03 00:00 | anonymous | sf_bug_id | 0 => 2944922 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |