Question Re: SQLAnywhere - SQL Remote Agent not applying messages in Technology Q&A

SQLAnywhere - SQL Remote Agent not applying messages

Mark_Stoker — Wed, 08 Jul 2026 07:34:48 GMT

We have a situation where messages are recieved from one particular remote site but not being applied. (STORE17). How can we get these to apply ?

I. 2026-07-08 08:12:36. SQL Remote Message Agent Version 17.0.9.4803
I. 2026-07-08 08:12:36.
I. 2026-07-08 08:12:36. Copyright © 2018 SAP SE or an SAP affiliate company.
I. 2026-07-08 08:12:36. All rights reserved.
I. 2026-07-08 08:12:36. Use of this software is governed by the SAP Software Use Rights Agreement.
I. 2026-07-08 08:12:36. Refer to http://www.sap.com/about/agreements.html.
I. 2026-07-08 08:12:36.
I. 2026-07-08 08:12:38. Received message from "STORE14" (0-010422941944-010422945038-0)
I. 2026-07-08 08:12:38. Applying message from "STORE14" (0-010422941944-010422945038-0)
I. 2026-07-08 08:12:38. Received message from "STORE17" (1-037364933530-037364953970-0)
I. 2026-07-08 08:12:38. Received message from "STORE17" (1-037364953970-037364969087-0)
I. 2026-07-08 08:12:38. Received message from "STORE17" (1-037364969087-037364994054-0)
I. 2026-07-08 08:12:38. Received message from "STORE17" (1-037364994054-037365019213-0)
I. 2026-07-08 08:12:38. Received message from "STORE17" (1-037365019213-037365043371-0)
I. 2026-07-08 08:12:38. Received message from "STORE17" (1-037365043371-037365068543-0)
I. 2026-07-08 08:12:38. Received message from "STORE17" (1-037365068543-037365088248-0)
I. 2026-07-08 08:12:38. Received message from "STORE17" (1-037365088248-037365115333-0)
I. 2026-07-08 08:12:38. Received message from "STORE17" (1-037365115333-037365115662-0)
I. 2026-07-08 08:12:38. Received message from "STORE17" (1-037365115662-037365127138-0)
I. 2026-07-08 08:12:38. Received message from "STORE17" (1-037365127138-037365154522-0)
I. 2026-07-08 08:12:38. Received message from "STORE17" (1-037365154522-037365175118-0)

Re: SQLAnywhere - SQL Remote Agent not applying messages

Baron — Wed, 08 Jul 2026 09:05:40 GMT

Were the messages being applied before? Which changes has triggered the problem?

Re: SQLAnywhere - SQL Remote Agent not applying messages

Baron — Wed, 08 Jul 2026 09:04:23 GMT

Can you check the table SYSREMOTEUSERS? Do you see entries for the mentioned stores (STORE17 / STORE14...)

Re: SQLAnywhere - SQL Remote Agent not applying messages

Mark_Stoker — Wed, 08 Jul 2026 09:08:42 GMT

Yes, all was working fine - no changes have been made at all.

Re: SQLAnywhere - SQL Remote Agent not applying messages

Mark_Stoker — Wed, 08 Jul 2026 09:11:35 GMT

Yes, this user is listed. It has suddenly stopped working for this user ?

Re: SQLAnywhere - SQL Remote Agent not applying messages

VolkerBarth — Fri, 10 Jul 2026 08:37:18 GMT

Have you tried to use dbremote with the -v option to display verbose output? It should show the contents of the messages. IIRC, the first digit within the message number ("1-...") might indicate that the messages by "STORE17" are being resent, and the receiver might ignore them by design as they have already by applied.
What does SYSREMOTEUSER show for both remotes? Are there differences according to receive_count vs. rereceive_count? Does the table show that the according log offsets have already been confirmed by the current database?

Re: SQLAnywhere - SQL Remote Agent not applying messages

Mark_Stoker — Fri, 10 Jul 2026 08:53:53 GMT

I removed the messages from the folders and subsequently there were resent by the remote - this time they applied correctly - not sure why it worked this way ?

Re: SQLAnywhere - SQL Remote Agent not applying messages

Baron — Fri, 10 Jul 2026 09:03:56 GMT

I guess they were all repeated messages

Re: SQLAnywhere - SQL Remote Agent not applying messages

VolkerBarth — Fri, 10 Jul 2026 11:31:27 GMT

Well, re-send of messages is not necessarily a problem but part of SQL Remote's "Guaranteed Message Delivery System"... s. https://help.sap.com/docs/SAP_SQL_Anywhere/dc2260c1b8de4966b6cdee9c6d5cbcb2/95f6e6a26ea11014ba2fb701100ea34f.html?locale=en-US