27 views

Description

sys_storage_alias record is not deleted when dropping a column through Update Set, resulting in a orphan record in sys_storage_alias

Steps to Reproduce

1. Import, Preview, and Commit the attached update set "create_updateset.xml" , this creates 3 columns (u_test_ref_3, u_test_ref_4 & u_test_ref_5) on table => 'dscy_route_interface'
2. Verify the sys_dictionary and sys_storage_alias exists for the 3 columns on table ==> 'dscy_route_interface'
3. Import, Preview, and Commit the attached update set "FieldDelete_apply_second.xml" (deletes for all 3 columns)

Expected Result:
*sys_storage_alias for all fields are deleted

Actual Result
*sys_storage_alias for column ==>'u_test_ref_3' is deleted
*sys_storage_alias for column (u_test_ref_4 & u_test_ref_5) is not deleted

Workaround

The orphan storage aliases need to be removed from the backend. Please contact Customer Support to resolve this issue


Related Problem: PRB1245494

Seen In

Jakarta

Fixed In

Jakarta Patch 10
Kingston Patch 6
London

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-09-20 23:41:48
Published:2018-09-06