After Installing Earned Value Management addin (EVMS) on vanilla 15.1 with SQL DB, the Baseline Revision Filter view gets broken.

Document ID:  TEC1711693
Last Modified Date:  06/08/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA PPM

Releases

  • CA PPM:Release:14.1
  • CA PPM:Release:14.2
  • CA PPM:Release:14.3
  • CA PPM:Release:14.4
  • CA PPM:Release:15.1
  • CA PPM:Release:14.1 On Demand
  • CA PPM:Release:14.2 On Demand
  • CA PPM:Release:14.3 On Demand

Components

  • CA PPM SAAS INSTALLATION AND UPGRADE INTERNAL ONLY:ODENV
  • CLARITY PPM INTEGRATIONS & INSTALLATIONS:PPMENV
Problem:


Installing Earned Value Management addin (EVMS) on vanilla 15.1 with SQL DB causes issues with View "Baseline Revision Filter::baselineRevisionList" : It will insert 3 records in odf_views table with object_code = 'evbaseline' and data_service = 'baseline'.


Steps to Reproduce:


1.    Take a vanilla 15.1 environment with SQL DB
2.    Go to Admin side - Objects.
Open baseline object.
Go to Views Tab.
For view "Baseline Revision Filter" check the Layout.
Attributes Name, Code are in Selected (Left Column)
Add attributes Current Revision, Start, Finish.
Click on Save.
3.    Go to Admin side - Views.
Filter by Object Name=baseline and category=Filter
There is 1 view with code "Baseline Revision Filter::baselineRevisionList"
Views of baseline object are OK.
4.    Install Earned Value Management addin (EVMS)
5.    Review Admin Log. It shows:

12/15/16 9:54 AM (admin) Content Pack Installation Complete
12/15/16 9:55 AM (admin) CA Clarity Earned Value Manager installation was successful and is complete.
12/15/16 9:55 AM (admin) Check the admin.log for errors that might not have been handled.


6.    Go again to Admin side - Objects.
Open baseline object.
Go to Views Tab.
For view "Baseline Revision Filter" check the Layout.

View: Baseline Revision Filter. It shows duplicates attributes in the Selected (Left Column):
Name
Code
Current Revision
Start
Finish
Name
Code
Current Revision
Start
Finish

7.    Go to Admin side - Views.
Filter by Object Name=baseline and category=Filter
There are now 2 views with code "Baseline Revision Filter::baselineRevisionList"

8.    Connected to the DB and run query:

select * from odf_views where data_service = 'baseline' and object_code = 'evbaseline'

Query Output:
3 rows with view type Filter and Codes:
baselineRevisionList
baselineRevisionList_default
baselineRevisionList_master


Expected Result: 
In odf_views table records for object_code = 'evbaseline' should have data_service 'evbaseline'.

Actual Result: 
In odf_views table there are 3 records for object_code = 'evbaseline' and data_service = 'baseline'.

Cause:

Caused by DE32902

Resolution:

Open. Defect is target for resolution in future release.

Additional Information:

However, the log also shows errors:

12/15/16 9:50 AM (admin) ERROR 15-12 09:50:55,395 - Failure while evaluating "integer(data/object/@code)" in expression "{integer(data/object/@code)}"
12/15/16 9:50 AM (admin) java.lang.Exception: Invalid expression integer(data/object/@code): Error parsing number evbaseline
12/15/16 9:50 AM (admin) Caused by: java.lang.NumberFormatException: Error parsing number evbaseline
12/15/16 9:51 AM (admin) ERROR 15-12 09:51:15,784 - Failure while evaluating "integer(data/object/@code)" in expression "{integer(data/object/@code)}"
12/15/16 9:51 AM (admin) java.lang.Exception: Invalid expression integer(data/object/@code): Error parsing number evcwbselement
12/15/16 9:51 AM (admin) Caused by: java.lang.NumberFormatException: Error parsing number evcwbselement
12/15/16 9:51 AM (admin) ERROR 15-12 09:51:33,287 - Failure while evaluating "integer(data/object/@code)" in expression "{integer(data/object/@code)}"
12/15/16 9:51 AM (admin) java.lang.Exception: Invalid expression integer(data/object/@code): Error parsing number evslpp
12/15/16 9:51 AM (admin) Caused by: java.lang.NumberFormatException: Error parsing number evslpp
12/15/16 9:51 AM (admin) ERROR 15-12 09:51:45,455 - Failure while evaluating "integer(data/object/@code)" in expression "{integer(data/object/@code)}"
12/15/16 9:51 AM (admin) java.lang.Exception: Invalid expression integer(data/object/@code): Error parsing number evcontrolaccount
12/15/16 9:51 AM (admin) Caused by: java.lang.NumberFormatException: Error parsing number evcontrolaccount
12/15/16 9:52 AM (admin) ERROR 15-12 09:52:04,191 - Failure while evaluating "integer(data/object/@code)" in expression "{integer(data/object/@code)}"
12/15/16 9:52 AM (admin) java.lang.Exception: Invalid expression integer(data/object/@code): Error parsing number evcontract
12/15/16 9:52 AM (admin) Caused by: java.lang.NumberFormatException: Error parsing number evcontract
12/15/16 9:52 AM (admin) ERROR 15-12 09:52:23,051 - Failure while evaluating "integer(data/object/@code)" in expression "{integer(data/object/@code)}"
12/15/16 9:52 AM (admin) java.lang.Exception: Invalid expression integer(data/object/@code): Error parsing number evagency
12/15/16 9:52 AM (admin) Caused by: java.lang.NumberFormatException: Error parsing number evagency
12/15/16 9:53 AM (admin) ERROR 15-12 09:53:24,047 - Failure while evaluating "integer(data/object/@code)" in expression "{integer(data/object/@code)}"
12/15/16 9:53 AM (admin) java.lang.Exception: Invalid expression integer(data/object/@code): Error parsing number evworkpackage
12/15/16 9:53 AM (admin) Caused by: java.lang.NumberFormatException: Error parsing number evworkpackage

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >