Very Computer

Hi,

I have a publisher with multiple publications and all of the publications
are working fine.  Then I set up a new publication base on the previous ones
and now it's giving me this "Invalid column name.." error.  I've tried
reproduct this on the Northwind database and created several publications.
They all worked fine, until I created a new one with the following extended
filter:

SELECT <published_columns> FROM [dbo].[Employees] INNER JOIN
[dbo].[Orders] ON [Employees].[EmployeeID] = 2 AND
datediff(d,[Orders].[OrderDate],[Employees].[HireDate]) >1

When I go and run the snapshot agent, it gave me the error:

Invalid column name 'EmployeeID'.
(Source: <server name> (Data source); Error number: 207)

Obviously, EmployeeID exists.  Why would this error occur?  Also, now all
other publications on the same database is giving me this same error when I
try to generate their snapshot.  Is this a * BUG?

Thanks.
Nick

I ran into a problem that sounds similar, but it was with
conflict resolvers in Merge.

I found that if the table was created with the column
called EmployeeID, but I typed into the conflict resolver
EmployeeId (or any other variation of upper and lower case
letters), I would get an error that the column didn't
exist when a conflict occurred- and none of our servers
are case sensitive.  

Check if the column name is typed into your query exactly
as it is created in the table.

Quote:>-----Original Message-----
>Hi,

>I have a publisher with multiple publications and all of
the publications
>are working fine.  Then I set up a new publication base

on the previous ones

Quote:>and now it's giving me this "Invalid column name.."
error.  I've tried
>reproduct this on the Northwind database and created

several publications.

Quote:>They all worked fine, until I created a new one with the
following extended
>filter:

>SELECT <published_columns> FROM [dbo].[Employees] INNER
JOIN
>[dbo].[Orders] ON [Employees].[EmployeeID] = 2 AND
>datediff(d,[Orders].[OrderDate],[Employees].[HireDate]) >1

>When I go and run the snapshot agent, it gave me the
error:

>Invalid column name 'EmployeeID'.
>(Source: <server name> (Data source); Error number: 207)

>Obviously, EmployeeID exists.  Why would this error

occur?  Also, now all

Quote:>other publications on the same database is giving me this
same error when I
>try to generate their snapshot.  Is this a * BUG?

>Thanks.
>Nick

>.

Thanks for replying,

Even though that may be the original cause of the problem, now that I've
deleted the original publication that's causing this problem, I still can't
generate any Snapshots from any other publication.  Originally, all my
publications work without problems.  It's only after adding this new
publication when the problem appears.  Now, even if I delete this
publication, I can't generate the snapshot for any other publication.

It looks like something is retained somewhere and deleting the publication
that originally caused the problem doesn't clear it out.  I can reproduce
this quite easily on the Northwind database.  So it does look like some sort
of bug?  Any thoughts?

Thanks.
Nick

Quote:> I ran into a problem that sounds similar, but it was with
> conflict resolvers in Merge.

> I found that if the table was created with the column
> called EmployeeID, but I typed into the conflict resolver
> EmployeeId (or any other variation of upper and lower case
> letters), I would get an error that the column didn't
> exist when a conflict occurred- and none of our servers
> are case sensitive.

> Check if the column name is typed into your query exactly
> as it is created in the table.

> >-----Original Message-----
> >Hi,

> >I have a publisher with multiple publications and all of
> the publications
> >are working fine.  Then I set up a new publication base
> on the previous ones
> >and now it's giving me this "Invalid column name.."
> error.  I've tried
> >reproduct this on the Northwind database and created
> several publications.
> >They all worked fine, until I created a new one with the
> following extended
> >filter:

> >SELECT <published_columns> FROM [dbo].[Employees] INNER
> JOIN
> >[dbo].[Orders] ON [Employees].[EmployeeID] = 2 AND
> >datediff(d,[Orders].[OrderDate],[Employees].[HireDate]) >1

> >When I go and run the snapshot agent, it gave me the
> error:

> >Invalid column name 'EmployeeID'.
> >(Source: <server name> (Data source); Error number: 207)

> >Obviously, EmployeeID exists.  Why would this error
> occur?  Also, now all
> >other publications on the same database is giving me this
> same error when I
> >try to generate their snapshot.  Is this a * BUG?

> >Thanks.
> >Nick

> >.