Timing Out On Downloading Snapshot ?
Feb 26, 2006
Hi
This is to do with HTTPS merge replication. We were getting an error when downloading the initial snapshot. The snapshot was about 25 meg, over an average link. It returned an error after a few minutes - it did start to download the .cab file (it was compressed).
By not compressing the cabinet file, it worked fine - I can only presume it was some sort of timeout error. The downside was that the amount of data was much greater, with it not being compressed.
Questions therefore are:
a) is this time of timeout a known condition and if so what can I do about it
b) slightly unrelated- can an alternate location be given for the snapshot, like you can in non-HTTPS anonymous subscriptions.
Main properties in creating the subscription is as follows:
subscription.InternetUrl = webSyncUrl
subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication
subscription.SubscriberType = MergeSubscriberType.Anonymous
subscription.SyncType = SubscriptionSyncType.None
and when synchronising....
subscription = New MergePullSubscription()
agent = subscription.SynchronizationAgent
agent.PublisherSecurityMode = SecurityMode.Standard
agent.DistributorSecurityMode = SecurityMode.Standard
agent.UseWebSynchronization = True
agent.InternetSecurityMode = SecurityMode.Standard
Thanks
Bruce
View 1 Replies
ADVERTISEMENT
Aug 29, 2007
Hi,
I'm merge replicating between SQL Server 2005 and SQL Server Compact on mobile devices. I recently had a problem with reinitialization of subscriber databases (please see my previous post, no responses yet...) which I couldn't resolve and had to get 15 subscribers to backup their dbs so I could manually restore each one onto the server. Most of the subscribers were able (yesterday) to then delete their local dbs, create new db files and sync with a snapshot. Today I'm trying to sync a new db with a newly created snapshot and getting the following errors:
2007/08/29 16:23:17 Thread=1118 RSCB=67 Command=SCHK Hr=8004563C An error occurred while reading the .bcp data file for the 'MSmerge_rowtrack' article. If the .bcp file is corrupt, you must regenerate the snapshot before initializing the Subscriber. -2147199428
2007/08/29 16:23:17 Thread=1118 RSCB=67 Command=SCHK Hr=80045017 The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. -2147201001
The only difference from yesterday is that there was a server restart this morning. I have regenerated the snapshot but it still doesn't work. This is only affecting users with new (empty) databases, users who regenerated their dbs yesterday can sync ok.
I have read other posts about folder/file permissions affecting snapshot delivery, but there have been no changes to permissions since successful snapshot deliveries yesterday.
I would really appreciate any help with this. At the moment I have 3 users who can't use the system at all.
Regards,
Greg
View 1 Replies
View Related
Jun 21, 2007
Hello.
I've been having an error when downloading the snapshot agent from our Publisher.
The articles selected are all the tables and all the stored procedures.
The Subscription is created programmatically and so is the synchronization. When trying to synchronize for the first time and when the subscriber tries to download the snapshot I have the following error:
Error messages:
The schema script 'Distrito_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001
The process could not read file 'GESZifuncAFRODITE$SILVITEST_GESZIF_GESZIF20070621182845Distrito_2.sch' due to OS error 3. (Source: MSSQL_REPL, Error number: MSSQL_REPL20143)
Get help: http://help/MSSQL_REPL20143
The system cannot find the path specified.
(Source: MSSQL_REPL, Error number: MSSQL_REPL3)
Get help: http://help/MSSQL_REPL3
The snapshot folder is at c:GESZifSnapshotFolder and the unc is \AfroditeSnapshot.
I'm getting a little desperate with this because we really need to propagate the schema changes around the subscribers.
Thanks in advance,
AVD
View 4 Replies
View Related
Jun 20, 2007
Hi
I seem to have a strange problem when applying a snapshot when the tables in the publication have been updated while the snapshot was being generated.
Say for example there is a table called RMAReplacedItem in the publication. When the snapshot starts being applied to the subscriber, a stored procedure called sp_MSins_RMAReplacedItem_msrepl_css gets created that handles an insert if the row already exists (ie it updates the row rather than inserting it). However, after all the data has been loaded into the tables, instead of calling this procedure, it tries to call one called sp_MSins_RMAReplacedIte_msrepl_cssm - it takes the last letter of the table name and adds it to the end of the procedure name.
The worst part is that this causes the application of the snapshot to fail, but it doesnt report what the error is, and instead it just tries applying the snapshot again. The only way i have managed to find which call is failing is to run profiler against the subscriber while the snapshot is being applied and see what errors.
I have run sp_broswereplcmds and the data in there is what is applied to the subscriber - ie the wrong procedure name.
All the servers involved are running sql 2005 service pack 2. The publisher and subscriber were both upgraded from sql 2000, but the distribution server is a fresh install of sql 2005.
View 1 Replies
View Related
May 8, 2006
I am trying to use Integration Services for something I've never done before; i.e., download a few files from an AS 400 and then turn around an email them to a user.
My basic problem is that I don't know where to start to get the files from the AS400 to a directory on the SQL Server. I have an Iseries ODBC connection configured correctly that will let me get to the files. Do I use a file system task to get the files from the AS 400 or do I use a data flow task? Don't know what task to start with. Once I get the files into a directory on the SQL server I don't think I will have any trouble emailing them.
I know it's a silly question but I've looked at a couple of books without any obvious answer popping out.
Steve Wells
View 1 Replies
View Related
Mar 1, 2001
hi all
i have the 2000 adition but i realy want the 7 version
and now microsoft offer as a shareware only the new 2000 to download as a limited pack
my questune is whare can i get the 7 version on the internet as a shareware
time trail or whatever
thanks in advance
View 1 Replies
View Related
Apr 8, 2007
I've been experienceing probelms downloading any of the visual studio express tools. I keep getting a site not available error and/or the vwsetup.exe crashes.
Do you have a better place for me to post for this issue?
I'm running Vista Home Premium 32-bit on a AMD Turion64x2 Mobile
Please help!
View 1 Replies
View Related
Nov 4, 2004
Dear All,
I am new to SQL I download "sql2ksp3" to my laptop (Window Xp Pentium III) and then I start to setup MSDE:
>> setup SAPWD=pass SECURITYMODE=SQL
After I run this command it gives me the following statment!!!
Setup failed to configure the server.Refer to the server error logs and setup error logs for more information.
Please help me what i have to do to make this stuff works!!
Sincerely
Henok
View 5 Replies
View Related
Mar 31, 2005
I am looking for some material for downloading documents from sql
server. I can upload documents in my app but i would also like to
download those files too.
Thank you
View 2 Replies
View Related
Sep 27, 2007
Hi,
I want to download data to excel in which each filename varies depending on the day i download them.
Ex.
ExportFile_09272007.xls
Can this be possible?
cherriesh
View 5 Replies
View Related
Apr 20, 2007
I keep getting eeror mess when downloading SQL server 2005. Micro soft cust service says they are not qualified to fix but if I pay $99.00 they can have someone help with it.
I think that is nuts since they are sending me the download. I tried to do it manually and some components installed but everyday I get update notifications
HELP! PLEASE!
View 1 Replies
View Related
Jun 11, 2008
Hi
I have a query which executes in 1 second and returning 14 rows whenever I execute it through Management Studio but when I execute it from a web page I am getting a timeout message and the stack trace is pointing towards the line which calls the stored procedure. The query is quite complex and there quite a few joins on tables and views including one to a lookup table, whenever I take out join onto the look up table the web page runs ok without timing out. I join the Lookup table (Parts) using a Left Outer Join similar to below. The syntax of the Join is fine but I cant find why it would cause the query to time out when executed from a webpage but is fine when I execute it from Management Studio
select *
from tables/view LEFT OUTER JOIN
Parts on Parts.PartNumber=tables/View.PartNumber
I've tried recompiling the Parts table but it didnt make any difference.
Any help would be much appreciated.
Cheers,
Frankie
View 3 Replies
View Related
Mar 28, 2001
I use SQL Server to provide data to asp web pages and have recently started to get ODBC time outs throughout the day.
The environment is as follows:
Server with dual PII processors & 512MB RAM running:
- SQL Server 7
- IIS
I have a number of asp based web sites hosted on this box, but only 1 of them seems to be affected by the time out problem. I have checked the resources on the server (NT Task Mgr - Memoey & Processor) and everything seems fine - in fact the resources are hardly being touched!!!
Within a few minutes the problem disappears completely without me doing anything.
Am I missing something here?
Should I look elsewhere other than SQL - maybe IIS ???
Any suggestions / pointers would be very much appreciated.
Thx
View 1 Replies
View Related
Aug 21, 2000
We are using asp's and tables sucessfully but when we click a link to an exe on a page it is slow, to the point of timing out. Very slow. Any help would be appreciated. Email me tperry@kpmg.com
Tim
View 2 Replies
View Related
Feb 28, 2001
Does anyone know how to time a DTS package?
Thanks
View 1 Replies
View Related
Jun 23, 2004
What could be the reason for my view to timeout? I thought it was because of the number or records, but i guessed wrong. The view is grabbing data from a UDF i have created.
View 1 Replies
View Related
Jan 3, 2008
I am trying to use statistics to get the time it takes to run a sql function. When I use SET STATISTICS TIME ON it returns multiple results (one for each insert statement in my loop). Is there any way to get results for the ENTIRE function? Here is the loop that I am timing.--> (It simply populates a calendar table)
SET NOCOUNT ON
DECLARE @Counter INT
DECLARE @ActualDateDATETIME
DECLARE @FirstDateDATETIME
SET @Counter = 1
SET @FirstDate = '1/1/1900'
SET @ActualDate = @FirstDate
WHILE @Counter < 43830
BEGIN
INSERT INTO Calendar(ActualDate)
values(@ActualDate)
SET @ActualDate = DATEADD(day, @Counter, @FirstDate)
SET @Counter = @Counter + 1
END
View 14 Replies
View Related
Feb 18, 2004
Can anyone tell me as to how I can Timeout a transaction. For example I have transactiopn that pulls in data from a remote source. So if the time of extraction exceeds sometime say 1hr..I need to rollback the transaction.
Cannot use Set Lock_Time out because it can be used only for timing out a waiting process. Here I want to timeout the executing process
Regards
Manmeet
View 1 Replies
View Related
Feb 12, 2008
How can I easily time a query entered in Studio Express for SQL Server 2005? Thanks in advance.
View 11 Replies
View Related
Mar 27, 2008
Hi. I'm new to SQL Server programming. I'm using it at my new job for the first time and catching on quickly. I've run into a problem where I run a request via interactive query and it times out. It's really annoying because it seems to happy a lot. Is this just a memory issue with my machine (it has 2.8 GB of RAM) or there a way around it?
Thanks!
View 12 Replies
View Related
Jul 20, 2005
Hi all,i have 97 honda CR-V with about 100,000 KM on it. i checked a doc onHonda web site and it said that 60,000 miles is point to change timingbelt. compared with other Honda cars, it is pretty low. is it correct? ifyes, do you know the reason??thanks for your help,jj
View 2 Replies
View Related
Nov 10, 2006
I'm using SQL 2k.
I wrote a query using the query analizer and tested it before turning it into a Stored Procedure. It worked fine an the execution time was acceptable (25 secs, since there was a lot of data to analize)
When I executed the recently created stored procedure, the execution time happened to be three or four times higher. (1 min, 38 secs)
It was the exact same code, i was logged in the same database server, the parameters were the same in btoh cases. So, my question is as follows:
Why is it that executing a script and executing a stored procedure with the exact same script differ so much in timing?
View 1 Replies
View Related
Mar 5, 2008
what data type am i going to put to my uploadedFiles column in my database... uploaded files are in document format or .txt
also.. how can i make those files converted into pdf files.. also enable users to download it..
tnx!!!
forums.asp.net = "great help"
View 7 Replies
View Related
Jan 7, 2004
Our entire sales database sits on an Informix server and users run their reports directly to this server.
Because of the volume of data - upwards of 7 million rows in some tables we are finding performance is becoming an issue. We realise that Informix is not the best for running queries and so are looking to replicate to a SQL server and use that as a reporting server.
My chosen method is DTS using ODBC which works fine. However due to the sheer volume of data to be downloaded each night (over a 512K wan link) we only want to download changed data.
Is there any way we can get SQL2000 to download only change data - i.e a differential download or something? We don't have a unique field in the table (for whatever reason) such as sales date or transaction ID (shops might upload old / back-dated transactions for example due to a systems failure).
If I do have to download all the data every night is my method the most efficient or is there some other approach I could use?
Ultimatly the aim here is to relieve the Informix server of the reporting overhead so any alternative ideas are welcome!
Many thanks
View 2 Replies
View Related
Jun 23, 2008
hi guys,
i want to use SSIS package to download files from an http website.
i am tried using Http connection managers and webservice task but it asking me the wsdl file. i dont know where that file is.
can anyone please guide me? or suggest me any other way to do this?
View 3 Replies
View Related
Dec 1, 2007
I can not download sql express 2005 from microsoft website. Everytime I click on the download button I get error saying "this page can not be displayed. Possible reason... internet connection" I know my internet connection is working because I am browsing through the microsoft website and other websites. I had .net 1.0 in my computer so I unintalled that to try to intall the latest 3.0 version but when I click to download that I get the same error. Seems I can not download anything from microsoft website. I uninstalled windows intaller and automatic update downloaded latest version of windows installer. When I tried to download windows installer from microsoft website I got the same error.
I am using Windows XP home edition version 5.1 sp2.
Please help!!
Thank you,
Jay
View 1 Replies
View Related
Jun 21, 2006
Hello World,
I am trying to download the SQL Express Server 2005 software direct from Microsoft. I am having trouble locating the ENGLISH version. I am located in Frane but prefer using software in my native language....no pun intended. Every attempt to d/l gives me the French version. Can anyone provide me a link for the ENU version of SQL Express Server 2005.
Thank You in Advance,
Best Regards,
Richard J. Rothery Jr.
rjstinyc@hotmail.fr
View 5 Replies
View Related
Aug 2, 2006
Hi,
I am not able to download the trial edition of sql server 2005.
http://www.microsoft.com/downloads/details.aspx?FamilyId=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en
From this page when I click continue to do the registration, it displays a page not found error !! Can you plz fix the link
thanks
View 1 Replies
View Related
Oct 31, 2007
I am creating an index on a table wit 35 million records but I get the error
'TT_ObjPerformance' table- Unable to create index 'IX_TT_ObjPerformance_CACode'. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
How can I get the index created?
ThanksSQL Server newbie
View 1 Replies
View Related
Dec 18, 2001
Hi Guys,
Anyone knows if there is a SQL equivalent of Oracle SET TIMING ON to give the excution time in milli/centi Seconds?
Cheers,
xiaobing
View 1 Replies
View Related
Jan 24, 2001
I am trying to run a program that works on another site but with a copy of the database(SQL6.5) and the vb front end I keep getting a timeout error.
The vb bit is trying to run an update statement on a table with just over 2000 rows. I cannot amend the vb side because this is an .exe
Is there something I might not have done on the server that could be causing this not to work, i.e configuration issues, bigger logs
Please help!!
View 2 Replies
View Related
Apr 21, 2008
I have a site that is experiencing the issue described in this doc. I'm unsure if the fix is going to blow anything up as I am unfamiliar with anything they are recommending.
http://support.microsoft.com/kb/931279
exec sp_configure 'affinity mask', 0x00000003
GO
reconfigure
GO
Any insight? Thanks,
Meg
View 2 Replies
View Related
Jan 12, 2007
Hopefully, this is an easy. Does SQL Server use the Windows system dateand time? Or does it keep track of what day/time it is on its own?We were just discussing this in the office today, because we'replanning for the changes in Daylight Savings Time in the United Statesthis year. It's going to start a month earlier and end a month laterthan it used to. Microsoft is apparently putting out patches forWindows so the OS will know to adjust the time by an hour on the rightdays, and we're trying to determine if our SQL and Oracle databases aregoing to be affected at all.--Richard
View 2 Replies
View Related