Dear Community Members,
When you login to CA PPM (Clarity 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
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 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:
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.
Anyone have a simple query to find the parent task of a task?
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 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
ORDER BY INVI.NAME, T.PRWBSSEQUENCE