Tasks Workspace SQL generates no data due to joins

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

No Rows to Show on Task Workspace due to faulty joins in the SQL query

STEPS TO REPRODUCE:

1. Go to Tasks workspace with admin user
2. Filter on Active = Yes, Template =No
3. Note the view returns all tasks
4. Now add any Project field to the view such as % Complete

Expected Results: To see same amount of rows

Actual Results: No Rows to Show

Environment

Release : 16.1.1

Cause

This is caused by ANSI_JOINS disabled in the system

Disabling the ANSI join feature was a temporary workaround for DE65166

Resolution

1. Check if the feature is disabled by running: 
   
   select name, enabled from cmn_features where code = 'S207096_ANSI_JOIN'
   
   If it's disabled, proceed with step 2
   
   
2. Run the below command in the database 
   admin toggle-feature S207096_ANSI_JOIN 1
3. Restart all services