Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 34

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 12th February 2018, 09:33
Marioth's Avatar
Marioth Marioth is offline
Senior Member
 
Join Date: Aug 2001
Location: Ireland
Posts: 144
Marioth is on a distinguished road
Baan: BFCS,BMCS,BOCS, Triton 1 until 2.2, BaaN 3 until BaaN ERP (5), Ln 6.1 FP3, Infor LN 10.5 - DB: Oracle, Informix, B-Isam, C-Isam - OS: HP-unix, AIX, Sun Solaris, Digital, NT
deleting old active users (ttaad2560m000)
Baan: ERP LN 6.1 FP11 (Infor ERP 10.5)
DB: SQL Server 2016
OS: Windows NT
C/S: Both

Hi,

I have a problem within ttaad2560m000 I see a couple of thousands old records with "active user data" but I can't delete them. If I select the sessions for "Noremal Users" I get an error message when trying to terminate them and for "Super Users" I can't even select the terminate option. Any suggestions??

Regards,

Mario
Reply With Quote
  #2  
Old 12th February 2018, 19:46
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,073
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows
Refer to the following KB articles but there is no mention on how to delete old data:

KB 1683541 - Support use of BSE Services on-premise
KB 1837562 - Old (not existing) Bshell User Processes shown in session "Active Users" (ttaad2560m000)

Did you set up the BSE services for your environment?
Quote:
Infor Enterprise ServerAdministration Guide
Document code refesag (U8854)
Release 10.5.1 (10.5.1)
Publication date December 9, 2016
Chapter 14 BSE Services
Also, refer to the section in the User Management Chapter -
Quote:
Active Users
Running the Active Users (ttaad2560m000) session shows the list of Active users on the LN environmentThe session monitors the logged in users and refreshes the list every five seconds.
Note
The Active Users session is only supported when the LN Application server runs on Windows.
Running the session (Windows only)
The session shows these columns:
▪ Login Time
▪ User info
▪ Bshell PID
▪ Category (Background Process or User Process)
▪ Description of the startup process, and the command line of the bshell
Examples of Category and Description:
▪ When a user logs in using LN UI, the Category is User Process, with 'UI Process' as description.
▪ A bshell handling Job ABC is displayed as a Background Process, with 'Job Process [ABC]'as description.
You can manually stop the bshell of an Active user with the Terminate command. The BaanLogin Daemon will stop the selected bshell. Note that when you are logged on as a Normal User you only can only stop your own processes. To be able to terminate the processes of other users you must log on as a Super User.
Every bshell that is started creates a bshell.<pid> file in the $BSE\proc folder, containing the mentioned properties of the bshell. If a bshell process is stopped in an abnormal way the proc folder can become out of sync. The BaanLogin Daemon will remove the remaining bshell.<pid> files in the $BSE\proc folder when the accompanying bshells do not exist.
Active Users BSE Service
The Active Users BSE Service compares every minute the files in $BSE\proc to the records in the Active Users session. The BSE Service ensures that Active Users tables in the database are in sync with the files in $BSE\proc. A cleanup process is started when there is a mismatch. and the database will be brought in sync with the $BSE\proc folder again.
For details, see BSE Services (p. 185) .
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
  #3  
Old 14th February 2018, 12:48
Marioth's Avatar
Marioth Marioth is offline
Senior Member
 
Join Date: Aug 2001
Location: Ireland
Posts: 144
Marioth is on a distinguished road
Baan: BFCS,BMCS,BOCS, Triton 1 until 2.2, BaaN 3 until BaaN ERP (5), Ln 6.1 FP3, Infor LN 10.5 - DB: Oracle, Informix, B-Isam, C-Isam - OS: HP-unix, AIX, Sun Solaris, Digital, NT
No we don't have set up the BSE services for our environment. We use the LNUI-Admin (active Users) to monitor the users. Maybe thats the problem.
Reply With Quote
  #4  
Old 14th February 2018, 19:44
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,073
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows
The Active Users session relies on a BSE which checks the contents of the directory $BSE/proc to see what processes are active, you can check what you have in that path and should be the same information that you are seeing in the session.

Please do not take into account what you are seeing in BW because BW is not supported using LN 10.X releases.

Once the BSE services are configured the old data should be gone.
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
  #5  
Old 16th February 2018, 00:50
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,073
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows
Also, refer to -
Quote:
KB 1947317
Not all users displayed in the session Active Users (ttaad2560m000)

Description:
TOOLS VERSION(S):
10.4, 10.5, 10.6
SITUATION IDENTIFIED IN:
"Active Users Monitor Service" (ttaad2261m000)

SITUATION DESCRIPTION:
The session Active Users (ttaad2560m000) shows only some logged-in users, but not everyone.
Usually the users with a different Time Zone set in their User Data Template (ttamd1110m000) are not listed.
Resolution:
SOLUTION DESCRIPTION:
As of portingset 9.2a.01 (TIV 2210), the files in the $BSE/proc have an extra attribute which stores the login time in UTC long format. When this attribute is present in the proc files, the Active Users Monitor Service (ttaad2261m000) compares the value that attribute against the login time as stored in table ttaad260. When this attribute is not present, the login time is not validated anymore, in order to prevent situations as mentioned in the situation description.

For the most accurate results it is therefore recommended to install portingset 9.2a.01 (expected release date is end of March, 2018).
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Tool to show active Baan users on Windows SLM and/or RDP sessions patrick Code & Utilities 6 5th July 2012 22:37
Listing Baan Active Users Indianidol Miscellaneous 1 24th February 2012 13:48
Deleting Users pjohns Tools Administration & Installation 5 18th August 2008 22:42
Active Users ltannous Operating Systems & Databases 13 30th November 2005 11:25
Deleting Multiple Users in One Go.. scpcooin Tools Administration & Installation 4 13th July 2005 16:33


All times are GMT +2. The time now is 23:51.


©2001-2018 - Baanboard.com - Baanforums.com