search cancel

Global variable contains invalid characters - how can I now delete it

book

Article ID: 255239

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

A global variable was incorrectly created that contained 2 question marks, and now we cannot delete it.

Environment

Release : 12.0

Resolution

If you need to manually delete some autosys global variable that contains non-ascii characters you can do so via a direct database update.

Example

Make sure you provide a partial name to get the single variable you want to delete...

select glo_name from aedbadmin.ujo_glob where glo_name like 'FDB_MAPS_MAPS_%';

Then you can delete it

delete from aedbadmin.ujo_glob where glo_name like 'FDB_MAPS_MAPS_%';

NOTE - Non-ASCII characters at the end of lines during your sendevent -E SET_GLOBAL commands can cause issues.
Make sure to remove any/all trailing non-ascii characters from your sendevents before issuing the commands.