August 5, 2009 at 2:06 am
Hi guys, my name is Ryan. I have a question about merge replication in SQL 2K5
I have built a merge replication across server. I built the publisher in the other server which is in the other office--faraway from mine that is. And the subscriber server is in my office. Once I have built the merge replication, when I start the merge rep it generates error when it starts to synchronizing. It says "The system cannot find the file specified. The step failed" ???
Can you guys help me, do you know what it means. I have seen errors when I built merge replication but not like this one, I already tried googling, but it turns out to be diddly squat. Can you guys help me please, I appreaciate any help you guys give. Thanks. 🙂
Regards,
Ryan
August 6, 2009 at 8:19 pm
Hi guys, just an update for my issue, I finally got the technical details of my error. I find it when I look to the Job activity monitor for my merge replication job. So the error is:
"The system cannot find the file specified. The step failed [SQLSTATE 42000][Error 14151]. The step failed". Hope this will help to solve my problem guys, I really need some answers, thanks.
Regards,
Ryan
August 7, 2009 at 2:25 am
Can you post the command that is being run for the step that failed, please?
If there are any directory paths in that step, verify that those paths exist, and that the agent has the necessary permissions to the path.
August 7, 2009 at 2:56 am
Hi Ian thanks for the reply. There are 3 steps for the job and the steps that failed is in step 2 and 3, here's the information :
Step 2 - Run Agent :
-Step Name:
Run Agent
-Type:
Replication Merge
-Run as:
SQL Agent Service Account
-Command:
"-Publisher [TNS-29ED7DBB0EB] -PublisherDB [TNS_DB MTH] -Publication [MERGE_TNS_DB_MTH] -Subscriber [SADISTSVR] -SubscriberDB [SNAPSHOT_MTH] -Distributor [TNS-29ED7DBB0EB] -DistributorSecurityMode 1 "
Error Message on Step 2:
Date8/6/2009 5:15:00 PM
LogJob History (TNS-29ED7DBB0EB-TNS_DB MTH-MERGE_TNS_DB_MTH-SADISTSVR-1)
Step ID2
ServerTNS-29ED7DBB0EB
Job NameTNS-29ED7DBB0EB-TNS_DB MTH-MERGE_TNS_DB_MTH-SADISTSVR-1
Step NameRun agent.
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
The system cannot find the file specified. The step failed.
=====================================================================
Step 3 - Detect nonlogged agent shutdown :
-Step name:
Detect nonlogged agent shutdown
-Type:
Transcript-SQL script (T-SQL)
-Database:
distribution
-Command:
"sp_MSdetect_nonlogged_shutdown @subsystem = 'Merge', @agent_id = 1"
Error Message on Step 3:
Date8/6/2009 5:15:00 PM
LogJob History (TNS-29ED7DBB0EB-TNS_DB MTH-MERGE_TNS_DB_MTH-SADISTSVR-1)
Step ID3
ServerTNS-29ED7DBB0EB
Job NameTNS-29ED7DBB0EB-TNS_DB MTH-MERGE_TNS_DB_MTH-SADISTSVR-1
Step NameDetect nonlogged agent shutdown.
Duration00:00:01
Sql Severity18
Sql Message ID14151
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: NT AUTHORITY\SYSTEM. Replication-agentclassname: agent TNS-29ED7DBB0EB-TNS_DB MTH-MERGE_TNS_DB_MTH-SADISTSVR-1 failed. The system cannot find the file specified. The step failed. [SQLSTATE 42000] (Error 14151). The step failed.
===========================================================
That's the more technical error on my issue, hope this help solving my problem folks. Thanks a lot.
Regards,
Ryan
August 7, 2009 at 3:21 am
What happens if you try to run the process from a command prompt?
Run C:\Program Files\Microsoft SQL Server\90\COM\replmerg.exe (assuming SQL Server is installed in the default folders) with the parameters you gave from the agent step i.e.
replmerg.exe -Publisher [TNS-29ED7DBB0EB] -PublisherDB [TNS_DB MTH] -Publication [MERGE_TNS_DB_MTH] -Subscriber [SADISTSVR] -SubscriberDB [SNAPSHOT_MTH] -Distributor [TNS-29ED7DBB0EB] -DistributorSecurityMode 1
August 9, 2009 at 8:41 pm
Ian Dude, problem solved man !!!!
Turns out to be the problem is the replmerg.exe file is missing, that's why the error is "The system cannot find the file specified" so I copy the file from my computer to the publisher server computer, whiew, finally. But thanks though for the replies, couldn't done without your help dude. Thanks a lot.
Regards,
Ryan
August 10, 2009 at 4:23 am
Glad you got it sorted... hope that was the only file that went missing.:ermm:
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply