0036902: Update.database fails under some circumstances if a model change is defined

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #36902		[ Back to Issue ]
Summary	0036902: Update.database fails under some circumstances if a model change is defined

Revision	2017-09-20 16:28 by inigosanchez
Description	Update.database fails if a model change such as columnSizeChange is defined in a configScript (Not all model changes generates the reported problem.) and the data is bigger than old size (defined in core) but smaller than new size. This problem has been found trying to update a BUT Instance with the new fixed issue of DBSM (0036137).

Revision	2017-09-20 16:20 by inigosanchez
Description	When doing an update database process, if there are some changes in a template that modifies the length of any column, that change is not applied.

Revision	2017-09-20 16:20 by inigosanchez
Steps To Reproduce	1.- Applied attached diff (columnSizeChange is done in description of AD_USER: 255 to 290) in pi 2.- Execute ant smartbuild -Dlocal=no -Dtr=no -> model change is applied properly. 3.- Update the value of description column for a user: UPDATE ad_user SET description='{STRING_BIGGER_THAN_255_AND_SMALLER_THAN_290}' WHERE AD_USER_ID='167450A5BB284AB29C4FEF039E98C963'; 4.- Execute ant smartbuild -Dlocal=no -Dtr=no again -> ERROR* *The ERROR appears in the recreation of the table AD_USER, when it is tried to insert the data in the recreated table.

Revision	2017-09-20 14:49 by inigosanchez
Steps To Reproduce	Update an environment with any template that changes the length of a column. Update the database without the change that causes the regression. Update the environment to tip and update again. The changes are not maintained.