Arif's Profile
Agile Angel
2067
points

Questions
19

Answers
131

PLM Enthusiast since 2011. Like Developing extensions,utilities,scripts and provide Configuration and Support on PC,PPM, PG&C, PQM,PCM on 9.3.5,9.3.3 and 9.3.2. Experienced in dev,config and design on PLM4P(6.0.0.3 till 6.1.1.x)
Title Agile PLM Technical Consultant
Company Company Not Entered
Agile Version 9.3.5, 9.3.3 , 6.X.X.X.
  • Agile Angel Asked 2 days ago in Product Collaboration.

    Hi Gurmeet,

    To find the users who have not logged in since last two months you can use the following query :

    Scenario-1
    ==========
    Select a.loginid,a.email,a.first_name,a.last_name from
    agileuser a
    where a.loginid not in (Select distinct(u.username) from user_usage_history u where login_time > sysdate – 60)
    and a.enabled=1  order by a.loginid

    //Just to breakdown-query for your convenience. Query has two parts.
    //1. This query gives the details of all the user who has logged in in last two months. i.e. If your current date is 4/20/2018, it should tell you all who have logged in since 2/20/2018 

    Select distinct(u.username) from user_usage_history u where login_time > sysdate – 60 

    //2. Query below gives you the details of all the user who are active. 

    select * from agileusers where a.enabled=1 

    Scenario-2
    ============
    Finding users have not logged in during particular duration — Here i am finding who logged in between 20th Feb till 20th April 

    Select a.loginid,a.email,a.first_name,a.last_name from agileuser a
    where a.loginid not in (Select distinct(u.username) from user_usage_history u where login_time between to_date(‘2/20/2018′,’mm/dd/yyyy’) and to_date(‘4/20/2018′,’mm/dd/yyyy’))
    and a.enabled=1
    order by a.loginid

    Please let me know in case of any queries. 

    Regards,
    Arif

    • 49 views
    • 3 answers
    • 0 votes
  • Agile Angel Asked 6 days ago in Product Collaboration.

    Hi Rahul,

    What kind of report/data you want to generate can you share the details. You can primarily use advanced search and save it as report/search to get the data.

    Regards,
    Arif

    • 42 views
    • 1 answers
    • 0 votes
  • Agile Angel Asked on April 13, 2018 in Other APIs.

    Hi Matt,

    As per my understanding and Oracle documentations, Currently there is no way to manipulate User-Monitor using SDK and  they pretty much advise doing it manual way like  opening user monitor and terminating the particular user.

    From SQL side User_Session tables maps accurately with data shown in monitor but never tried/read if deleting a row from this table will terminate user session.

    Also any kind of data-purge w.r.t this table is advised only after shutting down the app server so not sure if it will be useful to delete either.

    Do let us know if you get a way out.

    Regards,
    Arif

    • 59 views
    • 1 answers
    • 0 votes
  • Did you verify if your file manager servers are up and running. Try to re-start the file-manager servers and see.  Also if this issue is reproducible across the browser.

    • 51 views
    • 4 answers
    • 0 votes
  • Agile Angel Asked on April 12, 2018 in Product Collaboration.

    Hi Gantayya,

    Preferred is writing simple standalone code as batch job and executing over the weekends when server load is minimal.

    From SQL perspective i will take case of one particular part and try to outline the process:

    1. List-Values are stored as integers in database so you need to know what is the code corresponding to your list-entry. Below query gives what is the corresponding entryid for your list-attribute values.

    Select distinct(p2.list03),li.entryid, li.entryvalue from page_two p2, listentry li  where p2.list03=li.entryid(+)

    Output
    ========
    LIST03    ENTRYID    ENTRYVALUE
    219275    219275    No
    219274    219274    Yes

    2. Let’s consider we have a part XXX-XXXXXX where currently it is updated as Blank or No. So in order to update a given part number with say “Yes

    update page_two p2
    set p2.list03=219274
    where p2.id= (Select i.id from item i , page_two p2,listentry li where i.id=p2.id(+) and p2.list03=li.entryid and i.item_number=’XXX-XXXXXX’ and li.langid(+)=0)

    3. Once you execute it, commit the operation. Logout/Login or refresh the object to see the updated value.

    4. Also catch here is it doesn’t show in the history tab if the value is updated .  So generally not a good practice since it doesn’t have tracking on attribute changes.

    This i have tried and tested in lower environments and it works. So based on the above 1-3 approach you can do for all the data at once if it is one particular value or if you have list of what item should be updated to which list-value.

    Hope it helps.

    Regards,
    Arif

    • 118 views
    • 6 answers
    • 0 votes
  • Agile Angel Asked on April 12, 2018 in Product Collaboration.

    Hi Rahul,

    There are certain things you gotta do to start with. I recommend going through  SDK Developer Guide – Using APIs. Locate Agile PLM-9 documentation and download the zip as per version you are working on. In that zip you will have the guide.  Link : http://www.oracle.com/technetwork/documentation/agile-085940.html

    You can access the sample-codes/documentation available on the below url  : http://www.oracle.com/technetwork/indexes/samplecode/agileplm-sample-520945.html
    Based on your version you can download the code and have a look.

    Coming to Eclipse, there are little bit of customization you need to do based on the kind of solution you are developing.

    1. For standalone code to access Agile-API, create simple Java project from Create new wizard.  You need to add “AgileAPI.jar” in your build path to access agile api. You can find this file typically on your server at /Agile-Home/Agile/Agile9.X.X./Integration/sdk/lib or in the sample code.

    2. For Action Based PX/Event Base PX, you need to follow certain additional configurations. You will get these details in the developer guide SDK Developer Guide – Developing PLM Extensions

    3. For developing web-apps., create a web-project in eclipse add agile jars and get started.

    Regards,
    Arif

    This answer accepted by Rahul. on April 12, 2018 Earned 15 points.

    • 31 views
    • 1 answers
    • 0 votes
  • Agile Angel Asked on April 12, 2018 in Product Collaboration.

    Hi Gantayya,

    What is the type of attribute that you want to update. If it’s a list/multi-list it is little complicated from back-end but for other types it should be easy. Also is it page_two/three attribute.

    Again from sdk for any type of attributes it is straight forward. Lastly i executed for 2.5 lakhs rows and it took around 17 hrs to complete. 

    Can you share more details.

    • 118 views
    • 6 answers
    • 0 votes
  • Hi,

    I don’t think it is advised to do so. Item can have multiple dependencies and so does MPNs. If you must delete then try using sdk codes. First try to programmatically remove the dependencies, make the object orphan and then soft-delete it.

    Regards,
    Arif

    • 30 views
    • 2 answers
    • 0 votes
  • Agile Angel Asked on April 10, 2018 in Product Collaboration.

    Hi Rahul,

    Can you share more details about this. To start with, the screenshot. There can be many issues w.r.t java-version or settings.

    Which Agile version you are using currently and what’s the JRE version you have. It’s advised to have jdk1.8 and above for 9.3.5 and jdk1.7 above for 9.3.3

    Generally Java-client keeps loading when you haven’t added security settings. You can check the following like :

    1. Launch Java control panel.
    2. Go to Security tab.
    3. Click on Edit site-list and add your url upto the port number,

    Regards,

    • 26 views
    • 1 answers
    • 0 votes
  • Agile Angel Asked on April 9, 2018 in Product Collaboration.

    That’s perfectly alright. It shouldn’t matter how many destinations with same URL you have configured. Irrespective of success status, As long as there is only one subscriber with one of the successful destination is enabled it works fine.

    • 67 views
    • 5 answers
    • 0 votes