|
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. |
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.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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: 878 times
last updated: 20 Sep '16, 08:37
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)?
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.