Aras Update Guide: Self-Upgrading Innovator Independently
After plenty of trial and error – and some much-needed help from Aras Denmark – we finally got the Aras Update application working. We wanted to handle upgrades independently to reduce reliance on the upgrade team and speed up our deployment cycles. The catch? The Aras Update installer only runs smoothly on a clean, out-of-the-box Innovator installation, which is rarely the case in real-world production environments. To save others from the same headaches, I’ve documented the steps for anyone brave enough to attempt a self-upgrade. Note: This process is supported from Release 14 onwards. It’s recommended that an experienced software engineer performs these steps. Attempt at your own risk. 1. Prepare a Clone of Production Install your current Aras version on a separate machine using the ‘Configure Only’ option. Restore a recent production .bak file in SQL Server Management Studio. Run the following queries against the cloned database: exec sp_change_users_login 'Update_One', 'innovator', 'innovator'; exec sp_addrolemember 'db_owner','innovator'; exec sp_change_users_login 'Update_One', 'innovator_regular', 'innovator_regular'; exec sp_addrolemember 'db_owner','innovator_regular'; Update the InnovatorServiceConfig.xml with the correct SQL connection string 2. Install Prerequisites Install all required prerequisites from the Installation Guide PDF for the desired target version. 3. Back Up Your Code Make a backup of the Innovator folder (your code tree). 4. Download the Patch Get the desired patch from the Aras FTP. You do not have to go through each version. E.g., you can go from Release 26 to Release 34 directly. 5. Customize Patch Files In the following files, append a custom suffix to the <name> property (e.g., <name>VersionServiceUpdate[YOURCOMPANYNAME]</name>): VersionBuild.xml VersionLabel.xml VersionMajor.xml VersionMinor.xml VersionServiceUpdate.xml 6. Launch Aras Update Run Aras Update as Administrator. 7. Add the Patch Package Click ‘Local’ in the left menu and add a new package. Select the extracted patch folder. 8. Install the Patch Click ‘Install’ in Aras Update. 9. Update Each Module For each applicable module: Select only one module at a time (this helps isolate issues). Enter the required application/server/SQL credentials. Click ‘Install’. If errors occur: Login to Innovator failed: Check prerequisites and ensure IIS is running. TRUNCATE or FOREIGN KEY errors: Compare the affected ItemType with one from a clean install. Adjust the related XML file in .\Aras Innovator 34 Patch\Imports\com\aras\innovator\ as needed, or temporarily remove it from the manifest (keep a backup for step 11). Oftentimes, it has something to do with property lengths, foreign properties and permissions. Innovator Variables issues: Revisit step 5. GetMethodsKey endpoint (500 Internal Server Error): Make sure a user with loginname clientadmin exists in the database. Add it through nash.aspx Other: If you hit something else, prepare for some blood, sweat, and forum searches – or maybe it’s time to reach out to the support team. Do not forget to leave the error message and solution in the comments down below. Tip: if you need many attempts running the Aras Update installer, do not click 'Exit' when it fails. If you click 'Home' instead you do not have to enter the server credentials every attempt. 10. Verify the Update If the update completes without errors, try logging in. If login fails: Use the NASH endpoint (e.g., localhost/.../nash.aspx) to manually execute the contents of any removed XML manifest files. Use DevTools (F12 > Network) to check for failed requests. 11. Test Everything Test all features and modules. If Aras features have changed, manual conversion may be needed. I recommend writing down test plans with relevant key-users to confirm everything still works Review Release Notes for all versions between your source and target version and perform tests accordingly. Keep a checklist of manual actions required. Repeat the entire process – including running the Aras Update installer and performing all your documented manual actions – until a clean test environment upgrades completely without errors or issues, and all tests pass, before moving on to the cutover step. 12. Plan Production Cutover Schedule a cutover weekend to upgrade production. Run your customized Aras Update Patch and complete any manual steps identified in testing. Congratulations You’ve now performed a self-upgrade. Time to celebrate. Just remember: this isn’t formal documentation, and I’m not responsible for any production issues you may face as a result of following these steps.
On the Aras Innovator login screen, the database drop-down list does not show any entries.
After installing Aras Innovator, I attempted to log in, but the database drop-down list is empty. I expected the database created during the Aras Innovator installation to appear in the list. Could you please tell me why the database drop-down list is empty? The versions are as follows: Aras Innovator: 14.35 SQL Server: 2022 Express Microsoft .NET: 8.0.16 I followed the installation procedure from the link below: https://aras.com/ja-jp/blog/aras-innovator-install
Response speed of the ver11 become fast?
Hello all, I manage some development team of Aras Innovator for my clients. Some clients needs to become fast of response speed ver11 Sp8/15. Actually, upload xls/csv file to Aras and searching are very slowly response, 5mins or more. I'd already confirmed network speed, server spec, DB tuning, a lot of times. But, Aras DB will rock and down about uploading file or searching. Please, shared this and discuss or advice me. Thanks.
Backup only the newly added customization part
Hello, Is there any way to backup & restore only the customization part realized inside the Aras Innovator 11? I managed to realize a full database backup & restore on my Aras system, but this way all the test data, which were added during the customization process are backed up and moved to the new environment and I would like to avoid that. Thanks! Chris