SQL Anywhere database replication - Problem with remote user

Author

Problem with remote user

Sybase

2005-11-03, 8:25 pm

Hello, my name is Miguel, and i am try to extract a ASE 12.5.3 database.

My script configuration is:

sp_remote_type file, 'C:\oasis\Oasis_Anyw
here\Desarrollo' go
exec sp_addlogin publicador_desarroll
o, publicador, desarrollo go
exec sp_role 'grant', sa_role, publicador_desarroll
o go
use desarrollo go
exec sp_adduser publicador_desarroll
o go
exec sp_publisher publicador_desarroll
o go
exec sp_addlogin suscriptor_desarroll
o, suscriptor, desarrollo go
exec sp_adduser suscriptor_desarroll
o go
exec sp_grant_remote suscriptor_desarroll
o, file,
'C:\oasis\Oasis_Anyw
here\Suscriptor' go
exec sp_create_publicatio
n desarrollo_pub go
exec sp_add_remote_table ****** go (all my tables) go
exec sp_add_article desarrollo_pub, ***** go (all my tables) go
exec sp_subscription 'create', desarrollo_pub, suscriptor_desarroll
o,
'rep_desarrollo' go
Then, i execute:
ssxtract -c " eng=dataserver;dbn=d
esarrollo;uid=sa;pwd
="
C:\oasis\Oasis_Anywh
ere\Suscriptor suscriptor_desarroll
o -e
"english,iso_1" -i -o C:\oasis\Oasis_Anywh
ere\Suscriptor\error
.sql -r
C:\oasis\Oasis_Anywh
ere\Suscriptor\reloa
d.sql -l 3 -xv

But the command report:

Adaptive Server Anywhere Extraction Utility Version 9.0.2.3044
Adaptive Server Anywhere Extraction Utility Version 9.0.2.3044
Cannot allocate context version 12.5, now try version 11.0
SQL Server has run out of LOCKS. Re-run your command when there are fewer
active users, or contact a user with System Administrator (SA) role to
reconfigure SQL Server with more LOCKS.
" suscriptor_desarroll
o" is not a remote user of this database

The Lock of my ASE database is: Number of locks = 30000

What is the problem? Waht can I do?

Thanks

Nick Elson

2005-11-03, 8:25 pm

30,000 lock is not much at all. I believed the 11.5 default used to be
25,000.

By extracting at isolation level 3 (via ssxtract -l 3) every row
extracted from all tables will incur a lock [assuming DOL tables].
This can add up much more quickly than expected.

A lower isolation level may allow you to get past this but I usually
do not recommend doing that. If you do then run the extraction
when no one else is running on the system.

Other possible approaches might incorporate reducing the lock
escalation thresholds enough that table locks will be incurred,
explicitly issuing a LOCK TABLE for all tables to be extracted,
or extracting from a read-only database; among other possibilities
I may have not anticipated. All of which will probably require
more ASE expertise that might be found on this newsgroup.

Hope it helps.

"Sybase" <soporte@oasis.com.co> wrote in message
news:436a3963$1@foru
ms-1-dub...
> Hello, my name is Miguel, and i am try to extract a ASE 12.5.3 database.
>
> My script configuration is:
>
> sp_remote_type file, 'C:\oasis\Oasis_Anyw
here\Desarrollo' go
> exec sp_addlogin publicador_desarroll
o, publicador, desarrollo go
> exec sp_role 'grant', sa_role, publicador_desarroll
o go
> use desarrollo go
> exec sp_adduser publicador_desarroll
o go
> exec sp_publisher publicador_desarroll
o go
> exec sp_addlogin suscriptor_desarroll
o, suscriptor, desarrollo go
> exec sp_adduser suscriptor_desarroll
o go
> exec sp_grant_remote suscriptor_desarroll
o, file,
> 'C:\oasis\Oasis_Anyw
here\Suscriptor' go
> exec sp_create_publicatio
n desarrollo_pub go
> exec sp_add_remote_table ****** go (all my tables) go
> exec sp_add_article desarrollo_pub, ***** go (all my tables) go
> exec sp_subscription 'create', desarrollo_pub, suscriptor_desarroll
o,
> 'rep_desarrollo' go
> Then, i execute:
> ssxtract -c " eng=dataserver;dbn=d
esarrollo;uid=sa;pwd
="
> C:\oasis\Oasis_Anywh
ere\Suscriptor suscriptor_desarroll
o -e
> "english,iso_1" -i -o C:\oasis\Oasis_Anywh
ere\Suscriptor\error
.sql -r
> C:\oasis\Oasis_Anywh
ere\Suscriptor\reloa
d.sql -l 3 -xv
>
> But the command report:
>
> Adaptive Server Anywhere Extraction Utility Version 9.0.2.3044
> Adaptive Server Anywhere Extraction Utility Version 9.0.2.3044
> Cannot allocate context version 12.5, now try version 11.0
> SQL Server has run out of LOCKS. Re-run your command when there are fewer
> active users, or contact a user with System Administrator (SA) role to
> reconfigure SQL Server with more LOCKS.
> " suscriptor_desarroll
o" is not a remote user of this database
>
> The Lock of my ASE database is: Number of locks = 30000
>
>
> What is the problem? Waht can I do?
>
> Thanks
>
>

Sponsored Links