Sync Will Work Only 1 Time.
Jan 29, 2007
I am really stuck on this, if anyone has some insight into this problem
any help would appreciated...
I'll try to explain what is happening the best I can:
We have a server running Windows Advanced Server 2000 (SP4) w/ SQL
server 2000 (SP3) (from now on Server A). I have a publication on this
machine with dynamic filters (Changing the HOST_NAME()). The
publication is sending the snapshots to another machine (desktop
machine). The Mobile agent is in the same machine as the snapshots.
The mobile application is syncing fine when hitting Server A. The sync
is done Asynchronously.
Then we have Server B. Running Windows Server 2003 (SP1) w/ SQL 2000
(SP4), same publication w/ dynamic filter however the snapshots and the
mobile agent are in this server.
The mobile application will sync the 1st time but any subsequent syncs
will not work. I check on the Replication monitor and it tells me that
the Merge was a success but the mobile application will not execute the
download table callback, it will execute the Sync callback 5 times and
not proceed in executing the download table callback.
If I change the configuration on the mobile app to point to Server A
the sync will work just fine but, if I change it back to Server B the
sync will work once then it will stop working.
Anyone have some suggestions for troubleshooting?
View 6 Replies
ADVERTISEMENT
Oct 17, 2006
Hi!
Well..
There's operable web sync with parameterized filter.
But sometimes the strange errors appear.
Below the list of the errors I got from ComErrorCollection property of MergeSynchronizationAgent instance:
ERROR: -2147199433
SOURCE: Merge Replication Provider(Web Sync Server)
TEXT: The Merge Agent was unable to start the SQL Server Agent job to generate the partitioned snapshot for this subscription. Verify that the SQL Server Agent service is running at the Distributor.
ERROR: 22022
SOURCE: HOST3MAIN
TEXT: SQLServerAgent Error: Request to run job dyn_HOST3MAIN-Customers-Main-2__20061014_14 (from User distributor_admin) refused because the job is already running from a request by User distributor_admin
ERROR: 20633
SOURCE: HOST3MAIN
TEXT: Failed to start the dynamic snapshot job. Verify that the SQLServerAgent service is running on the distributor.
ERROR: 20628
SOURCE: HOST3MAIN
TEXT: Failed to generate dynamic snapshot.
I'm sure that SQL Server Agent is running...
What is the reason and how it can be solved?
Thanks
Paul
View 6 Replies
View Related
Dec 6, 2007
hello all,
I am having an intersting problem using sql replication.
I have a staging database inside my firewall that I am replicating out to my sales force over gprs. The web synchronziation server is in the dmz and the dbin in the firewall.
When I initiate the sync from the mobile devices, I am monitoring the replication monitor. The replication takes about 5-30 seconds to complete on the server but the operation can take up to 15 minutes to complete on the mobile device. The time delay happens over gprs, wi-fi or even activesync'ed so it is not the connection speed. I have tried tweaking settings on my IIS box but to no avail. To make things even more interesting the problem is intermittant. Anyone ever see anything like this?
View 4 Replies
View Related
May 29, 2008
Hi,
I'm writing a query to select rows that are included in work time :
AND ((SUBSTRING(CONVERT(char(30), Dateid, 120),12,8) >= @WorkTimeIni and SUBSTRING(CONVERT(char(30), Dateid, 120),12,8) <= @WorkTimeEndAM)
OR (SUBSTRING(CONVERT(char(30), Dateid, 120),12,8) >= @WorkTimeIniPM and SUBSTRING(CONVERT(char(30), Dateid, 120),12,8) <= @WorkTimeEnd))
is there another way to do this, i mean, with a more simple sintax..?
entire query :
(SELECT COUNT(tblindex.recordNum)
FROM SRVCCC.SDXARCHIVER.dbo.tblIndex as tblindex
LEFT JOIN SRVCCC.SDXARCHIVER.dbo.tblCallDirectionCodes as CalldirCode
ON tblIndex.cdir = CalldirCode.CallDirectionCode
WHERE dateid >= @CalcPeriodStart and dateid < @CalcPeriodEnd
AND ((SUBSTRING(CONVERT(char(30), Dateid, 120),12,8) >= @WorkTimeIni and SUBSTRING(CONVERT(char(30), Dateid, 120),12,8) <= @WorkTimeEndAM)
OR (SUBSTRING(CONVERT(char(30), Dateid, 120),12,8) >= @WorkTimeIniPM and SUBSTRING(CONVERT(char(30), Dateid, 120),12,8) <= @WorkTimeEnd))
AND ndbo=@Subset AND ( (cdir ='I') or (cdir='C' and ccid in('7','27')) or (cdir='N' and ccid='7')) )
View 6 Replies
View Related
Sep 19, 2007
Hello,I need to create a column that will store hours bigger than 24. Forexample '25:00:00', '129:23:12', etc).That column will be used too, for perform calculations betweendatetime intervals: 'time'.In MySQL there is a datatype that perfect fits that necessity.Does anyone know what is the corresponding datatype in SQL Server?Thanks a lot!
View 4 Replies
View Related
Jan 28, 2008
As in title. Is there any tool? I'm asking beceuse, I have some big bases, and processing may take a lot of time (at least few hours), and I'll be glad if it's possibility to know estimate time before query runs. I'm using MsSql 2005 Developer edition.
View 14 Replies
View Related
Apr 18, 2006
I had try calling a function, that call a store procedure, repeatly using a for loop, but I notice it will only get the expected part_id in the first time, and return an empty string sub-sequentially without throwing an exception. So I had try using a sql query instead, but the same thing happen. Below is my function, can you point out to me what's wrong?
My original version that calls a store procedure
Public Shared Function getPartId(ByVal part_supplierserialnumber As String) As String
Dim mySqlCommand As New SqlCommand
Dim mySqlConnection As SqlConnection = New SqlConnection(GetERATSConnectionString())
Dim myPart_id As String
mySqlCommand.CommandType = CommandType.StoredProcedure
mySqlCommand.CommandText = "getPartId"
mySqlCommand.Connection = mySqlConnection
mySqlCommand.Parameters.Add(New SqlParameter("@part_supplierserialnumber", part_supplierserialnumber))
Try
mySqlConnection.Open()
myPart_id = mySqlCommand.ExecuteScalar()
Catch ex As Exception
myPart_id = ""
Finally
mySqlConnection.Close()
mySqlConnection.Dispose()
End Try
Return myPart_id
End Function
My Store procedure
create procedure getPartId@part_supplierserialnumber as nvarchar(50)as
select top 1 part_id from tblPtSingapore where part_supplierserialnumber = @part_supplierserialnumber order by part_datecreated desc
GO
The new version I tried which happen the same thing
Public Shared Function getPartId(ByVal part_supplierserialnumber As String) As String
Dim myPart_id As String
Dim strSql As String = "select top 1 part_id from tblPtSingapore where part_supplierserialnumber = '" & part_supplierserialnumber & "' order by part_datecreated desc"
Dim mySqlConnection As SqlConnection = New SqlConnection(GetERATSConnectionString())
Dim mySqlCommand As New SqlCommand(strSql, mySqlConnection)
Try
mySqlConnection.Open()
myPart_id = mySqlCommand.ExecuteScalar()
Catch ex As Exception
myPart_id = ""
Finally
mySqlConnection.Close()
mySqlConnection.Dispose()
End Try
Return myPart_id
End Function
View 2 Replies
View Related
Jul 23, 2005
I convert my DB from Access to SQL Server ,When i try to run my script (in ASP) it's not store the data atDate/Time field!!!And i have troble with insert the value TRUE in Sql Server (it's workwith access)I want to know if i need to change my scripts(in ASP) or the type offields?Please, HelpBest regards.
View 2 Replies
View Related
Jul 28, 2007
Hi Friends
"I wonder why the boolean values Set to "Disable Property" using expressions does not work as expected (though Precedence constraints work fine). I find no way to disable individual task. "
I have a boolen variable V, (False) enabled by default at design time for a task T, I disable T based on a condition (if A ! = 'a') during runtime.
Now first time when I run the Package, Task gets disabled (works fine on the condition given). However T gets permanently disabled even after we stop debug mode, which is not the expected behavior. Further on when you run, it wont work at all.
Is it true that a task disabled at design time cannot be enabled during runtime via expressions ?
If things are working fine in your case, pls let me know what settings are required.
Thanks
Subhash Subramanyam
View 5 Replies
View Related
May 31, 2015
I have a table that stores working hrs, such as
RecID,StaffID,StartDate,EndDate
17,969,2015-05-18 00:00:00.000,2015-05-18 06:00:00.000
18,969,2015-05-18 18:00:00.000,2015-05-19 06:00:00.000
19,969,2015-05-19 18:00:00.000,2015-05-20 06:00:00.000
20,969,2015-05-20 18:00:00.000,2015-05-21 06:00:00.000
21,969,2015-05-21 18:00:00.000,2015-05-22 06:00:00.000
22,969,2015-05-22 18:00:00.000,2015-05-23 06:00:00.000
23,969,2015-05-23 14:00:00.000,2015-05-24 08:00:00.000
24,969,2015-05-24 22:00:00.000,2015-05-25 00:00:00.000
So working times can go over midnight, there can be more than one working period in a day etc.
For this staff member the summary of the weeks work will be
18/05/2015 - 12 hrs
19/05/2015 - 12 hrs
20/05/2015 - 12 hrs
21/05/2015 - 12 hrs
22/05/2015 - 12 hrs
23/05/2015 - 16 hrs
24/05/2015 - 10 hrs
Now for the complicated part, a person can take absence(sick,holiday,other) for any part of a day or whole day(s). For these absence periods only the worked time on that day needs to be negated off, not the whole period of time.
So for example
If this person
had a days holiday on the 22nd, shown in the HOLIDAY table as
StaffID,DateFrom, DateTo
969, 22/05/2015 00:00:00.000,22/05/2015 23:59:59.000
A Leave of Absence on the 20th, shown in the LEAVE table as
StaffID,DateFrom, DateTo
969,20/05/2015 12:00:00.000,20/05/2015 16:00:00.000
And was off sick on the morning of the 19th, shown in the SICKNESS Table as
StaffID,DateFrom, DateTo
969, 19/05/2015 00:00:00.000,19/05/2015 11:59:59.000
Now the Summary table should now show
18/05/2015 - 12 hrs
19/05/2015 - 6 hrs
20/05/2015 - 12 hrs
21/05/2015 - 12 hrs
22/05/2015 - 0 hrs
23/05/2015 - 16 hrs
24/05/2015 - 10 hrs
The 'Leave of Absence' on the 20th had no effect on the total for the day as it was between planned work times. how to do this within T-SQL, as simple as possible as I've got to had this code over to other staff members to maintain, who have not had much SQL experience yet?
I've tried doing it as a temp table, with dual insert/select commands, splitting the times over midnight, which partially worked but missed some of the combinations.
View 1 Replies
View Related
May 16, 2008
Clean vista install,
Clean full office 2007plus install
Clean visual studio 2008pro install
Many failed sql 2005dev installed, did SKUUPGRADE-1
Now have office2007 Smallbiz, VS2008pro, SqlExpress and sql 2005dev installed.
Note outlook 2007 error on first run after sql2005dev.
Seams to have broken and created a new sql connection, don€™t think its the original.
but that€™s not the current issue !
web admin page error, could not connect to db
I did regsql.exe from the net dir and the web admin work and the db is created for roles and such in vs 2008 via web admin page and mssql.
Managed to create db in apps data folder and modify connection in server explorer.
Added table to aspx page from apps folder and it runs via f5, but errors under localhost.
€œCannot open user default database. Login failed.€?
€œLogin failed for user 'NT AUTHORITYNETWORK SERVICE'€?
Have seen some reference to iis permissions, but not sure what to change?
Is it a file level permission, a virtual permission
Works in vs2008 using f5 run!
http://localhost:50115/vs2008/
Can work with apps folder db file in vs 2008 server explorer
Had to modify db connection back to sqlexpress in server explorer
Can work with db in sql management studio, have three local instances;
Pc
Pcsqlexpress
Pcsmallbiz
Can display db data in aspx page via f5 , but not localhost unless vs2008 is not running!!!
Have not been able to make vs2008, Sql2005dev, sqlexpress all work together using iis in vista via localhost and vs2008 f5 at same time??
Can€™t do anything with db in solutions explorer, but can work in server explorer if I modify connection back to sqlexpress
Can€™t display data aspx page via localhost
http://localhost/vs2008/
Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITYNETWORK SERVICE'
Localhost works in iis via virtual directory if I remove db grid in page or vs is not running
Could someone test and tell how to use all of these together?
What is going to happen if I get it to work local and then try to upload to shared host?
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Server=wabpc;Database=VS2008test;Integrated Security=true" providerName="System.Data.SqlClient" />
<add connectionString="Server=SQLEXPRESS;Database=Database.mdf;Integrated Security=true" name="sqlexpress" />
</connectionStrings>
If I close vs2008 and the management studio, localhost works and displays the db info!!
Open vs2008, modify connection back to sqlexpress and the aspx page breaks via localhost
Close vs2008 and local host works
Open vs2008 and get a error 25 in server explorer connection string invalid, but f5 works after the offline clears.
I change db connection back to sqlexpress to work with db in server explorer!
That breaks localhost, but f5 works
Any ideas?
Need more Tylenol
View 9 Replies
View Related
Aug 7, 2007
Hi all,
I have created a report in SSRS 2005 which is being viewed by users from different Time Zones.
I have a dataset which has a field of type datetime (UTC). Now I would like to display this Date according to the User Time Zone.
For example if the date is August 07, 2007 10:00 AM UTC,
then I would like to display it as August 07, 2007 03:30 PM IST if the user Time Zone is IST.
Similarly for other Time Zones it should display the time accordingly.
Is this possible in SSRS 2005?
Any pointers will be usefull...
Thanks in advance
sudheer racha.
View 5 Replies
View Related
Feb 22, 2008
Hi Forum, Ive been unsuccessfully trying to copy data from one table to another, very simple scenerio!
Table1 ID(PK), FirstName, Mobile, Date.
Table2 FirstName, Mobile.
The first question I have is should I fill Table2 at the insert stage OR should/do I update Table2 from Table1 as the users details are entered. ie create some kind of relationship.
Really appreciate good advice! cheers P
View 7 Replies
View Related
Apr 18, 2005
I have two db instances on different SQL Servers. One is my test db and the other the prod. db. Each has two tables that hold lookUp values for the entire application. I would like to keep these tables in sync. in both dbs. The prod. db would be the master. I was trying to design a trigger to insert, update, or delete the appropriate records in the test db as they were added or deleted from the prod db.
I'm getting too many prefixes errors on the script when trying to reference the table on the test db using four part naming convention.
Any ideas on how to resolve this issue? Do I need to set up a linked server to accomplish this functionality? If so, how do I setup security for a linked server?
Thanks in advance.
Oscar
View 1 Replies
View Related
Jan 31, 2000
I have a SQL 7 backup file that I restored onto a new server. All the objects within the database are not owned by dbo, instead they are owned by a db user. When I tried to login to the db it said that it wasn't a valid user. So I added the login to the system. Now when I login it says it is not a valid db user. I have attempted to sync the id's but don't know how. In 6.5 I could run an ad-hoc query to match the SUID's for the system and the database. In 7.0 I can not because the suid for the db is computed. Any ideas on how to sync the user ID's so that I can login to the server using the target db as my default and can query the table with prefacing the owner(I can get in if I give my login SA privelages but then I have to preface all the objects with the owners name)?
Thanks in advance for any help that you can offer.
View 2 Replies
View Related
Feb 20, 2003
hi,
we currently have a web server/db on-site and a similar backup machine across the country. we're using a pretty bad backup strategy. we zip up a backup file, thats done on the main server every night, then ftp over to the back up server then run a restore.
lately ive been having problems with the main server. i would like to have the machines sync'd up as close as possible.
ive searched the threads and noticed replication and log shipping to be the most practical, but im assuming most of the machines are on the same domain.
what would be my best bet for machines connected over the internet, no vpn?
also the db on the main machine get queried/inserts all day from 7am - 6:30pm
thoughts?
thx
View 1 Replies
View Related
Mar 18, 2007
I need to syncronize two separate databases. One is SQL Server the other is MySql. I don't have a lot of experience with MSSQL and need a little advice on how best (in terms of speed especially) to gather records that have been added since the last sync and any that have been modified. The table in question has datetime fields for both, the time each record was created (CreatedTime) and the time that the record was last modified (ModifiedTime). Sync will happen daily.
I have worked out a few ways I might do this with DATEADD or DATEDIFF, but my question is, what is the most effecient way? Currently I'm just looking for a way to get inserted and updated records from SQL Server to MySQL. I may have to do a two way sync of some sort later.
View 2 Replies
View Related
Mar 19, 2006
I need to make a sync between 3 or more SQL Servers. We have 3 Small Business server with sql server 2000. In all the 3 locations, branch and headquarters we've the same databate data.
For sync with 2 there's no problem. I need to make it with three and then at the end of the year with four.
Can anyone help me?
Cheers
João Almeida
View 1 Replies
View Related
Jul 23, 2007
how do i write a sync procedure that syncs both tables and ensures that Table_2 keeps all services that are listed in Table_1
how do i write a procedure for the sync between both tables, and put this procedure into the package
so basically there have to be two sync parts: First is INSERT of what is not yet existing, second one is UPDATE on the appropriate attributes.
How would i write this sync procedure?
View 1 Replies
View Related
Jul 23, 2007
how do i write a sync procedure that syncs both tables and ensures that Table_2 keeps all services that are listed in Table_1
how do i write a procedure for the sync between both tables, and put this procedure into the package
so basically there have to be two sync parts: First is INSERT of what is not yet existing, second one is UPDATE on the appropriate attributes.
How would i write this sync procedure?
View 2 Replies
View Related
Sep 24, 2007
Hi all,
I have three tables and i want to bring all tables into sync.
My problem is that the difference in the amount of records is huge.
CORE -- 85659 This table doesnt have a PK
CRF -- 59895 This table has a composite key (MIN,MAX)
DS -- 58595 This table also has a the same composite key (MIN,MAX)
All the tables have their own UIDs. Additionally CRF has a column which stores the UID of CORE table and DS has a column which stores UID of the CRF table.
CORE --> CRF --> DS
UID --> UID,CORE_UID --> UID,CRF_UID
I have only 3 columns (UID, MIN, MAX) that can be used to sync all the tables. Can anybody help me...?
Thanks in advance....
View 3 Replies
View Related
Jan 17, 2008
I want to synchronize two databases. Is there a query or a tool to synchronize them?
View 3 Replies
View Related
Jul 20, 2005
Hello,I've got 2 databases (both on MS-SQL Sever2k). One of them (remote)contains table which is often updated. For various reasons I'd like tomaintain a copy on local MSSQLServer. Is there any built-in mechanism whichallows to do such things?! I can do this manually, by examining the remotetable contents, and downloading new stuff (local table cannot be modified inany other way), but I guess that there is a smarter way. Any ideas?!ThanksPiotrek
View 1 Replies
View Related
Jul 20, 2005
I have tried to set up log shipping for one of our databases - firsttime. Using EM I was able to create the job and maintenance plansucessfully. I wasn't able to find any errors in any logs. In themonitor server, when I look at job history, everything is gettingcopied and loaded sucessfully, yet the STATUS in the log shippingmonitor states it is out of sync.How do I get this into sync? I have set the out of sync threshold to45 minutes. I have made changes in our production database and thosechanges are showing up in the standby database, so it all appears tobe working.Thanks.
View 1 Replies
View Related
Feb 11, 2008
I have two databases data1(Express 2005) and data2( Enterprise 2005). Data1 is a subset of Data2. Now beginning from that state any changes to either database should be reflected on both of them.
Now what's my best solution to accomplish this considering one is the subset of other??
Thanks
View 3 Replies
View Related
Feb 5, 2007
What is the best solution to run a disconnected database on a tablet pc and then sync wirelessly to a SQl Server database?
Thanks
View 1 Replies
View Related
Aug 29, 2006
I set up log shipping,
after a while the log shipping pair in LogShip Monitor is out of sync.
what cause this & how to solve this problems.
thx
View 5 Replies
View Related
Dec 21, 2005
I have set up a database with log shipping to the backup server. I have actually set it up multiple times because it continues to get out of sync, and I do not know another way to get it back in sync (despite much effort to learn how). I have not found much documentation in BOL, nor in the on-line areas that I can find. I have not been able to discover why it keeps getting out of sync.
If there is anyone who may shed some light on this, I would be very greatful.
Particulars (both servers):
Windows ADV Server 2003
SQL 2000 (Enterprise Ed.)
Servers on a work group (not domain)
There is a separate database on the same servers that continues to have successful log shipping.
Thank you very much (in advance).
View 1 Replies
View Related
Aug 26, 2006
what is the work around for Out of Sync error?
What cause this problems ?
thx
View 1 Replies
View Related
Jan 14, 2007
I have (finally) successfully gotten through the maze and 'published' my database to a folder:
Physical path: I:SqlReplication
unc: WarrenassocSQLReplication
Since I'm running XP pro, I don't have the options of assigning specific read/write permissions to a folder.
However it appears the problem is with accessing the snapshot and the logon's there.
When I run the IIS Web Configure wizard I error out at the snapshot share permissions step (see report below)
Wizard Settings:
Click Finish to perform the following actions:
Modify a virtual directory immediately.
Copy the ISAPI dll 'sqlcesa30.dll" to 'I:SqlReplication" immediately.
Set NTFS permissions immediately.
The virtual directory 'SqlReplication' will be configured with the following options:
On server 'WARRENASSOC'.
Use 'SqlReplication' as the alias.
Use 'I:SqlReplication' as the physical path for the virtual directory.
Use 'Anonymous' as the authentication method(s).
Do not require secure channel.
Set user permissions to 'Execute'.
Clients can use 'http://WARRENASSOC/SqlReplication/sqlcesa30.dll' as the Internet URL.
'sqlcesa30.dll' will be copied from 'C:Program FilesMicrosoft SQL Server 2005 Mobile Editionserver' to 'I:SqlReplication'.
'WARRENASSOCEd Warren' will get the following NTFS permission:
'Read & Write' on physical path 'I:SqlReplication'.
'Read & Execute' on the ISAPI DLL 'I:SqlReplicationsqlcesa30.dll'.
'Read' on share physical path '\WarrenassocI$SqlReplication'.
'Read' on the share '\WarrenassocI$SqlReplication'.
- Modifying the virtual directory (Rolled back)
- Copying the ISAPI DLL (Rolled back)
- Setting the directory permissions (Rolled back)
- Setting the server agent permissions (Rolled back)
- Setting the snapshot directory permissions (Rolled back)
- Setting the snapshot share permissions (Error)
Messages
The operation completed successfully. (Exception from HRESULT: 0x80070000) (mscorlib)
- Modifying the Virtual Directory configuration file. (Stopped)
When I created the snapshot I used my personal logon (admin rights) at each step
I've tried all combinations of setting the permissions in the wizard from requiring a login and providing my personal login to no requirements and I get the same error.
I'm trying to set up to copy a database from my SQL Server 2005 --> SQl Server CE 31 RC1
to see it it meet my development needs.
I'm at a loss as to how to navigate the security maze!!
Thanks Edward Warren.
View 8 Replies
View Related
Jan 24, 2006
Hello everyone:
I wanted to ask a question about log shipping going out of sync. We have a remote server in the UK that is our production server, and we are trying to set up log shipping with another server in the US. Our Log shipping monitor goes "out-of-sync" after about 8-10 hours. We changed the US server to have the same time as the server in the UK, but there still seems to be an out of syn error after 8 hours.
We are using Windows server 2000 and SQL server 2000.
SQL server will restore logs then after a few hours it stops restoring and goes out of sync. Was just wondering if someone knew the possibilities of why.
Thank you.
View 2 Replies
View Related
May 6, 2008
Hi guys
Is there anyway to sync a sdf database on a device with a mdb database on a desktop
Thanks
View 1 Replies
View Related
Mar 3, 2008
I'm using SQL'05, VS'08 SQLCE 3.5 building VB.NET applications.
I'm using LocalDataCache to sync SQLCE and SQL'05
When I write a new record to SQLCE the corresoponding record in SQL'05 shows both LastEditDate and CreationDate values.
When I update the recored in SQLCE the LastEditDate gets updated, but CreationDate gets set to NULL.
Ideas?
David L.
View 8 Replies
View Related
