Merg replication: subcriber fail to connect to snapshot data

I am new in replication, but really need your help... My replication is simple but I am struggling
Set up
-Win 2000 server with sql200
- 2 server, non trusted domain and hapy to use sql authentication.
- Both server have the same sqlexec user and impersonating the sqlserver agent
- I am trying a simple replication between a publisher/ distributer and a subscriber using just one article and it is working when they are in the same LAN
- the snap shot is located in a shared directory, I also used the default directory \\server name\C$\bl bla
- Once I move to the WAN using a VPN the agent fails with fail to proprogate snapshot data
- Note I can register both server and query both of them without a problem using both query analyzer and enrpMgr, so communication is fine...
Where is the problem please ... your help is appreciated
Regards,
Haith,
this could be a number of issues - often it is simply a case of setting up
the alias to an IP address. Have a look at the detailed instructions in this
article: http://support.microsoft.com/?id=321822.
A few extra points outside of the article from when I set it up:
(a) don't use an administrative share to set this up - create an explicit
share as \\server\repldata.
(b) if you use pass-through security then you won't need to set up security
on the fiolder, but with SQL security I have to give the windows guest
account access.
(c) finally, I found I had to add an entry to the Hosts file to be able to
see the snapshot share.
HTH,
Paul Ibison
|||Hi Paul,
Thanks for your prompt reply ...
... My problem is when I have more than one article aded to the publication it comes with the message "The schema script '\\YKUL8K2WEFKEFSZ\D$\ABIS\ReplData\unc\YKUL8K2WEF KEFSZ_Northwind_Northwind\20040527153100\Region_8. sch' could not be propagated to t
he subscriber." As you can see I was just testing using Northwind DB. I have the aliases in place and what is funny is that it works when I have a simple small one article per publication and only a handfull of changes... Is this to do with the size of th
e snapshot (Schema scrip) against the slow rate I have in my link (Down to 23KB at times)... My connection time out is set up really high and I never had any timeout message for both connection and query and I have no probem seeing and accessing the other
server's DB.
I will use your advice and change to a private share and will also edit the host file... But more info in this sympton will really help as I have alot of replication to do and all will have the same problems I beleive...
Thanks again Paul for your help and looking forward to your next reply
|||Haith,
there's no need to convert the share or host file if it's working for one
article. Presumably you are now using pass-through security as I noticed you
have an admin share (D$) which is accessible by local admins? Anyway, if it
is only the initialization that is the problem due to a slow/intermittent
link, I'd consider BCPing the data to a textfile, zip it up, send it over,
restore it then initialize with nosync. After that, choose the slow link
agent profile for synchronization.
HTH,
Paul Ibison

Memory Problem

Hi,

I need help, Im workin with 30,000,000 rows in Asociation Rules algorithm, but, when process the model, it fail for memory problem.

PLEASE help me

Charlie

Hello, Charlie

Here are a few suggestions that would reduce the memory pressure on the server:
- Increase the value of the MINIMUM_SUPPORT parameter. The default (0.03) value requires a group of items to appear in at least 3% of the transactions to be considered for the left hand side of a rule. By increasing it, the algorithm will analyze fewer items
- Decrease the MAXIMUM_ITEMSET_COUNT parameter.
- Decrease the value of MAXIMUM_ITEMSET_SIZE or increase the value of MINIMUM_ITEMSET_SIZE. If shorter rules correlating two or three items are OK, then decrease the MAX... parameter (the default value is 3, which generates rules with up to 3 items on the left hand side).

Hope this helps|||

Can you recommended a good source for reading up on tuning Analysis Services and in particular the mining model viewer? Fixing problems is one thing, but I'd also like to build up a good foundation of knowledge.

Thanks,

Nick

|||

Hi Bogdan, Thank you!

I reduce the parameters, but this model is important to a supermarket and they dont want reduce some parameters because yours business.

I was reading, Its posible that the problem is support in 32 bits?. The server have 4 procesor and 16 GB of RAM.

Please any suggestion

HELP ME!!

Charlie

|||

Carlos, can you post the exact error message that you receive? That may help us to narrow down the issue.

Thanks

|||

Are you running the 64 bit or 32 bit version of Analysis Services? With the 32 bit version, the server cannot take advantage of the 16 GB of RAM.

|||

Hi,

The Error is : Server Timeout. the procces has been canceled.

umm, There is limit of records in a platform of 32 bits?

The process run for 3 hours and begins to read the cases, when it read the last cases it is when fails.

Thank you for the help!

Charlie

|||

cbdl10 wrote:

Hi,

I need help, Im workin with 30,000,000 rows in Asociation Rules algorithm, but, when process the model, it fail for memory problem.

PLEASE help me

Charlie

hi,
i've got the same problem as yours ..
I can't find a solution yet .. did u?

is it correct considering a MAXIMUM_ITEMSET_COUNT equal to count(*) of my fact table?
[if i reduces my fact table, which means that if i have a fact table working with a 180,000 rows i'll consider only 9,000rows randomly and even in this situation, the algorithm lasts 25min to be accomplished]
|||

cbdl10 wrote:

Hi,

I need help, Im workin with 30,000,000 rows in Asociation Rules algorithm, but, when process the model, it fail for memory problem.

hi there,

i've got the same problem as you ... I'm working with 180,000 records fact table and i've memory problem too (32bit, 2gb ram).

I tried to sample my fact table, by using only 9,000 records randomly chosen but it lasts more or less 25minutes. So, i decided to try to tune algorithm parameters:

MAXIMUM_ITEMSET_COUNT: 9,000;

MAXIMUM_ITEMSET_SIZE: 2;

MINIMU_SUPPORT = 0.1;

It executes very fast, but it doesn't show any result .. does a tuning howto exist? did u solve your problem?

Memory Problem

Hi,

I need help, Im workin with 30,000,000 rows in Asociation Rules algorithm, but, when process the model, it fail for memory problem.

PLEASE help me

Charlie

Hello, Charlie

Here are a few suggestions that would reduce the memory pressure on the server:
- Increase the value of the MINIMUM_SUPPORT parameter. The default (0.03) value requires a group of items to appear in at least 3% of the transactions to be considered for the left hand side of a rule. By increasing it, the algorithm will analyze fewer items
- Decrease the MAXIMUM_ITEMSET_COUNT parameter.
- Decrease the value of MAXIMUM_ITEMSET_SIZE or increase the value of MINIMUM_ITEMSET_SIZE. If shorter rules correlating two or three items are OK, then decrease the MAX... parameter (the default value is 3, which generates rules with up to 3 items on the left hand side).

Hope this helps|||

Can you recommended a good source for reading up on tuning Analysis Services and in particular the mining model viewer? Fixing problems is one thing, but I'd also like to build up a good foundation of knowledge.

Thanks,

Nick

|||

Hi Bogdan, Thank you!

I reduce the parameters, but this model is important to a supermarket and they dont want reduce some parameters because yours business.

I was reading, Its posible that the problem is support in 32 bits?. The server have 4 procesor and 16 GB of RAM.

Please any suggestion

HELP ME!!

Charlie

|||

Carlos, can you post the exact error message that you receive? That may help us to narrow down the issue.

Thanks

|||

Are you running the 64 bit or 32 bit version of Analysis Services? With the 32 bit version, the server cannot take advantage of the 16 GB of RAM.

|||

Hi,

The Error is : Server Timeout. the procces has been canceled.

umm, There is limit of records in a platform of 32 bits?

The process run for 3 hours and begins to read the cases, when it read the last cases it is when fails.

Thank you for the help!

Charlie

|||

cbdl10 wrote:

Hi,

I need help, Im workin with 30,000,000 rows in Asociation Rules algorithm, but, when process the model, it fail for memory problem.

PLEASE help me

Charlie

hi,
i've got the same problem as yours ..
I can't find a solution yet .. did u?

is it correct considering a MAXIMUM_ITEMSET_COUNT equal to count(*) of my fact table?
[if i reduces my fact table, which means that if i have a fact table working with a 180,000 rows i'll consider only 9,000rows randomly and even in this situation, the algorithm lasts 25min to be accomplished]
|||

cbdl10 wrote:

Hi,

I need help, Im workin with 30,000,000 rows in Asociation Rules algorithm, but, when process the model, it fail for memory problem.

hi there,

i've got the same problem as you ... I'm working with 180,000 records fact table and i've memory problem too (32bit, 2gb ram).

I tried to sample my fact table, by using only 9,000 records randomly chosen but it lasts more or less 25minutes. So, i decided to try to tune algorithm parameters:

MAXIMUM_ITEMSET_COUNT: 9,000;

MAXIMUM_ITEMSET_SIZE: 2;

MINIMU_SUPPORT = 0.1;

It executes very fast, but it doesn't show any result .. does a tuning howto exist? did u solve your problem?