A JOB error..SQL SERVER MANAGMENT STUDIO 2012

Ramon Quintana

8y1.7k

Hi Comunity,

I have a JOB with only one step scheduled to run each Saturday Monthly, but the JOB HISTORY show me the error listed below:

Executed as user: NT SERVICE\SQLSERVERAGENT. String or binary data would be truncated. [SQLSTATE 22001] (Error 8152) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.

Nevertheless the INSERT INTO in the Stored Procedure was execute successfully..

I guess it is a kind of Warning but not an error as such.

OOOHH PLEASE GOD HELP MEEE!!!

thanks a lots

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suraj Kumar8y ago
Accepted answer
Hello Ramon,
You may be correct but as per my experience and worked with sql server I have also faced this issue several times due to insufficient length of column.

I want to say that if your stored procedure or sql server run hundred times and the value is going to insert is either equal or less than the length of the column then error will not come.
This error will only come when the length exceeds but you have to check only why length exceeded and what you have to do? In that you can not say it has already run hundred times and everything is correct and you do not need to do anything.

When you will search across the google it will suggest you to increase the length of the column.

Regard
Suraj

Ramon Quintana8y ago

Hi Suraj,

I think i have to use this before and after the insert sentence:

SET ANSI_WARNINGS  OFF

INSERT INTO t VALUES('My name is victor and i am a good guy','d')

SET ANSI_WARNINGS  ON

Concerning to if my SP procedure inserts in two tables is not, only inserts in one table and have enought length on his columns.

I will try to put the sets mentioned to avoid the Warning in the LOG

thanks a lot.

Suraj Kumar8y ago
Hello Ramon,
It is the very clear message that the procedure or query in your job step is trying to insert some value in the table but the length of the column is less than the value going to insert in that table column. So, the job gets error and failed to execute.

Suppose, you have to insert 'India' in the country name table but the length of the country_name column is varchar(4) so it will not insert and will give the error also.

Please try to find the table and column which need to increase length of the column then this error will not come and the job will execute successfully.

I think you are going to perform insert operation in two or more tables. So, the job has inserted values correctly where the length was as expected but in some table it has not inserted because the length of the column was not sufficient as the value.

Please increase the length by modifying the table in which this error is coming.

Regard
Suraj