Hi Forum,

I remember giving answer to this question and total of 4 answers to this query.  The same can be seen in mails and user profile answers tab but details are missing.  Also option to to upload image is disabled.

Can we retrieve the answers ??

Regards,

Arif

Surya,

Can you verify the criteria as well. Like the correct workflow and status is specified in Criteria conditions. Also in Read validate the fields.

Regards,

Arif

Hi KE,

The OOTB reports can’t be called using Web-Apps. Over the period of last few years i have seen similar demands from PLM user base.

As Karthik said, the way to go about that is formatting sql query for the reports like Where-Used and BOM-Explosions etc. for single or multiple input. On how to format these reports you can follow the following threads

https://myagileplm.com/question/query-to-fetch-bom-upto-nth-level/

https://myagileplm.com/question/sql-query-to-get-where-used-upto-nth-level/

Also, i would suggest you to write a stored procedure to utilize these report outputs as per your needs.

Regards,

Arif

Hi Surya,

The best way to go about it is writing a simple Groovy Script. Configure it on Change-Status event and in subscriber mention Error Handling Rule –> Stop. 

Sample Script
——————
import com.agile.agileDSL.ScriptObj.IBaseScriptObj
import com.agile.agileDSL.ScriptObj.AgileDSLException;
import com.agile.api.*;

void invokeScript(IBaseScriptObj obj) {

try {

def session = obj.getAgileSDKSession()
IWFChangeStatusEventInfo eventInfo = obj.getPXEventInfo()
dataObject = eventInfo.getDataObject()
IChange m_change = (IChange)dataObject

ITable affectedItem = m_change.getTable(ChangeConstants.TABLE_AFFECTEDITEMS)

if (affectedItem.size()<=0) {
throw new AgileDSLException(“Please add Affected Item(s) prior to submitting this Change”);
}

}

catch(AgileDSLException ex) {
throw new AgileDSLException(ex.getMessage());
}
}

Regards,
Arif

Hi Srinivasa,

Yup A-verify should able to resolve it. I remember encountering similar issue for Advanced search in 9.3.5 and i worked with Oracle to get included in RUP-2. So if A-Verify doesn’t fix it, Oracle SR to get it included in RUP is the way to go. 

Regards,
Arif

Hi Gomez,

Just adding to what Kevin said, you can use the below query to load a Change with affected Items and expand it if you need to add additional details. 

/* ***** Change Affected Item Query *********/
SELECT DISTINCT
change.change_number,
item.item_number,
item.description AS “Description”,
rev.old_revnumber AS “Old_Rev”,
rev.rev_number AS “New_Rev”,
oldlifecycle.description AS “Old_Lifecycle”,
newlifecycle.description AS “New_Lifecycle_Phase”,
NEW_TIME (rev.obsolete_date, ‘gmt’, ‘PDT’) AS “Obsolete_Date”,
NEW_TIME (rev.effective_date, ‘gmt’, ‘PDT’) AS “Effective_Date”
FROM agile.rev rev,
agile.item item,
agile.change change,
agile.nodetable oldlifecycle,
agile.nodetable newlifecycle
WHERE rev.item = item.id
AND rev.change = change.id
AND rev.old_release_type = oldlifecycle.id(+)
AND rev.release_type = newlifecycle.id(+)
AND change.change_number = ‘ENTERYOURCHANGENUMBERHERE’
ORDER BY item.item_number

Regards,
Arif

Yes, agree with you faced multiple issues after applying RUP-7. 

Just to summarize for all : 

1. It updates your applications.ear and AgileAPI ,jar file. So all the Web-Apps/Utilities where you have explicitly used the Jar, you need to update those. 
2. Generally some of the timeout setting changes that we do in different xml files or component JARs inside application.ear file needs to be re-set. 
3. Double check your file manager configuration and core config files.

All of sudden faced same exception today while executing the Web-App which was in use for last year or so.

In order to resolve this, restarted the Apache tomcat services and killed the stale ids and things came back to normal.

Hi Nagma,

The sample code for your situation will be like :

—————————————————
public EventActionResult doAction(IAgileSession m_session, INode m_node, IeventInfo m_context) {
try{
        ActionResult result= new ActionResult(ActionResult.String, “Hello World!!!”);   //This is where you build your string
       return new EventActionResult(m_context, result);  //This is what throws the message.
}
catch (Throwable error) {
    ActionResult error= new ActionResult(ActionResult.Exception, error);
    return new EventActionResult(m_context , error);
}

—————————————————

I advise you to go through Developing extensions guide for detailed information.

Regards,
Arif