Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Impact of pyDuplicateProperty on sppr_sys_reserverqueueitem_b



The developers have been using the pyDuplicateProperty when calling PRQueueManager to enque a new item, as detailed in:

Since making this change they are observing an increase in the number of calls to the SPPR_SYS_RESERVEQUEUEITEM_B stored procedure, which is impacting overall performance.

Error Messages

Not Applicable

Steps to Reproduce

Ensure that a property is specified in .pyDuplicateProperty when using PRQueueManager to queue a new entry. 


When queuing a new item with pyDuplicateProperty specified, the underlying code needs to check the existing records to match that property.

This in turn will make a call to the SPPR_SYS_RESERVERQUEUEITEM_B stored procedure to collect the matches for the same class (in sets of 20).
It will then cycle through the first 20 results to check whether the specified property of the new record matches any of those existing queued records.

Once this has completed it will call SPPR_SYS_RESERVEQUEUEITEM_B again to process the next set, until all queued entries that match the class have been exhausted.

Unfortunately, when using pyDuplicateProperties, these additional calls to SPPR_SYS_RESERVERQUEUEITEM_B are unavoidable, as this is needed to ensure there are no duplicates.


Published July 23, 2018 - Updated October 8, 2020

Was this useful?

100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us