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

Home Page Forums Issues – SSIS PowerPack MongoServer.Create has already created 100 servers which is the maximum number of servers allowed.

This topic contains 0 replies, has 1 voice, and was last updated by  ZappySys 2 years, 10 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #2506

    ZappySys
    Keymaster

    Problem:

    Sometimes when you use SSIS MongoDB Connection for SSIS MongoDB Source / Destination you may get following error during Validation phase.

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

    Cause:

    Such error occurs because of internal limit of 100 Server instance in MongoDb driver. If you have many connections then MongoServer.Create API is called too many times during 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

     

     

     

     

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.