This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SUPPORT Q&A - No database dropdown item on login form

sinoyuwenho - Tuesday, November 2, 2010 3:43 AM:

Hi

  I just finished Aras PLM 9.2.0 installation on Windows Server 2008 R2/IIS 7.5 + .NET Framework 3.5 + SQL Server 2008 R2. Here is the question that I met:

 On server machine, I can open login form by IE, but there is no any database dropdown item on it. Of course I see "Missing database" if I enter admin/innovator and click login. The DB setting is correct in C:Program Files (x86)ArasInnovatorInnovatorServerConfig.xml, I can login into SQL server to see new tables of InnovatorSolutions by that setting using SQL Server Mgt Console. Would anyone tell me what's wrong with it?

Thanks in advanced!



Brian - Tuesday, November 2, 2010 6:39 AM:

Hi,

Can you post the InnovatorServerConfig file so we can see the database connection string?

Cheers,

Brian.



wmcheung - Friday, May 6, 2011 3:32 AM:

Hi,

Have you solved the problem of missing database selection drop down?

I have encountered the problem.

My testing server platform is

- Windows Server 2008 Standard Edition Service Pack 1

- IIS7.0

- .NET 3.5

- SQL Server 2008

Client platform

- Windows XP

- .NET 2.0

- IE6 or IE7

Here is the result:

 

 

Here is my InnovatorServerConfig.xml:

====================================================================================================================

<Innovator>

  <UI-Tailoring login_logo="../images/logos/innovator_splash.jpg" branding_img="../images/logos/banner_02.jpg" product_name="Aras Innovator" banner_url="../scripts/banner.aspx" banner_height="50"></UI-Tailoring>

 

  <IEClient RequiredSyncMode5="Never" CustomBuildVersion="1" />

  <operating_parameter key="DebugServerMethod" value="true" />

  <operating_parameter key="debug_log_flag" value="true"></operating_parameter>

  <operating_parameter key="debug_log_limit" value="10000"></operating_parameter>

  <operating_parameter key="debug_log_pretty" value="true"></operating_parameter>

  <disabled_operating_parameter key="performance_logging" value="cpu"></disabled_operating_parameter>

  <operating_parameter key="xslt_processor_debug" value="false"></operating_parameter>

  <disabled_operating_parameter key="email_debug_option" value="file"></disabled_operating_parameter>

  <License lic_type="Unlimited" lic_key="40fd38d54b10bf3d529b34deb09ba1da"></License>

  <Mail SMTPServer="queue"></Mail>

  <operating_parameter key="temp_folder" value="C:Program FilesArasInnovatorInnovatorServer emp"></operating_parameter>

  <operating_parameter key="ServerMethodTempDir" value="C:Program FilesArasInnovatorInnovatorServerdll"></operating_parameter>

  <operating_parameter key="debug_log_prefix" value="C:Program FilesArasInnovatorInnovatorServerLogs"></operating_parameter>

  <DB-Connection id="InnovatorSolutions" database="InnovatorSolutions" server="SVR09" uid="innovator" pwd="password" dbType="SQL Server" />

</Innovator>

====================================================================================================================

 

 



authentic - Monday, August 15, 2011 3:59 AM:

888Tiger4:

Moncler name came from the abbreviation in Monestier de Clermon. Our Moncler Outlet specializes in the production of outdoor sports equipment. We provide the Cheap Moncler Jackets you will just love. Our Moncler Jackets Outlet is secured and trusted by the world. Our products reach a large variety, including vests for all ages, such as the Kids Moncler Jackets which looks wonderful on the little boys and girls. Also, come and take a look, you will find the one Moncler Jackets For Women made just for you. Moncler went through a long history to reach its place today. Our Moncler Jackets Men and Moncler Shirt Women are up to date with the latest fashion trends. At the same time, Moncler Vest Men and the Moncler Vest Womens is made from the best materials and can keep you away from the harms of the bitter cold this coming winter. If you are a person extremely afraid of the cold like me, I would recommend you the Moncler Scarf which will keep your neck cosy and warm in the snow. Another one of my favorites is the Women Moncler Long Down Jacket which can give you the mysterious look as you stroll down the path in the white snow.

 



sinoyuwenho - Tuesday, November 2, 2010 9:18 PM:

Thanks for the reply. Here is the content of InnovatorServerConfig (I didn't change it at all, it's all default setting)

<Innovator>
  <UI-Tailoring login_logo="../images/logos/innovator_splash.jpg" branding_img="../images/logos/banner_02.jpg" product_name="Aras Innovator" banner_url="../scripts/banner.aspx" banner_height="50"></UI-Tailoring>

  <IEClient RequiredSyncMode5="Never" CustomBuildVersion="" />

  <operating_parameter key="debug_log_flag" value="false"></operating_parameter>
  <operating_parameter key="debug_log_limit" value="10000"></operating_parameter>
  <operating_parameter key="debug_log_pretty" value="true"></operating_parameter>
  <disabled_operating_parameter key="performance_logging" value="cpu"></disabled_operating_parameter>
  <operating_parameter key="xslt_processor_debug" value="false"></operating_parameter>
  <disabled_operating_parameter key="email_debug_option" value="file"></disabled_operating_parameter>
  <License lic_type="Unlimited" lic_key="cc04f5323eecf8abbaf0e3548b9e8c87"></License>
  <Mail SMTPServer="queue"></Mail>
  <operating_parameter key="temp_folder" value="C:Program Files (x86)ArasInnovatorInnovatorServer emp"></operating_parameter>
  <operating_parameter key="ServerMethodTempDir" value="C:Program Files (x86)ArasInnovatorInnovatorServerdll"></operating_parameter>
  <operating_parameter key="debug_log_prefix" value="C:Program Files (x86)ArasInnovatorInnovatorServerLogs"></operating_parameter>
  <DB-Connection id="InnovatorSolutions" database="InnovatorSolutions" server="(local)" uid="innovator" pwd="innovator" dbType="SQL Server" />
</Innovator>

 



jweipert - Friday, May 11, 2012 3:42 PM:

I found that the MAC Address of your Computer or Server Hosting the Aras Innovator Application may have changed since you installed Aras Innovator.  Especially if your Server is running in a VM.

This will result in your InnovatorServerConfig.xml file referencing an invalid License Key.

1 - Run IPCONFIG /ALL from the DOS Command and get the MAC Address

2 - Request new License Key from ARAS

3 - update your InnovatorServerConfig.xml file with the new Key Aras sends you

* This fixed my issue that occurred today :)

** Look at your Server's Administrative Events for Warnings or Errors...  Server Manager | Diagnostics | Event Viewer | Custom View | Server Roles | Administrative Events

Mine shows the following Warning :

   Source: ASP .NET 2.0.50727.0

   Task Category: Web Event

   Exception Type: ServerConfgException

   Exception message: License Key is Invalid.

Good Luck!



Brian - Thursday, November 4, 2010 1:59 AM:

I'm not sure what is happening here but I think that some of your settings may not have been correct during the install process.

The line <DB-Connection...../> includes an attribute 'server="(local)".  This is the SQL Server instance that the database is part of. There is no SQL Server instance included in this string. I would have expected something like 'server="(local)SQLEXPRESS" This is set on the "Create Database" screen of the Install process at the top of the form there is a dropdown where you can select the SQL Server Instance. It defaults to (local) but you need to select an actual instance.

What operating system are you installing under?

I would be inclined to remove innovator and try the install again.

Cheers,

Brian.