Our Powerbuilder application executes a stored procedure in Sybase and has been running without problems for a few years. About a month ago the stored procedure began stopping without finishing and did not report any error to the calling application.
The procedure itself runs successfully to completion when it is run in Rapid SQL, and it also completes successfully when it is run in the Appeon Powerbuilder development environment in debug mode. It does not complete successfully when run in the Appeon Powerbuilder development environment in non-debug mode (normal execution).
The stored procedure has different sections in which it processes the same type of data, but the volume of data varies significantly, and the problem occurs in the section that typically has a large volume. When the procedure does not process the section with large volumes, the procedure completes successfully in the standalone application.