Data Loader Error while updating records: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:C_IncidentWorkFlowTrigger: System.LimitException: BMCServiceDesk:Too many SOQL queries: 101

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Helix Remedyforce Service Desk



    QUESTION:

    Data Loader Error while updating records: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:C_IncidentWorkFlowTrigger:
    System.LimitException: BMCServiceDesk:Too many SOQL queries: 101 


    ANSWER:


    This error can be related to the Data Loader Batch size setting. Try changing the Batch size to 10 and try the insert again. If you still see the error, try changing it again to 2 and attempt the insert again.

    To change the Batch size setting, start the Data Loader, on the Welcome screen click Cancel, then click Settings on the Data Loader main screen. The top option is Batch size and the default is 200. You can change it as directed above.


    Article Number:

    000116982


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles