Unable to submit timesheets

Products

• Clarity PPM On Premise

Issue/Introduction

we are observing an Error:  Contact System Administrator when users are trying to submit their clarity timesheets (v15.8.1). 

Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.

 

Environment

Release : 15.8.1

 

Cause

Database Mail is not running, it will need to be started.

Resolution

It is recommended to consult with a DBA to address this issue, but a command like this will start the sysmail again:

       USE msdb ;       
       EXEC msdb.dbo.sysmail_start_sp;

 

If the processes continues to stop, further review from a DBA may be required to determine why.