sql server replication: I am stumped. Can anyone help?

I have a Publication database on a Win2KSP1/SQL2KSP1 which is having difficulties syncronizing with a subscription database on Win2K/SQL2K. It was working initially, but hasn't synchronized for the past month. In an effort to fix the problem. I deleted the subscription information and recreated it. I don't apply the snapshot because of the month's worth of data on the subscription. When I start the merge agent, I get the following error.

****************************************************************************************************
Cannot insert the value NULL into column 'objid', table 'its_greensboro.dbo.sysmergeschemaarticles'; column does not allow nulls. INSERT fails.
(Source: CTC-GB1 (Data source); Error number: 515)
---------------------------------------------------------------------------------------------------------------
The process could not deliver the snapshot to the Subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
---------------------------------------------------------------------------------------------------------------
****************************************************************************************************

To exclude any other variables, I try to do the same thing on a backup database that is on the publishing server. I get the exact same error.
If I try to create a brand new database, it works fine.
If I try to apply the snapshot on a backup database, it works fine, but the months worth of data is wiped out.
I have tried recreating the snapshot several times to no avail.
I have deleted all subscriptions, the publication, disabled publishing, enabled publishing, recreated the publication and snapshot, recreated the subscription. No Luck.


Any help would be awesome,

can you script out your publication and tables and post them here?

[quoted text, click to view]
difficulties syncronizing with a subscription database on Win2K/SQL2K. It
was working initially, but hasn't synchronized for the past month. In an
effort to fix the problem. I deleted the subscription information and
recreated it. I don't apply the snapshot because of the month's worth of
data on the subscription. When I start the merge agent, I get the following
error.
[quoted text, click to view]
****************************************************************************
************************
[quoted text, click to view]
'its_greensboro.dbo.sysmergeschemaarticles'; column does not allow nulls.
INSERT fails.
[quoted text, click to view]
****************************************************************************
************************
[quoted text, click to view]
enabled publishing, recreated the publication and snapshot, recreated the
subscription. No Luck.
[quoted text, click to view]

I also had such an error. My solution was to remove all articles except
table articles (sp's, UDF's, views) from publication. I already had all
those objects restored on subscriber, so there was no point to have them in
publication.

That helped :)

--
Best regards,
Kestas

[quoted text, click to view]
difficulties syncronizing with a subscription database on Win2K/SQL2K. It
was working initially, but hasn't synchronized for the past month. In an
effort to fix the problem. I deleted the subscription information and
recreated it. I don't apply the snapshot because of the month's worth of
data on the subscription. When I start the merge agent, I get the following
error.
[quoted text, click to view]
****************************************************************************
************************
[quoted text, click to view]
'its_greensboro.dbo.sysmergeschemaarticles'; column does not allow nulls.
INSERT fails.
[quoted text, click to view]
****************************************************************************
************************
[quoted text, click to view]
enabled publishing, recreated the publication and snapshot, recreated the
subscription. No Luck.
[quoted text, click to view]