Clarity

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

Apr 19, 2017 03:34 AM

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. 

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.