mrmathison's Profile
Agile Talent
246
Points

Questions
27

Answers
36

    • 1395 views
    • 4 answers
    • 0 votes
  • Thanks Florina.  Is the CHANGE table you mention on the Agile server, in the AGILE schema?

    In the CHANGE table from Agile, I see 5 distinct TRANSFERRED values.  Here they are with counts:

    SELECT count(*) from CHANGE where TRANSFERRED IS NULL    —  count = 102,796
    SELECT count(*) from CHANGE where TRANSFERRED = ‘1’        —   count = 37
    SELECT count(*) from CHANGE where TRANSFERRED = ‘1 100000000000000000000000000000’    —  count = 5
    SELECT count(*) from CHANGE where TRANSFERRED = ‘10000000000000000000000000000000’   —  count = 3,263
    SELECT count(*) from CHANGE where TRANSFERRED = ‘10100000000000000000000000000000’   —  count = 501

    I tried using the ‘Set Transfer Flag’ from the ChangeCAST GUI.  The CHANGE.TRANSFERRED value was null, then I changed it to Yes from the GUI and it was still null.  Is there another CHANGE table local to ChangeCAST?

    • 1503 views
    • 5 answers
    • 0 votes
  • Thank you Danny.  What you wrote should be in the Oracle manual.

    • 1714 views
    • 3 answers
    • 0 votes
  • I opened a service request with Oracle Support and this is their reply:

    This is not the correct URL users should be using for whatever reason/issue to access Agile PLM, as per the application code:
    https://agileplm.<your-domain.com>/Agile/default/login-cms.jsp
    Users should always be using this URL anytime, resolving any issues if any in case:
    https://agileplm.<your-domain.com>/Agile/PLMServlet

    We also turned off a caching setting on our A10 network appliance which seemed to help.  Traffic flows through this secure A10 device then to the Agile server.
    Mark

    This answer accepted by mrmathison. on May 18, 2022 Earned 15 points.

    • 9649 views
    • 3 answers
    • 0 votes
  • Agile Talent Asked on January 15, 2016 in Agile PLM (v9).

    Thanks, I also found this on the Oracle Support site, Document 568607.1

    How to Convert a Database User to an LDAP User? (Doc ID 568607.1) 

    APPLIES TO:
    Oracle Agile PLM Framework – Version 9.2.1.0 and later
    Information in this document applies to any platform.

    GOAL
    How to convert a database user to an LDAP user?
    Users already exist prior implementing LDAP, now want to covert these users from using Agile Database authentication to LDAP authentication.

    SOLUTION

    IMPORTANT:
    This solution requires a database edit.
    Before any modification, please make sure you have a backup copy of production database.
    Check with DBA or call Agile Support if any questions and concerns.

    *** To convert ALL database users to LDAP users:

    1. Go to AgileAgileDomainbin

    2. Open a command window and run below command which will clear all agile users auth_src, guid values:
    migrateUsersToDB -R

    3. Run below command:
    migrateUsersToDB

    4. Restart Agile service.

    *** To convert specific users from database authentication to LDAP authentication:

    1. Connect to agile database in sqlplus

    2. Find the current authentication values for this user

    SELECT AUTH_SRC, GUID FROM AGILEUSER WHERE LOGINID='<User’s loginID>’;

    If user is database authenticated, AGILEUSER.AUTH_SRC will have value “AGILE_DB”.
    If user is LDAP authenticated, AGILEUSER.AUTH_SRC will have value value like LDAP_<ldap name configured in Java Client>

    3. Update this user

    UPDATE AGILEUSER SET AUTH_SRC=NULL WHERE LOGINID='<User’s loginID>’;
    UPDATE AGILEUSER SET GUID=NULL WHERE LOGINID='<User’s loginID>’;
    COMMIT;

    4. Update the LDAP time stamp in Agile

    UPDATE PROPERTYTABLE SET VALUE=’1970-01-01 00:00:00′ WHERE PROPERTYID=479 AND PARENTID=5004;
    COMMIT;

    5. Restart Agile service

    6. Run refreshing users from LDAP.

    Note: User attribute information controlled by LDAP will be updated with the information configured in LDAP
    Note: There is no Agile API to update GUID and AUTH_SRC as these are internal only attributes. These changes must be done using sql.

     

    • 4027 views
    • 3 answers
    • 0 votes
  • Agile Talent Asked on November 10, 2015 in IT and Networking.

    We tried bouncing the system, but that did not make it go away.  I submitted a help ticket with Oracle and this was their initial response:

    Please try the following :

    1. Change the users browser cache setting:

    Internet Explorer:

       Tools | Internet Options | General | Settings
       Check for newer versions of stored pages: Every visit to the page
      
    Firefox:

        Tools | Options | Privay tab
        Under the “History” header, remove the check from the box labeled “Remember visited pages for the last xx days.”

    2. Configure web caching appliance to not reuse existing sessions:

        Change the Internet Explorer settings to “Bypass proxy server for local addresses”

        Tools > Connections > LAN Settings > set Bypass Proxy Server for local addresses

    3. Check with your IT if any new network devices have been added.

    • 2213 views
    • 3 answers
    • 0 votes