benguela - Monday, April 23, 2007 7:33 AM:
I get the following error when I tried to login with the client after I installed Innovator
Exception during initialization (InnovatorDatabaseException): Invalid columne name 'id'. Invalid column name 'login_name'. Invalid column name 'password'. Invalid column name 'logon_enabled'. In SQL: SELECT id FROM [USER] WHERE login_name='admin' AND password='42de...8e02' AND login_enabled='1')
Running on Windows 2003, SQL Server 2000
Any help appreciated.
thanks.
SamsAn - Monday, April 23, 2007 12:04 PM:
Hi.
Please, check first: do id, login_name, logon_enabled columns exist in USER database table (it may be that the database is corrupted because of some reasons).
If these columns do not exist then it would be better to install another database and use it.
Bill - Monday, April 23, 2007 5:11 PM:
Hello, benguela, and welcome to the forums.
I will start by assuming that you selected "Create a new database" and not "Use and existing database" when selecting the database creation parameters during install. (See Section 3.3.14 of the Aras Innovator - Installation Guide.)
Because you say this is "After initial setup", my first guess on this is that the database failed to install properly.
If you want the "quick" fix, I would recommend just re-installing Aras Innovator, because you have not done any customizations, yet.
If you do not wish to do a full re-install, we can provide some steps for restoring the database from a backup copy of the installation database.
Hope this helps,
Bill
benguela - Tuesday, April 24, 2007 9:47 AM:
"After initial setup" means that I installed innovator and it created the database just fine, I can see the User table in SQLServer enterprise and it contains all the correct columns but still I get the same error when I try login.
I gave up and installed innovator on another box and that worked fine. However now I am not able to save attached files on an ECR but I explain this in another topic in this forum.
Deacon - Tuesday, May 29, 2007 6:00 PM:
Reinstall database server and restored the database. Process innovator is running on another server. I am getting Exception During Initialization. Can you please help?
snnicky - Wednesday, May 30, 2007 2:26 AM:
Hello Deacon.
It is very likely you need to run the following SQL for the restored DB
EXEC sp_change_users_login 'Update_One', 'innovator', 'innovator'
Explanation:
The backup of the DB you restored was created on another database server instance. Thus SQL Server login innovator had some id associated with that. Let's say that was 123. In your new SQL Server instance SQL Server login innovator has some different id. Let's say it is 456. And even login names are the same restored DB cannot function properly without additional work. Thus :
1) Ensure you have login innovator defined in your newly installed SQL Server.
2) Run sql EXEC sp_change_users_login 'Update_One', 'innovator', 'innovator' to associate SQL Server login innovator with restored DB user innovator.
Let us know if this helped you.
Thank you.