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:
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.
