Recent Discussions
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 aboveAuto expand x-properties
We used to have a small javascript deployed on the server which made sure that x-properties was auto expanded when the user opened a Document: Now we are on release 35 and it same that we have missed this part and that the functionality on x-properties in forms have changed a lot. Does anybody have implemented a solution to auto expand x-properties on R35 (or higher) ? Many thanks in advanceSolid Edge derived part (Part Copy of a Part Copy) → empty 3D viewable, conversion task "Succeeded"
Hi all, We're seeing an empty 3D viewable for some Solid Edge parts, and we'd like to know whether anyone has hit the same thing. Environment - Aras Innovator 20 - Aras 3D Visualization , Monolithic + Dynamic Viewer (no Streaming) - Solid Edge 2025 - Conversion rule: "Aras 3D CAD to PDF Conversion", file type "Solid Edge Part" Scenario A 2-level chain of derived parts, built with Solid Edge Part Copy: PART_C.par (Part Copy of PART_B) → viewable EMPTY └─ PART_B.par (Part Copy of PART_A) → viewable OK └─ PART_A.par (base part) → viewable OK Is it a known limitation or issue that a part with CAD Structure children is converted as a dynamic-assembly root and loses its own body, specifically with 2+ levels below it? Is this specific to Solid Edge Part Copy, or have you seen it with other derived-part mechanisms (SolidWorks derived parts, Inventor derived components, NX WAVE)? Thanks, Marco.Does anyone see performance issues in Chrome
Hi community, since yesterday Innovator 12 seems to be slow when using Chrome. As soon as I start Innovator, it uses 100% RAM and the app freezes for a short time on a regular basis. Chrome Version 155.0.8059.40 When using future Canary Chrome 157, everything is fine. Same for Edge and Firefox. I got the behavior for 12SP7 and 12SP9. Not for 12SP10 and newer versions like I14+. Can somebody replicate this one?Solved0likes3CommentsHow to highlight a custom CUI Button like the Notification Button based on events of interest?
Hi community, does anyone know where Aras stores the "New Release" information that is shown in the CUI notification button (see screenshot)? I want to implement a similar button-highlighting mechanism. I have a time-tracking system in Innovator that is launched via a similar CUI button in the main header. I want users to be able to see at a glance whether their timer is currently running. (the timer is used for something not PLM related if you wonder about the use case) I know that we can use Messages/Notifications to make the button react, but I don't want to use the Messages feature itself. I think CUI buttons that can indicate a "status" of something could be a powerful feature. Thanks for any hints! Angela0likes6CommentsIs it possible to create custom ConversionServer tasks without external DLL?
Hi community, does anyone know if we can create custom ConversionServer without external DLLs? I want to run some "export files" task in the background if the expected file size is very large. I right now use a Minerva extension for this task, but I want to replace it with an own solution. The tool will probably not work anymore after next update (I have no subscription...), so I want to be prepared for the future. There are a few blog articles regarding creating custom ConversionServer DLLs. But I wonder if we can avoid the DLL at all? I am able to create a custom ConversionTask, but the code inside is not executed yet. I mainly look for hints regarding how to build a proper "onConvert" Method that can be used in the ConversionRule. Can anyone share some experience regarding this topic? If you have a solution but don´t want to share it in public (aká give it away for free): I would exchange a solution for this one with one of my own solution that you might be interested ! [emoticon:c4563cd7d5574777a71c318021cbbcc8] Many thanks! Angela0likes10CommentsInstallation issue : ODBC Driver 18 SSL Provider error
Hello 😊 I'm trying to install Aras Innovation (all in one server for testing purpose) and I'm stuck on this nice message while trying to connect to the DB : Just to inform that my system is under : Windows Server 2025 Datacenter Azure Edition (10.0) IIS server version 10 (10.0.26100.32860) .NET 6.0.36 installed Microsoft SQL Server Express 2025 (17.0.1000) ☝️ And I've already pushed ODBC17/18 but without success regarding the install. Thank you for your precious "lights" 💡 Regards, G.Edge upgrade kills search grid - find workaround here
Hi communty, if today your Edge users report that "Innovator doesn´t work" - this is the post you need. Does you Innovator look like this? Solution #1: Use Chrome OR Solution #2 (temporary workaround until we find a better fix): Add SearchMode ItemType to TOC. Edit Simple Search mode. Uncomment yellow highlighted line: Affected Edge Version: 154.0.4258.371like4Comments
Tags
- Methods118 Topics
- ItemTypes109 Topics
- Forms100 Topics
- Version 1299 Topics
- Relationships98 Topics
- JavaScript86 Topics
- Installation72 Topics
- Workflows69 Topics
- AML68 Topics
- Server Methods54 Topics