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 |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2010-05-25 : 09:18:24
|
| one of my sqljob failed stating below error,the job contains stored procedure to be executed every nightxxx\sqladmin. ...her SET operation. [SQLSTATE 01003] (Message 8153) String or binary data would be truncated. [SQLSTATE 22001] (Error 8152) Table pppSavingsByMonthSummary has not been truncated [SQLSTATE 01000] (Error 0) usp_pppFillYearMonths populated [SQLSTATE 01000] (Error 0) usp_pppFillTopVendors populated [SQLSTATE 01000] (Error 0) usp_pppFillLowLevelDetail populated [SQLSTATE 01000] (Error 0) usp_pppFillLowLevelDetailCSF populated [SQLSTATE 01000] (Error 0) usp_pppFillLowLevelDetailTop10Vendors populated [SQLSTATE 01000] (Error 0) usp_pppFillLowLevelDetailTop10VendorsCSF populated [SQLSTATE 01000] (Error 0) usp_pppFillHighLevelDetail populated [SQLSTATE 01000] (Error 0) usp_pppFillHighLevelDetailMWBE populated [SQLSTATE 01000] (Error 0) usp_pppFillHighLevelDetailTop10Vendors populated [SQLSTATE 01000] (Error 0) usp_pppFillHighLevelDetailSourcingType populated [SQLSTATE 01000] (Error 0) usp_pppFillMWBESpendByMonthChart populated [SQLSTATE 01000] (E... The step failed. |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-05-25 : 09:34:35
|
| What is your question?IF you are wondering why your job failed I suggest this may be the cause:[SQLSTATE 01003] (Message 8153) String or binary data would be truncated.Maybe you are trying to insert information into one table from some source and the data is too wide?There's not much you can do except get the job step and start debugging it manually.Regards,Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
|
|
|
job failed