Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-28 : 08:03:26
|
| Mchael writes "I am attempting to set up Transactional replication. I am running SQL 2000 SP2 (8.00.534) in a Windows 2000 SP2 (5.00.2195)environment. These specs are the same on both the source and the destination machines.The distributor is set up on the publisher machine, and the subscription machine uses the 'pull' method.When I initialize the subscription, and run the Snapshot agent it appears to be running fine. However, the process errors outWhen I look under the 'Distribution Agent Error Details' I see this:Error Message: Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber.Error Details : Invalid column name 'LastValuationAmt'.(Source: DRBRFS000-01 (Data source); Error number: 207)---------------------------------------------------------------------------------------------------------------Invalid column name 'LastValuationDate'.(Source: DRBRFS000-01 (Data source); Error number: 207)---------------------------------------------------------------------------------------------------------------Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber.(Source: AGENT (Agent); Error number: 00000)The .mdf file on the destination machine is 9024kb. On the source machine it is 471,040kbI have found no information on this particular error on Microsoft’s web site. The closest match is Q308732 http://support.microsoft.com/default.aspx?scid=kb;EN-US;q308732This suggests the problem was corrected in SP2, but sadly it is not.Please Help,Michael D. Whitkofski" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-28 : 15:15:18
|
| How did you apply the snapshot? was the table dropped and recreated on the subscriber, or did you tell it the subscriber already has the schema?Does those columns exist in the subscribing table?-Chad |
 |
|
|
whitkofski
Starting Member
2 Posts |
Posted - 2002-04-01 : 09:29:06
|
| Chad,I told the database that the subscriber did not have already have the schema.It was a brand new database on the destination machine.I did not create any additional columns on the subcribing tables because I assumed that SQL would copy the tables over exactly how they appeared in the source database. I am not filtering any data.Please let me know if you need any more information.Thank you,Michael |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-02 : 01:03:07
|
| But do those columns that it is complaining about exist on the subscriber? (ex. 'LastValuationAmt')-Chad |
|
|
|
whitkofski
Starting Member
2 Posts |
Posted - 2002-04-04 : 15:28:13
|
| Chad,Sorry it has taken so long for me to respond. There are 482 table in the source database, and I do not know which fields in which tables it is complaining about.I did notice however that the snapshot only created 467 tables on the destination database.Thank you,Michael |
|
|
|
|
|
|
|
|
Transactional Replication Error