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.


How does one increase the number of messages in the messaging system on SQL remote since we keep getting the message "The maximum number of messages in the messaging system has been reached"

Regards Eric

asked 04 Oct '16, 05:19

ericsonill's gravatar image

accept rate: 0%

The maximum number of messages in the FILE, FTP and HTTP messaging system is

26 + (26 * 26) + (26 * 26 * 26) = 18,278
As opposed to asking how to increase the number of messages, IMHO, the better question is why are so many messages being generated and not being picked up? Are remotes hainvg trouble picking up messages, is there a massive amount of data being transfered, or is it maybe a combination of both of those things?

To answer your immediate question, there is no way to increase the maximum number of messages, but you can increase the size of the messages with the -l switch. This switch will need to be change and both the sending side and the receiving side. The default message size is 50kb (pre-compressed), so increasing this value won't allow you to increase the maximum number of messages, but will allow you to send more data with the number of messages that are allowed.


permanent link

answered 04 Oct '16, 08:29

Reg%20Domaratzki's gravatar image

Reg Domaratzki
accept rate: 37%

edited 04 Oct '16, 08:31

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: 04 Oct '16, 05:19

question was seen: 2,783 times

last updated: 06 Oct '16, 07:02