Friday, March 9, 2012

Error with web synchronization

Hello,

We have SQL2k5 SP1 as our database server. We have another box running IIS for web synchronization. We are seeing a lot of errors on the client side stating that they are unable to connect to the distributor. When we look at the event log on the IIS box we find application errors with the replisapi.dll. Below is a dump from the event log of the IIS box. Both boxes are 2003 with the currect patches and each have 4 GB RAM. Any help would be appreciated.

John

Event Type:Error

Event Source:Application Error

Event Category:(100)

Event ID:1000

Date:9/12/2006

Time:8:12:48 PM

User:N/A

Computer: SERVER-IIS5

Description:

Faulting application w3wp.exe, version 6.0.3790.1830, faulting module replisapi.dll, version 2005.90.1399.0, fault address 0x0002bd67.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Data:

0000: 41 70 70 6c 69 63 61 74Applicat

0008: 69 6f 6e 20 46 61 69 6cion Fail

0010: 75 72 65 20 20 77 33 77urew3w

0018: 70 2e 65 78 65 20 36 2ep.exe 6.

0020: 30 2e 33 37 39 30 2e 310.3790.1

0028: 38 33 30 20 69 6e 20 72830 in r

0030: 65 70 6c 69 73 61 70 69eplisapi

0038: 2e 64 6c 6c 20 32 30 30.dll 200

0040: 35 2e 39 30 2e 31 33 395.90.139

0048: 39 2e 30 20 61 74 20 6f9.0 at o

0050: 66 66 73 65 74 20 30 30ffset 00

0058: 30 32 62 64 36 3702bd67

Hi John

1) What results do you get running the diagnostics mode?

"https://{secuseServerAddress}/{virtualFolder}/replisapi.dll?diag"

2) How did you set up Web Synchronization on the IIS box i.e. Through "Configure Web Synchronization Wizard" or by manually creating folders, copying and registering replisapi.dll etc..? (Incorrectly registered dll and web extensions not being installed will also cause issues)

3) Was IIS already installed prior to installing the SQL Server 2005 Components onto this box? (SQL Server setup may not have been able to set up the extensions correctly)

4) Is the Database Server box running the same version of SQL Server 2005 i.e. Service Packs included. (I have experienced problems with this in the past)

Just a few pointers from my experience so far. I'm not too knowledgable about IIS and it's more detailed inner workings there may be others better placed to suggest action?

Rab|||

Rab,

1.

SQL Websync diagnostic information

Client Information:

AUTH_USER:domain\user
AUTH_TYPE:Basic
HTTPS:on
LOGON_USER:domain\user
REMOTE_ADDR:24.30.144.122
REMOTE_HOST:24.30.144.122
REMOTE_USER:domain\user
REQUEST_METHOD:GET
SERVER_NAME:replicate.url.com
SERVER_PORT:443
SERVER_PROTOCOL:HTTP/1.1
SERVER_SOFTWARE:Microsoft-IIS/6.0
URL:/replia/replisapi.dll

Class Initialization test:

ClassStatusErrorCode
replisapi.dll classesSUCCESS0x0
CLSID_SQLReplErrorsSUCCESS0x0
replrec.dll classesSUCCESS0x0
msxml6.dll classesSUCCESS0x0

ReplIsapi Statistics:

CounterValue
Active worker threads.8
Active Requests.1
Total Query Requests1
Total File Download Requests0
Total Sync Requests373
Total Requests Handled1120
Max queue wait time (ms)0
Average time in Queue (ms)0
Max sync duration (ms)148078
Average Sync Duration (ms)6615

ReplIsapi Settings:

PropertyValue
SNAC version (sqlncli.dll)2005.90.1399.0
Logging EnabledFALSE

2) How did you set up Web Synchronization on the IIS box i.e. Through "Configure Web Synchronization Wizard" or by manually creating folders, copying and registering replisapi.dll etc..? (Incorrectly registered dll and web extensions not being installed will also cause issues)

We created the files manually as SQL isn't really installed on this box other than what the documents told us to do
3) Was IIS already installed prior to installing the SQL Server 2005 Components onto this box? (SQL Server setup may not have been able to set up the extensions correctly)

IIS was already installed on the box
4) Is the Database Server box running the same version of SQL Server 2005 i.e. Service Packs included. (I have experienced problems with this in the past)

When we upgraded the server to SP1 we took the new replisapi.dll and replaced the old one on the IIS box.

|||

Firstly you should be using the install process to install the tools only installation on the IIS box.

Next, you should not be just copying the replisapi.dll and replacing it on the IIS box. The IIS SQL components should be upgraded to SP1 too.

If you are already doing this and still hitting the error, I would recommend contacting CSS and opening a case with them.

No comments:

Post a Comment