SUPPORT Q&A - Error 27506. Error executing SQl script CoreAndSolutions.sql

htorun - Monday, March 29, 2010 5:04 PM:

Hi,

I received the following error while installing Aras Innovator v9.1.0, during database configuration:

"Error 27506.  Error executing SQL script CoreAndSolutions.sql.  Line 81601.  Must declare the scalar variable "@project_id". (137)"

Searching the forum, I have found a very similar post but there was not much help there: http://www.aras.comhttp://www.aras.com/Community/forums/t/304.aspx 

I am using the latest installer for windows, have IIS and SQL server running. The installer creates InnovatorSolution DB and tables inside until I get this error.

Any ideas, solutions?

Thanks in advance,

Hami

htorun - Saturday, April 3, 2010 6:39 AM:

Tried version 9.2 hoping that it will solve my problem but still getting the same error.

Looks like inside the sql script the variable @project_id is used before it is declared or it is used inside a dynamic SQL but declared outside of it (scope issue).

Any suggestions? Anyone having the same issue?

Thanks

RobMcAveney - Saturday, April 3, 2010 11:24 AM:

Not sure what the error is about, but you should be able to work around it.  In the installer, choose the "Configure Only" option for the database.  This will set up the configuration file without actually creating a database.  After you're done with the installer, go into SQL Server Management Studio and restore CoreAndSolutions92.bak as a database with the same name you used in the installer  (e.g. InnovatorSolutions).  After the database is restored you'll need to run the following SQL to sync the SQL Server Login with the User in your db:

sp_change_users_login 'Auto_Fix','innovator';

Once those steps are complete, you should be able to run Innovator normally.

Rob

htorun - Sunday, April 4, 2010 1:45 AM:

Thank you very much Rob. I did what you suggested and was able to install without any error.

But when I tried to run Innovator I received the following error:

" Aras Innovator client has failed to initialize. Some required controls('IEClient.dll') were not loaded. Reinstalling application may solve this problem."

I uninstalled and reinstalled just to get the same error. So I checked Innovator/Client/default.aspx and found the following HTML error:

<object id="ieClient" classid="cbin/IEClient.dll#Aras.Innovator.IEClient" style="width: 1px; height: 1px;">
        <param name="CustomBuildVersion" value="<%= ieClientSettings.CustomBuildVersion %>">">
        <param name="RequiredSyncMode5" value="<%= ieClientSettings.RequiredSyncMode5 %>">">
      </object>

At the end of <param> lines there were extra "> characters, so I removed them (it seems like Aras did not even run their installer once to see if it was installing a running version of their software). Anyways, after fixing this, I received an other error:

"Aras Innovator client has failed to initialize.
Please, contact your system administrator to review your .NET security settings."

At first it seems like I did something wrong configuring the .NET client security policy but I followed the instructions in the manual, checked sdns.NET.2.0.log, put localhost to trusted zones, enabled everything in IE Internet Options and all. Everything regarding .NET security seems OK but I am still getting the same error. Searching the internet and this forum, I can see that I am not the only one having similar difficulties.

Too many bugs, errors and difficulties for me to install a software just to evaluate it. In fact, all this gave me an overall idea about the software so I consider it evaluated.

RobMcAveney - Sunday, April 4, 2010 10:44 AM:

I understand your frustrations, but I urge you to reconsider.  I have installed the software dozens of times on a number of different computers and have not experienced much in the way of errors.  Remember, this is enterprise software akin to SharePoint or an ERP system.  There are a lot of moving parts, and there's bound to be some configuration differences that were not anticipated in the installer.  Also, please consider your alternative -- paying exorbitant upfront license fees to another PLM vendor for the privilege of having a consultant come install it for you :-)

htorun - Sunday, April 4, 2010 2:03 PM:

Rob, thank you for your reply.

The sad thing is I was the one explaining all this to my colleagues and promoting open source solutions in general and Aras in particular as I have installed, implemented and contributed to several open source projects. I may have overreacted because the pressure is building on me to evaluate the alternatives and chose one.

Therefore I would appriciate any help, alternative manual installation suggestions or even link to a previous version of the windows installer tested and known to be working.

Regards,

Hami

dubhe - Wednesday, November 3, 2010 6:14 PM:

Hami,

Did you ever manage to install Aras?

We are trying to install it on a brand new SBS 2008 and are seeing the exact same issue with IEClient.dll.

After removing the two extra ">'s that seem to have sneak its way into default.aspx we are now getting:

allenyyang - Saturday, December 4, 2010 10:28 PM:

I got the same error while configuring a Windows 7 client to access Aras Innovator 9.20. Build 5562.

"Some required controls('IEClient.dll') were not loaded. Reinstalling application may solve this problem."