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: History Function
Topic Summary: History function SQL Enterprise Manager
Created On: 14-Jun-2006 17:40
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.
 14-Jun-2006 17:40
User is offline View Users Profile Print this message


Milton Yang

Posts: 3
Joined: 20-Mar-2006

I'm trying to enable the history function that allows users to track the history of the definitions in a reposity.  The help section in SA describes a process within SAEM. 

We are currently running SA 10.3 but we're accessing databases that were originally created with SA v9.  As such, we cannot use the updated SAEM with the old SA.  Does anyone know of how to turn on history using the SQL Enterprise Manager?
Report this to a Moderator Report this to a Moderator
 15-Jun-2006 16:09
User is offline View Users Profile Print this message


Andrea Heithoff

Posts: 33
Joined: 15-Aug-2005

To clarify, you're using SA 10.3 to access your encyclopedias dating to version 9 but you're not using the latest SAEM?  If that's the case, how did you do the conversion of the encyclopedias to version 10.3?

Instead of using SQL Enterprise Manager, I'd first investigate your SAEM installation.  Creating your encyclopedia in version 9 shouldn't restrict you from using a new SAEM.  I would be very reluctant to turn on history from SQL Enterprise Manager--it's not just a switch, but a new table in your underlying database specifically for history.

Report this to a Moderator Report this to a Moderator
 16-Jun-2006 00:01
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

Does this record changes to every object within SA? I was going to build a set of triggers to do this to capture the User ID of the person making the change to a record and the deleted record information.
Report this to a Moderator Report this to a Moderator
 16-Jun-2006 14:19
User is offline View Users Profile Print this message


Milton Yang

Posts: 3
Joined: 20-Mar-2006

"The History command enables you to track the history of the definitions created in a repository and revert back to privious versions of the definition. You turn the History function on via SAEM. You may turn it on for an encyclopedia's Entity and/or Files tables." This is what SA has in the help section when you run a search on "history". I can't answer your question about audit IDs b/c I have not been able to turn it on.
Report this to a Moderator Report this to a Moderator
 16-Jun-2006 19:05
User is offline View Users Profile Print this message


Andrea Heithoff

Posts: 33
Joined: 15-Aug-2005

We briefly tested history just to see what it does, so my experience is limited.  Essentially, with each change made to a definition, a copy of the previous set of properties is added to a history table.  You get an approximate log of who made what changes when, and you can view them by clicking the "History" button on the definition window (next to "Referenced By").  My colleage did some report testing and was able to retrieve data to show the evolution of the properties.

An inconvenience I found was that when you retrieve the history, only the changes made to properties currently shown are displayed, along with the name and date, and a System Architect version number.  If you want to see changes to a property on a different tab, you need to close the history window, go to the second tab and reopen the history window.

This inconvenience carried into the recovery mode: if you want to restore a version of the requirement, you have to recover the specific version number for every history display screen--only the properties displayed are restored.  This means that for 5 tabs/pages you have to execute 5 restorations in order to truly get to the version you want to restore, and all 5 restorations are record as additional changes.  This may be corrected in 10.4.

Duane, you should explore history before writing your own triggers.  It may be exactly what you need.

Milton, any luck in reviewing your SAEM installation?
Report this to a Moderator Report this to a Moderator
 22-Jun-2006 03:31
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

Thanks Andrea and Milton. I will check it out. Sounds like what I want. :-)
Report this to a Moderator Report this to a Moderator
 22-Jun-2006 05:01
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

Damn, I don't see it within 10.22. Would need to upgrade first which will not happen just yet.
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.