windows ce - SQL Server 2008 data loss with CE replication -

-

I am using SQL Server 2008 CE replication, and some data loss (i.e. After complete sync)

I get the following entries in the Application log:

Replication-Replication Merge Subsystem: Agent 0033007 B-0043-0039-4400-440036003300 Failure Internal Error: A Synchronization Request A reading action by the device or IIS server returned an incorrect number of bytes while attempting to process. [,,,,,]

Replica-Replication Merge Subsystem: Agent 0045007 B-0038-0037-3200-430036004200 Failure Internal Error: either the computer running IIS is out of memory or a wrong session ID A request was sent in. [Session ID ,,,,,]

Replica-Replication Merge Subsystem: Agent 0033007 B-0043-0039-4400-440036003300 Failed table validation validation failed. Try to re-sync [,,,,,]

Replica-Replication Merge Subsystem: Agent 0043007 B-0036-0044-4400-320032003000 Failure Could not start merge process membership. Ensure that the membership registration is present on the publisher, and if necessary re-register the subscription.

Replication-Replication Merge Subsystem: The agent 0036007B-0037-0042-4500-370036003600 failed authentication on the computer running IIS. [,,,,,]

The messages indicate that IIS is running out of RAM. It is using approximately 22 MB, and the W3WP is using approximately 70 MB. SQL Server consumed most of the remaining 4GB RAM, there are plenty of disk space

Update

Add more RAM to help machine problem (I have missed memory exceptions) However, I still have problems.

It seems that it takes a lot of time for users' data to run before verification 'verification' work on the database (I'm talking> 20 minutes) that I contribute to this problem I can do

I was getting this exact error. The real problem was IIS pool timeout! Therefore, the slower and slower database, the process will become slower and slower as long as the device takes up to 20 minutes, due to which the pool session is time expired so that it is backend choke after the next request . Therefore, one option is to increase the timeout but !! The solution I used to use was to increase the process buffer beside the customer as mentioned here:

This is my post when I work through this

An interesting idea is that you can merge the PC once and then put that file on the device, of course it will not fit in your scenario.


Comments

Post a Comment

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

-
I'm new to this I'm writing a clr. stored procedure that can be used to get values ​​used in a calculation Call for another stored procedure for Gives an archived methodology int (I think SqlInt32? Value of the table's value is int) which is then necessary to convert to decimal. Here I have the code: Public static integral mood (SQL MDMMYLUE, escalistering AMY type, out of SQLDCM Result) {aResult = 0; Try {SqlConnection conn = New SqlConnection ("Reference Connection = True"); SqlCommand cmd = New SqlCommand ("sp_GetType", conn); Cmd.Parameters.AddWithValue ("@ myValueType", aMyValueType); Cmd.CommandType = CommandType.StoredProcedure; Conn.Open (); Object type = CMD. Exclamation Asser (); Conn.Close (); Decimal type FORCalculation = Convert. ToDecimal (type); Decimal value = convert toDecimal (aMyValue); // ** calculation calc = new calculation (); Decimal result = calorie.docalulation (typefarculation, value); I get an exception...
Read more

Calling GetGUIThreadInfo from Outlook VBA -

-
I need to find the active window'm writing a VBA macro in MS Outlook, which is a specific process. The goal of this is to get the active window / document name even if its original application has more than one document interface. User processor with GetCurrentThreadId is active, I am using GetGUIThreadInfo to get .dll. Here is the correct code: private type RECT as as Left LongPtr top LongPtr right LongPtr down LongPtr termination of private type GUITHREADINFO cbSize as LongPtr flags LongPtr hwndActive LongPtr hwndFocus LongPtr hwndCapture LongPtr as as as as as reset as LongPtr rcCaret as LongPtr hwndCreate as LongPtr hwndMoveSize as HwndMenuOwner end of Private Equity PtrSafe function GetWindowThreadProcessId Lib "user32" (_BVV hnw LongPtr as LongPtr Nig Mr. announced as PtrSafe function GetGUIThreadInfo Lib "user32" _ (ByVal dwthreadid as LongPtr, _ lpguithreadinfo as GUITHREADINFO) LongPtr Sub MyFunction () as dim strWindowTitle string = space as s...
Read more

Obfuscating Python code? -

-
I'm looking for a way to hide my Python source code. print "Hello World!" How can I encode this example so that it is not human-readable? I have been asked to use Base 64 but I'm not sure how. itemprop = "text"> It is limited only, first level ambiguous resolution, but has built-in: byte-code in Python Is a compiler for: dragon-o-m py_compile & lt; Your program.py & gt; creates a .pyo file with a byte-code, and where the docstrings are removed, etc. You can rename .pyo with the .py extension, and python & lt; Your program.py & gt; runs as your program, but it does not have your source code. PS : If your program blur modules like this, you need to rename them with the .pyc suffix (I Not sure it will not break a day), or you can work with .pyo and run them with python -o ... .pyo ( Import should work). This will allow dragon to search your modules (otherwise, Python looks for the .py module).
Read more