Skip to main content
4-Participant
Feb 17, 2022 8:39 PM UTC
Question

Cannot search for OrgPrincipals using CAGE code as criteria on Participant Administrator

I am using Windchill PDMLink Release 12.0 and Datecode with CPS 12.0.1.3

When searching for Org Principals using CAGE code as criteria, search errors because it is returning to many results.
It does not matter what CAGE code value you put in, it always returns too many.

Here are the errors that I faced
Too many results returned

It looks to me like the QueryPrincipalsServerHelper.class is expecting to see organizationIdentifier in the paramString but what is there is actually ptcUniqueOrganizationIdentifier, so the sql query has incorrect where clause.

    10 replies

    18-Opal
    Feb 18, 2022 10:50 AM UTC

    Hello Steve Haberman,

     

    I'm Charles from PTC Tech Support in Europe, regarding this question can you provide the full error message you're seeing in the Windchill UI / MethodServer? Any further details regarding the use-case?

     

    I will be grateful if you can send me this information.

     

    KR,

    Charles.

    Translate
    4-Participant
    Feb 18, 2022 5:32 PM UTC

    StephenHaberman_0-1645205498431.png

    Translate
    4-Participant
    Feb 18, 2022 5:43 PM UTC

    Here is some output from method server log..  it is not from the same query as above but you can see that the 'ptcUniqueOrganizationIdentifier' value that is input in the GUI does not make it into the sql query where clause.

    2022-02-17 13:10:05,985 DEBUG [ajp-nio-127.0.0.1-8010-exec-3] wt.org.QueryPrincipalsServerHelper wcadmin - In getDatabasePrincipal : principalClass class wt.org.WTOrganization, criteria(((name='*steve*'))&((ptcUniqueOrganizationIdentifier='*123*'))), containers.size() : null

    2022-02-17 13:10:06,001 DEBUG [ajp-nio-127.0.0.1-8010-exec-3] wt.org.QueryPrincipalsServerHelper wcadmin - filter value: (&(name=*steve*)(ptcUniqueOrganizationIdentifier=*123*))

    2022-02-17 13:10:06,001 DEBUG [ajp-nio-127.0.0.1-8010-exec-3] wt.org.QueryPrincipalsServerHelper wcadmin - getDatabasePrincipal qs: SELECT A0.*

    FROM wt.org.WTOrganization A0

    WHERE (UPPER(A0.name) LIKE '%STEVE%') AND (A0.internal = 1) AND (A0.status = 'public') AND (A0.disabled = 0)

    joins=null

    Translate
    TomU
    23-Emerald IV
    Feb 18, 2022 7:16 PM UTC

    I don't use CAGE codes, but it sounds like it's hitting the 50 user limit in the participant search.  Maybe try increasing this setting in Windchill.  Make sure to restart the Windchill processes after making this change.


    xconfmanager -s com.ptc.netmarkets.userSearch.maxCount=500 -t codebase\wt.properties -p

     

    https://www.ptc.com/en/support/article/cs33609

    Translate
    4-Participant
    Feb 21, 2022 3:48 PM UTC

    Thank You for your reply!
    I should have explained the issue better..  The problem is not that it won't let me see the results.  The issue is that adding more detailed criteria does not reduce the size of the result set.  There is something causing the cage code criteria to not be included in the database query.

     

    Translate
    18-Opal
    Feb 22, 2022 12:00 PM UTC

    Sounds pretty much related to SPR 13575247:CS363191

    Translate
    18-Opal
    Feb 22, 2022 12:02 PM UTC

    ? SPR 13575247 ?

    Translate
    18-Opal
    Feb 22, 2022 3:45 PM UTC

    I also see in 12.0.2.2 that when searching for an Organization, the Organization ID criteria (CAGE code) is ignored. Whereas it is taken into account when searching for users.

     

    Unfortunately above SPR is not fixed, neither 12.0 nor 12.1.

     

    KR,

    Charles.

    Translate
    4-Participant
    Feb 22, 2022 3:54 PM UTC

    I have opened ptc case:   C16266449

    Thank you for your research!

    Translate