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: SQL Transaction Loss Within a Citrix Environment
Topic Summary: Has anyone experienced a situation where updates to diagrams are not recorded?
Created On: 17-Jul-2006 02:12
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.
 17-Jul-2006 02:12
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

I have had two separate incidents where a user has updated a diagram or created a new diagram and when they reopen them, the updates/changes they have made are missing. Details:

SA is running under a Citrix environment.

Incident 1.
- User created a new diagram which took two hours to create.
- User pressed the save button a number of times during diagram creation.
- Closed SA.
- Reopened SA only to find the the diagram did not exist.
- We checked all encyclopedias to see if it was accidentally put elsewhere.

Incident 2.
- User updated several diagrams throughout the day.
- Save button was pressed on a number of occasions.
- User had diagram filter within the Browser window on during the updating process.
- I noticed that the user's filter was creating a blocking process within SQL Server stopping other users accessing the database. I asked them to log out.
- Upon logging back in to System Architect, their changes were not apparent within any of the diagrams.

I am conjecturing at this point that an apparent blocking of SQL Server processes has caused the transactions for the changes to diagrams to not be committed and that there is no notification to the user that the updates have failed.

Any other ideas or experiences welcome. Thanks.

Report this to a Moderator Report this to a Moderator
 5-Dec-2006 20:50
User is offline View Users Profile Print this message


Omar Balkissoon

Posts: 7
Joined: 14-Mar-2006

I have seen this happen twice to my users and they look at me as if I'm crazy since I can't provide them with any explanation.  Have you delved into this any further??  It seems as if the user is saving on some sort of cache and then it isn't being written to the database...  I can't see this happening though because SA can't write to any thing local, right??  We are running terminal services - similar to that of Citrix.  Would like to hear if you have problems of this type lately...  I had one of my engineers loose a whole days worth of work this past Sunday....

Report this to a Moderator Report this to a Moderator
 6-Dec-2006 04:09
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

I never got to the exact cause of the problem. We moved our SA backend to an updated Citrix Environment and the problem seems to have gone away. Although, I haven't had the flux of users using SA at the same time as we did when it was happening.

I'm not sure how SA caches its data, suffice to say that it can recover diagrams every now and then.

I tried to create a VBScript timer (using APIs) to save the XML of the diagram a user is working on every now and then so we could restore the diagram. Of course that didn't work because I could not extract XML from a currently active diagram.

In the end I left the problem open and have not had any calls with the problem for a while.

My conjectures in my last post is all I have to go on unfortunately.

Sorry I could be of no more help. I have found with over a year of administering System Architect (we're on 10.0.22, before Telelogic took the application over) that user confidence has dropped and many moved to Visio for their Business Process Diagram needs.
Report this to a Moderator Report this to a Moderator
 7-Dec-2006 14:32
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

Omar and Duane - Have you logged these issues with support? If so please could you post the support numbers, so I can look into this.

Thank you
Ian

-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 4-Mar-2007 22:02
User is offline View Users Profile Print this message


Alex Pickens

Posts: 2
Joined: 4-Mar-2007

I have also experienced the same problem, although I did get a message saying that the database was left open. I now close and reopen the encyclopedia every now and then to make sure what I am doing has been saved.
Report this to a Moderator Report this to a Moderator
 4-Mar-2007 22:02
User is offline View Users Profile Print this message


Alex Pickens

Posts: 2
Joined: 4-Mar-2007

 



Edited: 4-Mar-2007 at 22:04 by Alex Pickens
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.