Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SQLAnywhere - SQL Remote Agent not applying messages

Mark_Stoker
Discoverer

Wednesday

0 Likes
155

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)

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
View Entire Topic
Baron
Participant
Wednesday
0 Likes

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

Show replies
Show replies
Mark_Stoker
Discoverer
Wednesday
0 Likes
Yes, this user is listed. It has suddenly stopped working for this user ?
VolkerBarth
Contributor
yesterday

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?

Mark_Stoker
Discoverer
yesterday
0 Likes
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 ?
Baron
Participant
yesterday
0 Likes
I guess they were all repeated messages
VolkerBarth
Contributor
yesterday
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/95f6e6a26ea11014ba2fb701...
Ask a Question