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.

Since upgrade from SQL Anywhere 9 to 16 (build 2283) we have problems with the database server that does not response anymore. All clients that are connected are freezing. A new connection in ISQL freezes after a click on the "Connect" button.

With request log we saw that the problem is in the command xp_startmail(). I created a small test sp that sends a email using the startmail, but the behavior is not always the same. Sometimes the db server freezes sometimes not.

asked 20 Sep '16, 04:31

SamuelCosta's gravatar image

accept rate: 20%

closed 20 Sep '16, 08:37

Graeme%20Perrow's gravatar image

Graeme Perrow

Could you show a snippet of your code to connect via MAPI and to send the mail, say, to show whether you check the return code for xp_startmail and the like?

Note that v16 has introduced the new xp_get_mail_error_text system procedure and xp_get_mail_error_code system procedure that could be of help here - in case you get a return code before the engine freezes...

Does the behaviour depend on the user/privileges trying to mail and/or the kind of recipient (part of your mail domain or not)?

(20 Sep '16, 05:56) Volker Barth

sorry i'm so bored about this issue, that i did not think clearly... actually i'm using xp_startsmtp(); xp_sendmail(); xp_stopsmtp();

i will direct for the xp_startsmtp question.

(20 Sep '16, 06:42) SamuelCosta

The question has been closed for the following reason "The question was asked in error" by Graeme Perrow 20 Sep '16, 08:37

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 Sep '16, 04:31

question was seen: 888 times

last updated: 20 Sep '16, 08:37