0014600: update.database.script does 'wrong' changes compare to normal update.database

Description

Running update.database.script and checking console-output & .sql script output shows changes which look wrong (even after just doing a nomrla update.database, so none of those changes should be there).

From the output some changes looks wrong (isactive,null changes)

And the AD_MODULE.TYPE T-M change seems to 'revert' a change done in a existing configscript (which contained only a single change to do M->T in this one ad_module row)

Tags

No tags attached.

Attached Files

script-console-output.txt [^] (2,771 bytes) 2010-09-17 12:35 [Show Content] [Hide Content]

[alterscript] 65841 INFO  - Loading and applying configuration scripts
[alterscript] 65847 INFO  - Loading configuration script: /home/huehner/ob_branches/pi_pg/modules/org.testtemplate/src-db/database/configScript.xml
[alterscript] 65940 INFO  - Comparing databases to find differences
[alterscript] 70107 INFO  - Data changes we will perform: 
[alterscript] 70111 INFO  - [AD_MODEL_OBJECT_MAPPING.ISACTIVE <N->Y> PK: 7FF6CA0FA880B943E040007F01002CC9]
[alterscript] 70113 INFO  - [AD_MODEL_OBJECT_MAPPING.ISACTIVE <N->Y> PK: 7FF6CA0FA881B943E040007F01002CC9]
[alterscript] 70116 INFO  - [AD_MODEL_OBJECT_MAPPING.ISACTIVE <N->Y> PK: 7FF6CA0FA882B943E040007F01002CC9]
[alterscript] 70120 INFO  - [AD_MODEL_OBJECT_MAPPING.ISACTIVE <N->Y> PK: 7FF6CA0FA884B943E040007F01002CC9]
[alterscript] 70123 INFO  - [AD_MODULE.TYPE <T->M> PK: 2688DDFCDEF247BF9AEE2DB8CA548F76]
[alterscript] 70125 INFO  - [AD_MODULE_DEPENDENCY.DEPENDENCY_ENFORCEMENT <MAJOR->null> PK: 807F637DF4F74AF5AEF5B352368EB2CA]
[alterscript] 70128 INFO  - [AD_MODULE_DEPENDENCY.USER_EDITABLE_ENFORCEMENT <N->null> PK: 807F637DF4F74AF5AEF5B352368EB2CA]
[alterscript] 70131 INFO  - [AD_MODULE_DEPENDENCY.DEPENDENCY_ENFORCEMENT <MAJOR->null> PK: 89326AE95DAD449D85DFAB2C5B1C6683]
[alterscript] 70134 INFO  - [AD_MODULE_DEPENDENCY.USER_EDITABLE_ENFORCEMENT <N->null> PK: 89326AE95DAD449D85DFAB2C5B1C6683]
[alterscript] 70137 INFO  - [AD_MODULE_DEPENDENCY.DEPENDENCY_ENFORCEMENT <MAJOR->null> PK: B97FC854C6DD41E692161585645A900F]
[alterscript] 70140 INFO  - [AD_MODULE_DEPENDENCY.USER_EDITABLE_ENFORCEMENT <N->null> PK: B97FC854C6DD41E692161585645A900F]
[alterscript] 70142 INFO  - [AD_MODULE_DEPENDENCY.DEPENDENCY_ENFORCEMENT <MAJOR->null> PK: C955293F63F4497C87F75FBFEF4A3056]
[alterscript] 70145 INFO  - [AD_MODULE_DEPENDENCY.USER_EDITABLE_ENFORCEMENT <N->null> PK: C955293F63F4497C87F75FBFEF4A3056]
[alterscript] 70148 INFO  - [AD_MODULE_DEPENDENCY.DEPENDENCY_ENFORCEMENT <MAJOR->null> PK: F4C3E927F54547F1B0448A65442D2B38]
[alterscript] 70151 INFO  - [AD_MODULE_DEPENDENCY.USER_EDITABLE_ENFORCEMENT <N->null> PK: F4C3E927F54547F1B0448A65442D2B38]
[alterscript] 70153 INFO  - Appending default prescript
[alterscript] 70164 INFO  - Updating database model...
[alterscript] 70621 INFO  - Model update complete.
[alterscript] 70625 INFO  - Disabling foreign keys
[alterscript] 70646 INFO  - Disabling triggers
[alterscript] 70659 INFO  - Updating database data...
[alterscript] 70664 INFO  - Removing invalid rows.
[alterscript] 70700 INFO  - Recreating Primary Keys
[alterscript] 70807 INFO  - Executing update final script (NOT NULLs and dropping temporal tables
[alterscript] 70915 INFO  - Enabling Foreign Keys and Triggers
[alterscript] 95492 INFO  - Executing default postscript

script-sql-output.txt [^] (2,387 bytes) 2010-09-17 12:35 [Show Content] [Hide Content]

DROP FUNCTION OBUISEL_SELECTOR_TRL_TRG()
/
UPDATE AD_MODEL_OBJECT_MAPPING SET ISACTIVE = 'Y', UPDATED = now() WHERE AD_MODEL_OBJECT_MAPPING_ID = '7FF6CA0FA880B943E040007F01002CC9'
/
UPDATE AD_MODEL_OBJECT_MAPPING SET ISACTIVE = 'Y', UPDATED = now() WHERE AD_MODEL_OBJECT_MAPPING_ID = '7FF6CA0FA881B943E040007F01002CC9'
/
UPDATE AD_MODEL_OBJECT_MAPPING SET ISACTIVE = 'Y', UPDATED = now() WHERE AD_MODEL_OBJECT_MAPPING_ID = '7FF6CA0FA882B943E040007F01002CC9'
/
UPDATE AD_MODEL_OBJECT_MAPPING SET ISACTIVE = 'Y', UPDATED = now() WHERE AD_MODEL_OBJECT_MAPPING_ID = '7FF6CA0FA884B943E040007F01002CC9'
/
UPDATE AD_MODULE SET UPDATED = now(), TYPE = 'M' WHERE AD_MODULE_ID = '2688DDFCDEF247BF9AEE2DB8CA548F76'
/
UPDATE AD_MODULE_DEPENDENCY SET UPDATED = now(), DEPENDENCY_ENFORCEMENT = NULL WHERE AD_MODULE_DEPENDENCY_ID = '807F637DF4F74AF5AEF5B352368EB2CA'
/
UPDATE AD_MODULE_DEPENDENCY SET UPDATED = now(), USER_EDITABLE_ENFORCEMENT = NULL WHERE AD_MODULE_DEPENDENCY_ID = '807F637DF4F74AF5AEF5B352368EB2CA'
/
UPDATE AD_MODULE_DEPENDENCY SET UPDATED = now(), DEPENDENCY_ENFORCEMENT = NULL WHERE AD_MODULE_DEPENDENCY_ID = '89326AE95DAD449D85DFAB2C5B1C6683'
/
UPDATE AD_MODULE_DEPENDENCY SET UPDATED = now(), USER_EDITABLE_ENFORCEMENT = NULL WHERE AD_MODULE_DEPENDENCY_ID = '89326AE95DAD449D85DFAB2C5B1C6683'
/
UPDATE AD_MODULE_DEPENDENCY SET UPDATED = now(), DEPENDENCY_ENFORCEMENT = NULL WHERE AD_MODULE_DEPENDENCY_ID = 'B97FC854C6DD41E692161585645A900F'
/
UPDATE AD_MODULE_DEPENDENCY SET UPDATED = now(), USER_EDITABLE_ENFORCEMENT = NULL WHERE AD_MODULE_DEPENDENCY_ID = 'B97FC854C6DD41E692161585645A900F'
/
UPDATE AD_MODULE_DEPENDENCY SET UPDATED = now(), DEPENDENCY_ENFORCEMENT = NULL WHERE AD_MODULE_DEPENDENCY_ID = 'C955293F63F4497C87F75FBFEF4A3056'
/
UPDATE AD_MODULE_DEPENDENCY SET UPDATED = now(), USER_EDITABLE_ENFORCEMENT = NULL WHERE AD_MODULE_DEPENDENCY_ID = 'C955293F63F4497C87F75FBFEF4A3056'
/
UPDATE AD_MODULE_DEPENDENCY SET UPDATED = now(), DEPENDENCY_ENFORCEMENT = NULL WHERE AD_MODULE_DEPENDENCY_ID = 'F4C3E927F54547F1B0448A65442D2B38'
/
UPDATE AD_MODULE_DEPENDENCY SET UPDATED = now(), USER_EDITABLE_ENFORCEMENT = NULL WHERE AD_MODULE_DEPENDENCY_ID = 'F4C3E927F54547F1B0448A65442D2B38'
/
DELETE FROM AD_ALERTRECIPIENT WHERE AD_ALERTRULE_ID IN ((SELECT AD_ALERTRULE_ID FROM AD_ALERTRECIPIENT) EXCEPT (SELECT AD_ALERTRULE_ID FROM AD_ALERTRULE))

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

design defect

0038296

acknowledged

Triage Platform Base

Review & cleanup build.xml

Notes
(0052481) AugustoMauch (manager) 2012-09-24 23:30	Impact: low Plan: mid

Issue History
Date Modified	Username	Field	Change
2010-09-17 12:35	shuehner	New Issue
2010-09-17 12:35	shuehner	Assigned To	=> marvintm
2010-09-17 12:35	shuehner	File Added: script-console-output.txt
2010-09-17 12:35	shuehner	File Added: script-sql-output.txt
2010-09-20 09:00	alostale	Status	new => scheduled
2012-05-08 16:39	marvintm	Type	defect => design defect
2012-09-24 23:30	AugustoMauch	Note Added: 0052481
2012-09-24 23:30	AugustoMauch	Priority	high => normal
2018-04-08 17:02	shuehner	Assigned To	marvintm => platform
2018-04-08 17:02	shuehner	Relationship added	blocks 0038296
2022-02-01 08:08	alostale	Assigned To	platform => Triage Platform Base