Hello Again,

I am trying to update the Affected Items table (of an ECO) and I get statusCode=SUCCESS in the UpdateRowsResponseType.  I am trying to update the “Affected Items.Lifecycle Phase” field (and itemDescription) but when I look at the ECO in the Java client, the fields are not changed.   Next, I am trying to do a ChangeStatusRequestType on the ECO and I get an error as follows:

Agile Exceptions:Exception Id: -60086- Except ion Message: -The following required fields are missing: C53228: Affected Items.Lifecycle Phase: GGO2B-MPMT-00P0- Exception Cause: -null-

Clearly, I am doing something wrong (my fault), but I have tried to figure it out and so far failed.  Any advice, please?

My code:

public void updateTable(Integer tableId, String ecoNumber, String revision, Integer objectClass, String partNumber, Map<String,String> paramsMap) {

// See: https://docs.oracle.com/cd/E69230_12/otn/pdf/integration/html_agaap/output/chapter_4.htm

// See: https://docs.oracle.com/cd/E50306_29/otn/pdf/user/html_agaad/output/chapter_8.htm

String log = null;

LoadTableResponseType loadTableResponseType = getTables(ecoNumber, revision, objectClass.toString(), tableId.toString());

if (loadTableResponseType == null) {

throw new AgileException("Response is null while retrieving Table " + tableId.toString() + " " + ecoNumber + " " + revision);

} else {

log = ToStringBuilder.reflectionToString(loadTableResponseType, ToStringStyle.MULTI_LINE_STYLE);

System.out.println("loadTableResponseType: " + log);

checkStatus(loadTableResponseType.getStatusCode(), loadTableResponseType.getExceptions());

}
// Find the target row in the ECO Affected Items table

AgileRowType targetRow = null;

for (AgileTableType agileTable: loadTableResponseType.getTableContents()) {

List<AgileRowType> rows = agileTable.getRow();

for (AgileRowType row : rows) {

List<Element> any = row.getAny();

for (Element elt: any) {

if (partNumber.equals(elt.getTextContent())) {

targetRow = row;

break;

}

}

}

}

if (targetRow == null) {

String msg = "ERROR: part number missing from ECO AffectedItems";

System.out.println(msg);

throw new AgileException(msg);

}
// Build Request

UpdateRowsRequestType updateRowsRequestType = new UpdateRowsRequestType();

AgileUpdateRowsRequest agileUpdateRowsRequest = new AgileUpdateRowsRequest();

RequestTableType table = new RequestTableType();

table.setClassIdentifier( "ECO" );

table.setObjectNumber( ecoNumber );

table.setTableIdentifier( "AffectedItems" );

AgileUpdateRow updateRow = new AgileUpdateRow();

updateRow.setRowId(targetRow.getRowId());

paramsMap = new HashMap<String,String>();

paramsMap.put("itemDescription", "Maptile Bundle");

paramsMap.put("description", "Maptile Bundle");

paramsMap.put("lifecyclePhase", "Preliminary");

//paramsMap.put("itemLifecyclePhase", "Production");

//paramsMap.put("workflow", "Production");

List<Element> elements = buildMessageElements(paramsMap);

log = ToStringBuilder.reflectionToString(elements, ToStringStyle.MULTI_LINE_STYLE);

System.out.println("List<Elements>: " + log);

targetRow.getAny().addAll(elements);

updateRow.setRow(targetRow);

agileUpdateRowsRequest.setObjectInfo(table);

updateRowsRequestType.getData().add(agileUpdateRowsRequest);
createTableProxy();

UpdateRowsResponseType resp = agileStubTable.updateRows(updateRowsRequestType);

if (resp == null)

throw new AgileException("UpdateRowsResponseType is null");

else {

log = ToStringBuilder.reflectionToString(resp, ToStringStyle.MULTI_LINE_STYLE);

System.out.println("UpdateRowsResponseType: " + log);

}

}

And my logs:

2020-01-05 19:52:22,675 INFO [main] [Workflower] - Updating ECO Affected Items WorkflowParameters(partNumber=GGO2B-MPMT-00P0, ecoNumber=C53228, revision=A)

loadTableResponseType: com.agile.ws.schema.table.v1.jaxws.LoadTableResponseType@2f67a4d3[

tableContents=[com.agile.ws.schema.common.v1.jaxws.AgileTableType@49b2a47d]

outputParameters=<null>

messageId=<null>

messageName=<null>

statusCode=SUCCESS

sessionParameters=<null>

generalParameters=<null>

notes=<null>

exceptions=<null>

warnings=<null>

]

List<Elements>: java.util.LinkedList@147e2ae7[

]

UpdateRowsResponseType: com.agile.ws.schema.table.v1.jaxws.UpdateRowsResponseType@2235eaab[

messageId=<null>

messageName=<null>

statusCode=SUCCESS

sessionParameters=<null>

generalParameters=<null>

notes=<null>

exceptions=<null>

warnings=<null>

]

2020-01-05 19:52:23,810 INFO [main] [Workflower] - Updated ECO Affected Items WorkflowParameters(partNumber=GGO2B-MPMT-00P0, ecoNumber=C53228, revision=A) {lifecyclePhase=Preliminary}

2020-01-05 19:52:23,811 INFO [main] [Workflower] - Changing Status for ECO Number C53228 to Review State

2020-01-05 19:52:24,790 ERROR [main] [Workflower] - Workflow.workflowEco failed with AgileException: Agile Exceptions:Exception Id: -60086- Exception Message: -The following required fields are missing: C53228: Affected Items.Lifecycle Phase: GGO2B-MPMT-00P0- Exception Cause: -null-

Thank you very much !!

Randy