How To Delete Manually Created Control File That Does Not Have Expiration Time

Question

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, the following file is generated by specifying the control name 'customer': 5d976fca_81c20_15392.ctrl-o2s-integ-snwct-customer

The following file is generated by default control name, i.e., adhoc: 5d498b9a_9b9af_5828. ctrl-o2s-integ-snwct -adhoc

How can I delete a manually created control file that does not have an expiration time?

Environment

HVR 5

Answer

To delete a manually created control file, do the following:

1. Stop the integrate job.
2. Delete the control files from location: $HVR_CONFIG/router/<hubname>/<channelname>/control/*.<ctrlname>.
3. 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).
4. Start the integrate job.