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 above106Views0likes3CommentsCustomizing BatchLoader in ARAS 31 to Add Users with Identities
Hi everyone, I recently migrated from ARAS version 11 to version 31. In ARAS 11, we used the BatchLoader tool to import user data from an Excel file, which included both user details and their associated identities. However, after migrating to ARAS 31, I noticed that the BatchLoader no longer supports adding users and identities together in a single operation. The AML mapping now restricts us to using only one ItemType at a time, which makes it difficult to replicate our previous process. Has anyone tried customizing the BatchLoader in ARAS 31 to overcome this limitation? I’d really appreciate any guidance or suggestions on how to achieve this. Thanks in advance for your help! — Salini64Views0likes0CommentsHow can I control behavior of BOM on revision up
Hi community, Here is an use case that User want to control Part by item that make the BOM are float or fixed when revision up. I read some solution that you can use a customized property and replace the action when creating a new revision. But I need more explain on doing this. Thanks to read this.47Views0likes0CommentsHow to detect when a BOM position floats automatically to next revision?
Hi community, when we use float/hard float behavior in a BOM, a new revision of a Part will automatically update the BOM of the parent Part. Is there any way we can detect when this kind of update event on a BOM position occurs? Thanks for any hint! Angela750Views0likes1CommentHow can I control/track floating behavior of Parts?
Hi community, I use floating behavior on certain Parts in the BOM. This way the BOM will always show the latest Part as long as the Parent hasn´t been released yet. But I wished we would have more control about the float action it self. I don´t want to use "fixed" behavior. It would be helpful to know that a automatic "float" occurred and which Parts were affected. I am thinking about two possible concepts: 1. Inform user before a float update will occurs (include information regarding the affected elements) 2. Track somewhere in Innovator which BOM elements were updated via "float" Does anyone know a solution for something like this? Or has any other idea how to use the "float" behavior in a more controlled way? Any input welcomed! Many thanks! Angela860Views1like3CommentsRelation and versioning
Hi, I have an ItemType STUDY with a property (type=Item) pointing on an ItemType CONTEXT. The CONTEXT is versionable and has a simple lifecycle WIP => REL. I would like that: When the relation is created, the STUDY is pointing on the last version/generation of the CONTEXT When the CONTEXT is modified (same version), the STUDY is pointing on the last version/generation of the CONTEXT When the CONTEXT is released (LF set to REL), then all STUDIES are now fixed on this version/generation To do that: I set the "Item behavior" of the property to "Float" On the LifeCycle, I set the ""Item behavior" of the state "REL" to "Fixed" But, the point (3) of my expectations doesn't work, if I create a new version, the study is pointing now of this new version. What should I do?1.8KViews0likes0CommentsIntegrating aras innovator with an external database
Hi folks, I have a question and i think you guys can help me. my question is how to change the property of operation number in process plan from Integer to a String. when i tried to change in the properties of mpp_operation which is a item type, it showing error that can't change the system properties. what can i do? because I have operation number something like A0, B0 etc.. and another question is how can i share data from aras database to another external database and vice versa, i mean how can i integrate aras innovator with an external database. Thanks folks..!!Solved4KViews0likes1CommentPurge and float
Hi, I create Itemtype A and B , both are version controlled and A has B as an item property defined as float. I create an instance of both and relate instance B to instance A . I modify both multiple times so they both go up several generations. When I purge instance A it goes to the previous generation with still referencing the latest generation of instance B . When I purge instance B I get an error instead stating that that specific generation of instance B is still referenced by instance A . 1. what is the Aras standard way of dealing with this situation? 2. what is the Aras standard way of dealing with a similar situation, but instead applied on relationship itemtypes? I'm having a hard time finding information on how to deal with the above 2 situations. Regards, /MB1.7KViews0likes1CommentWill Item Behaviour set on Life Cycle take precedence to a property Item too?
I have an Item “ItemA” which has a property “PropA” of type Item with Item Behavior as Float. If I set the Item Behavior on the LifeCycle of the “ItemA” to be Hard Fixed. Will “PropA” behave as “Float” (as set) or “Fixed” (by taking the precedence from Parent’s Life Cycle state)? I tried mocking this up. But “PropA” still has Float behavior (I expect it to behave it as Fixed :(). The Parent’s Life Cycle State’s Item Behavior does not take precedence in this case. Please clarify. Thanks in advance.2.3KViews0likes1Comment