I. 07/26 18:07:44. The maximum number of messages in the messaging system has been reached.
Why the limitation?
asked 26 Jul '12, 18:12
SQL Remote only currently uses three characters in the extension for messages files for the FILE, FTP and HTTP message system, and we limit the characters to alpha-numeric character. Because of that, the maximum number of messages that one database can send to another database in the system is 36 + 36*36 + 36*36*36 = 47988. At the default message size of 50K, that allows for approximately 2GB of SQL statements to be pending in the message system.
If you reach the maximum number of messages, you will need to either increase the message size, or convince your remote databases to pick up messages more often.