| Author |
What means this error ?
|
|
| Fantom 2005-11-14, 7:23 am |
| When i want start synch on remoe database i get error :
I. 11/14 13:41:43. Log scan starting at offset 0000565744
I. 11/14 13:41:43. Processing transaction logs from directory
"'host=192.168.1.5""
E. 11/14 13:41:43. Cannot open transaction log directory
"'host=192.168.1.5"\"
Whats is this ?
Fantom
| |
| Reg Domaratzki 2005-11-14, 7:23 am |
| It means you've done something wrong on your dbmlsync command line. Can you
post the dbmlsync command line you use?
--
Reg Domaratzki, Sybase iAnywhere Solutions
Certified SQL Anywhere Associate
Please reply only to the newsgroup
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL and click "GO"
"Fantom" <szczukot@skasujto.poczta.onet.pl> wrote in message
news:437887db@forums
-1-dub...
> When i want start synch on remoe database i get error :
>
> I. 11/14 13:41:43. Log scan starting at offset 0000565744
> I. 11/14 13:41:43. Processing transaction logs from directory
> "'host=192.168.1.5""
> E. 11/14 13:41:43. Cannot open transaction log directory
> "'host=192.168.1.5"\"
>
> Whats is this ?
>
> Fantom
>
| |
| Fantom 2005-11-14, 9:24 am |
| > It means you've done something wrong on your dbmlsync command line. Can
you
> post the dbmlsync command line you use?
dbmlsync -c dsn="test_remote" -adr 'host=192.168.1.5"
Fantom
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-11-14, 11:24 am |
| ADR is an extended option, so it needs to be inside the -e switch. The
proper command line for you would be :
dbmlsync -c dsn="test_remote" -e "adr=host=192.168.1.5"
--
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"
"Fantom" <szczukot@skasujto.poczta.onet.pl> wrote in message
news:4378aa0e$1@foru
ms-1-dub...
> you
>
> dbmlsync -c dsn="test_remote" -adr 'host=192.168.1.5"
>
> Fantom
>
>
| |
| Fantom 2005-11-14, 11:24 am |
| > ADR is an extended option, so it needs to be inside the -e switch. The
> proper command line for you would be :
>
> dbmlsync -c dsn="test_remote" -e "adr=host=192.168.1.5"
oki. But when i change for example to
dbmlsync -c dsn="test_remote" -x tcpip(host=192.168.1.5) i have next error :
I. 11/14 16:43:13. Log scan starting at offset 0000574835
I. 11/14 16:43:13. Processing transaction logs from directory
"C:\koma\baza\"
E. 11/14 16:43:13. No off-line transaction log file found and on-line
transaction log starts at offset 0000581023.
I. 11/14 16:43:13. We are looking for a transaction log file starting at
offset 0000574835.
E. 11/14 16:43:13. Upload aborted at offset 0000574835
E. 11/14 16:43:13. Download aborted
Fantom
| |
| David Fishburn 2005-11-14, 1:24 pm |
| "Fantom" <szczukot@skasujto.poczta.onet.pl> wrote in
news:4378b283$1@foru
ms-1-dub of sybase.public.sqlanywhere.mobilink:
F>> ADR is an extended option, so it needs to be inside the -e switch.
F>> The proper command line for you would be :
F>>
F>> dbmlsync -c dsn="test_remote" -e "adr=host=192.168.1.5"
F>
F> oki. But when i change for example to
F> dbmlsync -c dsn="test_remote" -x tcpip(host=192.168.1.5) i have next
F> error :
I do not understand. Why are you using the -x tcpip syntax when Reg
just showed you the command line you *should* be using right above it?
Why not use the *correct* command line?
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
| Fantom 2005-11-15, 3:24 am |
| > F>> dbmlsync -c dsn="test_remote" -e "adr=host=192.168.1.5"
>
> I do not understand. Why are you using the -x tcpip syntax when Reg
> just showed you the command line you *should* be using right above it?
>
> Why not use the *correct* command line?
When i use this command i get this same error.
Fantom
| |
| Fantom 2005-11-15, 9:24 am |
| And when i unload and load to new databse and i run :
dbmlsync -c dsn="test_remote" -e "adr=host=192.168.1.5"
i get error :
I. 11/15 10:46:59. Log scan starting at offset 0000574835
I. 11/15 10:46:59. Processing transaction logs from directory
"c:\koma\baza\"
I. 11/15 10:46:59. Processing transactions from active transaction log
E. 11/15 10:46:59. Unable to find log offset 0000574835
I. 11/15 10:46:59. Hovering at end of active log
E. 11/15 10:46:59. Upload aborted at offset 0000574835
E. 11/15 10:46:59. Download aborted
Fantom
| |
| Reg Domaratzki 2005-11-15, 9:24 am |
| This error means that you deleted or renamed a transaction log that still
contains operations that need to be uploaded to MobiLink. dbmlsync scans
the transaction logs to send data to the MobiLink, so dbmlsync needs to know
where the renamed transaction logs are if you are not storing them in the
same directory as the active transaction log.
Do you still have the transaction log that contains log offset 574835? YOu
can run the dblog command against transaction logs to see the starting and
ending offsets of a transaction log. If you do still have the transaction
log, then place it back in the directory when your active transaction log is
sto dbmlsync can find it. Alternatively, you can specify a directory for
the old logs as the last parameter on the dbmlsync command line.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Certified SQL Anywhere Associate
Please reply only to the newsgroup
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL and click "GO"
"Fantom" <szczukot@skasujto.poczta.onet.pl> wrote in message
news:4379b02f@forums
-1-dub...
> And when i unload and load to new databse and i run :
> dbmlsync -c dsn="test_remote" -e "adr=host=192.168.1.5"
>
> i get error :
> I. 11/15 10:46:59. Log scan starting at offset 0000574835
> I. 11/15 10:46:59. Processing transaction logs from directory
> "c:\koma\baza\"
> I. 11/15 10:46:59. Processing transactions from active transaction log
> E. 11/15 10:46:59. Unable to find log offset 0000574835
> I. 11/15 10:46:59. Hovering at end of active log
> E. 11/15 10:46:59. Upload aborted at offset 0000574835
> E. 11/15 10:46:59. Download aborted
>
> Fantom
>
| |
| Fantom 2005-11-15, 9:24 am |
| My log starts on 498717 and end on 502878. In error is 574835. This number
not in my log. But this log is fresh. I run unload and lod to new database.
i dont edit, delete etc from this new log. First after load to new database
i try run synch and i get this error. Log name is not edited etc. Log is
exist in this same directory.
Whats is wrong ?
Fantom
> This error means that you deleted or renamed a transaction log that still
> contains operations that need to be uploaded to MobiLink. dbmlsync scans
> the transaction logs to send data to the MobiLink, so dbmlsync needs to
know
> where the renamed transaction logs are if you are not storing them in the
> same directory as the active transaction log.
>
> Do you still have the transaction log that contains log offset 574835?
YOu
> can run the dblog command against transaction logs to see the starting and
> ending offsets of a transaction log. If you do still have the transaction
> log, then place it back in the directory when your active transaction log
is
> sto dbmlsync can find it. Alternatively, you can specify a directory for
> the old logs as the last parameter on the dbmlsync command line.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Certified SQL Anywhere Associate
> Please reply only to the newsgroup
>
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL and click "GO"
>
>
> "Fantom" <szczukot@skasujto.poczta.onet.pl> wrote in message
> news:4379b02f@forums
-1-dub...
>
>
| |
| David Fishburn 2005-11-15, 9:24 am |
| "Fantom" <szczukot@skasujto.poczta.onet.pl> wrote in
news:4379f5d6$1@foru
ms-1-dub of sybase.public.sqlanywhere.mobilink:
F> My log starts on 498717 and end on 502878. In error is 574835. This
F> number not in my log. But this log is fresh. I run unload and lod to
F> new database. i dont edit, delete etc from this new log. First after
F> load to new database i try run synch and i get this error. Log name is
F> not edited etc. Log is exist in this same directory.
F> Whats is wrong ?
I assume you are using 9.0.1 or lower.
Please ALWAYS include version and MORE importantly BUILD number
with EACH post (dbeng9 -v).
If you rebuild the remote database you must RESET the log offset stored
in the MobiLink server database if you are using 9.0.1 or LOWER.
The easiest way to do this is to use dbmluser -d -u user_name, which
will delete the user and then you can re-add them.
If you are using 9.0.2, it will be reset without manual intervention
since the 9.0.2 MobiLink server recognizes this as a first
synchronization from this database. So it can ignore any previous log
offsets for this user.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
| Fantom 2005-11-16, 3:24 am |
| > If you rebuild the remote database you must RESET the log offset stored
> in the MobiLink server database if you are using 9.0.1 or LOWER.
>
> The easiest way to do this is to use dbmluser -d -u user_name, which
> will delete the user and then you can re-add them.
Thanks. This is it.
Fantom
ps. I use 8.0.3 with newest EBF
|
|
|
|