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 John1) 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:
Class | Status | ErrorCode |
replisapi.dll classes | SUCCESS | 0x0 |
CLSID_SQLReplErrors | SUCCESS | 0x0 |
replrec.dll classes | SUCCESS | 0x0 |
msxml6.dll classes | SUCCESS | 0x0 |
ReplIsapi Statistics:
Counter | Value |
Active worker threads. | 8 |
Active Requests. | 1 |
Total Query Requests | 1 |
Total File Download Requests | 0 |
Total Sync Requests | 373 |
Total Requests Handled | 1120 |
Max queue wait time (ms) | 0 |
Average time in Queue (ms) | 0 |
Max sync duration (ms) | 148078 |
Average Sync Duration (ms) | 6615 |
ReplIsapi Settings:
Property | Value |
SNAC version (sqlncli.dll) | 2005.90.1399.0 |
Logging Enabled | FALSE |
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