Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0013674 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Modules] zz obsolete Easy Extensible Attributes | minor | have not tried | 2010-06-16 15:38 | 2010-06-16 15:38 | |||||||
| Reporter | roklenardic | View Status | public | |||||||||
| Assigned To | marvintm | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | 2.50 | SCM revision | ||||||||||
| Regression date | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Regression level | ||||||||||||
| Review Assigned To | ||||||||||||
| Regression introduced in release | ||||||||||||
| Summary | 0013674: Triggers not recreated on rebuild | |||||||||||
| Description | 1. Use the Easy Extensible Attributes 1.0.1 and 2.50MP18 2. create a new image column/field of type BLOB for the M_Product table 3. immediately apply the changes and rebuild the application You will find a warning about nonexisting M_PRODUCT_TRG (see also screenshot attached) set.code.rev: code.rev: init: core.lib: init: compile: build.jar: build: copy.core.lib: database.lib: init: compile: build.jar: jar: buildvalidation: buildvalidation: update.database.mod: update.database.mod.java: [java] 0 INFO - Database connection: jdbc:postgresql://localhost:5432/openbravo. [^] User: tad [java] 908 INFO - Creating submodel for application dictionary [java] 18269 INFO - Loading data from XML files [java] 33265 INFO - Loading and applying configuration scripts [java] Checking if database structure was modified locally. [java] Checking if data has changed in the application dictionary. [java] 33618 INFO - Change detected in table: AD_Element [java] 33678 INFO - Database was modified locally, but as update.database command is forced, the database will be updated anyway. [java] 33965 INFO - Updating module: com.woofinc.openbravo.module [java] 33970 INFO - Loading submodel from database... [java] 34019 INFO - Reading tables... [java] 74076 INFO - Reading views... [java] 74086 INFO - Reading sequences... [java] 74093 INFO - Reading triggers... [java] 74145 INFO - Reading functions... [java] 74203 INFO - Sorting foreign keys, indexes and checks... [java] 74207 INFO - Starting function and trigger standardization. [java] 74213 INFO - Submodel loaded [java] 74496 INFO - Updating database model... [java] 77777 WARN - SQL Command failed with: ERROR: trigger "m_product_trg" for table "m_product" does not exist [java] 77785 WARN - -- END [java] -- ----------------------------------------------------------------------- [java] -- TRIGGER M_PRODUCT_TRG [java] -- ----------------------------------------------------------------------- [java] DROP TRIGGER M_PRODUCT_TRG ON M_PRODUCT CASCADE [java] 77847 WARN - SQL Command failed with: ERROR: trigger "m_product_trg2" for table "m_product" does not exist [java] 77851 WARN - -- END [java] -- ----------------------------------------------------------------------- [java] -- TRIGGER M_PRODUCT_TRG2 [java] -- ----------------------------------------------------------------------- [java] DROP TRIGGER M_PRODUCT_TRG2 ON M_PRODUCT CASCADE [java] 78125 INFO - Executed 71 SQL command(s) with 2 error(s) [java] 78130 INFO - Model update complete. [java] 78134 INFO - Loading data from XML files [java] 78529 INFO - Comparing databases to find data differences [java] 78535 INFO - Updating database data... [java] 78597 INFO - Disabling foreign keys [java] 79600 INFO - Executed 185 SQL command(s) successfully [java] 79610 INFO - Disabling triggers [java] 79778 INFO - Executed 132 SQL command(s) successfully [java] 85405 INFO - Executed 5013 SQL command(s) successfully [java] 85418 INFO - Updating database data for module Woof Inc Module [java] 85422 INFO - Recreating Primary Keys [java] 85567 INFO - Executed 5 SQL command(s) successfully [java] 85571 INFO - Removing invalid rows. [java] 101082 INFO - Executed 171 SQL command(s) successfully [java] 101089 INFO - Executing update final script (NOT NULLs and dropping temporary tables) [java] 103268 INFO - Executed 89 SQL command(s) successfully [java] 115893 INFO - Executed 120 SQL command(s) successfully [java] 115898 INFO - Enabling Foreign Keys and Triggers [java] 147228 INFO - Executed 5509 SQL command(s) successfully [java] 149877 INFO - Executed 185 SQL command(s) successfully [java] 186232 INFO - Executed 132 SQL command(s) successfully [java] 186237 INFO - Executing default postscript [java] 188708 INFO - Executed 22 SQL command(s) successfully ... ... ... | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files |  BTTerroraddnewfield.png [^] (70,387 bytes) 2010-06-16 15:38
| |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-06-16 15:38 | roklenardic | New Issue | |
| 2010-06-16 15:38 | roklenardic | Assigned To | => marvintm |
| 2010-06-16 15:38 | roklenardic | File Added: BTTerroraddnewfield.png | |
| 2022-02-18 04:26 | priyam | Category | Easy Extensible Attributes => zz obsolete Easy Extensible Attributes |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |