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: 
Subscribe

We are currently experiencing issues with dbremote running on remote databases. Replication has been running for months without issue but now we are getting the database locking up and dbremote failing to run. Dbremote seems to lose connection while processing files: 

I. 2013-11-11 17:43:29. UPDATE shipclip.NIIN
                           SET FSC=NULL,
                               COG=NULL,
                               DESCR=NULL,
                               UNIT_PRICE=224.08,
                               BRF=NULL,
                               UOM=NULL,
                               AAC=NULL,
                               SLC=NULL,
                               SLAC=NULL,
                               NET_PRICE=NULL
                        VERIFY (FSC,COG,DESCR,UNIT_PRICE,BRF,UOM,AAC,SLC,SLAC,NET_PRICE)
                        VALUES ('4820','9B','SEAT,VALVE',222.21,.25,'EA','Z','0','00',0)
                         WHERE NIIN='012090384'


E. 2013-11-11 18:02:07. SQL statement failed: (-85) Communication error
E. 2013-11-11 18:04:08. SQL statement failed: (-832) Connection error: Shared memory connection to server timed out
E. 2013-11-11 18:04:08. Error connecting to database
E. 2013-11-11 18:04:08. SQL statement failed: (-101) Not connected to a database
E. 2013-11-11 18:04:08. SQL statement failed: (-85) Communication error
E. 2013-11-11 18:04:08. Communication error (-85)
E. 2013-11-11 18:04:08. SQL statement failed: (-85) Communication error
E. 2013-11-11 18:04:08. Communication error (-85)
E. 2013-11-11 18:04:08. SQL statement failed: (-101) Not connected to a database
I. 2013-11-11 18:04:08. Shutdown by request
I. 2013-11-11 18:04:08. Execution completed
I. 2013-11-11 19:02:43. SQL Remote Message Agent Version 12.0.1.3750

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
VolkerBarth
Contributor
‎2013 Nov 12 6:03 AM
0 Likes

You may try to add the LOG=filename connection parameter to DBREMOTE's connection string to get debug information on connection issues.

You also might use sa_conn_info() and sa_locks() in a DBISQL session to try to find out whether the operations from SQL Remote are blocked by concurrent OLAP transactions...

If this is a blocking issue, have you set individual values for the BLOCKING and BLOCKING_TIMEOUT options, or are they used with their default values (ON and 0, meaning infinite waiting on blocks to be released)?

regdomaratzki
Product and Topic Expert
Product and Topic Expert
‎2013 Nov 12 8:17 AM
0 Likes

Does the database engine log have any entries from around the same time to indicate what might have happened?

Former Member
‎2013 Nov 12 10:39 AM
0 Likes

Are you modifying the SUBSCRIBE BY values for an article when this happens?

View Entire Topic
Former Member
‎2013 Nov 12 12:05 PM
0 Likes

There is nothing in the Server Log. It does not even show the database shutdown

I. 11/12 10:45:55. Now accepting requests I. 11/12 10:45:55. Starting TCPIP listener on IP address (::):2641 I. 11/12 10:45:55. Starting TCPIP listener on IP address 0.0.0.0:2641 I. 11/12 10:52:30. Starting checkpoint of "shipclip" (shipclip.db) at Tue Nov 12 2013 10:52 I. 11/12 10:52:31. Finished checkpoint of "shipclip" (shipclip.db) at Tue Nov 12 2013 10:52 I. 11/12 10:59:11. Starting checkpoint of "shipclip" (shipclip.db) at Tue Nov 12 2013 10:59 I. 11/12 10:59:11. Finished checkpoint of "shipclip" (shipclip.db) at Tue Nov 12 2013 10:59 I. 11/12 11:05:52. Starting checkpoint of "shipclip" (shipclip.db) at Tue Nov 12 2013 11:05 I. 11/12 11:05:52. Finished checkpoint of "shipclip" (shipclip.db) at Tue Nov 12 2013 11:05 I. 11/12 11:12:32. Starting checkpoint of "shipclip" (shipclip.db) at Tue Nov 12 2013 11:12 I. 11/12 11:12:33. Finished checkpoint of "shipclip" (shipclip.db) at Tue Nov 12 2013 11:12 I. 11/12 11:19:13. Starting checkpoint of "shipclip" (shipclip.db) at Tue Nov 12 2013 11:19 I. 11/12 11:19:13. Finished checkpoint of "shipclip" (shipclip.db) at Tue Nov 12 2013 11:19 I. 11/12 11:25:54. Starting checkpoint of "shipclip" (shipclip.db) at Tue Nov 12 2013 11:25 I. 11/12 11:25:54. Finished checkpoint of "shipclip" (shipclip.db) at Tue Nov 12 2013 11:25 I. 11/12 11:31:03. Connection ID 1: "rep_dbo" connected to database "shipclip" from SQL Anywhere 12.0.1 (3817) client over SharedMemory I. 11/12 11:31:03. Connection ID 1: AppInfo is IP=10.24.20.96;HOST=bth497286a;OSUSER=SYSTEM;OS='Windows 7 Build 7601 Service Pack 1';EXE='C:Program FilesSQL Anywhere 12Bin32dbremote.exe';PID=0x7100;THREAD=0xa14;VERSION=12.0.1.3817;API=DBLIB;TIMEZONEADJUSTMENT=-300 I. 11/12 11:31:03. Connection ID 1: Server character set conversion is enabled, but not required using character set "windows-1252" I. 11/12 11:31:03. Connection ID 2: "rep_dbo" connected to database "shipclip" from SQL Anywhere 12.0.1 (3817) client over SharedMemory I. 11/12 11:31:03. Connection ID 2: AppInfo is IP=10.24.20.96;HOST=bth497286a;OSUSER=SYSTEM;OS='Windows 7 Build 7601 Service Pack 1';EXE='C:Program FilesSQL Anywhere 12Bin32dbremote.exe';PID=0x7100;THREAD=0xa14;VERSION=12.0.1.3817;API=DBLIB;TIMEZONEADJUSTMENT=-300 I. 11/12 11:31:03. Connection ID 2: Server character set conversion is enabled, but not required using character set "windows-1252" I. 11/12 11:31:03. Connection ID 3: "rep_dbo" connected to database "shipclip" from SQL Anywhere 12.0.1 (3817) client over SharedMemory I. 11/12 11:31:03. Connection ID 3: AppInfo is IP=10.24.20.96;HOST=bth497286a;OSUSER=SYSTEM;OS='Windows 7 Build 7601 Service Pack 1';EXE='C:Program FilesSQL Anywhere 12Bin32dbremote.exe';PID=0x7100;THREAD=0xa14;VERSION=12.0.1.3817;API=DBLIB;TIMEZONEADJUSTMENT=-300 I. 11/12 11:31:03. Connection ID 3: Server character set conversion is enabled, but not required using character set "windows-1252" I. 11/12 11:31:03. Connection ID 4: "rep_dbo" connected to database "shipclip" from SQL Anywhere 12.0.1 (3817) client over SharedMemory I. 11/12 11:31:03. Connection ID 4: AppInfo is IP=10.24.20.96;HOST=bth497286a;OSUSER=SYSTEM;OS='Windows 7 Build 7601 Service Pack 1';EXE='C:Program FilesSQL Anywhere 12Bin32dbremote.exe';PID=0x7100;THREAD=0xa14;VERSION=12.0.1.3817;API=DBLIB;TIMEZONEADJUSTMENT=-300 I. 11/12 11:31:03. Connection ID 4: Server character set conversion is enabled, but not required using character set "windows-1252"

Show replies
Show replies
regdomaratzki
Product and Topic Expert
Product and Topic Expert
‎2013 Nov 12 12:22 PM
0 Likes

Are you sure no mini-dump files were generated? They would likely be at "%ALLUSERSPROFILE%SQL Anywhere 12diagnostics", although the page below gives more information about where the files might be located.

http://dcx.sybase.com/index.html#1201/en/dbadmin/dbutilities-s-3600377.html*diagnostic-directory-loc...

Ask a Question