Support Article

Sybase external database update not consistent.



After user upgrade to PEGA 7.2 from PRPC 6.2, the external Sybase database stored proc is not getting executed in RDB-SAVE to update values consistently. There is no failure in Pega but the database update is not always being done.

Error Messages

Not applicable.

Steps to Reproduce

Calling Sybase database stored proc to update table rows through RDB-SAVE.

Root Cause

This is attributable to the setup of the data source resource in the application server. When the stored procedure involves cursors, special handling comes into play for unprocessed results. In this case, WebSphere Admin console needs to specify a custom property to handle this. 


Add custom property "skipCheckForUnprocessedResults=true" to the data source.


Published August 9, 2016 - Updated August 13, 2016

Have a question? Get answers now.

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