Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: Cannot Open Imported Encyclopedia
Topic Summary: System Architect Encyclopedia
Created On: 24-Sep-2006 22:33
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by Ian Souchard, on Monday, September 25, 2006 4:52 PM

Answer:
if it's a pre version 10.3 encyclo that you've restored, it will need to be upgraded (Tools menu in SAEM) - I believe v 10.3 introduced the ShortProps field...
 24-Sep-2006 22:33
User is offline View Users Profile Print this message


Stuart Altenhaus

Posts: 4
Joined: 11-Jul-2006

After receiving a database extract from a colleague, the SA Encyclopedia Manager v2.0 was used to restore from a file.  The encyclopedia was successfully created.

However, when opeing the encyclopedia in SA the first time, an error message reporting that 2 DOORS triggers were missing and
"<Entity> Table <PropType> Column not found
<Entity> Table <ShortProps> Column not found"

When trying to open the encyclopedia in SA thereafter, the only message received was
"<Entity> Table <PropType> Column not found
<Entity> Table <ShortProps> Column not found"

Has anyone encountered this or a similar problem?  If so, how did you overcome the problem?

How do I create the columns PropType and ShortProps in the Entity table (assuming that is the solution)?

Regards,
Stuart Altenhaus

-------------------------
r/s,
Stu
Report this to a Moderator Report this to a Moderator
 25-Sep-2006 00:48
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

I haven't encountered the problem, but, assuming that the solution is to add two fields to the database, albeit you'll have to know what type the fields are, you'd do the following:

1. Open Encyclopedia Manager
2. Choose the database you want to update
3. The SQL syntax to add columns/fields is:

ALTER TABLE entity ADD proptype VARCHAR(250)
ALTER TABLE entity ADD shortprops VARCHAR(250) --I've made them varchar type for example.

Check out what fields you have in the Entity table currenlty by using the following SQL string within your Enterprise Manager or SQL Server Query Manager.

SELECT
COLUMN_NAME,
DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='entity'

What you should have listed as fields are:
COLUMN_NAME DATA_TYPE
Audit,                   nvarchar
Class,                   smallint
FromArrow,          bit
FromAssc,            int
ID,                         int
Name,                   nvarchar
SeqNum,              smallint
Properties,           ntext
ToArrow,              bit
ToAssc,                int
Type,                    smallint
UpdateDate,         datetime
SAGuid,               nvarchar



Report this to a Moderator Report this to a Moderator
 25-Sep-2006 04:00
User is offline View Users Profile Print this message


Ian Souchard

Posts: 22
Joined: 28-Feb-2006

Answer Answer
if it's a pre version 10.3 encyclo that you've restored, it will need to be upgraded (Tools menu in SAEM) - I believe v 10.3 introduced the ShortProps field...
Report this to a Moderator Report this to a Moderator
 25-Sep-2006 16:53
User is offline View Users Profile Print this message


Stuart Altenhaus

Posts: 4
Joined: 11-Jul-2006

Duane,
Thanks for the prompt reply.  As it turns out, the encyclopedia predated v10.3 and needed to be updated.

Thanks again.
Stu

-------------------------
r/s,
Stu
Report this to a Moderator Report this to a Moderator
 25-Sep-2006 16:54
User is offline View Users Profile Print this message


Stuart Altenhaus

Posts: 4
Joined: 11-Jul-2006

Ian,
thanks... that did the trick!

Appreciate your prompt response.

Stu

-------------------------
r/s,
Stu
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.