The “activate config” results in “The data source name in the config file is not valid” (4297073)

The “activate config” results in “The data source name in the config file is not valid”

The following errors are observed when activating a config:

sp_ctrl>activate config config_file_name

   cnc_activate() The data source name in the config file is not valid

The entry for the datasource is either missing or is incorrect

The first line in the config file contains the datasource specification where datasource is SharePlex terminology for the SID of the source database. If that line is missing or if the datasource specified is incorrect, then the above error will occur. To correct the problem, edit the config file to either include the datasource entry (if one is missing) or correct it (if it is incorrect) before activating again. 

For your info, here is the format of the datasource entry and the subsequent lines of the config file: datasource:o.sourceSID #source tables target tables routing map OWNER.SOURCE_TABLE OWNER.TARGET_TABLE target_server@o.targetSID . A good practice is to first issue “verify config ” for validation purpose. This command will not activate a config file but would rather do the sanity check in terms of syntax, objects and SIDs specified in the config file, etc to that it does not result in a show stopper when the activation is actually done in a tight maintenance window. . For details on the command “activate config” or “verify config” and other related commands, please refer to SharePlex Reference Guide.