Hi,

You may try Standard Import Process to make the Bulk Changes. Refer Import/Export Guide for more details.

https://docs.oracle.com/cd/E83928_04/otn/docset.html

Regards,

Karthik

Hi Feri,

Could you please confirm if the AgileAPI Jar which you are using in your custom Application is Taken from Application Server.

let me know if you are receiving same error with Non SSL URL as well.

Thank You

Karthik

Hi Manju,

Please check if below queries work for you. You may Join these tables to get all Information.

SELECT ID FROM ITEM WHERE ITEM_NUMBER=’TEST_ITEM’;

RESULT: 6022378

SELECT  FILE_ID FROM ATTACHMENT_MAP WHERE PARENT_ID=’6022378′;

RESULT: 6216321

SELECT LOCATIONS,IFS_FILEPATH FROM FILE_INFO WHERE FILE_ID=’6216321′;

RESULT : 13388, 000/061/196/agile9342123.xls

SELECT DESCRIPTION FROM NODETABLE WHERE ID=’13388′;

RESULT: IFS

ACTUAL FILE PATH: BASE STORAGE DIRECTORY OF IFS(CONFIGURED IN JAVA CLIENT) EX : D\Vault

D:Vault\000\061\196\gile9342123.xls

Thank You

Hi Arif,

Could you please let me know if you are facing this Issue in all the Browsers.

Also try checking Emulation Feature in IE ( Open IE –> Click on F12–> Developer Tools will be opened—> Click on Emulation —-> Try Changing the Document Mode to 9 ) and upload the file.

Thank You

Please review the below KB from Oracle Support.

Generating Standard Reports in Agile Results in Blank or 0 Byte Files; stdout.log Shows “java.util.MissingResourceException”: “Can’t find resource for bundle” (Doc ID 1307737.1)

Hi Feri,

Assign Role having Discover Privilege,Read Privilege ,Modify Privilege on Attributes(Inclusive of all Attributes which needs to be modified) and assign it to PX. In this way, Other users cannot Modify the attributes but  attributes can be updated via PX.

Thanks,

Karthik

Hi Stortip,

Please find the below details.

1. If you are fetching the Item by Iterating the Affected Items Table of a Change, use getReferentIterator() to Iterate the Change Affected Items Table. This would give you the Item with the rev specific to the Change
2. If you want to load any rev, use item.setRevision(IChange) or  item.setRevision(Change Number). You can get the Revision/Change Details in two ways

a. item.getRevisions()

b. Can get the Information from Change History Tab.

Please refer to SDK  and API Documentation for more  information .

Let me know if you still face any issues in getting the data.

Thank You,

Karthik

Hi Dorota,

You can build a PX which consumes a file to  create/update the values in Cascade List. Please make sure you handle the special Characters  while creating/updating  list entries.

Thank You,

Karthik

Hi Pete,

Please find the sample code below .

Java PX:

return new ActionResult(ActionResult.EXCEPTION, new Exception(“Error Message”));

Script PX:

import  com.agile.agileDSL.ScriptObj.AgileDSLException;

throw new AgileDSLException(“Error Message”);

Regards,

Karthik

Hi Vaibhav,

Please try the below code.

IChange change=(IChange) session.getObject(IChange.OBJECT_TYPE,”SCO00001″);
ITable affItems=change.getTable(ChangeConstants.TABLE_AFFECTEDITEMS);
session.disableWarning(517);

HashMap<Integer,String> map=new HashMap<Integer,String>();
map.put(ChangeConstants.ATT_AFFECTED_ITEMS_SITES, “Site1”);
map.put(ChangeConstants.ATT_AFFECTED_ITEMS_ITEM_NUMBER, “P00001”);
affItems.createRow(map);

Regards,

Karthik