Sounds like that particular machine may have the wrong version of Sysem.EnterpriseServices.Wrapper.dll. Are you distributing it or relying on it being present in the GAC?

IAC check whether the machine has the same .NET framework version installed as that being targeted by the project....


>Hi,
>
>I have the following code compiled into en executable and running successfully at multiple sites. At one site in particular the exe just crashes without any error displaying, just a notice from Windows that the exe has crashed. The Event Log shows this:
>
>Faulting application ProvisionClient.exe, version 1.0.0.0, time stamp 0x53408368, faulting module System.EnterpriseServices.Wrapper.dll, version 4.0.30319.18408, time stamp 0x5231093c, exception code 0xc0000005, fault offset 0x00015d65, process id 0x%9, application start time 0x%10.
>
>This is my code, any ideas what I can do to work out what is going wrong?
>
>

using System;
>using System.Collections.Generic;
>using System.Linq;
>using System.Text;
>
>using System.Data;
>using System.Data.SqlClient;
>
>using Microsoft.Synchronization;
>using Microsoft.Synchronization.Data;
>using Microsoft.Synchronization.Data.SqlServer;
>
>using System.Configuration;
>using System.IO;
>
>namespace ProvisionServer
>{
>    class Program
>    {
>        static void Main(string[] args)
>        {
>            try
>            {
>                Console.WriteLine("Getting connection string");
>                string serverConnection = ConfigurationManager.ConnectionStrings["Server"].ConnectionString;
>
>                // connect to server database
>                Console.WriteLine("connect to server database");
>                SqlConnection serverConn = new SqlConnection(serverConnection);
>
>                // define a new scope named CompleteScope
>                DbSyncScopeDescription scopeDesc = new DbSyncScopeDescription("CompleteScope");
>
>                // add the description of all the tables from the database
>                //DbSyncTableDescription tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Accounts", serverConn);
>
>                // add the table description to the sync scope definition
>                //scopeDesc.Tables.Add(tableDesc);
>
>                //tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("AccountTypes", serverConn);
>                //scopeDesc.Tables.Add(tableDesc);
>
>                DbSyncTableDescription tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("AppConfig", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("ApptTypes", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Attendance", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("AttendanceDetails", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Branches", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("CLLabOrder", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("CLTrials", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("CreditNotes", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Discounts", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Drawings", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                //tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("ErrorLog", serverConn);
>                //scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("ExamDiagnoses", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("ExamLensType", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Exams", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Holidays", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("ItemCategories", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Items", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("LabOrderLensType", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("LabOrders", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Letters", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                //tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("LoginHistory", serverConn);
>                //scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Lookups", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("LookupTypes", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("MemoAE", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("MsgSvc", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                //tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Navigator", serverConn);
>                //scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("PatientAddresses", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("PatientEmails", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("PatientPhones", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("PatientRecallPlans", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Patients", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Payments", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("PaymentsDetails", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("RecallDetails", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("RecallNotices", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("RecallPlans", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Recalls", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("RefundDetails", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Refunds", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("ReportCatalog", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Sales", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("SalesDetails", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Schedule", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("SecuredItems", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("SecurityAccess", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("StockReceipts", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Transfers", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("UserAccExceptions", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("UserGroups", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                //tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("UserPrefs", serverConn);
>                //scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Users", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("UsrGrpXRef", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Vacation", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("VAT", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Vendors", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("VFPCommands", serverConn);
>                scopeDesc.Tables.Add(tableDesc);
>
>                // create a server scope provisioning object based on the ProductScope
>                SqlSyncScopeProvisioning serverProvision = new SqlSyncScopeProvisioning(serverConn, scopeDesc);
>
>                // skipping the creation of table since table already exists on server
>                serverProvision.SetCreateTableDefault(DbSyncCreationOption.Skip);
>
>                // start the provisioning process
>                serverProvision.Apply();
>            }
>            catch (Exception error)
>            {
>                using (StreamWriter tw = new StreamWriter("BPOSync.log", true))
>                {
>                    // write a line of text to the file
>                    tw.WriteLine(DateTime.Now);
>                    tw.WriteLine("Error");
>                    tw.WriteLine(error.ToString());
>                    //tw.WriteLine(error.InnerException); 
>                    tw.WriteLine("---");
>
>                    // close the stream
>                    tw.Close();
>                }
>            }
>        }
>    }
>}