|
Home > Archive > SQL Anywhere Mobile > August 2005 > dbmlsync error message
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 |
dbmlsync error message
|
|
|
| Hello everyone,
ASA 901.2009
I have create 1 remote db and have 2 publication for 1
remote users.
It run ok when i have 1 publication, however, it has an
error message when It has 2 publication ???
Error message on dbmlsync out put:
E. 08/09 14:48:29. Multiple synchronization subscriptions
found in the database. Please specify a publication and/or
MobiLink user on the command line.
thanks,
Fei
| |
| Shuchit 2005-08-10, 3:25 am |
| Fei wrote in news:42f8fc88.3add.1681692777@sybase.com:
> ASA 901.2009
>
> I have create 1 remote db and have 2 publication for 1
> remote users.
> It run ok when i have 1 publication, however, it has an
> error message when It has 2 publication ???
>
> Error message on dbmlsync out put:
> E. 08/09 14:48:29. Multiple synchronization subscriptions
> found in the database. Please specify a publication and/or
> MobiLink user on the command line.
>
When there are more than one publications, you have to use the -n switch on
dbmlsync to specify which publication you want dbmlsync to synchronize.
Shuchit
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-08-10, 7:25 am |
| Or specify the -u [user_name] switch to synch all publications for a given
synch user.
--
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
"Shuchit" <me@privacy.net> wrote in message
news:Xns96AE6D8BA983
svelkarprivacynet@12
7.0.0.1...
> Fei wrote in news:42f8fc88.3add.1681692777@sybase.com:
>
>
> When there are more than one publications, you have to use the -n switch
on
> dbmlsync to specify which publication you want dbmlsync to synchronize.
>
> Shuchit
| |
|
| Thank Shuchit & Reg for quick respond.
1. It works fine when adding -n pub1 -n pu2 .....
Is there a way to avoid adding to command line for
almost 100 publications ???
2. I got the error message when I try to add - u [mluser]
E. 08/10 08:31:07. Multiple synchronization subscriptions
found in the database for MobiLink user 'a1'. Please specify
a publication on the command line.
Please advice
thanks,
Toni
> Or specify the -u [user_name] switch to synch all
> publications for a given synch user.
>
> --
> 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
>
> "Shuchit" <me@privacy.net> wrote in message
> news:Xns96AE6D8BA983
svelkarprivacynet@12
7.0.0.1...
> use the -n switch on
> to synchronize. >
>
>
| |
| Breck Carter [TeamSybase] 2005-08-10, 11:26 am |
| Toni: Why do you have almost 100 publications? I am curious.
Toni: Do you have more than one synchronization user defined? I think
the answer is "no" because the -n option worked without -u.
Shuchit and Reg: I was under the impression that neither -n nor -u was
required if there was only one synchronization user in the database.
If that is not true, the book (point 1 on p 226) is wrong... I'll have
to start giving refunds :)
Breck
On 10 Aug 2005 06:43:07 -0700, Toni wrote:
[color=darkred]
>Thank Shuchit & Reg for quick respond.
>
>1. It works fine when adding -n pub1 -n pu2 .....
> Is there a way to avoid adding to command line for
>almost 100 publications ???
>
>2. I got the error message when I try to add - u [mluser]
>E. 08/10 08:31:07. Multiple synchronization subscriptions
>found in the database for MobiLink user 'a1'. Please specify
>a publication on the command line.
>
>Please advice
>
>thanks,
>Toni
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
|
| Hi,
1. We have about 98 tables, and we plan to have each
publication for each table. => Any suggestion ???
2. We have either -n or -u to test muliple publication, but
not both of them at the same time.
Thanks,
> Toni: Why do you have almost 100 publications? I am
> curious.
>
> Toni: Do you have more than one synchronization user
> defined? I think the answer is "no" because the -n option
> worked without -u.
>
> Shuchit and Reg: I was under the impression that neither
> -n nor -u was required if there was only one
> synchronization user in the database. If that is not true,
> the book (point 1 on p 226) is wrong... I'll have to start
> giving refunds :)
>
> Breck
>
>
> On 10 Aug 2005 06:43:07 -0700, Toni wrote:
>
> specify >a publication on the command line.
> 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 >>
> news:42f8fc88.3add.1681692777@sybase.com: >> >
> for 1 >> > > remote users.
> has >> > > an error message when It has 2 publication ???
> a >> > > publication and/or MobiLink user on the command
> line. >> > >
> to >> use the -n switch on
> dbmlsync >> to synchronize. >
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
>
http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-08-10, 11:26 am |
| > 1. We have about 98 tables, and we plan to have each
> publication for each table. => Any suggestion ???
You could put all the tables in a single publication. That would be my
suggestion. Is there a reason this won't work for you?
--
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
<Toni> wrote in message news:42fa2140.4dad.1681692777@sybase.com...[color=darkred]
> Hi,
>
> 1. We have about 98 tables, and we plan to have each
> publication for each table. => Any suggestion ???
> 2. We have either -n or -u to test muliple publication, but
> not both of them at the same time.
>
> Thanks,
>
>
>
>
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
| |
| Greg Fenton 2005-08-10, 11:26 am |
| Toni wrote:
> 1. We have about 98 tables, and we plan to have each
> publication for each table. => Any suggestion ???
Why? What benefit do you expect to achieve with one table per
publication? At the very least, this will offer a performance hit as
there is overhead for each publication. Worse, you will have a very
complicated server configuration.
The suggestion we make to 99% of our customers is to have one or two
publications and only one synchronization user per remote. In the two
publication situation, this is for "high priority" synchronizations
where you put a set of tables that have frequent changes but small
amounts of data that you synchronize often, and a "low priority" synch
that has the rest of the tables where changes may include large amounts
of data, but not changing often (or not immediately needed).
For example, in a "field force automation" application, you might put a
"work order" table into one publication for synchronizing every 5
minutes, but put other tables (product catalog, employees list, etc...)
into a second publication that gets synchronized once a day.
Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
|
>
> You could put all the tables in a single publication.
> That would be my suggestion. Is there a reason this won't
> work for you?
We have 50 tables will synch all rows & column, however the
rest of tables are by rows (userid) only.
any idea/ suggestion ???
thanks
| |
| Greg Fenton 2005-08-10, 8:25 pm |
| Toni wrote:
>
> We have 50 tables will synch all rows & column, however the
> rest of tables are by rows (userid) only.
>
The publication's definition does not affect the rows that get
downloaded, only those that are uploaded. Since the rows being uploaded
(insert, updates and deletes) are to rows that are in the remote, they
likely *belong* to that userid. So you shouldn't need a separate
publication for those tables.
For the partitioning of downloads, you simply use the userid in the
WHERE clause of the download_cursor (and download_delete_curs
or). Those
scripts are unaffected by the definition of the publication.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
|
|
|
|
|