![]() |
Telelogic System Architect (steve huntington) | ![]() |
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 |
![]() |
![]()
|
![]() |
|
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? |
|
![]() |
|
![]() |
|
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? |
|
![]() |
|
![]() |
|
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.
|
|
![]() |
|
![]() |
|
"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.
|
|
![]() |
|
![]() |
|
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? |
|
![]() |
|
![]() |
|
Thanks Andrea and Milton. I will check it out. Sounds like what I want. :-)
|
|
![]() |
|
![]() |
|
Damn, I don't see it within 10.22. Would need to upgrade first which will not happen just yet.
|
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.