Hello, you would still need LDAP for following purposes

1. To sync in new users/renames of existing

2. When you do approvals

3. Login to Java client for administrative actions

Hope that helps

Hello

You have 2 options

1. Disable All Warnings OR

2. Specific warning

For example, to supporess this specific warning, you can use

session.disableWarning(ExceptionConstants.APDM_COPYFILESTOREV_WARNING);

Hope this helps

– Raj

Hello

Please check item_history table. This table holds all history for “non-routable” objects. So, User would also be here

Join agileuser.id to item_history.item and class = 11605. That should give you the details you see in UI History tab

Thanks

Raj

Hello

Have you tried cascade list? That would give  what you are looking for in a single list

– Raj

Hello

Yes, Agie does provide a set of web services to access data

Here is the link for the documentation

https://docs.oracle.com/cd/E91823_62/otn/pdf/integration/agabd.pdf

If you use Java, they also support SDK

Hope this helps

– Raj

Hello

Agile modules uses JMS heavily for various asynchronous operations

Some of them include

– Notifications. All notifications that need to be sent to users are queued up and one of the modules process them

– Synching across nodes in the cluster

– For example, if you do an admin change in one node, it publishes the changes to the queue and other nodes will pick it up and update

– Updates to objects

– ACS transactions

Hope this helps

– Raj

Hello

If one-time or adhoc, use Agile import

If automation, one way is to use Apache POI to read the Excel, get the data and use SDK to do the updates

– Raj

Hello

Please check SDK Developer Guide – Developing PLM Extensions

Example 5–10 Using IEventDirtyTable – it gives a good example of how to use UpdateTable and set dirty cells in BOM tab

You can follow similar approach for Affected items tab as well

– Raj

Hello

Try this query

select c.”ID”,c.”CLASS”,c.”SUBCLASS”,c.”CHANGE_NUMBER”,c.”CATEGORY”, c.”STATUS”,c.”REASON_CODE”,c.”ORIGINATOR”,c.”OWNER”,
c.”CREATE_DATE”,c.”RELEASE_DATE”,c.”DESCRIPTION”,c.”REASON”,c.”MODIFYDATE”,c.”OBJVERSION”,c.”DELETE_FLAG”,c.”SUBMIT_DATE”,c.”ROUTE_DATE”,c.”PRODUCT_LINES”,c.”FLAGS”,c.”WORKFLOW_ID”,c.”STATUSTYPE”,c.”FINALCOMPLETE_DATE”,c.”PROCESS_ID”,c.”IN_REVIEW”,s.signoff_status, s.user_assigned, s.user_name_assigned, ch.timestamp, 0, null, null, trunc(sysdate – route_date)
from agile.signoff s join change c on c.process_id=s.process_id join agile.change_history ch on ch.id=s.history_id left outer join agile.agileuser a on s.user_assigned = a.id
left outer join agile.agileuser cm on c.owner = cm.id
where c.statustype = 2 and s.signoff_status = 0

– Raj

Hello

Is this a clustered environment? if so, please login into individual node and check if you can see the search in any of them. I am thinking it is an out of sync between nodes. If you are able to see it, please restart the cluster

– Raj