06-25-03, 09:31 #1Registered User
- Join Date
- Nov 2001
- Finland, Kirkkonummi
Unanswered: SQLServer replication fails with vague error 'text column data incomplete'
We have a problem with out product enviroment replication.
Both servers are SQLServer 2000s.
Replication is transactional replication.
Source and target schemas should be identical (initial snapshot recreates tables).
There are NTEXT-columns in tables.
This has worked like an angel so far but now it started to break apart.
After updating ntext column (3 rows out of more than 15 000) with updatetext we got error complaining about offset.
I reinitialized replication and got error
Text column data incomplete. ODBC error S1000.
Eventually we tried even recreating those three rows (to get a new pointers to lob data) and deleting old ones but that did not help either.
And finally our distribution agent hangs up and starts to consume memory. So far it has consumed 2 gigs. Time to kill it again..
So something is clearly damaged but logs are not giving me any clues (no error messages there). Snapshot is created without any problems but it's distribution does not work.
So far searching the Net for any information has not revealed anything useful, actually I got only one true hit..
06-25-03, 11:21 #2Registered User
- Join Date
- Jan 2003
- Nottinghamshire, UK
Just thought I'd mention that in SQL7 U had to use the WITH LOG Option when using UPDATETEXT to update Published tables.
checkout Replication -Data Needs and Characteristics - in SQL Server Books Online for 2k
Last edited by GWilliy; 06-25-03 at 11:24."Everything should be made as simple as possible, but not simpler." - Albert Einstein
"Everything should be made as complex as possible, so I look Cleverer." - Application Developer