Maximum Cursor Size – BC Property

It is quite rare requirement but you can face it none the less and can act as good information.

 Requirement:

 To restrict the number of records fetched by BC should return when we execute a query against that BC.

 Solution:


To set the Maximum Cursor Size property of that BC to the number of records we want to retrieve for example if we want a BC to return only 100 records then we will set the Maximum Cursor Size property of that BC to 100.

Note:

There is a parameter called MaxCursorSize available in CFG file which is set to -1 by default.

 -1 here means fetch records while End of file (EOF) is not reached. If you set the property to a positive number it is going to affect the whole application not a particular BC.

If you want to restrict just a particular BC then set the Maximum Cursor Size property of that BC.

Important thing to note here is Maximum Cursor Size at BC level will override MaxCursorSize parameter specified in CFG file.

21 Responses to Maximum Cursor Size – BC Property

  1. The valid values for MaxCursorSize are either -1 or value greater than 0. if you set it as null it will give error once you restart your application

  2. The valid values for MaxCursorSize are either -1 or value greater than 0. if you set it as null it will give error once you restart your application

  3. u told us how to set for the application…that is fine..But how to set this for a Particular BC..i.e i am asking for syntax to set a particular BC.

  4. u told us how to set for the application…that is fine..But how to set this for a Particular BC..i.e i am asking for syntax to set a particular BC.

  5. Goto that particular business component. Scroll to the right and find a property called

    Maximum Cursor Size and set it whatever you want that bc to return. For example if I want it to return only 100 records then I will set

    Maximum Cursor Size = 100

    I hope that makes it clear 🙂

  6. Goto that particular business component. Scroll to the right and find a property called

    Maximum Cursor Size and set it whatever you want that bc to return. For example if I want it to return only 100 records then I will set

    Maximum Cursor Size = 100

    I hope that makes it clear 🙂

  7. Hi,

    Thanks to your comment.Will there be any performance effect with this property (if it set to 2000).And also could you please tell me the use of “PreFetch size”.

    Thanks,
    Gopinadh

  8. Hi,

    Thanks to your comment.Will there be any performance effect with this property (if it set to 2000).And also could you please tell me the use of “PreFetch size”.

    Thanks,
    Gopinadh

  9. Yes there will be but I think performance will improve because now instead of processing all the records on database you will be processing only limited number of records.

    But this is just my personal opinion I haven’t tried it to say for sure. But logic says performance should be better.

  10. Yes there will be but I think performance will improve because now instead of processing all the records on database you will be processing only limited number of records.

    But this is just my personal opinion I haven’t tried it to say for sure. But logic says performance should be better.

  11. PreFetchSize is similar to MaxCursorSize but it will take precedence over MaxCursorSize setting.

    So, Ideally you should set both to the same value so that the cursor can be freed and be used for next query

  12. PreFetchSize is similar to MaxCursorSize but it will take precedence over MaxCursorSize setting.

    So, Ideally you should set both to the same value so that the cursor can be freed and be used for next query

  13. what version of the siebel app does the

    “Maximum Cursor Size” user prop apply to?
    I am trying to get this working for 7.7 , Action BusComp , but with unexpected results , i.e. does not work.

    Syntax or other recomendations will be appreciated

    Thanks,
    Karan

  14. what version of the siebel app does the

    “Maximum Cursor Size” user prop apply to?
    I am trying to get this working for 7.7 , Action BusComp , but with unexpected results , i.e. does not work.

    Syntax or other recomendations will be appreciated

    Thanks,
    Karan

  15. What does end of file (-1) means?? our BC component doesnt have anythig specified in this property.. and we get this error in the script . how to rectify it?

  16. facing one issue due to max cursor size.. can some one suggest any better option.
    When we use the same BC which is set max cursor size as 500 in scripting. it is only able to process 500 record. Any suggestion to over come this problem other then creating new bc?

Leave a Reply

Contribute