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 - Database exception

オフライン Archive User 18 年以上前

DenizEralp - Monday, June 25, 2007 11:51 AM:

Hi Bill,

With all your help I managed to overcome most of the errors. Now my problem is the database exception at the first login.

I checked the post in the forum regarding this problem, but that error was overcome by a clean installation. That did not help me.

Everything works fine during the installation. I create a new database, no problem occurs. After the database creation the database parameters window (3.3.14 in the installation manual) appears again. I choose `existing database` and configure. No problem occurs again.

But when I try to log in using the `admin` to this database I see the following exception:

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')

What can I do?

Bill - Monday, June 25, 2007 3:58 PM:

1) Did you use the installer to install the databse, or did you restore it from a backup?

2) Can you examine your InnovatorServerConfig.xml file?

Open the file C:Program FilesArasInnovatorInnovatorServerConfig.xml

This is an example of the contents:

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

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

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

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

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

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

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

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

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

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

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

</Innovator>

You need to make the following changes:

1) Replace the license section

Replace 48d2df96aab6922ccc92d5ba5f0923f1 with your license key

2) Set the smtp server value

Replace queue with the connection string to your smtp server. Conversely, you can leave “queue” and configure IIS smtp server. “queue” refers to the IIS mail queue.

3) Change the file path to that of your install.

C:Program FilesArasInnovator

Refers to the install path, this value is the default.

4) Fix the connection string for the database

id="InnovatorSolutions"

This is the name that will be display for what database you will log into. This usually matches the database name, but does not have to. If it does not match your database name, please pick the name carefully, changing it later has affects on the vault.

database="InnovatorSolutions"

This is the name of the database you will use in SQL Server.

server="localhost"

Localhost is the default, but it is the name of the SQL Server instance

For standard SQL Server 2000 and 2005 use localhost or the machine name

For SQL Server 2005 Express, you will need to specify something like MACHINENAMESQLEXPRESS

SUPPORT Q&A - Database exception

Legal

Connect With Us