Does CA PPM Show as an "Untrusted Site" in Your Browser? Learn with Rego.

Document created by navzjoshi00 Champion on Apr 19, 2017Last modified by navzjoshi00 Champion on Apr 20, 2017
Version 2Show Document
  • View in full screen mode

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

 

 

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 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 Jenn Rinella, Ramesh Rathnam, Marlon McKenzie, David Matzdorfand the Rego Guides for this Q/A material. 
2 people found this helpful

Attachments

    Outcomes