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.

Hi all,

i have a ASA12 service that crashes unexcpectedly, unfortunately both -o message log and Windows 2008 event log do not show any useful info. ASA12 (build 3276) runs on a Windows 2008 R2 64 bit server with 8 GB Ram. ASA12 starts with -ch 6 GB switch.

Do you know some tool/switch to capture more details in this situation ?

Thanks Mark

asked 18 Jun '12, 12:49

info2012's gravatar image

accept rate: 0%

You could try:

1) allowing dbsupport to capture a crash log and submit it to SQL Anywhere development for analysis (post the submission ID here and someone may take a look at it).

2) validating your database to make sure that it hasn't been corrupted.

3) upgrading to a more recent build to see if the problem has already been fixed - this won't tell you what was causing the issue but if the problem goes away it would at least get you past the problem.

permanent link

answered 18 Jun '12, 13:51

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

In addition to Mark's suggestions, you can always open a technical support case with Sybase technical support and we can work with you to investigate the crash. We have internal tools to assist that we can provide to you for specific situations, if required.

(18 Jun '12, 15:16) Jeff Albion

Hi all,

i will try to use all your directions, i will update asap.

Thanks Mark

(19 Jun '12, 04:18) info2012

In addition to Marks suggestions you can use the following server configuration commands

Turn on capturing of the most recently-prepared SQL statement for each connection. Used for the sa_conn_activity -zl

Turn on logging of SQL operations. The default is NONE. -zr { all | SQL | none }
-zr all

Redirect request logging information to a separate file. -zo filename -zo "E:Sybase ASA 09.0Application Log FilesEmprise-DB6-ASA9 SQL Commands.log"

Limit the size of the log file used for request logging. -zs size -zs 500K

Specifies the number of request log file copies to retain. -zn integer -zn 1

permanent link

answered 19 Jun '12, 04:08

J%20Diaz's gravatar image

J Diaz
accept rate: 10%

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: 18 Jun '12, 12:49

question was seen: 3,441 times

last updated: 19 Jun '12, 05:45