How To Delete Manually Created Control File That Does Not Have Expiration Time
Introduction
Find out how to delete a manually created control file that does not have an expiration time.
Description
Control files that are created manually by the users are suffixed with ad-hoc provided they have specified a name. In case a name is specified they will be suffixed with the control name.
For example, this file is generated by specifying the control name 'customer':
5d976fca_81c20_15392.ctrl-o2s-integ-snwct-customer
This file is generated by default control name, i.e., adhoc:
5d498b9a_9b9af_5828. ctrl-o2s-integ-snwct -adhoc
Steps
To delete a manually created control file, do the following:
- Stop the integrate job.
- Delete the control files from location:
$HVR_CONFIG/router/<hubname>/<channelname>/control/*.<ctrlname>
. - Refresh the table (Only if the table is required in the channel otherwise delete this table from the channel. For more information, see our documentation).
- Start the integrate job.