Search results

  1. Mike

    Long running transaction by a user and his activity code

    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...
  2. Mike

    Long running transaction by a user and his activity code

    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...
  3. Mike

    Long running transaction by a user and his activity code

    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...
  4. Mike

    Need to find RCA even though .lk file exist Application team wont able to connect via ERP.

    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?
  5. Mike

    Need to find RCA even though .lk file exist Application team wont able to connect via ERP.

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

    Need to find RCA even though .lk file exist Application team wont able to connect via ERP.

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

    Need to find RCA even though .lk file exist Application team wont able to connect via ERP.

    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...
  8. Mike

    Need to find RCA even though .lk file exist Application team wont able to connect via ERP.

    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...
  9. Mike

    Error Connections exceeding.

    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...
  10. Mike

    Error Connections exceeding.

    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...
  11. Mike

    Error Sql users getting error :-Exceeding permissible number of connections and No SQL servers are available

    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...
  12. Mike

    Question Need to update open edge version 11.7.9 to 11.7.20

    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...
  13. Mike

    Error Sql users getting error :-Exceeding permissible number of connections and No SQL servers are available

    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...
  14. Mike

    Error Sql users getting error :-Exceeding permissible number of connections and No SQL servers are available

    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...
  15. Mike

    Error Unable to start app server.

    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
  16. Mike

    Question Way to delete records of table from database? (DBA related query using and utility)

    Hi Tom Team, We had a situation where we had an urgent need purge (delete records of 1 year old ) from a database table. Progress version 11 and linux platform.We called the programmer to write the code and delete the records of 1 year of table. We took backup of table .df and .d of table and...
  17. Mike

    Conversion.

    Hi Tom, Thanks for reply, Basically we have two databases account (dbname) and sale(dbname) :- 1: account (dbname) is starts with DLC path :- DLC=/progress9/dlc;export DLC and it starts successfully . 2:- sales (dbname is starts with DLC path :- DLC=/progress9_64/dlc;export DLC and it starts...
  18. Mike

    Conversion.

    Hi Tom, Here , we have scenario that we are connecting with progress editor of 32 bit database via mpro but when we try to connect inside progress editor with 64 bit database its throwing version difference error. So Is it possible to connect with 32 bit via progress editor and connect to 64...
  19. Mike

    We need to use test server and test databases as a prod.

    Tom, Actually , We are closing production server and database and make the test database as production. Its a requirement.
  20. Mike

    Conversion.

    Hi, OS version:- HPUX Progress version :- 9.1d with 32bit and 64 bit We have two database with different version one is 9.1d 32bit and another is 9.1d 64bit .I have some doubts:- Q1:- what are difference between 32bit and 64bit ? Is it coz of performance aspects? Q2:- Can we convert 32 bit...
Back
Top