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 - Empty database list

matthewpace - Friday, May 4, 2012 6:49 PM:

I'm able to get to the login box at arasservername/.../Client now, but the database drop down menu is empty.  I actually have two databases set up, but neither is showing.

A few questions to help me debug this: Does Innovator check to see if the connections are valid before it lists them in the drop down box, or does it list them, then attempt a connection at login? Do I need to tell the SQL server to listen on any TCP/IP ports?  The SQL database is on the same server as the Innovator installation...

Things I've checked:

  • SQL instances are running
  • logins work as listed in xml file (via MS SQL management studio express)
  • added a second connection option to xml file, stopped IIS, restarted IE and IIS, and page still loads with no options in drop down box
  • changed "(local)" to 127.0.0.1, localhost, and the name of the machine, all to no avail.

Here's my InnovatorServerConfig.xml file, with the passwords asterisked out for my protection

 

<?xml version="1.0" encoding="utf-8"?>

<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="6fc8e8525c61e6d5e94e57b48ec27c24"></License>

  <Mail SMTPServer="mail026-1.exch026.serverdata.net"></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="InnovatorSolutions2" database="InnovatorSolutions" server="(local)INNOVATORINSTANC" uid="innoadmin" pwd="***" dbType="SQL Server" />

  <DB-Connection id="InnovatorSolutions" database="InnovatorSolutions" server="(local)SQLEXPRESS" uid="arasadmin" pwd="***" dbType="SQL Server" />

</Innovato



vishal_trivedi - Saturday, May 5, 2012 1:54 AM:

Hi Matthew,

- Get new license key from www.aras.com/.../

- Edit below attribute 'lic_key' and set new license key at  \InnovatorInnovatorServerConfig.xml

"<License lic_type="Unlimited" lic_key="6fc8e8525c61e6d5e94e57b48ec27c24"></License>"

- Vishal

 

 



matthewpace - Monday, May 7, 2012 1:06 PM:

I just tried that, but I cannot get Aras to issue me a new license through that tool.  Aras is just sending me the same license key.  I tried different company names and email addresses too, but it seems like it's based solely on MAC address, if anything.

 

Any other suggestions, or ways to get a new license key?



Brian - Monday, May 7, 2012 5:58 PM:

Hi Matthew,

The licence key is based on the MAC address so you will always get the same key for the same machine.

Check on the Documentation page of this site for release 9.2 (I think) Client Clean procedure. This has been recommended to me in the past to try to fix this issue. Essentially it helps to reset the client environment. Once you have done this then try again.

I have had this same problem in the past but it has always been resolved by ensuring that I have the correct licence key in the config file.

You could also try logging in from another client to see if this is specific to the client or more general.

Innovator does not test the validity of the log on information before it lists them in the login screen.

Hope this helps,

Brian.