SQL Server Reporting Services (SSRS) via HTTPS in Innovator Release 2023. How to fix?
Hi community, the release notes of Innovator 26 mentions following fixed issue: I-050277 Fixed an error that prevented Aras Innovator from connecting to SQL Server Reporting Services via HTTPS. I did a quick test in Release 2023 and noticed that I cannot create SSRS reports via HTTPS in this release. When executing the Report, I get following error message: "The provided URI scheme 'https' is invalid; expected 'http'. (Parameter 'via')". I assume Release 2023 still contains the bug that was patched with Innovator 26. Release 2023 removed the RSGateway.aspx that was previously used to connect to SSRS. Not sure how Aras calls the reports in the new versions. Does anyone know how to fix this one? I assume we need to customize the codetree, add some assembly binding or similar. But I have no idea so far how to do it. Thanks and best regards! Angela
How to load aras 2023 dll with cpp host cli without native net core?
[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:4aacaea8-0c4c-471c-aefc-402fbf171d8a:type=text&text=%23using%20%22C%3A%2Ftemp%2Faras2023dlls%2Fbin%2FIOM.dll%22%0D%0A%23using%20%22C%3A%2Ftemp%2Faras2023dlls%2Fbin%2FSystem.Configuration.ConfigurationManager.dll%22%0D%0A%23using%20%22C%3A%2Ftemp%2Faras2023dlls%2Fbin%2FAras.Net.dll%22%0D%0A%0D%0Ausing%20namespace%20System%3B%0D%0Ausing%20namespace%20System%3A%3AIO%3B%0D%0Ausing%20namespace%20System%3A%3AReflection%3B%0D%0Ausing%20namespace%20System%3A%3AConfiguration%3B%20%20%0D%0A%0D%0A%0D%0Avoid%20arasDo%28%29%0D%0A%7B%0D%0A%20%20%2F%2F%20sample%20aras%20code%0D%0A%20%20System%3A%3AString%20%5E%20url%20%3D%20%22http%3A%2F%2Fdevaras2023%2FInnovatorServer%2FServer%2FInnovatorServer.aspx%22%3B%0D%0A%20%20System%3A%3AString%20%5E%20database%20%3D%20%22InnovatorSolutions%22%3B%0D%0A%20%20System%3A%3AString%20%5E%20user%20%3D%20%22admin%22%3B%0D%0A%20%20System%3A%3AString%20%5E%20password%20%3D%20%22innovator%22%3B%0D%0A%0D%0A%20%0D%0A%20%20auto%20conn%20%3D%20Aras%3A%3AIOM%3A%3AIomFactory%3A%3ACreateHttpServerConnection%28url%2C%20database%2C%20user%2C%20password%29%3B%0D%0A%20%20auto%20result%20%3D%20conn-%3ELogin%28%29%3B%0D%0A%20%20auto%20s%20%3D%20result-%3EToString%28%29%3B%0D%0A%7D%0D%0A%0D%0Astatic%20Assembly%20%5E%0D%0A%20%20LoadFromSameFolder%28Object%20%5E%20sender%2C%20ResolveEventArgs%20%5E%20args%29%20%7B%0D%0A%20%20%20%20String%20%5E%20folderPath%20%3D%20%22C%3A%5C%5Ctemp%5C%5Caras2023dlls%5C%5Cbin%22%3B%0D%0A%20%20%20%20String%20%5E%20assemblyPath%20%3D%20Path%3A%3ACombine%28folderPath%2C%20%28gcnew%20AssemblyName%28args-%3EName%29%29-%3EName%20%2B%20%22.dll%22%29%3B%0D%0A%20%20%20%20if%20%28File%3A%3AExists%28assemblyPath%29%20%3D%3D%20false%29%0D%0A%20%20%20%20%20%20return%20nullptr%3B%0D%0A%20%20%20%20Assembly%20%5E%20assembly%20%3D%20Assembly%3A%3ALoadFrom%28assemblyPath%29%3B%0D%0A%20%20%20%20return%20assembly%3B%0D%0A%20%20%7D%0D%0A%0D%0Avoid%20aras%28%29%0D%0A%7B%0D%0A%20%20%2F%2F%20put%20this%20somewhere%20you%20know%20it%20will%20run%20%28early%2C%20when%20the%20DLL%20gets%20loaded%29%0D%0A%20%20System%3A%3AAppDomain%20%5E%20currentDomain%20%3D%20AppDomain%3A%3ACurrentDomain%3B%0D%0A%20%20currentDomain-%3EAssemblyResolve%20%2B%3D%20gcnew%20ResolveEventHandler%28LoadFromSameFolder%29%3B%0D%0A%20%20arasDo%28%29%3B%0D%0A%7D] The exePath does not exist Assembly.GetEntryAssembly() returns a NULL Can someone explain me how to execute the added cpp sample code so I can load the aras 2023 dlls?Self-update from Innovator 12 to Release 2023 - Join the ride! Share the joy!
Hi community, is anyone here who plans to update from Innovator 12SP9 to Release 2023 but doesn´t have the luxury of using the Aras update service? I plan (to try) to update 1-2 instances from Innovator 12 to 2023 within this year. The process requires a lot of research and preparation. So I would be happy to hear if other users want to achieve something similar. Maybe we can exchange some experience? Release 2023 self-update requires a full move of all data from one instance to another. So this can be more considered a "full migration". Basically we have these tasks to solve: 1. Cleanup and document existing instance - Achieve 100% documentation rate of literally everything ever touched in the instance 2. Prepare new instance - Merge codetree customizations, custom database applications, customized Aras components and similar - Update all components to fit Release 2023 (I expect .NET Core changes require some work, but I assume also UI needs some update) 3. Merge actual data / cutover - This one requires a lot of scripting and tons of test runs. From my POV the most risky part of the whole process. Cutover time has to be minimal and 100% of the life data (Parts, Files, Workflows,.... including all the involved background tables) has to be accurately transferred. Important: This thread is not indented to promote self-update "as easy to do fun process". Neither shall it encourage you to discontinue your subscription to save some money, cause it doesn´t. Self-update process takes an enormous amount of time and preparation, you bear all the risks and in the end you can still fail. So if you have a subscription, be happy about it, be nice to the update team, keep you database tidy and write proper test cases! This thread is mainly intended to user groups too small to qualify for subscription and if you have less complex use cases. Best regards AngelaWhere and how does the new TOC Editor in Release 2023 store it´s data?
Hi community, In Release 2023 Aras replaced the classical TOC Access / TOC View ItemType tables with the "TOC editor". The two tables are not used anymore in Release 2023 and completely empty. When updating an existing db based on Innovator 12, we have to modify the imports to support the new way to config the TOC. Sure we can use the TOC Editor to modify the structure later, but I prefer the update process includes the correct TOC settings so I can reduce cutover time. Does anyone know, which table the TOC editor uses to store the new structure? Is it solely done in the "Client Presentations"? And which table is used to store the TOC editor "TOC View" symbol itself? It would be interesting to understand how the TOC editor itself works. But the ItemType obviously wasn´t named "TOC Editor" and so far I weren´t able to identify it. Thanks for any help! Angela
