Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.


every 1-2 days our server crashed with the Error Message in the title. There was a reportet error here but i should be fixed since Any ideas what to do?

asked 20 Nov '14, 08:08

dnichterwitz's gravatar image

accept rate: 0%

Some data structure within the server is normally allocated within a single memory page and it is exceeding the page size. The assertion failure could come from different source allocations so we don't have enough information to understand what causes the problem. If you send the crash report information using the Support utility (dbsupport) then technical support can identify the server operation causing the issue.

Alternatively, if you can identify the statement causing the assertion (perhaps using request level logging, see the -zr database server option then you can perhaps identify what is causing the memory allocation to be large (perhaps in cooperation with the forum or technical support).

If the memory is allocated on the main heap, you would be able to work around the problem by using either the -gp database server option to increase the page size used for the main heap. If that does not work, another possibility is to increase the page size of the database. If you can identify the statement causing the problem, there may be a way to simplify the statement.

This is also a candidate for a server change to either give an improved error message (instead of a fatal assertion) or to use a different data structure that does not have to fit into a single page.

permanent link

answered 20 Nov '14, 08:44

Ivan%20T.%20Bowman's gravatar image

Ivan T. Bowman
accept rate: 39%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 20 Nov '14, 08:08

question was seen: 6,231 times

last updated: 20 Nov '14, 08:44