When activating a config, you come across the following error:
sp_ctrl>activate config <name>
Bad config file: file - <config>; Check line 4, for bad routing spec (targetA@o.targetSID1+)
The config file looks like this with a long route specification due to compound routing:
Datasource: o.SID
#Source Table Destination Table Routing Map
#
owner.table1 owner.table2 targetA@o.targetSID1+
targetB@o.targetSID2+targetC@o.targetSID3
A newline character in the middle of a routing spec may have resulted in this error.
Do a closer examination of the config file by editing it through a vi or other editor that would indicate a presence of newline character in the middle of a compound routing, if one exists. Get rid of that character so that the compound route is free of any such character and the <enter> is hit only at the end of the entry as the following shows:
Datasource: o.SID
#Source Table Destination Table Routing Map
#
owner.table1 owner.table2 targetA@o.targetSID1+targetB@o.targetSID2+targetC@o.targetSID3
This will resolve the problem and activation will succeed.
Here is a brief excerpt from Wikipedia, the free encyclopedia defining a newline character:
In computing, a newline (also known as a line break or end-of-line / EOL character) is a special character or sequence of characters signifying the end of a line of text. The name comes from the fact that the next character after the newline will appear on a new line, that is, on the next line below the text, immediately proceeding the newline.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center