Replication-Replication Distribution Subsystem: agent SERVERA-dbCreator-TranPub_dbCreator-SERVERB-6 failed. The process could not read file 'C:\Replication\unc\SERVERA_DBCREATOR_TRANPUB_DBCREATOR\20170830103552\Subjects_2.pre' due to OS error 3.
Error message: I got this error when i am trying to configure Transnational publication in replication. I have chosen pull subscription while i am configuring Transnational publication
Error messages:
The process could not read file 'C:\Replication\unc\SERVERA_DBCREATOR_TRANPUB_DBCREATOR\20170830103552\Subjects_2.pre' due to OS error 3. (Source: MSSQL_REPL, Error number: MSSQL_REPL20024)
Get help: http://help/MSSQL_REPL20024
The system cannot find the path specified.
(Source: MSSQL_REPL, Error number: MSSQL_REPL3)
Get help: http://help/MSSQL_REPL3
From Eventviewr:
Replication-Replication Distribution Subsystem:
agent SERVERA-dbCreator-TranPub_dbCreator-SERVERB-6 failed.
The process could not read file 'C:\Replication\unc\SERVERA_DBCREATOR_TRANPUB_DBCREATOR\20170830103552\Subjects_2.pre'
due to OS error 3.
Troubleshooting Step:
1) When i check the snapshot agent status it has run fine. No issues with it
2) When i check log reader agent status it has running fine. No issues with it
3) Then i found above error in " Launch replication monitor" side as well as Eventvwr side.
4) When i check distribution Agent job status because i have configured PULL subscription. Don' find any error message.
5) I checked the path from both publisher and subscriber server side file exists. and no issues with the path.
6) I checked the login account and service accounts with which agents are running. And both accounts have sysadmin privileges.
7) The issue here is distribution agent job which is running from subscriber end because of PULL subscription is failing not with error icon you can find the same in replication monitor view details
Work Around:
1) UNC folder is not in shared mode and not in the network. So that is the reason subscriber is not able to find it. So create this folder in shared mode and check the same from subscriber too like(\\SERVARA\UNC)
2) Go the publisher server--> Right click on Replication folder-->Go to Publishers--->Click on .....
window
3) Find Default snapshot folder and change the path to network and click on Ok button
Comments