I just installed Aras for evaluation purposes and turned it over to a couple of people to test.  When the user tries to add a new project, they get the following error:

"The method associated with the server event onAfterAdd failed: InnovatorDatabaseException: Invalid object name 'SELECT_CRITICAL_PATH_SCHEDULE'. Warning: Null value is eliminated by an aggregate or other SET operation.  in SQL: exec udpate_schedule <then a bunch of numbers> Error while running method SQL process"

 Here is a screenshot of the errors:

http://www.digecor.com/temp/error.jpg (~60k)

http://www.digecor.com/temp/error_detail.jpg (~600k)

Any ideas?

1) What OS are you running the server and database in?  (Windows Server 2003 English)

2) Is this the standard InnovatorSolutions database, without customization?

1. Windows Server 2008 Standard, MS SQL 2005.  These are both eval editions, but are fully functional.

2. I just did a standard installation since I am testing the setup.  I did have a bit of trouble getting the database going, but I finally got it working up until this point. (Had to uninstall Innovator, nuke the database, and then reinstall again.)

 

 

 

Anybody have any ideas on this?  I'm evaluating the product -- is there a better way to get support?  However, I'm kind of also curious how well the community support works.

My guess would be that you have made the login assigned to the innovator user a dba.

When you install the database, did you use make a new login for the innovator user or use an existing user?

-Bill

I believe I used the administrator account on the machine.  I'm sure that it was a dba.  How/what do I change this after the fact?

I created a new db user for innovator and modified the innovator settings file to use the new login, but I'm still getting errors.  I'm not sure how to make sure the user has the right access.

I would hate to have to uninstall and start the entire installation again.  Can anybody help?

 

For the archive...

Since I didn't have any data in my database, support suggested that I delete the database and restore a backup copy of it and then grant access. Here's the scoop...

1.       Log into SQL Server Management Studio
2.       Delete the current Aras Innovator Solutions database
3.       Right click on the Security tab and create a new login
a.       Login Name: innovator
b.      Select  SQL Server Authentication radio button
c.       Enter your password
d.      Click OK
4.       Right click on Databases from the TOC and select Restore Database
a.       Enter the database name into the text box for “To Database” field
b.      Select “From Device” radio button
c.       Click on the Ellipse and select add
d.      Browse to root of your Aras Innovator Installation directory and select \\Innovator\Server\DB\CoreAndSolutions90.bak
e.      Click OK
f.        Check off Restore
5.       Select the Options located in the TOC for Restore Database
6.       Check off Overwrite the Existing Database
7.       Under the “Restore As” column select the location you want your Database files to be stored. (Currently set to the SQL Server default directory)
8.       Click OK to restore the database.
9.       After successful restore run each of the following three queries on the newly restored database
a.       sp_change_users_login 'Update_One','innovator','innovator'
                        i.      Completed Successfully
b.      sp_grantdbaccess 'innovator','innovator'
                        i.      Errors out (this is proper behavior)
c.       sp_addrolemember 'db_owner','innovator'
                        i.      Completed Successfully
10.   Now you must edit the InnovatorServerConfig.xml file located in the root of your Aras Innovator installation.
11.   From initial installation with the “broken” database the config file should contain a line like the following (fields in  yellow may need to be changed):
<DB-Connection id="InnovatorSolutions" database="InnovatorSolutions" server="(local)" uid="innovator" pwd="innovator" dbType="SQL Server" />
a.       id- Name of database as seen in Login Screen for Aras Innovator from the database dropdown menu
b.      database- Name of the SQL Server Database
c.       server- Name of SQL Server (local) should be fine if on the SQL Server is on same machine as Aras Innovator Server
d.      uid- login name you created in 3
e.      pwd- password to login created in step 3
12.   Save the config file.