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 - Demo Database 9.0.1 BL6 ITEMTYPE table missing columns

jupakka - Monday, June 15, 2009 4:02 AM:

Hi,

I loaded the Demo Database 9.0.1 BL6 on to a working 9.0.1 installation. When I try to log in to the demo database (BasicsDemo901) as user 'Bill' (or the others), I get an error:

Invalid column name 'enforce_discovery'.

I compared the ITEMTYPE table of the demo database with the working installation's table and noticed the table is missing several colums like ENFORCE_DISCOVERY, CLASS_STRUCTURE, HISTORY_TEMPLATE, CACHE_QUERY
and has the following that don't exist in the clean install database:
SAVE_HISTORY, HISTORY_ID, DEFAULT_LIFECYCLE, CACHE_QUERY, CLASS_STRUCTURE, label_plural_de, label_de, help_url_de.

To my best understanding I installed the needed updates from BL5 and BL6. Reasoning from the fact that there are german language (de) specific tables in the demo database, am I missing some language specific updates or is there something majorly wrong with the demo installation?

TIA,
juha



Anonymous - Monday, June 15, 2009 10:01 AM:

Your installed databases are Aras Innovator 9.1.0. 

Your demo database is version 9.0.1.

Code tree and database must match versions.

I recommend trying this demo database, that supports Aras Innovator 9.1.0:

 http://www.aras.com/communityProjects/default.aspx?projectid=59D9F0D66ECC477DB67660F24198695D

-Chris

 

 



jupakka - Tuesday, June 16, 2009 5:27 AM:

Right. Thanks for clearing this up!

BR,
Juha