2770
Points
Questions
7
Answers
147
-
- 3349 views
- 4 answers
- 0 votes
-
FROM OTN:
Agile PLM does not support Microsoft Project (MSP) 2007 or 2010. Till Agile 9.0.x MSP 2000 was supported and from 9.2.x. onwards MSP 2003 is supported.
There is an enhancement request open to support MSP 2007 and MSP 2010. See Bug 9284171 for the status.- 1990 views
- 2 answers
- 0 votes
-
Did you configured the event as PRE event? In this case, you can block the execution of the update and return (in case of error) a new ActionResult(EXCEPTION, new Exception(message));
return new EventActionResult(request, new ActionResult(ActionResult.EXCEPTION, new RuntimeException("An Error Occurs"));
this should be displayed as error message to the user but only in case of Pre event with stop execution in case of error
- 2425 views
- 3 answers
- 0 votes
-
For the same class, you have multiple property in propertytable. The Property id 38 is the classname.
However, as mentioned by Kevin, it is not a good idea to use Agile DB to get some queries because it can be changed installing a new patch/version and it is not documented. You can use the SDKs quickly to get this info (slower but more reliable)- 3788 views
- 2 answers
- 0 votes
-
- 4622 views
- 3 answers
- 0 votes
-
Which Agile version are you using?
with 9.3.2 the following code returns IItem 123’456 properlysession.getObject(IItem.OBJECT_TYPE, "123'456")
However, try to get the objects using an IQuery
IQuery q = (IQuery) session.createObject(IQuery.OBJECT_TYPE, "Document"); q.setCriteria("[Number] == %1",new Object[]{"123''456"});
using the double apostrohpe will looking for number 123’456
- 1751 views
- 2 answers
- 0 votes
-
You can add a post Event on Approve and iterate the workflow history checking if there is any other Awaiting Approval.
ITwoWayIterator iterator = object.getTable(.getTableIterator(); while (iterator.hasNext()) { IRow row = (IRow) iterator.next(); String action = row.getCell(ProgramConstants.ATT_WORKFLOW_ACTION).getValue().toString(); String statusCode = row.getCell(ProgramConstants.ATT_WORKFLOW_STATUS_CODE).getValue().toString(); if(action.equalsIgnoreCase("Awaiting Approval") && statusCode.contains("Current Process") ){ //Awaiting Approver found. So Not all approvers approved } }
Mind that if there is the autopromotion on current status, the event can be triggered in parallel with Change Status
This answer accepted by robertom. on April 20, 2024 Earned 15 points.
- 2645 views
- 2 answers
- 0 votes
-
Event should be the one related to the concern affected object tab.
For instance, the Update Table event set for BOM table could be used for any BOM redlining triggerThis answer accepted by karthik. on April 20, 2024 Earned 15 points.
- 2689 views
- 2 answers
- 0 votes
-
As reported in OTN it can depend by several issues. The one that helped us is related to bug
https://support.oracle.com/MMOS/faces/ui/km/kmBugDisplay.jspx?parent=DOCUMENT&sourceId=1324660.1&kmBugId=12592293In particular run query below
INSERT INTO OBJECTACL
SELECT TEAM.activity_id,(SELECT CLASS FROM ACTIVITY WHERE
id=TEAM.activity_id),
TEAM.user_id,’,9506,’,sysdate,sysdate FROM TEAM
WHERE TEAM.user_id NOT IN (SELECT USERID FROM OBJECTACL WHERE
OBJECTACL.objid=TEAM.activity_id AND OBJECTACL.objclass IN (18022,18387))
and team.activity_id>0;For us was necessary to restart agile service
- 2011 views
- 1 answers
- 0 votes
-
- 2368 views
- 1 answers
- 0 votes