Recent content by Mike

Hi George, Thanks for replying. As you said we can use _Connect._Connect-Cache* which data field in _connect table? to get the program name run by the user which . Can you please help me to get exact query and execute in progress editor to find out the user connected and their activities? Need...

Hi Rob, Thanks for your response. version is = 11.2 Promon result Status: Active Transactions by user number for all tenants Usr:Ten Name Domain Type Login time Tx start time Trans id Trans State 45 Rxcm -4 SELF/ABL 06/03/25...

Hi all, I have a question about long running transactions of database by using R&D and active transaction. We always having transaction number like below:- 45 Rxcm -4 SELF/ABL 06/03/25 08:27 06/03/25 13:20 1746518328 Active But it is not giving complete info like what...

Did you translate that .lg file somehow or other? There are a LOT of messages whose text is strangely worded. Hi Tom, Please help me to find out root cause please?

Hi Tom, Yes I did translation from Spanish to English. Request you to please help in this . Thanks and regards Mike

Can you please check the db log file and let me know something for RCA?

Hi George , Thanks you for your response on this issue. But I am seeking the root cause that what happened on that day? I tried -by option and even emergency shut down but nothing worked and users wont able to connect with Chui and problem resolved soon after server reboot and db start up after...

1:- We have progress version 11.2 and OS version :-Hp-UX Yesterday there was an issue with database or server . User not able to connect database ERP CHUI mode and showing black screen. We login to the server and went to the db path where we see .lk file exist .We tried to do Promon and db and...

Hi Rob , Thanks for the valuable response. So The progress version is :- 11.7 So here we go :- 4gl broker parameters below: - Ma 5 -maxport 51999 -Mi 1 -minport 51900 -mmax 8192 -Mn 20 -Mpb 20 -n 400 -nb 200 Secondary broker configuration -m3 -Ma 1 -maxport 51999 -Mi 1 -minport 51900 -N...

Hi, We have a situation where sql connection exceeding. User complaining about connection exceeding. With error in db log file:- :00:04.200-0600] P-3750 T-140117189777216 I BROKER 1: (8839) No SQL servers are available. Try again later. [2024/11/06@13:54:28.711-0600] P-3750...

Hi Rob, I have a question. We have Mn=20 value (its including 4GL+ SQL connection) and Ma = 1 for SQL broker and -Mpb =0 but why I can see below 2 server started by broker? What is the default value of -Mpb .why below to connections broker started even the value is -Mpb=0 for secondary SQL...

Hi Tom and Team, We need to update the open edge version 11.7.9 to 11.7.20service installation pack because of security issue and fixes. Os = Linux Can you please tell me steps in detail? Does in impact on existing version? Will it overwrite in existing version? How can we test this? Please...

Hi Job, Thanks for your reply. Really Appreciated. I think issue is happening coz no -Mbp is supplied. So below is the Secondary broker configuration more broker-sql-mfg.pf (main script) -pf /apps/scri/com/broker-sql-standard.pf -S mfgdb-sql ( I guess if i add these line below it...

Hi Tom and team, Progress version:- 11.7 OS :- Linux Sql users getting error :-Exceeding permissible number of connections and No SQL servers are available 2024/08/26@14:27:25.990-0500] P-3750 T-140117189777216 I BROKER 1: (8839) No SQL servers are available. Try again later...

Hi Team, We are getting error while starting App server: Progress version:- 10.1B OS =Linux Error below:- plug-in of type: com.progress.ubroker.tools.UBCommandPlugin (Aug 14, 2024 02:40:32:153) dev_fg_AS is not responding to ping (8307). Thanks and Regards Mike