New records were not replicated on publisher and subscriber

I have seen this happen in 2 circumstances:
(1) Firstly when the filter was set to 1=2 and inserts
were made while the merge agent was running
(2) If you bulk insert the rows and choose the defaults,
then FIRE_TRIGGERS is false and consequently the rows are
not added to MSmerge_contents.
In either case, you need to run sp_addtabletocontents to
include the rows then resynchronise. Alternatively you
can use sp_mergedummyupdate for a single row.
rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Paul,
Thanks for the answer, I would give it a try.
Hope it will solve my problem.
Thanks again, and more power.
Roland
"Paul Ibison" wrote:

> I have seen this happen in 2 circumstances:
> (1) Firstly when the filter was set to 1=2 and inserts
> were made while the merge agent was running
> (2) If you bulk insert the rows and choose the defaults,
> then FIRE_TRIGGERS is false and consequently the rows are
> not added to MSmerge_contents.
> In either case, you need to run sp_addtabletocontents to
> include the rows then resynchronise. Alternatively you
> can use sp_mergedummyupdate for a single row.
> rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

New Job Sql Server Agent error *FIXED*

I am running SQL Server 2005 and recently installed Office Sharepoint Server 2007 on the same server. After the install I receive the following error message while trying to add a new SQL Server Agent Job.

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)

Also when I right click on a job to view properties a new job window pops up instead.

I realised that Office Sharepoint Server 2007 installs SQL Server Express and might me causing my issues. I uninstalled Sharepoint however I am still having the same problem.

Can anyone shed some light or have any suggestions?

Installing SP2 solved the problem.|||

I am having the same error when trying to create a job in SQLServer using SSIS package. The SSIS package does a very simple two steps ftp tasks: delete the existing file on the ftp server and copy the new one. Can somebody also share experience or idea on my case as well please.

Thanks

|||

I am have the same issue as Htin. I have run all Windows updates and I am running office 2007.

TITLE: Microsoft SQL Server Management Studio

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)

BUTTONS:

OK

|||This problem seems to have been resolved by running the SQL Server SP2.|||

Hi I got the same error but after I install SP 2 for SQL 2005

Any idea how to resolve this problem ?:-)

|||I have succeeded in getting a job deployed but I accessed the Management Studio whilst on the Server so it looks like it's the tools not the server itself where the problem lies.|||I have SQL SERVER 2005 (SP2). I'm having the same problem. I upgraded the server via command prompt (c:/>setup SKUUPGRADE = 1). Still I'm having the same problem. Can any one tell me how to resolve this problem.

New Job Sql Server Agent error

I am running SQL Server 2005 and recently installed Office Sharepoint Server 2007 on the same server. After the install I receive the following error message while trying to add a new SQL Server Agent Job.

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)

Also when I right click on a job to view properties a new job window pops up instead.

I realised that Office Sharepoint Server 2007 installs SQL Server Express and might me causing my issues. I uninstalled Sharepoint however I am still having the same problem.

Can anyone shed some light or have any suggestions?

Installing SP2 solved the problem.|||

I am having the same error when trying to create a job in SQLServer using SSIS package. The SSIS package does a very simple two steps ftp tasks: delete the existing file on the ftp server and copy the new one. Can somebody also share experience or idea on my case as well please.

Thanks

|||

I am have the same issue as Htin. I have run all Windows updates and I am running office 2007.

TITLE: Microsoft SQL Server Management Studio

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)

BUTTONS:

OK

|||This problem seems to have been resolved by running the SQL Server SP2.|||

Hi I got the same error but after I install SP 2 for SQL 2005

Any idea how to resolve this problem ?:-)

|||I have succeeded in getting a job deployed but I accessed the Management Studio whilst on the Server so it looks like it's the tools not the server itself where the problem lies.

New Job Sql Server Agent error

I am running SQL Server 2005 and recently installed Office Sharepoint Server 2007 on the same server. After the install I receive the following error message while trying to add a new SQL Server Agent Job.

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)

Also when I right click on a job to view properties a new job window pops up instead.

I realised that Office Sharepoint Server 2007 installs SQL Server Express and might me causing my issues. I uninstalled Sharepoint however I am still having the same problem.

Can anyone shed some light or have any suggestions?

Installing SP2 solved the problem.|||

I am having the same error when trying to create a job in SQLServer using SSIS package. The SSIS package does a very simple two steps ftp tasks: delete the existing file on the ftp server and copy the new one. Can somebody also share experience or idea on my case as well please.

Thanks

|||

I am have the same issue as Htin. I have run all Windows updates and I am running office 2007.

TITLE: Microsoft SQL Server Management Studio

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)

BUTTONS:

OK

|||This problem seems to have been resolved by running the SQL Server SP2.|||

Hi I got the same error but after I install SP 2 for SQL 2005

Any idea how to resolve this problem ?:-)

|||I have succeeded in getting a job deployed but I accessed the Management Studio whilst on the Server so it looks like it's the tools not the server itself where the problem lies.