Symptom
- You see the following message while running SQL Remote Message Agent (dbremote) with -v verbose switch:
I. 2016-02-29 13:02:09. COMMIT
I. 2016-02-29 13:02:09. Sending message to "G080" (1-050151928772-050151938041-0)
I. 2016-02-29 13:03:32. Sending message to "G080" (1-050151938041-050152291226-0)
I. 2016-02-29 13:03:32. sopen "T:G080t04.1m7" failure 64: Invalid argument
I. 2016-02-29 13:03:32. sopen "T:G080t04.1m8" failure 64: Invalid argument
I. 2016-02-29 13:03:32. sopen "T:G080t04.1m9" failure 64: Invalid argument
I. 2016-02-29 13:03:32. sopen "T:G080t04.1ma" failure 64: Invalid argument
I. 2016-02-29 13:03:32. sopen "T:G080t04.1mb" failure 64: Invalid argument
E. 2016-02-29 13:03:32. Error sending message
I. 2016-02-29 13:03:32. Resend requests are being queued
I. 2016-02-29 13:04:40. Execution completed
- On a next run, you see the following message with starting offset "stuck" (050151938041 in the example):
I. 2016-02-29 14:35:09. Processing transactions from active transaction log
I. 2016-02-29 14:35:10. Sending message to "G080" (1-050151938041-050152294405-0)
I. 2016-02-29 14:35:10. sopen "T:G080t04.1m7" failure 3: No such file or directory
I. 2016-02-29 14:35:10. sopen "T:G080t04.1m8" failure 3: No such file or directory
I. 2016-02-29 14:35:10. sopen "T:G080t04.1m9" failure 3: No such file or directory
I. 2016-02-29 14:35:10. sopen "T:G080t04.1ma" failure 3: No such file or directory
I. 2016-02-29 14:35:10. sopen "T:G080t04.1mb" failure 3: No such file or directory
E. 2016-02-29 14:35:10. Error sending message
I. 2016-02-29 14:35:10. Resend requests are being queued
I. 2016-02-29 14:35:10. Hovering at end of active log
I. 2016-02-29 14:36:16. Execution completed
- Any subsequent runs generate same error messages with transaction log's ending offset increased
- dbremote appears to work after few hours later and report insert/delete/update from the same stuck starting offset
I. 2016-02-29 17:04:17. Scanning logs starting at offset 050151938041
I. 2016-02-29 17:04:17. Processing transaction logs from directory "c:\vs_pos\"
I. 2016-02-29 17:05:15. Processing transactions from active transaction log
I. 2016-02-29 17:05:31. Sending message to "G080" (1-050151938041-050155323926-0)
I. 2016-02-29 17:05:31. Hovering at end of active log
- As result, you lost some of the transactions
Read more...
Environment
- SAP SQL Anywhere
- SQL Remote
- SQL Remote message files stored on a mapped drive
- Any supported Microsoft Windows OS
Product
SAP SQL Anywhere all versions ; SQL Anywhere all versions
Keywords
anyhwere, asa, synchronization, synchronizes, synchronizing, missing file, disconnect, mapped drive, network, NET USE, connectivity, connection, Windows, system, code , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.