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:
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
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.
For a full list of Clarity Services, visit regoconsulting.com.