System Error when Transaction Class in Cost Plan Detail classic filter is changed to Multi Select

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Internal Server error when the attribute Transaction Class is modified at the user level. 

ErrorERRORError 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.

 

STEPS TO REPRODUCE
1. Login and navigate to Projects in Classic UX
2. Open a project and create a Cost Plan having Transaction Class in the grouping attribute
3. In the Cost Plan Details page, click on the configure icon
4. List Filter Section Tab - Fields
5. Click on transaction Class properties and change Lookup Style from Single Select to Multi Select
6. Save and Return
7. Save this Filter as Test Filter
8. Navigate to Administration - Objects - Cost Plan Details - Views Tab
9. Click on Cost Plan Detail View (List Column) - Layout
10. Add any attribute from the available to Selected and Save and Return
11. Publish the view
12. Navigate to Project - Cost Plan Details page
13. Change ther filter from System Default to Test Filter (created in Step 7)

Expected: The results do show up without any error 
Actual: The below error pops up
ErrorERRORError 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.

Workaround: Change the Transaction Class to Multi select in the Cost Plan Detail - Filter - Fields but this will delete all Saved filters using this view.

Environment

16.2.1

Resolution

DE80115 - Fixed in 16.2.3

Additional Information

From the trace file, the below query is executed and the where condition highlighted is causing the problem

select
                tc.ID transaction_class_id,tc.DESCRIPTION transaction_class_id_caption,
                w.transdate txn_date,
                COALESCE( sum( wv.totalcost ), 0) total_cost,
                COALESCE( sum( wv.totalamount ), 0) total_revenue,
                COALESCE( sum( w.quantity ), 0) quantity
        from ppa_wip w   ,
             ppa_wip_values wv
              ,TRANSCLASS tc                                 
            where w.investment_id = ?
            and w.transno = wv.transno
            and w.status = 0
            and wv.currency_type = 'HOME'
            and w.transdate >= ?
            and w.transdate <  ?
              and w.TRANSCLASS = tc.TRANSCLASS   and  1 = 1   and tc.ID = 5000010,5000008,5000000,5000007,5000001,5000005,5000003,5000002
        group by   tc.ID,tc.DESCRIPTION,  w.transdate