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. Questions:
|
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. Thanks Glenn. Will do. We will deploy on sa 11 in the meantime. Another question: we're a not-for-profit outfit, so budgets are tight and we can't afford to buy support plans with our licences. Is there any way I can open a case with Sybase technical support in that situation? 1
You can always report a bug for free using CaseXpress. The URL is http://case-express.sybase.com. |