|
Home > Archive > SQL Anywhere Mobile > August 2005 > Problem to start two "dbmlsync"
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem to start two "dbmlsync"
|
|
|
| The following error messages were encountered when starting two "dbmlsync"
agasint two different databases on the same PC.
-728 cannot register 'sybase.asa.dbmlsync' since another exclusive instance
is running
Any ideas?
Thanks
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-08-03, 11:24 am |
| This error should only occur when two dbmlsync sessions are run against the
same database. Are you sure they ran against two different databases?
--
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 "Platform Preview" and "Time Frame" to ALL
"liy" <li_yuping@bls.gov> wrote in message news:42f0f096$1@foru
ms-1-dub...
> The following error messages were encountered when starting two "dbmlsync"
> agasint two different databases on the same PC.
>
> -728 cannot register 'sybase.asa.dbmlsync' since another exclusive
instance
> is running
>
> Any ideas?
>
> Thanks
>
>
| |
|
| Yes, the two "dbmlsync" were ran against two different databases on the same
PC.
Thanks
"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:42f0f47e$1@foru
ms-1-dub...
> This error should only occur when two dbmlsync sessions are run against
> the
> same database. Are you sure they ran against two different databases?
>
> --
> 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 "Platform Preview" and "Time Frame" to ALL
>
> "liy" <li_yuping@bls.gov> wrote in message news:42f0f096$1@foru
ms-1-dub...
> instance
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-08-03, 1:25 pm |
| I'd shut down any dbmlsync processes that you think are running and then
check your task manager (under processes, not applications) for another
instance of dbmlsync that may be kicking around (possibly a service that
doesn't interact with the desktop?).
--
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 "Platform Preview" and "Time Frame" to ALL
"liy" <li_yuping@bls.gov> wrote in message news:42f0f6f8@forums
-1-dub...
> Yes, the two "dbmlsync" were ran against two different databases on the
same
> PC.
>
> Thanks
>
> "Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
> wrote in message news:42f0f47e$1@foru
ms-1-dub...
news:42f0f096$1@foru
ms-1-dub...[color=darkred]
>
>
| |
|
| Reg,
We shutdown all dbmlsync processes, but still got the same problem.
Everything works fine if we only run one dbmlsync against one database at a
time.
Thanks
"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:42f0fc21$1@foru
ms-1-dub...
> I'd shut down any dbmlsync processes that you think are running and then
> check your task manager (under processes, not applications) for another
> instance of dbmlsync that may be kicking around (possibly a service that
> doesn't interact with the desktop?).
>
> --
> 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 "Platform Preview" and "Time Frame" to ALL
>
> "liy" <li_yuping@bls.gov> wrote in message news:42f0f6f8@forums
-1-dub...
> same
> news:42f0f096$1@foru
ms-1-dub...
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-08-03, 1:26 pm |
| Please try the following :
1) Create a file called sql.sql with the following text :
create table t1 (pkey integer primary key, c1 integer );
create publication p1 ( table t1 );
create synchronization user u1;
create synchronization subscription to p1 for u1;
2) Create a file called go.bat with the following text :
dbinit db1.db
dbinit db2.db
dbisqlc -c "dbf=db1. db;uid=dba;pwd=sql;e
ng=cons;autostop=no" read sql.sql
dbisqlc -c "dbf=db2. db;uid=dba;pwd=sql;e
ng=cons;autostop=no" read sql.sql
start dbmlsync -c " eng=cons;dbn=db1;uid
=dba;pwd=sql" -v+ -ot t1.txt -k
start dbmlsync -c " eng=cons;dbn=db2;uid
=dba;pwd=sql" -v+ -ot t2.txt -k
pause
start dbmlsync -c " eng=cons;dbn=db1;uid
=dba;pwd=sql" -v+ -ot t3.txt -k
start dbmlsync -c " eng=cons;dbn=db1;uid
=dba;pwd=sql" -v+ -ot t4.txt -k
pause
find "E. 08" *.txt
3) Run go.bat. When the script pauses, wait for both dbmlsync processes to
shut down, then press any key to continue.
4) Please confirm that your output looks similar to :
---------- T1.TXT
E. 08/03 14:37:38. Unable to open a 'tcpip' network connection. Unable to
connect a socket. The system-specific error code is 10061 (hex 0000274d).
E. 08/03 14:37:38. Unable to connect to MobiLink server.
E. 08/03 14:37:38. Upload aborted at offset 0000421064
E. 08/03 14:37:38. Download aborted
---------- T2.TXT
E. 08/03 14:37:39. Unable to open a 'tcpip' network connection. Unable to
connect a socket. The system-specific error code is 10061 (hex 0000274d).
E. 08/03 14:37:39. Unable to connect to MobiLink server.
E. 08/03 14:37:39. Upload aborted at offset 0000421064
E. 08/03 14:37:39. Download aborted
---------- T3.TXT
E. 08/03 14:38:11. Unable to open a 'tcpip' network connection. Unable to
connect a socket. The system-specific error code is 10061 (hex 0000274d).
E. 08/03 14:38:11. Unable to connect to MobiLink server.
E. 08/03 14:38:11. Upload aborted at offset 0000421121
E. 08/03 14:38:11. Download aborted
---------- T4.TXT
E. 08/03 14:38:08. SQL statement failed: (-782) Cannot register
'sybase.asa.dbmlsync' since another exclusive instance is running
5) Note that t1.txt and t2.txt failed to connect to the ML server (
expected ), but both were able to start since they connected to different
databases. In files t3.txt and t4.txt, one will fail with the same error,
but the other will fail with -782, since they are both trying to connect to
the same database.
--
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 "Platform Preview" and "Time Frame" to ALL
"liy" <li_yuping@bls.gov> wrote in message news:42f10165$1@foru
ms-1-dub...
> Reg,
>
> We shutdown all dbmlsync processes, but still got the same problem.
> Everything works fine if we only run one dbmlsync against one database at
a
> time.
>
> Thanks
>
> "Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
> wrote in message news:42f0fc21$1@foru
ms-1-dub...
<FirstName.LastName@ianywhere.com>[color=darkred]
against[color=darkre
d]
databases?[color=darkred]
>
>
| |
|
| Reg,
We are able to run two dbmlsync against the two databases without any
problems by adding "eng=db1". Can you explain why it doesn't work without
the "eng="? BTW, what's the different by starting dbmlsync as followings,
start dbmlsync -c " eng=db1;dbn=db1;uid=
dba;pwd=sql"
start dbmlsync -c "dbs=db1.db;uid=dba;pwd=sql"
Thanks for your help
"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:42f10fb9$1@foru
ms-1-dub...
> Please try the following :
>
> 1) Create a file called sql.sql with the following text :
>
> create table t1 (pkey integer primary key, c1 integer );
> create publication p1 ( table t1 );
> create synchronization user u1;
> create synchronization subscription to p1 for u1;
>
> 2) Create a file called go.bat with the following text :
>
> dbinit db1.db
> dbinit db2.db
> dbisqlc -c "dbf=db1. db;uid=dba;pwd=sql;e
ng=cons;autostop=no" read sql.sql
> dbisqlc -c "dbf=db2. db;uid=dba;pwd=sql;e
ng=cons;autostop=no" read sql.sql
> start dbmlsync -c " eng=cons;dbn=db1;uid
=dba;pwd=sql" -v+ -ot t1.txt -k
> start dbmlsync -c " eng=cons;dbn=db2;uid
=dba;pwd=sql" -v+ -ot t2.txt -k
> pause
> start dbmlsync -c " eng=cons;dbn=db1;uid
=dba;pwd=sql" -v+ -ot t3.txt -k
> start dbmlsync -c " eng=cons;dbn=db1;uid
=dba;pwd=sql" -v+ -ot t4.txt -k
> pause
> find "E. 08" *.txt
>
> 3) Run go.bat. When the script pauses, wait for both dbmlsync processes
> to
> shut down, then press any key to continue.
>
> 4) Please confirm that your output looks similar to :
>
> ---------- T1.TXT
> E. 08/03 14:37:38. Unable to open a 'tcpip' network connection. Unable to
> connect a socket. The system-specific error code is 10061 (hex 0000274d).
> E. 08/03 14:37:38. Unable to connect to MobiLink server.
> E. 08/03 14:37:38. Upload aborted at offset 0000421064
> E. 08/03 14:37:38. Download aborted
>
> ---------- T2.TXT
> E. 08/03 14:37:39. Unable to open a 'tcpip' network connection. Unable to
> connect a socket. The system-specific error code is 10061 (hex 0000274d).
> E. 08/03 14:37:39. Unable to connect to MobiLink server.
> E. 08/03 14:37:39. Upload aborted at offset 0000421064
> E. 08/03 14:37:39. Download aborted
>
> ---------- T3.TXT
> E. 08/03 14:38:11. Unable to open a 'tcpip' network connection. Unable to
> connect a socket. The system-specific error code is 10061 (hex 0000274d).
> E. 08/03 14:38:11. Unable to connect to MobiLink server.
> E. 08/03 14:38:11. Upload aborted at offset 0000421121
> E. 08/03 14:38:11. Download aborted
>
> ---------- T4.TXT
> E. 08/03 14:38:08. SQL statement failed: (-782) Cannot register
> 'sybase.asa.dbmlsync' since another exclusive instance is running
>
> 5) Note that t1.txt and t2.txt failed to connect to the ML server (
> expected ), but both were able to start since they connected to different
> databases. In files t3.txt and t4.txt, one will fail with the same error,
> but the other will fail with -782, since they are both trying to connect
> to
> the same database.
>
> --
> 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 "Platform Preview" and "Time Frame" to ALL
>
> "liy" <li_yuping@bls.gov> wrote in message news:42f10165$1@foru
ms-1-dub...
> a
> <FirstName.LastName@ianywhere.com>
> against
> databases?
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-08-03, 8:24 pm |
| I believe if you read through the following section of the docs, both of the
questions you asked in your last post will be answered :
ASA Database Administration Guide
Connecting to a Database
Troubleshooting connections
Assembling a list of connection parameters
Locating a server
Locating the database
There are flowcharts in the three sections that describe how ASA decides
what database to connect to given a list of connection parameters, and how
that list is generated.
If you haven't yet figured it out after reading the above documentation,
please post the full command line for both dbmlsync sessions.
--
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 "Platform Preview" and "Time Frame" to ALL
"liy" <li_yuping@bls.gov> wrote in message news:42f1232a$1@foru
ms-2-dub...
> Reg,
>
> We are able to run two dbmlsync against the two databases without any
> problems by adding "eng=db1". Can you explain why it doesn't work without
> the "eng="? BTW, what's the different by starting dbmlsync as followings,
>
> start dbmlsync -c " eng=db1;dbn=db1;uid=
dba;pwd=sql"
> start dbmlsync -c "dbs=db1.db;uid=dba;pwd=sql"
>
> Thanks for your help
>
>
> "Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
> wrote in message news:42f10fb9$1@foru
ms-1-dub...
sql.sql[color=darkred]
sql.sql[color=darkred]
to[color=darkred]
0000274d).[color=darkred]
to[color=darkred]
0000274d).[color=darkred]
to[color=darkred]
0000274d).[color=darkred]
different[color=dark
red]
error,[color=darkred
]
news:42f10165$1@foru
ms-1-dub...[color=darkred]
at[color=darkred]
<FirstName.LastName@ianywhere.com>[color=darkred]
another[color=darkre
d]
exclusive[color=dark
red]
>
>
| |
|
| Thanks for your help.
"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:42f12929$1@foru
ms-2-dub...
>I believe if you read through the following section of the docs, both of
>the
> questions you asked in your last post will be answered :
>
> ASA Database Administration Guide
> Connecting to a Database
> Troubleshooting connections
> Assembling a list of connection parameters
> Locating a server
> Locating the database
>
> There are flowcharts in the three sections that describe how ASA decides
> what database to connect to given a list of connection parameters, and how
> that list is generated.
>
> If you haven't yet figured it out after reading the above documentation,
> please post the full command line for both dbmlsync sessions.
>
> --
> 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 "Platform Preview" and "Time Frame" to ALL
>
> "liy" <li_yuping@bls.gov> wrote in message news:42f1232a$1@foru
ms-2-dub...
> sql.sql
> sql.sql
> to
> 0000274d).
> to
> 0000274d).
> to
> 0000274d).
> different
> error,
> news:42f10165$1@foru
ms-1-dub...
> at
> <FirstName.LastName@ianywhere.com>
> another
> exclusive
>
>
|
|
|
|
|