SQL Anywhere database replication - Re: SQLREMOTE: - 308 error message intermittently -

Author

Re: SQLREMOTE: - 308 error message intermittently -

Reg Domaratzki $iAnywhere Solutions$

2005-09-08, 11:23 am

The interesting information from this error will be on the database engine,
where the engine log may have information about why dbremote was
disconnected. Do you have the database engine output from 08/12 ?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"Don Clayton" < dclayton_nospam@inte
rtech-us.com> wrote in message
news:431f13c3@forums
-2-dub...
> I have a strange issue with SQL Remote Message Agent Version 9.0.2.3137.
> Both the consolidated database and the SQLREMOTE agent are running on the
> same W2K server. The SQLREMOTE agent will run for a few days, and then I
> get the following error:
>
> I. 08/12 14:44:08. Received message from "laptop_003"
> (0-0001170482-0001170482-0)
> E. 08/12 14:44:08. SQL statement failed: (-308) Connection was terminated
> I. 08/12 14:44:09. Execution completed
>
> In the attached log the error occurs twice over a four day period. Remote
> user laptop_003 is always the triggering laptop, but this was not always
the
> case. I should mention that this was happening before, so I upgraded the
> database, completely rebuilt the database (25 MB, 3 remote users), dropped
> and recreated the remote users, etc. Also, the central DB receives a lot
of
> messages from laptop_003 without choking. The database schema is running
at
> other installations without issue.
>
> Any help or suggestions would be greatly appreciated.
>
> Don Clayton
>
>
>
>

Don Clayton

2005-09-13, 8:23 pm

I'll turn logging on now and will report back. I'll also check to see how
long the replication service has stayed up.

Thanks,

Don

"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:43204d3c$1@foru
ms-1-dub...
> The interesting information from this error will be on the database
> engine,
> where the engine log may have information about why dbremote was
> disconnected. Do you have the database engine output from 08/12 ?
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
>
> "Don Clayton" < dclayton_nospam@inte
rtech-us.com> wrote in message
> news:431f13c3@forums
-2-dub...
> the
> of
> at
>
>

Sponsored Links