Datamart Extraction fails - SQL error code 8114

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

• The Datamart Extraction job has two parameters in it:
  • Extract Only OBS
  • Extract Only Calendars
• When the job is executed with 'Extract Only OBS', it fails with the following error message: 
  • SQL error code: 8114
Error message: Error converting data type nvarchar to numeric.
Executed:
 {call nbi_datamart_light_sp(?,?)} 

Cause

The depth column in prj_obs_units table holds values less than 1, such as -2.

Resolution

This column should not hold such negative values.