ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Unable to submit timesheets

book

Article ID: 213416

calendar_today

Updated On:

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.

 

Cause

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

Environment

Release : 15.8.1

 

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.