Clarity PPM | Does Clarity PPM Show as an "Untrusted Site" in Your Browser?

When you login to Clarity PPM (CA PPM), do you see that pesky untrusted site warning? Learn why in today's Q&A.

We'll also delve into an MSP XML Parsing Trick and provide a couple queries you can use if you're looking for a Parent Task. Please feel free to comment on any alternative answers you've found. At Rego, we always love your input.  

Learn with Rego | Q&A

1. "Untrusted Site" Warnings Logging into Clarity

2. TIP: MSP XML Parsing Trick

3. Query to Find Parent Task

 

1. Why do I get an "untrusted site" warning when I try to login to Clarity? 

 If you're using an updated Chrome or Firefox browser and SSL in Clarity, you've probably seen untrusted site warnings like this:

site warning clarity.png

Until late last year, SSL certificates were based on the SHA-1 algorithm. That algorithm has been replaced by SHA-2, which has stronger encryption and fewer vulnerabilities. Chrome and Firefox are leading the pack in declaring war on SHA-1 Certificates. Some of our clients have started the process of upgrading their SSL certificates.

For more details, see the following links:

https://konklone.com/post/why-google-is-hurrying-the-web-to-kill-sha-1

https://www.entrust.com/lp/sha-1-sha-2-faq/

 

2. If any of you need to debug MSP XML files, I found a trick by accident after trying to parse a 2000000 + row file by hand, looking for tasks with problems in their names. (This was a plan with 15000+ tasks. . . .)

OWB was designed to open the MSP XML file format, even before the XML version of the driver was created. And OWB was kind enough to tell me exactly what I needed to search for in Notepad++, so we could figure out what character was causing the error. Very helpful. In my case, it was the copyright symbol.

 

3. Anyone have a simple query to find the parent task of a task?

Try this if you're just going one level up, to the direct parent:

 SELECT p.prid task_id, p.prname task_name, q.prid parent_task_id, q.prname parent_task_name, I.code Investment_Id

FROM prtask p

LEFT JOIN prtask q ON p.prprojectid = q.prprojectid AND p.wbs_parseq = q.prwbssequence

LEFT JOIN inv_investments I on I.id = p.prprojectid

--WHERE p.prwbslevel <> 1


Or this . . .

 SELECT INVI.ID

, INVI.CODE

, INVI.NAME

, T.PRID

, T.PRNAME

, T.PRWBSSEQUENCE

, T.WBS_PARSEQ

, (SELECT PT.PRNAME FROM PRTASK PT WHERE PT.PRPROJECTID = T.PRPROJECTID AND PT.PRWBSSEQUENCE = T.WBS_PARSEQ AND PT.PRWBSSEQUENCE < T.PRWBSSEQUENCE AND PT.WBS_NNBSEQ >= T.WBS_NNBSEQ) PARENT_TASK

FROM INV_INVESTMENTS INVI

JOIN PRTASK T ON INVI.ID = T.PRPROJECTID

WHERE 1=1

ORDER BY INVI.NAME, T.PRWBSSEQUENCE


 

Thank You------------------------------ 

A special thank you to our Rego Guides: Jenn Rinella, Ramesh Rathnam, Marlon McKenzie, and Dave Matzdorf for this Q/A material. 

Let Rego Be Your Guide

Join us live and in-person at RegoUniversity in San Diego Sept 29-Oct 2 and learn from the expert guides who deliver Clarity PPM and Agile services to 60% of Fortune 20 companies. Act now to save $300 on Early Bird Pricing until July 1st.

Rego also offers free health assessments, webinars, and half-day training classes for Clarity PPM on Roadmaps in the Modern UX, Power BI, Portfolio Management, and Jaspersoft. 

For a full list of Clarity Services, visit regoconsulting.com

By Camille Pack|April 20, 2017

About the Author: Camille Pack

Camille Pack

Camille Pack has been in marketing for over a decade and started her career as a college composition instructor during graduate school. Technical writing lends itself well to mastery, and in her time at Rego, Camille offered clients product support, configured environments, and served as both a project manager for an internal reporting group and a business analyst for a large external client. Camille holds an MA in Literature and Writing, and a BS in Biology.

Rego Home
Contact Us

Subscribe to Email Updates

  

Recent Rego Articles

Sign up for our Weekly Newsletter