To create a new Data Base without administrative rights on the computer
Hello, I would like to add new data bases in my ARAS Innovator 11 SP12, with corresponding selection at login popup windows, but without using installation wizard that needs administrative rights on the computer. There is a way to do that? Thank you, Vincent.
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
Commit the transaction half way through the code and continue the execution from there.
Hi Team, We have a scenario where we want to commit the transaction half way through the code and continue the execution from there. For example : 1. We are working on Background tasks implementation 2. Where we want to change the status [property] of the task from "new" to "in progress" at the beginning of the execution of task. 3. After that we execute some business logic. 4. Later we change the status of task from "in progress" to "done"/"failed" based on the result from 3rd step. What we have observed is Aras considers step 2-4 as a single transaction and commits that at once. But we want to see the change in status of task from new -> in progress [step 2] -> done/failed. [This change of status is must.] We found an reference from Aras Community, where we can use the "CCO.DB.InnDatabase.CommitTransaction();", to commit the transaction half way and continue from there. Questions : 1. Are there any repercussions/issues by using the solution that we have found ? 2. Is there any other way to achieve this ? Thanks !Error during database setup and admin login
Hello, I've followed the YouTube installation videos and installation guide PDFs to the letter several times, but it seems I can not get past an error. When I click "configure database" during Aras Innovator installation, after about a minute or two of what seems to be useful work, I get an error message that says: "Error 27506. Error executing SQL script CoreAndSolutions.sql. Line 136543. Must declare the scalar variable "@EXISTING_ID". (137)" I then hit OK and the "database installation process" stops without any further errors. At this point I don't know whether the installer attempted to continue to do other stuff or just gave up after the above error. I then click "Next" in the installer and continue Aras installation. There are no further errors and the installation is completed. I then go to: localhost/.../ and the login screen pops up. I enter "admin" as username and "innovator" as password, but I get the following message and can not proceed further: "Invalid column name 'id'." I started SQL management studio to check the DB, and the "InnovatorSolutions" db appears to be in there. Owner is "sa", size is 62.75MBi Number of users 6, Collation: Turkish_CI_AS This is a Windows 7, 64-bit system. SQL server is SQL Express 2014. Aras innovator is the latest innovator as of June 2018. We tried the entire installation process 3 times to no avail. We'd appreciate any help with this issue.
