We have tried to install ARAS Innovator 12.0 on a PC a few times over the last couple of days and have hit various different errors when trying to login. This time, I decided to delete the InnovatorSolutions DB that was created by the first install and have the install process recreate it. Now, when trying to log in with admin/innovator for the first time, I get the error "Invalid object name 'LOCALE'." How can I troubleshoot this? Is there any additional information I should post? Thanks,

Hey Neil, Kind of same thing on my end. I had to bring in a colleague that had more experience with server database management, he did a very thorough manual deleting of old database traces, and then I was able to get a working new install. It is frustrating that ARAS does not remove these traces in its included uninstall, and I still don't know what really went wrong on the first once, nor do I know what specific part of the old installs were causing the issue. All I can say to people reading this from Google is - do a very thorough removal of old databases through a SQL server manager. This seemed to work for me.

Bumping this thread for additional advice. I would really like to get going using the software, but this error has us stumped.

Surely someone has seen this issue before. Any advice would be appreciated.

Hello, I haven't seen this issue before myself, but I found some older forum posts that suggested this was an issue with the configuration of the SQL Server users. Typically the Aras Innovator installer handles this configuration of the users automatically, but I've seen people report other login issues when they tried to install Aras Innovator onto a machine that they did not have admin privileges for. I'd recommend trying to configure these users manually to see if that resolves the issue. Section 8 of the Aras Innovator installation guide covers how the users in SQL Server need to configured. You can find that document as well as some other useful guides here. Chris Christopher Gillis Aras Labs Software Engineer

Hey Chris, Thanks for the response. I have opened up the users in MS SQL Server Management Studio for the database and have checked the following roles to try to match what I read in the install guide. Is this the correct spot I should be setting these? Do these look correct to you? I'm pretty new to all of this. Thanks,

First-time login: Invalid object name 'LOCALE'.

18 Replies

mstemple
Ideator II
7 years ago
Bumping this thread for additional advice. I would really like to get going using the software, but this error has us stumped.
- neil_lindberg
  Creator III
  6 years ago
  Use the MS SQL Management Studio to see if there is a table under your db, "innovator.LOCALE".
  
  PATH: Databases > YOUR_DB_NAME (default InnovatorSolutions) > Tables:
  
  Mine were not there so I had to meticulously remove users from previous install attempts, also using MSSMS, throughout the DB, and reinstall.
  
  Of course, this is way late. Just hoping to help the next person stuck here...
mstemple
Ideator II
7 years ago
Surely someone has seen this issue before. Any advice would be appreciated.
christopher_gillis
Community Manager
7 years ago
Hello,

I haven't seen this issue before myself, but I found some older forum posts that suggested this was an issue with the configuration of the SQL Server users. Typically the Aras Innovator installer handles this configuration of the users automatically, but I've seen people report other login issues when they tried to install Aras Innovator onto a machine that they did not have admin privileges for.

I'd recommend trying to configure these users manually to see if that resolves the issue. Section 8 of the Aras Innovator installation guide covers how the users in SQL Server need to configured. You can find that document as well as some other useful guides here.

Chris

Christopher Gillis

Aras Labs Software Engineer
- mstemple
  Ideator II
  7 years ago
  Hey Chris,
  
  Thanks for the response. I have opened up the users in MS SQL Server Management Studio for the database and have checked the following roles to try to match what I read in the install guide. Is this the correct spot I should be setting these? Do these look correct to you? I'm pretty new to all of this.
  
  Thanks,
mstemple
Ideator II
7 years ago
Hey Chris,

I am still encountering the same error. Can you take a look at the permissions in my previous reply and let me know if anything looks wrong?

Thanks,
- christopher_gillis
  Community Manager
  7 years ago
  Hello,
  
  I compared the screenshots you sent me with the settings on a 12.0 database I have set up locally. I'm seeing a difference in that the users in my database don't have db_accessadmin membership. I'm not sure this alone would cause the issue, but it does indicate that these users were configured differently than expected.
  
  Can you confirm that you have administrative access on the machine running SQL Server? When you run the installer, are you configuring the database using Windows Authentication credentials or with the built in sa SQL Server user?
  
  Chris
  - mstemple
    Ideator II
    7 years ago
    I tried unchecking db_accessadmin but that did not change anything. I used Windows Authentication credentials and do have admin access to the server.
neil_lindberg
Creator III
6 years ago
Same problem, but different setup. I wanted a 12 and 11 both on the same machine. I had it all working, but I had 12 installed all with defaults and then 11 with tacked-on "11"s everywhere. When writing a guide I decided it should approach at the least different versions on the same system. So, I uninstalled both versions, deleted the associated DBs, and re-installed where both used settings that included the version number (folder locations, paths, vault folder, etc. - db users, everything). I can log into 12 right away w/o issue. 11 shows this error when attempting to log in... I've not found my answer in this thread, but will comment when I do.
- mstemple
  Ideator II
  6 years ago
  Hey Neil,
  
  Kind of same thing on my end. I had to bring in a colleague that had more experience with server database management, he did a very thorough manual deleting of old database traces, and then I was able to get a working new install. It is frustrating that ARAS does not remove these traces in its included uninstall, and I still don't know what really went wrong on the first once, nor do I know what specific part of the old installs were causing the issue.
  
  All I can say to people reading this from Google is - do a very thorough removal of old databases through a SQL server manager. This seemed to work for me.
  - neil_lindberg
    Creator III
    6 years ago
    Thank you for sharing this. Seems we found a solution! :)
- neil_lindberg
  Creator III
  6 years ago
  
  As you can see, my 12 has a ton more tables. These do include "innovator.LOCALE". My Innovator11 db includes none of these. I've tried re-installation of 11 to no avail. Section 8 of the guide didn't shed any light on this problem.
  - neil_lindberg
    Creator III
    6 years ago
    I meticulously walked through the mess using Microsoft SQL Server Manangement Studio, as Admin, and deleted any reference to my innovator11 and innovator_regular11 users. I also deleted my InnovatorSolutions11 db altogether. Again, reinstalling, I saw this for the first time doing 11. Before it just kinda hung awhile, no feedback, I thought that was just a UX improvement between 11 and 12...