A web application developed against and working fine in SA 11 is causing silent server crashes under version 12 (latest patch).
Crashes can be traced back to a series of stored procedures used in
All those procedures are using recursive CTEs after the model below:
We tried connecting the web tier to the database using
Running the same SELECT statements in ISQL sometime works, sometime doesn't.
I apologize for the inconvenience - I don't believe you are doing anything wrong. In (almost) all cases Version 12 software should be backwards-compatible with Version 11, and nonetheless the server should not crash.
Sending crash dumps is outlined in the documentation in the section
SQL Anywhere Server - Database Administration » Maintaining your database » Troubleshooting SQL Anywhere database issues » Error reporting in SQL Anywhere
You can find it quickly in the online help by doing an index search for "dbsupport" or "crashes".
You can run dbsupport to upload the crash information, and at the same time open a case with technical support, making sure to pass on the crash identifier so we can match the uploaded files with your support case.