Hi Anand,

projects are based in time and, by concept, they can’t be in Hold status. If the company needs to stop a project I see two ways out:
   – Delete the not needed tasks and complete the project;
   – Create a new task, lets call “Hold”, and use it to shift the project schedule as much as needed, increasing the task duration. I don’t like it because we are going to have projects with the status in “In Progress” what it’s not true.

My best
Carlos

Hi Balakrishnan,

I couldn’t realize what you want. Do you want to create a search that shows ECO Number, Part Number and so on?
Please, elaborate.

My bes
Carlos

Hi pmarfell,

you’re trying to log into Agile and it’s asking to enter a CAPTCHA besides the username and password?
If so, I’m not sure if Agile is capable to do that, I’m wondering if you don’t have any custom login page.

My best
Carlos

Hi Abdellah,

Here goes some answers, not all.

Is anyone running Agile 9.3.3 on Windows server 2012 R2 ? if so how is it working? any issues?

I have looked at the capacity planing document for 9.3.3 and it seems that win server 2012 R2 is not certified for 9.3.3 which is not good.

That is the problem, you won’t have a good support if the OS is not certified against Agile version. Also, I strongly recommend that you consider to go to at least 9.3.5 version, 9.3.6 is available and so far I faced no issue.

Right now, we are running Agile 9.3.3 on Win server 2008 R2 and we will have to move to win server 2012 R2 sooner than later. I am trying to explore my options:

1- is an OS upgrade of the same servers from 2008 to 2012 an option? if it is an option, is it recommended? has this been done before?

Take a look at the Windows Tech note bellow. It seems that for some versions you can upgrade, but others don’t, the example in the note bellows says that is feasible to go from WS2012 to 2016.

https://technet.microsoft.com/en-us/windowsserver/dn527667.aspx

2- Or fresh 2012 servers with fresh Agile installation is the route to go?

If the upgrade is possible,do it in place, better than migrate. However I strongly recommend to you to use a Linux OS. Oracle Linux 6 or seven are really stable and easy to use.

My best
Carlos

Hi Santhosh,

I don’t know which are the modules that you company actually uses, but I’d start suggesting you to upgrade straight ahead to the 9.3.6 version.
It’ll be a considerable change but if you use PPM module, for example, the users will face many improvements that afford the change, Oracle support’s is something that matters as well, in average Oracle supports versions with no more than 4 years of age.
The first step is to analyse the Capacity Planning document to evaluate hardware and software requirements.
There are several possibilities according to the hardware ans software compatibility.

Upgrade Database from 11 to 12.
Uninstall Agile/File Manager applications;
Run AUT (Agile Upgrade Tool);
Reinstall Agile/File Manager apps.

Assuming that you are considering to move everything from database to files, there will be more things to do.

Uninstall Agile/File Manager applications;
Run AUT (Agile Upgrade Tool);
Create a DB dump file to migrate data to the new Data Base. Note that Agile has specific tools to export and import dumps.
Reinstall Agile/File Manager apps on a new server.
Import DB dump.

All the details you can find in 

http://www.oracle.com/technetwork/documentation/agile-085940.html

My bes
Carlos

Ilan, you’re welcome.
I think it’s not possible to create an action item without a task, the action items born in the task/project/gate collaboration tab.
So you can create a task and relate it to the CAPA using the Relationship tab, you can create rules between both to keep to progress of both tight.

Carlos

Hi Ilport

1. I want to know what is the best way for making action items or tasks outside the PPM module (Product Collaboration), I know there is the Disquisition object, is it the only way?
May you elaborate it?  Disquisition, which version are you using? There is the Discussion that you could configure to became something “like” a action item but with less features.

2. How can I multiple two numeric attributes and put the result in the third one (on every save)? 
You need to write a Groovy Script to do the multiplication, Oracle provides some examples that you can use as a starting point.

Following is a simple example of a Groovy Script, it takes to attribute, multiplies them and insert the value in a fourth attribute.

My best
Carlos

// ===========================================================================
//
// Author: Carlos Benassi
// Date: 25/10/2016
// Desc: This script generates a number based on the calculation of other 3 number.
// In this example it uses the SubClass names and several Page2 attributes to calculate the result.
//
// Implementation: This script should be run as a Post event on the SubClass Create event
// it can also be tied to the SubClass UpdateTitleBlock event to prevent changes
//
//

import com.agile.agileDSL.ScriptObj.IBaseScriptObj
import com.agile.api.ChangeConstants

void invokeScript(IBaseScriptObj obj) {
// get the change type
changetype = obj.getValueByAttId(ChangeConstants.ATT_COVER_PAGE_CHANGE_TYPE);

// Get the PAGE2 Attributes to calculate the result
// page2.list04 = fit
// page2.list05 = techrisk
// page2.list06 = mktrisk

fit = obj.getValueByAttId(ChangeConstants.ATT_PAGE_TWO_LIST04);
techrisk = obj.getValueByAttId(ChangeConstants.ATT_PAGE_TWO_LIST05);
mktrisk = obj.getValueByAttId(ChangeConstants.ATT_PAGE_TWO_LIST06);

// Create the calculus
score = fit.toInteger() * techrisk.toInteger() * mktrisk.toInteger()

// Update the score values
obj.setValueByAttId(ChangeConstants.ATT_PAGE_TWO_NUMERIC01, Integer.toString(score));

// log to Event Handler Monitor –
// View the log monitor to ensure the action is completing correctly
obj.logMonitor( “Value=” + score);
}

Hi Gykumar

you need to create workflow criteria to handle with these “ifs”.
This criteria should decide who are the approvers based on changes or items attribute values.

My best
Carlos

Hi Runemeijer,

have you thought about to create/modify a change’s modify privilege? If you remove the properties regarding to change affected items attributes, you’ll disable the ability to modify the affected items tab.
Does it make sense?

My best
Carlos

Hi Ushav,

in web client you can go to a Gate, Workflow Tab, Workflow panel, scroll right and you’ll find a column called Signoff Duration.
Out-of-the-box you won’t have the Read privilege, so you need to configure it in Java Client.

My best
Carlos