Replication failed

Hi,
We are using transactional replication and it failed and
showing following error
Error:
The process could not bulk copy into table 'TableName'.
Error Number:
22001
Category:ODBC
Source: ODBC
Full Message:
String data, right truncation
Is any one having solution for this?
Regards,
Manoj
Manoj,
can you check if the schemas are identical on publisher and subscriber if
you are doing a nosync initialization.
If you are sending over the table schema, can you ensure that you take the
collation.
Regards,
Paul Ibison

replication error - agent is suspect

Hi,
I have set up a replication and it was doing the bulk copy from SrvA to
SrvB when it says "The agent is suspect as there's no response for the last
10 mins" or something like that ?
what could be the problem here ?
however, after i refresh it , it keeps running though but i am unsure if the
data has been successfully replicated over as the processing's running
appreciate any advise
tks & rdgs
Hi,
See the previous posts:-
http://groups.google.co.in/group/mic...36c788aeacadb7
Thanks
Hari
SQL Server MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:13D1D8DF-E095-4F6C-9CAB-06D63015A95D@.microsoft.com...
> Hi,
> I have set up a replication and it was doing the bulk copy from SrvA to
> SrvB when it says "The agent is suspect as there's no response for the
> last
> 10 mins" or something like that ?
> what could be the problem here ?
> however, after i refresh it , it keeps running though but i am unsure if
> the
> data has been successfully replicated over as the processing's running
> appreciate any advise
> tks & rdgs
|||Hi ,
I have managed to resolve this issue by increasing the default 10 mins of
agent inactivity
tks & rdgs
"maxzsim" wrote:

> Hi,
> I have set up a replication and it was doing the bulk copy from SrvA to
> SrvB when it says "The agent is suspect as there's no response for the last
> 10 mins" or something like that ?
> what could be the problem here ?
> however, after i refresh it , it keeps running though but i am unsure if the
> data has been successfully replicated over as the processing's running
> appreciate any advise
> tks & rdgs

replication error - agent is suspect

Hi,
I have set up a replication and it was doing the bulk copy from SrvA to
SrvB when it says "The agent is suspect as there's no response for the last
10 mins" or something like that ?
what could be the problem here ?
however, after i refresh it , it keeps running though but i am unsure if the
data has been successfully replicated over as the processing's running
appreciate any advise
tks & rdgsHi,
See the previous posts:-
http://groups.google.co.in/group/mi...936c788aeacadb7
Thanks
Hari
SQL Server MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:13D1D8DF-E095-4F6C-9CAB-06D63015A95D@.microsoft.com...
> Hi,
> I have set up a replication and it was doing the bulk copy from SrvA to
> SrvB when it says "The agent is suspect as there's no response for the
> last
> 10 mins" or something like that ?
> what could be the problem here ?
> however, after i refresh it , it keeps running though but i am unsure if
> the
> data has been successfully replicated over as the processing's running
> appreciate any advise
> tks & rdgs|||Hi ,
I have managed to resolve this issue by increasing the default 10 mins of
agent inactivity
tks & rdgs
"maxzsim" wrote:

> Hi,
> I have set up a replication and it was doing the bulk copy from SrvA to
> SrvB when it says "The agent is suspect as there's no response for the las
t
> 10 mins" or something like that ?
> what could be the problem here ?
> however, after i refresh it , it keeps running though but i am unsure if t
he
> data has been successfully replicated over as the processing's running
> appreciate any advise
> tks & rdgs

replication error - agent is suspect

Hi,
I have set up a replication and it was doing the bulk copy from SrvA to
SrvB when it says "The agent is suspect as there's no response for the last
10 mins" or something like that ?
what could be the problem here ?
however, after i refresh it , it keeps running though but i am unsure if the
data has been successfully replicated over as the processing's running
appreciate any advise
tks & rdgsHi,
See the previous posts:-
http://groups.google.co.in/group/microsoft.public.sqlserver.replication/browse_thread/thread/45cba0e7e1543879/7936c788aeacadb7?q=replication+agent+is+suspect&rnum=2&hl=en#7936c788aeacadb7
Thanks
Hari
SQL Server MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:13D1D8DF-E095-4F6C-9CAB-06D63015A95D@.microsoft.com...
> Hi,
> I have set up a replication and it was doing the bulk copy from SrvA to
> SrvB when it says "The agent is suspect as there's no response for the
> last
> 10 mins" or something like that ?
> what could be the problem here ?
> however, after i refresh it , it keeps running though but i am unsure if
> the
> data has been successfully replicated over as the processing's running
> appreciate any advise
> tks & rdgs|||Hi ,
I have managed to resolve this issue by increasing the default 10 mins of
agent inactivity
tks & rdgs
"maxzsim" wrote:
> Hi,
> I have set up a replication and it was doing the bulk copy from SrvA to
> SrvB when it says "The agent is suspect as there's no response for the last
> 10 mins" or something like that ?
> what could be the problem here ?
> however, after i refresh it , it keeps running though but i am unsure if the
> data has been successfully replicated over as the processing's running
> appreciate any advise
> tks & rdgs

REplication and BLOB tables

Anyone ever see this error:
The process could not bulk copy into table '"JobApplBlob200501"'.
Expected the text length in data stream for bulk copy of text, ntext, or
image data.
(Source: ELMER (Data source); Error number: 4813)
Elmer is the Subscribing system.
The only odd thing I can see is the publisher and subscriber are build 922.
The distribution host server is build 818. I have other BLOB fields going
from the same publisher to the same subscriber through the same distributor.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
Is this transactional replication ? Is this error during initial snapshot or
during intial load on the subscribers. I have included the replication group
'cos you have some experts in there like Hilary and Paul who can help
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:e20gvdqAFHA.2584@.TK2MSFTNGP09.phx.gbl...
> Anyone ever see this error:
>
> The process could not bulk copy into table '"JobApplBlob200501"'.
> Expected the text length in data stream for bulk copy of text, ntext, or
> image data.
> (Source: ELMER (Data source); Error number: 4813)
>
> Elmer is the Subscribing system.
> The only odd thing I can see is the publisher and subscriber are build
922.
> The distribution host server is build 818. I have other BLOB fields going
> from the same publisher to the same subscriber through the same
distributor.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
>

REplication and BLOB tables

Anyone ever see this error:
The process could not bulk copy into table '"JobApplBlob200501"'.
Expected the text length in data stream for bulk copy of text, ntext, or
image data.
(Source: ELMER (Data source); Error number: 4813)
Elmer is the Subscribing system.
The only odd thing I can see is the publisher and subscriber are build 922.
The distribution host server is build 818. I have other BLOB fields going
from the same publisher to the same subscriber through the same distributor.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.orgIs this transactional replication ? Is this error during initial snapshot or
during intial load on the subscribers. I have included the replication group
'cos you have some experts in there like Hilary and Paul who can help
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:e20gvdqAFHA.2584@.TK2MSFTNGP09.phx.gbl...
> Anyone ever see this error:
>
> The process could not bulk copy into table '"JobApplBlob200501"'.
> Expected the text length in data stream for bulk copy of text, ntext, or
> image data.
> (Source: ELMER (Data source); Error number: 4813)
>
> Elmer is the Subscribing system.
> The only odd thing I can see is the publisher and subscriber are build
922.
> The distribution host server is build 818. I have other BLOB fields going
> from the same publisher to the same subscriber through the same
distributor.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
>

REplication and BLOB tables

Anyone ever see this error:
The process could not bulk copy into table '"JobApplBlob200501"'.
Expected the text length in data stream for bulk copy of text, ntext, or
image data.
(Source: ELMER (Data source); Error number: 4813)
Elmer is the Subscribing system.
The only odd thing I can see is the publisher and subscriber are build 922.
The distribution host server is build 818. I have other BLOB fields going
from the same publisher to the same subscriber through the same distributor.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.orgIs this transactional replication ? Is this error during initial snapshot or
during intial load on the subscribers. I have included the replication group
'cos you have some experts in there like Hilary and Paul who can help
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:e20gvdqAFHA.2584@.TK2MSFTNGP09.phx.gbl...
> Anyone ever see this error:
>
> The process could not bulk copy into table '"JobApplBlob200501"'.
> Expected the text length in data stream for bulk copy of text, ntext, or
> image data.
> (Source: ELMER (Data source); Error number: 4813)
>
> Elmer is the Subscribing system.
> The only odd thing I can see is the publisher and subscriber are build
922.
> The distribution host server is build 818. I have other BLOB fields going
> from the same publisher to the same subscriber through the same
distributor.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
>