Troubleshooting error: "MongoServer.Create has already created 100 servers which is the maximum number of servers allowed"

PROBLEM

Sometimes when you open a package with too many MongoDB connection you may get the following error during the Validation phase.

MongoServer.Create has already created 100 servers which is the maximum number of servers allowed.

CAUSE

Such error occurs because of an internal limit of 100 Server instance in MongoDB driver. If you have many connections then MongoServer.Create API is called too many times during the validation phase and you may see such errors.

SOLUTION

Try to set Delayvalidation=True for Data Flow task to avoid such error.

1. Goto Control Flow > Right Click on Data Flow task > Click Properties
2. In the Property Grid make sure DelayValidation is set to True

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/