relationships

99 Topics

Tree Grid View slow: reads whole branch on expand — improvement ideas?
Hi Aras Community Folks, I’m facing a performance issue with the Aras TGV, expanding a node is extremely slow at large data volumes (~10 minutes at 1M items), and it looks like the server reads all descendant rows even though only the first 100 are shown. Details below — would really appreciate any guidance. Environment: Aras Innovator 14.36(14 SP36). Standard TreeGridView over a recursive Query Definition. Short version of the problem: When a user expands a node, the grid shows only the first 100 children (page size 100, with a “Show More” row). But under the hood, the server reads every descendant item beneath that branch — hundreds of thousands of rows — even though only 100 are displayed and none of the descendants are returned in the response. At 1Million items this makes a single expand take ~10 minutes. Root item (starting point) │ └─ Level B item ← via root's reference property │ ├─ [B → B] Count(child B) > 0 │ └─ Level B item ⟲ "Reuse Query Element Definition" → back to B (recursion) │ └─ [B → C] Count(C) > 0 └─ Level C item (is_current = 1) │ └─ [C → C] Count(C) > 0 └─ Level C item ⟲ "Reuse Query Element Definition" → back to C (recursion) Page size (max_child_items) = 100 | Default grow depth = 2 Two recursive legs: B→B and C→C, each gated by Count(...) > 0 Two recursive legs: B→B and C→C, each via Reuse Query Element Definition. Each relationship is gated by a Count(...) > 0 child-existence filter. TGV settings: page size max_child_items = 100, default grow depth = 2. What we measured: Expand one mid-level B node at 1M items: ~8 min. Shows 100 B rows + “Show More”, 0 C rows — but SQL reads the full descendant set (hundreds of thousands of rows) twice (paging query + property read). Count(...) > 0 already compiles to a permission-aware EXISTS; the cost is the broad descendant read, tied to the expand-icon (hasChild) check. Relationship source_id/related_id indexes already exist. Questions: On expand of an item, only the first 100 children are shown — but the server reads all descendants beneath the branch (full data) first, then returns 100 items. The descendants are read in full just to show 100 rows and to decide each row’s “+” expand icon. Is there a supported way to fetch only the 100 displayed rows from the start, and to make the expand-icon check stop at the first match instead of reading everything? Regarding the global tgv_MaxFetchItemsCount variable (default 1,000,000): we’re considering temporarily lowering it (e.g. to 100) before an expand and restoring the default afterwards, to limit how much is fetched. Does it actually limit the result to that many rows (return just the first N), or does it only reject an over-limit request with an error? And is it checked before the heavy SQL runs (so it saves the work), or after (so the rows are already read)? Would really appreciate any guidance or suggestions on the queries above
PLMNewbie
5 hours ago Place Development
Views
0likes
Comments
Can we add multiple reverse relations targeting a single relation?
Hi, We have the following scenario: I have a custom itemtype which has relationships with different itemtypes like Part, Requirement, etc. Now I want to show the reverse relation on my custom item type pointing to Part and Requirement. On custom Itemtype we have one relationship that has the source itemtype as custom itemtype and related itemtype is null. On this single relationship can we add reverse relation using a Relationship View for both Part and Requirement, and more? If yes, how to add more than one Relationship View? Or if there is any other way that leads to showing the different itemtypes relation using a single relationship? Thanks in advance. Best regards Tanjum
tanjum_shaikh_altegra_se
8 months ago Place Getting Started
Views
0likes
Comment
Using a method to update a team, doesn't seem to iterate beyond the first
Hi Community. I am setting up a method to assign a user to multiple teams based on a form. The issue I am having is that it seems to only apply the user to the first team I select (using a multi-value list). Essentially, I am defining on the form - The user identity to add The name of the team to add them to Their team role and regions they are responsible for Code is below: Innovator inn = this.getInnovator(); //Get the form used to make the GPR change selections Item qryGprItem = this.newItem(this.getAttribute("type"), "a_GetControlledItem"); qryGprItem.setID(this.getID()); Item gprItem = qryGprItem.apply(); string[] prodCats = gprItem.getProperty("a_add_to_prodcat").Split(','); string regions = gprItem.getProperty("a_add_to_region"); string gprAction = gprItem.getProperty("a_add_or_remove"); foreach (string prodCatValue in prodCats) { string prodCat = prodCatValue; Item qryTeamItem = inn.newItem("Team", "get"); qryTeamItem.setProperty("name", prodCat); Item teamItem = qryTeamItem.apply(); if (gprAction == "Add") { Item teamMember = inn.newItem("Team Identity", "add"); teamMember.setPropertyItem("source_id", teamItem); teamMember.setPropertyItem("related_id", gprItem.getPropertyItem("a_user_to_modify")); teamMember.setProperty("a_team_region", regions); teamMember.setPropertyItem("team_role", gprItem.getPropertyItem("a_gpr_role")); return teamMember.apply(); } if (gprAction == "Remove") { } } return this;
Solved
Morgan
9 months ago Place Development
Views
0likes
Comments
What is the best way to validate whether an item has a parent?
I'm trying to send an email on promotion to "Released" of Parts when a couple of criteria are met, the parts being of a certain custom classification we've added, and them not being used in another BOM anywhere (i.e. they're top-level Parts being released). What's the best way to go about checking whether the part is a top-level part (i.e. doesn't have a parent)? I've tried isRoot(), getParentItem(), and getProperty("source_id"), but I'm either misusing those or for some reason they're not working for my case. This is what I have tried so far (this method is attached as a Post method to the lifecycle transitions to Released, and it is generating the emails, it's just not limiting it to only the times when it's a top-level BOM, like I want): Innovator inn = this.getInnovator(); Item myResult; if (this.getProperty("classification", "") == "Hull Assembly" && this.isRoot() == true) { //email code } return this; //or Innovator inn = this.getInnovator(); Item myResult; if (this.getProperty("classification", "") == "Hull Assembly" && this.getParentItem() == null) { //email code } return this; //or Innovator inn = this.getInnovator(); Item myResult; if (this.getProperty("classification", "") == "Hull Assembly" && this.getProperty("source_id", "") == "") { //email code } return this;
Solved
Kai_Kircher
9 months ago Place Development
Views
0likes
Comments
ARAS31 import.mf deployment issue
Hai, We recently upgraded our environment from Aras Innovator 11 to Aras Innovator 31, and we are running into several issues while deploying our solution packages. I wanted to share the details here to see if anyone has faced similar challenges or has suggestions. In Aras 11, we used an import.mf file with the following structure, and everything deployed without issues: <imports> <package name="DatabaseIdentifier" path="com\aras\innovator\DatabaseIdentifier" /> <package name="com.aras.innovator.solution.PLM" path="PLM\Import" /> <package name="com.aras.innovator.solution.Project" path="Project\Import"> <dependson name="com.aras.innovator.solution.PLM" /> </package> <package name="com.aras.innovator.core" path=".\" /> <package name="com.aras.innovator.cui_default" path=".\" /> <package name="Custom_Pkg1" path="CustomPkg1\Import" /> <package name="Custom_Pkg2" path="CustomPkg2\Import" /> </imports> After upgrading to Aras 31, we tried using the same .mf configuration, but we are encountering multiple deployment errors. Issues Observed 1. Null Reference Error Object reference not set to an instance of an object. 2. Method Not Found Error It points to this AML:→ Error: “No items of type Method found.” <Item type='ItemType' id='8052A558B9084D41B9F11805E464F443' action='edit'> <Relationships> <Item type="Server Event" action="add"> <related_id keyed_name="FileOnGet" type="Method"> <Item type="Method" action="get" select="id"> <name>FileOnGet</name> </Item> </related_id> </Item> </Relationships> </Item> Import package 'com.aras.innovator.core' failed with message: No items of type Method not found. 3. Timeout Error During Import The package was then marked as a failed release (seen for custom_Pkg). faultcode: 999 faultstring: System.Net.WebException: The operation has timed out 1. In Aras 31, are we required to use manifest.json instead of the old import.mf format for custom packages? 2. If yes, where exactly should the manifest.json file be placed, and what structure should it follow? 3. How should we handle customizations or extensions to system-level packages like com.aras.innovator.core and com.aras.innovator.cui_default that previously existed in Aras 11? 4. Has anyone encountered the faultcode 999 / timeout issue during import — and how did we resolve it? Thanks in Advance Salini
Solved
salini_sivasubramanian
10 months ago Place Development
Views
0likes
Comments
MAC Policy Issue in ARAS 31 – Need Help with Access Restrictions
Hi all, I’m working on implementing access restrictions for the a Itemtype in ARAS 31. There are around 46 records, and I want to group them into 5 categories. Each category will be assigned to specific identities, allowing controlled access based on the record's classification. To achieve this, I started configuring MAC policies. However, I’ve run into a few issues: The fields I need are disabled in the MAC Policy Condition Editor. User-defined properties are not accessible in the condition editor either. Has anyone faced similar challenges or found a workaround for this? Any help or guidance would be greatly appreciated! Thanks, Salini
salini_sivasubramanian
1 year ago Place Development
Views
0likes
Comments
filter the Relationship data automatically by identity and item type
For Identity A's user and Item type is Released. I want to show the relationship data (for example, part bom) with ShowFlag =1 For Identity B's user I want to show all the data Anyone knows how to do it?
ye_bingqing001
1 year ago Place Community Lounge
Views
0likes
Comments
How to change the position of a Relationship Accordion tab
I needed to make a tab visible to certain identity. Therefore, I selected "Hide All" in the relationship types and used the CUI control to make a new tab. I need this tab to be all the way to right. Sort Order fields don't work, neither in the Relationship Type nor in cui_windowSection. Pictures below
Hargul_Sidhu
2 years ago Place Development
Views
0likes
Comments
Error loading Recipient Relationship tab of DCO and EDR change management giving error when refreshing the CM tab
Hi, when opening ECO/EDR the first time there is no Proplem opening the Recipients Relationship tap, but when opening another a second ECO/EDR the recipients Relationship tap doesnt load. when trying to refresh the item it gives an error message 'The method "cui_ivicb_refresh_click" failed.' only when changing to another relationship tap i can click on refresh with no error, then if changed back to Recipients the recipients list will appear. this issue was not there before the updates were done on .NET code. please help me if you have an idea about this problem and how to approach it. thanks
Abdulrahman_Shahin
2 years ago Place Development
Views
0likes
Comment
Upload missing document relationship in Process Plan. "Add" statement doesn't work
I need to upload relationship between Operation Document and the Documents. As you can see from the picture below the hierarchy of Process Plan is: Process Plan--> Operation Number (which is `sort_order`, in this case it is 20)-->Document I have an excel sheet of the missing documents that need to show under an operation (20) The document relationship cannot by uploaded just to Operation because the operation 20 will exist under other Process Plans. However, under one process plan the operation number is unique, so in this case there will be only one operation with sort_order 20. The documents already exist, I just need them to be shown here. From the AML script I have the `get` command works. The code is below. <AML> <Item type="mpp_processPlan" action="get"> <item_number>080824-S10</item_number> <Relationships> <Item type="mpp_Operation" action="get"> <sort_order>20</sort_order> <Relationships> <Item type="mpp_operationDocument" action="get"> </Item> </Relationships> </Item> </Relationships> </Item> </AML> However, in the above script in the line `<Item type="mpp_operationDocument" action="get">` when `action = Update` it won't work. Basically the following doesn't work <AML> <Item type="mpp_processPlan" action="get"> <item_number>080824-S10</item_number> <Relationships> <Item type="mpp_Operation" action="get"> <sort_order>20</sort_order> <Relationships> <Item type="mpp_operationDocument" action="Update"> <item_number>MADL074161</item_number> </Item> </Relationships> </Item> </Relationships> </Item> </AML> Result of scriopt with all `action=get` [embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:b4eb42d4-78c3-44de-b633-1a7d250b7129:type=text&text=%3CSOAP-ENV%3AEnvelope%20xmlns%3ASOAP-ENV%3D%22http%3A%2F%2Fschemas.xmlsoap.org%2Fsoap%2Fenvelope%2F%22%3E%0A%3CSOAP-ENV%3ABody%3E%0A%3CResult%3E%0A%3CItem%20type%3D%22mpp_ProcessPlan%22%20typeId%3D%224E030A4723224002B3E94F40F01AC1DE%22%20id%3D%22767F3FCDCC0F4CCF95F3CA3D9DB9D391%22%3E%0A%3Cconfig_id%20keyed_name%3D%22080824-S10%22%20type%3D%22mpp_ProcessPlan%22%3E767F3FCDCC0F4CCF95F3CA3D9DB9D391%3C%2Fconfig_id%3E%0A%3Ccreated_by_id%20keyed_name%3D%22Data%20Migration%22%20type%3D%22User%22%3E08880028FF8C43D48CB02B44EB74B127%3C%2Fcreated_by_id%3E%0A%3Ccreated_on%3E2024-02-20T11%3A49%3A02%3C%2Fcreated_on%3E%0A%3Ccurrent_state%20name%3D%22Released%22%20keyed_name%3D%22Released%22%20type%3D%22Life%20Cycle%20State%22%3E7109CDD337C84AFF87F55B21CCAC34AC%3C%2Fcurrent_state%3E%0A%3Cdescription%3E%3C%2Fdescription%3E%0A%3Cgeneration%3E1%3C%2Fgeneration%3E%0A%3Chas_change_pending%3E0%3C%2Fhas_change_pending%3E%0A%3Cid%20keyed_name%3D%22080824-S10%22%20type%3D%22mpp_ProcessPlan%22%3E767F3FCDCC0F4CCF95F3CA3D9DB9D391%3C%2Fid%3E%0A%3Cis_current%3E1%3C%2Fis_current%3E%0A%3Cis_released%3E1%3C%2Fis_released%3E%0A%3Ckeyed_name%3E080824-S10%3C%2Fkeyed_name%3E%0A%3Clocation%3E10%3C%2Flocation%3E%0A%3Cmajor_rev%3EPP000%3C%2Fmajor_rev%3E%0A%3Cmodified_on%3E2024-02-20T11%3A49%3A02%3C%2Fmodified_on%3E%0A%3Cname%3ESlitter%20Knife%20Arm%2C%20Rotary%20Tip%2C%2035%22%20Ring%2C%20C%2FR%3C%2Fname%3E%0A%3Cnew_version%3E1%3C%2Fnew_version%3E%0A%3Cnot_lockable%3E0%3C%2Fnot_lockable%3E%0A%3Cowned_by_id%20keyed_name%3D%22Mfg%20Eng%22%20type%3D%22Identity%22%3ED46B8ECBDB0C4D94BFF7A93D36FAB474%3C%2Fowned_by_id%3E%0A%3Cpermission_id%20keyed_name%3D%22Process%20Plan%20-%20Released%22%20type%3D%22Permission%22%3EE4EB045B2622409BA09AC91778FAE18C%3C%2Fpermission_id%3E%0A%3Crelease_date%3E2024-01-29T00%3A00%3A00%3C%2Frelease_date%3E%0A%3Cstate%3EReleased%3C%2Fstate%3E%0A%3Citem_number%3E080824-S10%3C%2Fitem_number%3E%0A%3Citemtype%3E4E030A4723224002B3E94F40F01AC1DE%3C%2Fitemtype%3E%0A%3CRelationships%3E%0A%3CItem%20type%3D%22mpp_Operation%22%20typeId%3D%2291B674D7C7AF47F99CA1C2FB26C38DBF%22%20id%3D%2277DD37200C7B4858833A6D6D8A48F4FA%22%3E%0A%3Cconfig_id%20keyed_name%3D%2220%22%20type%3D%22mpp_Operation%22%3E77DD37200C7B4858833A6D6D8A48F4FA%3C%2Fconfig_id%3E%0A%3Ccreated_by_id%20keyed_name%3D%22Data%20Migration%22%20type%3D%22User%22%3E08880028FF8C43D48CB02B44EB74B127%3C%2Fcreated_by_id%3E%0A%3Ccreated_on%3E2024-02-20T12%3A06%3A27%3C%2Fcreated_on%3E%0A%3Ccycle_time%3E60%3C%2Fcycle_time%3E%0A%3Cdescription%20xml%3Alang%3D%22en%22%3EMC-1B%20MC2%20CNC%20Machine%20Centre%20S10%3C%2Fdescription%3E%0A%3Cgeneration%3E1%3C%2Fgeneration%3E%0A%3Cid%20keyed_name%3D%2220%22%20type%3D%22mpp_Operation%22%3E77DD37200C7B4858833A6D6D8A48F4FA%3C%2Fid%3E%0A%3Cis_current%3E1%3C%2Fis_current%3E%0A%3Cis_released%3E0%3C%2Fis_released%3E%0A%3Ckeyed_name%3E20%3C%2Fkeyed_name%3E%0A%3Cmajor_rev%3EPP000%3C%2Fmajor_rev%3E%0A%3Cmodified_on%3E2024-02-20T12%3A06%3A27%3C%2Fmodified_on%3E%0A%3Cname%20xml%3Alang%3D%22en%22%3EMC-1B%3C%2Fname%3E%0A%3Cnew_version%3E1%3C%2Fnew_version%3E%0A%3Cnmg_erp_name%3EMC-1B%3C%2Fnmg_erp_name%3E%0A%3Cnmg_location_id%3E10%3C%2Fnmg_location_id%3E%0A%3Cnot_lockable%3E0%3C%2Fnot_lockable%3E%0A%3Cpermission_id%20keyed_name%3D%22Process%20Plan%20-%20Released%22%20type%3D%22Permission%22%3EE4EB045B2622409BA09AC91778FAE18C%3C%2Fpermission_id%3E%0A%3Csetup_time%3E0%3C%2Fsetup_time%3E%0A%3Csource_id%20keyed_name%3D%22080824-S10%22%20type%3D%22mpp_ProcessPlan%22%3E767F3FCDCC0F4CCF95F3CA3D9DB9D391%3C%2Fsource_id%3E%0A%3Cwi_details%20xml%3Alang%3D%22en%22%3E%3C%2Fwi_details%3E%0A%3Csort_order%3E20%3C%2Fsort_order%3E%0A%3CRelationships%3E%0A%3CItem%20type%3D%22mpp_OperationDocument%22%20typeId%3D%2238BA57E0616B49A58317C267E436AE4C%22%20id%3D%22106F5032EE7F4C5497717888370A3BB6%22%3E%0A%3Cconfig_id%20keyed_name%3D%22106F5032EE7F4C5497717888370A3BB6%22%20type%3D%22mpp_OperationDocument%22%3E106F5032EE7F4C5497717888370A3BB6%3C%2Fconfig_id%3E%0A%3Ccreated_by_id%20keyed_name%3D%22Data%20Migration%22%20type%3D%22User%22%3E08880028FF8C43D48CB02B44EB74B127%3C%2Fcreated_by_id%3E%0A%3Ccreated_on%3E2024-02-20T12%3A36%3A02%3C%2Fcreated_on%3E%0A%3Cgeneration%3E1%3C%2Fgeneration%3E%0A%3Cid%20keyed_name%3D%22106F5032EE7F4C5497717888370A3BB6%22%20type%3D%22mpp_OperationDocument%22%3E106F5032EE7F4C5497717888370A3BB6%3C%2Fid%3E%0A%3Cis_current%3E1%3C%2Fis_current%3E%0A%3Cis_released%3E0%3C%2Fis_released%3E%0A%3Ckeyed_name%3E106F5032EE7F4C5497717888370A3BB6%3C%2Fkeyed_name%3E%0A%3Cmajor_rev%3EA%3C%2Fmajor_rev%3E%0A%3Cmodified_on%3E2024-02-20T12%3A36%3A02%3C%2Fmodified_on%3E%0A%3Cnew_version%3E1%3C%2Fnew_version%3E%0A%3Cnot_lockable%3E0%3C%2Fnot_lockable%3E%0A%3Cpermission_id%20keyed_name%3D%22Process%20Plan%20-%20Released%22%20type%3D%22Permission%22%3EE4EB045B2622409BA09AC91778FAE18C%3C%2Fpermission_id%3E%0A%3Crelated_id%20keyed_name%3D%22MADL074152%22%20type%3D%22Document%22%3E%0A%3CItem%20type%3D%22Document%22%20typeId%3D%22B88C14B99EF449828C5D926E39EE8B89%22%20id%3D%22BD9ECB6D5C5D4AEEBC0ED65680C5505C%22%3E%0A%3Cclassification%3EManufacturing%20Aid%3C%2Fclassification%3E%0A%3Cconfig_id%20keyed_name%3D%22MADL074152%22%20type%3D%22Document%22%3EBD9ECB6D5C5D4AEEBC0ED65680C5505C%3C%2Fconfig_id%3E%0A%3Ccreated_by_id%20keyed_name%3D%22NMIS%20_MADL%22%20type%3D%22User%22%3E41E9090B65234C899CAFF690C7C0F562%3C%2Fcreated_by_id%3E%0A%3Ccreated_on%3E2024-02-19T11%3A12%3A07%3C%2Fcreated_on%3E%0A%3Ccurrent_state%20name%3D%22Released%22%20keyed_name%3D%22Released%22%20type%3D%22Life%20Cycle%20State%22%3E8EDE39438A7E4A56A1B4A9D07EF4A2FF%3C%2Fcurrent_state%3E%0A%3Cdescription%3E35%22%20SLITTER%20ARM%20C%2FR%3C%2Fdescription%3E%0A%3Ceffective_date%3E2018-11-16T14%3A35%3A00%3C%2Feffective_date%3E%0A%3Cgeneration%3E1%3C%2Fgeneration%3E%0A%3Chas_change_pending%3E0%3C%2Fhas_change_pending%3E%0A%3Chas_files%3E1%3C%2Fhas_files%3E%0A%3Cid%20keyed_name%3D%22MADL074152%22%20type%3D%22Document%22%3EBD9ECB6D5C5D4AEEBC0ED65680C5505C%3C%2Fid%3E%0A%3Cis_current%3E1%3C%2Fis_current%3E%0A%3Cis_released%3E1%3C%2Fis_released%3E%0A%3Cis_template%3E0%3C%2Fis_template%3E%0A%3Ckeyed_name%3EMADL074152%3C%2Fkeyed_name%3E%0A%3Cmajor_rev%3EV007%3C%2Fmajor_rev%3E%0A%3Cmodified_on%3E2007-07-09T08%3A17%3A00%3C%2Fmodified_on%3E%0A%3Cname%3E080824%3C%2Fname%3E%0A%3Cnew_version%3E0%3C%2Fnew_version%3E%0A%3Cnmg_department%3EManufacturing%3C%2Fnmg_department%3E%0A%3Cnmg_type%3EProgram%20%28CAD%2FCAM%29%3C%2Fnmg_type%3E%0A%3Cnot_lockable%3E0%3C%2Fnot_lockable%3E%0A%3Cowned_by_id%20keyed_name%3D%22Mfg%20Eng%22%20type%3D%22Identity%22%3ED46B8ECBDB0C4D94BFF7A93D36FAB474%3C%2Fowned_by_id%3E%0A%3Cpermission_id%20keyed_name%3D%22Released%20Document%22%20type%3D%22Permission%22%3E74C205C37E7C4D56BBBE99B52B28431E%3C%2Fpermission_id%3E%0A%3Crelease_date%3E2018-11-16T14%3A35%3A00%3C%2Frelease_date%3E%0A%3Cstate%3EReleased%3C%2Fstate%3E%0A%3Citem_number%3EMADL074152%3C%2Fitem_number%3E%0A%3Citemtype%3EB88C14B99EF449828C5D926E39EE8B89%3C%2Fitemtype%3E%0A%3C%2FItem%3E%0A%3C%2Frelated_id%3E%0A%3Csource_id%20keyed_name%3D%2220%22%20type%3D%22mpp_Operation%22%3E77DD37200C7B4858833A6D6D8A48F4FA%3C%2Fsource_id%3E%0A%3C%2FItem%3E%0A%3C%2FRelationships%3E%0A%3C%2FItem%3E%0A%3C%2FRelationships%3E%0A%3C%2FItem%3E%0A%3C%2FResult%3E%0A%3C%2FSOAP-ENV%3ABody%3E%0A%3C%2FSOAP-ENV%3AEnvelope%3E]
Hargul_Sidhu
2 years ago Place Development
Views
0likes
Comments