Hi guys,

I'm having troubles with the smtp alerts from FEP. When I have a look at the SQL job FEP_GetNewData_FEPDW_XYZ I see that the job is always writing the following error:

Date  23.01.2012 15:02:04
Log  Job History (FEP_GetNewData_FEPDW_XYZ)

Step ID  4
Server  SQLABC
Job Name  FEP_GetNewData_FEPDW_XYZ
Step Name  ssisFEP_OlapProcessing_FEPDW_XYZ
Duration  00:00:02
Sql Severity  0
Sql Message ID  0
Operator Emailed  
Operator Net sent  
Operator Paged  
Retries Attempted  2

Message
Executed as user: SQLABC\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.1600.1 for 64-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  15:02:04  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  15:02:04  Finished: 15:02:05  Elapsed:  0.391 seconds.  The package execution failed.  NOTE: The step was retried the requested number of times (2) without succeeding.  The step failed.

Can someone please give me any hints.

Cheers

Sebastian

Hi Sebastian,

Thank you for your post.

Please check SQL Server Agent service account if set to Local System and  FEPDB/FEPDW DB owner permission.

If there are more inquiries on this issue, please feel free to let us know.

Regards,

Hi Rick,

I just checked and the SQL Server Agent is running under Local System and it does have DB owner permissions for both DBs.

Do you maybe have any other clues?

Cheers

Sebastian

This looks to be more of an issue specific to SQL as it is a SQL Agent job that happens to be related to FEP, but let me see if we can narrow down the failure.

If you look at the SQL Agent Error logs, are there any other failures you are seeing as the above information does not provide much detail?

I will look into this further to see if there is any other type of logging we can enable.

Thanks much,

Shain Wray [MSFT]

Dears,

I am also facing same issue.

Any resolution ?