The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Hi

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

ericsonill
21111
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.

Reg

permanent link

answered 04 Oct '16, 08:29

Reg%20Domaratzki's gravatar image

Reg Domaratzki
4.8k33269
accept rate: 41%

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×73

question asked: 04 Oct '16, 05:19

question was seen: 349 times

last updated: 06 Oct '16, 07:02