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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2012-06-12 : 15:21:05
|
| One of the ETL sql job is failing is failing with below error.Job name : RealTimeETL_8_IdentifyReportingDBSyncIssuesPlease advise.Error:Executed as user: LDRTEST\sqlservice301. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:00:20 AM Error: 2012-08-28 11:07:57.57 Code: 0xC002F304 Source: Send Mail Task Send Mail Task Description: An error occurred with the following error message: "Insufficient system storage. The server response was: 4.3.1 Insufficient system storage". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:00:20 AM Finished: 11:07:57 AM Elapsed: 456.718 seconds. The package execution failed. NOTE: The step was retried the requested number of times (50) without succeeding. The step failed. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-12 : 20:23:38
|
| i think issue is with exchange server storage settings. please contact exchange admin for more detailsAre you trying to send mail to too many recipients by the way?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-06-13 : 12:17:10
|
| In Exchange you can set limitations to the size of attachments being sent in an email and the email attachment you might be sending could be over the size limit setting in Exchange. It could also be that you are firing off multiple emails consecutively and you firewall such as barracuda flags this as some sort of trojan and virus. This has actually happened to me.Also it could be that you are sending an email with the From that has an email address that is outside your domain, which is a good safety net for some sort of trojan that tries to send an email out of your network.<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
ETL SQL agent job failed