Error Message: Unable to connect to a member of the replica set matching Secondary Preferred
Action:
When running my package manually by VS it executes succesfully, but when I run it by SQL Agent job I get the following error message:
Unable to connect to a member of the replica set matching Secondary Preferred
Error Message:
An error occurred with the following error message: "Unable to connect to a member of the replica set matching Secondary Preferred".
Solution:
Something is blocking the access to the Mongo DB server on that machine. It's possible that you have a network or a firewall issue. Also, it's possible that the server IP is not whitelisted. Please contact your system administrator about it.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
When to connect to MongoDB replica set?
You should connect to MongoDB replica set only when you have multiple hosts.How to connect to a MongoDB replica set?
In the Host parameter you need to specify all members of the MongoDB replica set using the following syntax host1[:port],host2[:port] . Then in the Advanced tab, you need to set to add a replicaSet parameter (e.g. replicaSet=my-replica-set)Error Message: The underlying connection was closed: An unexpected error occurred on a send. (System.Web.Services)
Action: My Salesforce connections have suddenly started giving errors. Attached is the error message I am recieving on testing the connections . Please note the connections were working fine until yesterday and I am getting same issue for both ...Error Message: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
Action: We migrated our COZYROC connector to a new server. Since then we get a timeout when trying to retrieve a large table and the following error message. Error Message: 'Unable to read data from the transport connection: A connection attempt ...Where can I find the documentation for the MongoDB Connection?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the MongoDB Connection can be found at the following link. For many of the components you can find ...