| Author | 
		  Message
		 | 
		
		  | CHF | 
		  
		    
			  
				 Posted: Thu Sep 09, 2004 12:39 pm    Post subject: [SOLVED] Problem in deleting an User from WF Runtime | 
				     | 
			   
			 
		   | 
		
		
		    Master
 
 Joined: 16 Dec 2003 Posts: 297
  
  | 
		  
		    
			  
				Hi all,
 
I am trying to delete a person called "USER1" from WF Runtime. When I run the fmcibie I am getting the following error:
 
 
   
	| Code: | 
   
  
	| 09/09/04 15:38:43pm FMC25650E DD:FMCIIMP(11): DELETE cannot be performed for PERSON 'USER1'. The person is logon | 
   
 
 
 
Can someone tell me what is wrong? 
 
 
I thought that the person might be logged on, So I did a forcelogon using this id and logoff. Even after that I am getting the same error. I did a query for all the activity instances or Workitems if he has any, using a Java program, and he don't have any.
 
 
Thanks in Advance _________________ CHF   
  Last edited by CHF on Fri Sep 17, 2004 9:37 am; edited 1 time in total | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | mike_mq | 
		  
		    
			  
				 Posted: Thu Sep 09, 2004 2:01 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Centurion
 
 Joined: 17 Oct 2003 Posts: 123
  
  | 
		  
		    
			  
				| Are you sure, the USER1 is in the runtime database ? If so, Can you send us the FDL. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | CHF | 
		  
		    
			  
				 Posted: Fri Sep 10, 2004 3:58 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Master
 
 Joined: 16 Dec 2003 Posts: 297
  
  | 
		  
		    
			  
				USER1 is in the Runtime DB.
 
 
I could delete everyone else except for this user. _________________ CHF    | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | texan | 
		  
		    
			  
				 Posted: Fri Sep 10, 2004 5:04 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Acolyte
 
 Joined: 25 Feb 2004 Posts: 74
  
  | 
		  
		    
			  
				| Can you check the session table and see whether there is an entry for this user? | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | CHF | 
		  
		    
			  
				 Posted: Fri Sep 17, 2004 9:36 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Master
 
 Joined: 16 Dec 2003 Posts: 297
  
  | 
		  
		    
			  
				The problem is solved now. I dont know why there was a session open for this USER1 (I have checked it in the session table). Even after I did a force logon from my machine and logoff, still the session table shows there is a session open for him. Anyhow I have bounced the Workflow, and then the session for that users is gone. Then I could be able to delete that user.
 
 
Thanks for your inputs. _________________ CHF    | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | jmac | 
		  
		    
			  
				 Posted: Fri Sep 17, 2004 10:42 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Knight
 
 Joined: 27 Jun 2001 Posts: 3081 Location: EmeriCon, LLC 
  | 
		  
		    
			  
				CHF:
 
 
Just FYI... the session timeout is 20 hours by default, so if you had a webclient that someone just closed, you would have to wait 20 hours to get it out of the session table. _________________ John McDonald
 
RETIRED | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | CHF | 
		  
		    
			  
				 Posted: Fri Sep 17, 2004 11:08 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Master
 
 Joined: 16 Dec 2003 Posts: 297
  
  | 
		  
		    
			  
				JMac:
 
 
If I do a force logon using my thick client, this should logout this user from the other machine and cancel that session right? 
 
 
Thanks _________________ CHF    | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | CP | 
		  
		    
			  
				 Posted: Fri Sep 17, 2004 11:25 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Novice
 
 Joined: 15 Jul 2004 Posts: 16
  
  | 
		  
		    
			  
				Can any body tell me, how do we see/access the session table ?
 
 
Thanks. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | jmac | 
		  
		    
			  
				 Posted: Fri Sep 17, 2004 11:35 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Knight
 
 Joined: 27 Jun 2001 Posts: 3081 Location: EmeriCon, LLC 
  | 
		  
		    
			  
				
   
	| CHF wrote: | 
   
  
	| If I do a force logon using my thick client, this should logout this user from the other machine and cancel that session right? | 
   
 
 
 
CHF:  That wont do it, because if you login with the thin client you get a Default session.  The force will only remove a Present session.  If you do not terminate a default session with a proper logoff, I believe it will have to time out, or you could clear the session table by using the technique you used... Brute Force    
 
 
CP: You can view the session table w/ Db2 control center _________________ John McDonald
 
RETIRED | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | CHF | 
		  
		    
			  
				 Posted: Fri Sep 17, 2004 12:05 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Master
 
 Joined: 16 Dec 2003 Posts: 297
  
  | 
		  
		    
			  
				JMac,
 
Thanks for the valuable inputs. _________________ CHF    | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |