Problem Summary: Instructions to delete a manually created control file that does not have expiration time
Description:
Control files that are created manually by the users are suffixed with adhoc 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 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
Answer:
Steps to delete this file:
- 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. To delete this table please refer to https://www.hvr-software.com/support-services/customer-resources/forum/topic/delete-table-existing-channel/)
- Start the integrate job