February 9, 2010 at 2:19 am
one of our production server job failed i checked in the hystory of jobs
error :
String or binary data would be truncated. [SQLSTATE 22001] (Error 8152) The statement has been terminated. [SQLSTATE 01000] (Error 3621) Associated statement is not prepared [SQLSTATE HY007] (Error 0) String or binary data would be truncated. [SQLSTATE 22001] (Error 8152) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.
please reply
thanks in advance
February 9, 2010 at 2:24 am
Check your job what it is doing..mostly it must be inserting some data and data in some source column may be of more length than the column in table you are trying to insert the data...
February 9, 2010 at 3:01 am
Any another or alternate solutions please
February 9, 2010 at 4:08 am
Did you checked what your job is doing?...in most of the cases thats the reason which I posted earlier for such error.
February 10, 2010 at 2:39 pm
I agree with jshailendra. You (and we) are going to need to know more information about what is going on in the job when it is failing in order to troubleshoot more efficiently. Is it possible to have a trace running while the job is running to see what is going on?
Joie Andrew
"Since 1982"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply